I am considering to apply a fix which will generate constant parameter sizes for (n)varchar parameters. The application is based on NHibernate with the old OracleClientDriver (using Microsoft Oracle ...
I've been trying to optimise our database, but not being a DBA and not having done a whole lot of tuning before I'm struggling a little with "too many options". I've already run pg_tune and bumped a ...
well known problem is that oracle's catsearch doesn't support functional invocation. but optimizer can choose to use execution plan that will fail because above limitation. so sometimes (for example ...