Since at least 10.2.0, Oracle has decided by default when to invalidate a dependent cursor when query optimizer statistics are gathered. You can determine what setting you have by the following: SQL> select dbms_stats.get_param(‘NO_INVALIDATE’) from dual; DBMS_STATS.GET_PARAM(‘NO_INVALIDATE’) ——————————————————————————– DBMS_STATS.AUTO_INVALIDATE SQL>…
Month: September 2012
Oracle database encryption
Under normal conditions using an out of the box setup, Oracle database datafiles are stored in a proprietary format. Data such as strings of alphabetic characters can be viewed just as they are in the database by the naked eye…