Warning: Creating default object from empty value in /home/customer/www/gavinsoorma.com/public_html/wp-content/themes/specular/admin/inc/class.redux_filesystem.php on line 29
February | 2011 | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Passing the 11g Oracle Certified Master (OCM) Exam – some thoughts

  • Posted by Gavin Soorma
  • On February 22, 2011
  • 7 Comments
I recently passed the 11g Oracle Certified Masters Upgrade Exam and am now an 11g OCM in addition to the 10g OCM. I had to sign a Non Disclosure Agreement (NDA) while taking the exam, so unfortunately I will not be able to divulge too many details about the exam, but would like to share […]
Read More
 

Using TUNE_MVIEW and EXPLAIN_REWRITE to enable us to tune MV Fast Refreshes and Query Rewrites

  • Posted by Gavin Soorma
  • On February 21, 2011
  • 0 Comments
We can use the DBMS_MVIEW.EXPLAIN_REWRITE package (which was first introduced in Oracle 9i if memory serves me right) to diagnose why Query redirection to a materialized view is not happening. We can redirect the output to a table called REWRITE_TABLE which is created via the utlxrw.sql script located under $ORACLE_HOME/rdbms/admin. Let us take a simple […]
Read More
 

Upgrade to 11g and ensure Optimizer Plan Stability using SQL Plan Baselines

  • Posted by Gavin Soorma
  • On February 15, 2011
  • 4 Comments
One of the major concerns a DBA has related to performing a database upgrade to Oracle 11g is ‘Are Execution Plans Going To Change Post-Upgrade?’ I am quite sure we would have experienced some queries having different execution plans when we did earlier upgrades to both 9i as well as 10g. This is due to […]
Read More