Oracle 11g Securefile LOB Overview - an enhanced LOB storage Part 1

Oracle has made several enhancements in LOB storage so as to provide better performance and utilizing less storage. As the name suggest, Securfile LOB secure the LOB data.

Click here to get complete Overview of Securfile LOB

Oracle 11g - Recover from loss of SPFILE

Prior to 11g, we have to explicitly specify SCOPE=SPFILE or BOTH to add initialization parameters changes in the SPFILE. With 11g, Oracle has provided some good enhancement so as manage the PFILE / SPFILE as shown below
1. CREATE pfile FROM MEMORY
2. CREATE Spfile FROM MEMORY
3. Check the location of the Paramter PFILE or SPFILE used to start the Database

CLICK here to get full article about SPFILE recovery

Oracle 11g Database Stats - Private Statistics

Oracle 11g allows you to collect statistics outside of Data Dictionary so that you can check it without affecting the application/production environment. If it works as desired, then this private statistics can be made permanent by moving them to Data Dictionary.

Get more detail are Oracle 11g Private Statistics

Oracle 11g Database Stats - Setting preferences

Oracle 10g has introduced Automatic Statistics Gathering job that run daily sometime between 8pm to 6am to collect the Database statistics. If we have to make some alteration, we have to either remove this auto Job or have to schedule several other statistics jobs based on application requirement. With 11g new Statistics preferences features, we can reduce the complexity.

Click here to get more step by step details od setting preferences and their benefits

11g Database Statistics enhancements - Overview

Oracle 11g has made lots of Database statistics enhancements which are very beneficial to DBA as well as production application. In this paper , I will discuss the initial configuration and high level overview and will go in more details in the next paper.

Click here to get complete details about the enhancements

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