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

ASMCMD examples

  • Posted by Gavin Soorma
  • On September 30, 2009
  • 1 Comments
asmcmd is a command line tool that we can use to manage Oracle ASM instances, ASM disk groups, files and dierctories, templates very much as in the same way we would do while working with say a UNIX file system. ASMCMD can be launched in interactive or non-interactive modes and we need to first ensure […]
Read More
 

10g EM Grid Control Notification Rules and Corrective Action Jobs

  • Posted by Gavin Soorma
  • On September 29, 2009
  • 3 Comments
In 10g Enterprise Manager Grid Control, we can create corrective action or ‘fixit’ jobs which can automatically run if say a metric threshold is crossed or a particular event occurs. For example, we may have situations where we monitor the disk space used by the archive log files and as soon as the disk space […]
Read More
 

11g RMAN Substitution Variables

  • Posted by Gavin Soorma
  • On September 22, 2009
  • 0 Comments
We can now use SQL*PLUS type substitution variables in RMAN like &1, &2 and so on and the same can be linked to shell scripts as shown below with the new clause USING where we are passing the Incremental Level and the backup tag to the actual RMAN command. Also note that in 11g we […]
Read More
 

11g Release 2 Edition-based Redefinition

  • Posted by Gavin Soorma
  • On September 21, 2009
  • 1 Comments
11g Release 2 Edition-based redefinition enables you to upgrade or change the database component of an application while it is in use, thereby minimising or eliminating down time which was earlier required when an object like a procedure required to be modified, but we could not do it without any outage as the application was […]
Read More
 

11g Pending and Published Statistics

  • Posted by Gavin Soorma
  • On September 18, 2009
  • 0 Comments
Prior to Oracle 11g, the default behaviour was to make statistics available for the optimizer to use as soon as they were gathered. While statistics are required to enable the optimizer to generate optimal execution plans, sometimes just by gathering fresh statistics tried and trusted execution plans can abruptly change and thereby adversely affect application […]
Read More
 1

11g Interval Partitioning

  • Posted by Gavin Soorma
  • On September 15, 2009
  • 0 Comments
In versions prior to Oracle 11g, we were very likely to have faced the error shown below especially if we used range partitioning and the partition column was a date field. We needed to ensure that we precreated all the partitions before hand based on the expected values of data that would be inserted (or […]
Read More
 

11g Real Application Testing – Part 2

  • Posted by Gavin Soorma
  • On September 14, 2009
  • 0 Comments
Analyze the impact of change on SQL statements using the SQL Performance Analyzer In the earlier post, we had discussed the Database Capture and Replay component of 11g Real Application Testing – (http://gavinsoorma.wordpress.com/2009/09/11/11g-real-application-testing-making-changes-with-confidence/) We can also analyse the impact of upgrading from 10.2.0.4 to 11.1.0.6 at the SQL statement level by using the other component […]
Read More
 

11g Real Application Testing – making changes with confidence

  • Posted by Gavin Soorma
  • On September 11, 2009
  • 0 Comments
CASE STUDY: Using 11g Real Application Testing to analyse the impact of making the following changes: 1) Upgrade the database from 10g to 11g 2) Convert from single instance database to a two node RAC database 3) Convert from file system based storage to 11g ASM Overview of Real Application Testing One of the best […]
Read More
 

Oracle 11g Advanced Compression

  • Posted by Gavin Soorma
  • On September 3, 2009
  • 2 Comments
Although table compression was introduced in Oracle 9i and 10g, it was aimed more at bulk load operations for data warehouse environments. The overhead associated with compression and uncompression made it unsuitable for OLTP type shops. In Oracle 11g, Advanced Compression (which is an additional licensed feature) includes OLTP compression capabilities as well as compression […]
Read More
 

DBA Monitoring Menu

  • Posted by Gavin Soorma
  • On September 3, 2009
  • 4 Comments
I have created a simple but very useful Unix shell script driven menu to enable easy monitoring of any number of Oracle databases from a single central location. This covers most of the normal DBA day to day standard monitoring requirements as well as a good interface for aiding in performance tuning. Set up is […]
Read More
 1

11g Snapshot Standby for real time testing

  • Posted by Gavin Soorma
  • On September 2, 2009
  • 2 Comments
One of the very good new features in Oracle 11g is the Snapshot Standby database where we can basically convert the physical standby database into a read-write real time clone of the production database and we can then temporarily use this environment for carrying out any kind of development testing, QA type work or to […]
Read More