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
June | 2011 | Oracle DBA – Tips and Techniques
News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Using DBMS_ADVANCED_REWRITE with an HINT to change the execution plan

  • Posted by Gavin Soorma
  • On June 29, 2011
  • 2 Comments
In one of my earlier posts, I had illustrated a use case of DBMS_ADVANCED_REWRITE and its use in cases where we cannot change the code, but can still influence and change the way the optimizer executes the same SQL statement. In case of many vendor provided and packaged applications, we do not have access to […]
Read More
 1

Upgrading Enterprise Manager Grid Control 10.2.0.5 to 11g

  • Posted by Gavin Soorma
  • On June 17, 2011
  • 0 Comments
Purpose: This note describes the steps taken to upgrade an existing 10.2.0.5 Enterprise Manager Grid Control environment hosted on Red Hat Linux 5.5 to Enterprise Manager 11g (11.1. The upgrade of the 10.2.0.5 OEM broadly involves the following steps • Install the Oracle 11g Release 2 database software. This will be used for the repository […]
Read More
 

Upgrading to 11g Release 2 and DST Updates

  • Posted by Gavin Soorma
  • On June 16, 2011
  • 0 Comments
When performing an upgrade to Oracle 11g Release 2, we would need to take into consideration if there are any DST (Daylight Saving Time) implications which could be the vase in case we have application tables using the datatypes TIMESTAMP WITH TIME ZONE and TIMESTAMP WITH LOCAL TIME ZONE. Oracle 11.2.0.2 uses Time Zone version […]
Read More