Monthly Archives: August 2008

Where is my alert.log?

Oracle 11g is loaded with many new exciting features like Change Management, enhanced Diagnosis Capability, Storage management etc. But it also have some basic changes, in terms of log / trace locations. Specifically, people who are using old versions (8i/9i/10g) … Continue reading

Posted in Oracle 11g Enhancements | Tagged | Leave a comment

How to pin the objects in shared_pool?

For pinning the objects in the shared_pool, we need to use DBMS_SHARED_POOL package. To create this package we can use $ORACLE_HOME/rdbms/admin/dbmspool.sql script. Procedure DBMS_SHARED_POOL.KEEP is used to pin the objects. We need to pass 2 parameters to this procedure. 1. … Continue reading

Posted in Oracle Database Architecture | Tagged | Leave a comment

Statistics gathering & Cursor invalidation

Does gathering the statistics for tables invalidates the dependent cursors? Lets take a simple query ===================== SQL> select count(*) from emp; COUNT(*) ———- 15 SQL> select sql_id, sql_text from v$sqlarea where sql_text like ‘select %’ and parsing_schema_name = ‘SCOTT’ / … Continue reading

Posted in Oracle Database Architecture | Tagged | 2 Comments