Oracle 11g Automatic Memory Management

Oracle has introduced Automatic Shared Memory Management in Oracle 10g and thus allows automatic tuning of five important component of SGA [Shared Global Area]. Oracle 11g has introduced Automatic
Memory Management which will automates SGA as well as PGA size according to your workload by dynamically transferring the memory from SGA to PGA and vice versa.

Click here is full detail about this new feature

Oracle 11g RAC Final Part 8 - Add Node to the RAC

Now we are ready to add second Node to the RAC environment. This will involves the following steps
1. Install and Configure OS and hardware for the new node
2. Configure ASMlib and RAW device on Second Node
3. Add CLusterware to New Node
4. Configure ONS for the new node
4. Add RAC/Oracle Home to the new node
5. Add a Listener to the new node
6. Add a database instance to the new node


Step 3- 7 can be check at the following Link

Oracle 11g Database Replay Part 4 - Analyze the Workload

In this last Part, I will discuss as how we can compare the performance of Data captured on Source and then Replayed on New server, which is upgraded target server. This will help DBA's as well as management to make decision as if it is necessary to Upgrade the Hardware or if Upgrading the Database can work.

Click Here to get more details and step by Step Instructions

Oracle 11g RAC part 7 - Convert Non-RAC instance to RAC instance

In this paper, you will learn as how we can convert Non-RAC single instance to RAC instance using Oracle rconfig utility.

Click here to get full details about the rconfig utility