Source: READ ONLY Tablespace Restore and Recovery « Oracle DBA – Tips and Techniques
dbms_stats Oracle SQL performance
Source: dbms_stats Oracle SQL performance
Source: How to Deploy Oracle RAC on Oracle Solaris 11 Zone Clusters
ng Index X when you wanted it to use index Y or query performing Nested Loop join when Hash Join would have completed the query much faster.
Source: Plan Stability using Sql Profiles and SQL Plan Management | AskDba.org Weblog
Links to Various sources
Create a free website or blog at WordPress.com.