Welcome to Oracle Masters. The portal, as the tagline says, is for anything Oracle. FAQs, Certifications, Resources! In addtion, there will be pages on real life scenarios, Oracle internals, approaching the DBA job at various stages in your career and many other useful resources.Further, if you have a question, you can ask it and we will answer it at the earliest!
So join in. Learn, share and prosper!
Register with us!
Are you interested in Weekend/Online Training in Oracle DBA? Do you have business/consulting requirements? Click here Enquiry Form to leave your requirements or mail me at Ramesh Menon
Tuesday, 13 Jul 2010 3:23 AM
This post is a demonstration of duplicating an Oracle database to another server over the network. The article is for the scenario where ALL directory structures are the same on both the source and the destination database.
Read the rest of this entry »
Popularity: 15% [?]
Friday, 7 May 2010 10:05 PM
Sunday, 28 Feb 2010 8:06 PM
This section describes various steps in configuring the Operating System.
Once you have booted your server, and logged in as root, perform the following tasks
Read the rest of this entry »
Popularity: 20% [?]
Sunday, 28 Feb 2010 8:03 PM
Sunday, 28 Feb 2010 8:01 PM
This section describes the following tasks
Read the rest of this entry »
Popularity: 3% [?]
Sunday, 28 Feb 2010 7:56 PM
The following images show the hardware setup used for setting up 11gR2 RAC on Solaris 10. The comments on the disk setup are typed in the image itself.
I have assigned 1 CPU and 2GB RAM to each of the VM nodes. This version of 11gR2 requires this much of memory. So do not try to install it if you do not meet hardware requirements. Also, preferrably, as in my case, the disks are physically separate. Node 1, Node 2 and shared disks are all on separate physical disks.
Read the rest of this entry »
Popularity: unranked [?]
Sunday, 28 Feb 2010 7:55 PM
Welcome to a multi part series on 11gR2 RAC – Solaris x86-64bit. The intended audience for this series are DBAs who wish to learn new features of 11gR2 hands on by setting up RAC in their environment. They could use this setup before they do an actual implementation on SPARC based setup.
I assume that you have read some basic documentation on Oracle 11gR2 and understand that it is different from earlier releases of Oracle RAC.
This series is for demonstration purposes only and not intended to be used as a guide for implementation. This installation was done in a test environment.
The following are the parts in the series
Popularity: unranked [?]
Sunday, 9 Aug 2009 2:30 AM
Generating Execution Plan for a SQL Query
To find the execution path of a query, first create the PLAN_TABLE by running the $ORACLE_HOME/rdbms/admin/utlxplan.sql script.
Once created, you can use any of the following methods to see a query’s execution path.
Read the rest of this entry »
Popularity: 15% [?]
Saturday, 18 Jul 2009 8:14 AM
In an Oracle database, resources can be accessed in different modes (read or write), by different processes or sessions at the same time. In order to prevent access of resources in incompatible mode concurrently, Oracle implements mechanisms for protecting and managing SGA data structures and database objects being accessed concurrently while maintaining consistency and integrity. These mechanisms are locks (enqueues) and latches.
You can find more about locks or enqueues in this article Oracle Locks/Enqueues
- What is a latch?
Latches are locking mechanisms used to protect shared memory structures from potential corruption due to concurrent access. In other words,latches ensure exclusive access to the shared data structures in the SGA. Access to SGA structures is seralized, using latches. Latches, unlike locks or enqueues are not used to protect database objects.
Read the rest of this entry »
Popularity: 10% [?]
Saturday, 11 Jul 2009 9:38 PM
In this section, we will go through a demo of generating and detecting locks with scripts
Read the rest of this entry »
Popularity: 53% [?]
