IN ORACLE MILIEU …

Beyond Knowledge

Category Archives: Oracle Database 11g

Removing targets from Grid Control – Oracle 11g

1 Comment Posted by on April 25, 2012

Many times we have to cleanup some old targets from grid control. This happens because of host getting deprecated. Example if you have database which was running on a host and is registered in grid. Because of scaling requirement you moved the database to bigger box. In that case you have to have agent installation [...]

Oracle Database 11g , ,

Inside Index block – Oracle Database 11g

Leave a Comment Posted by on December 12, 2011

I ran into a scenario where I really wanted to check whats inside the leaf block of an index. This post is to dig inside the index leaf block and find out various facts stored inside a block. We will start with taking a dump of a block SYS.ORCL>alter session set tracefile_identifier=’INDEX_BLOCK_DUMP’; Session altered. SYS.ORCL>alter [...]

Oracle Database 11g , , , ,

Oracle SQL Plan Management – Part 1

4 Comments Posted by on June 2, 2011

SQL Plan Management – Oracle Database 11g SQL Plan Management or SPM is a new feature introduced in 11g. We will take a detailed look at SPM in the following sessions. Before starting with practical example lets see some theory. What is SQL Plan Management? SPM is a new feature introduced in Oracle database 11g [...]

Database 10g Performance Tuning, Oracle Database 10g, Oracle Database 11g , , , ,

Creating Standby database using Active Duplication – Oracle Database 11g

1 Comment Posted by on May 9, 2011

Introduction: Oracle database 11g introduced a new feature called Active database duplication. Using this feature you can create a new database (primary/standby) from your current running database. This feature does not needs any backup to be taken, nor we have to do any restore. Creating active duplication is a RMAN feature and command for creating [...]

Oracle Database 11g , , , , ,

Avoiding “no data found” : Tips

3 Comments Posted by on April 29, 2011

Some time we face issue about no data found depending on selection criteria. And when this happens in PLSQL procedure we get annoying error ORA-01403: No data found and execution stops. One way to get around this error is to add exception block in our PLSQL procedure as shown below EXCEPTION WHEN NO_DATA_FOUND THEN <Take Action> [...]

ORA Errors, Oracle Database 11g , , ,

An insight into Oracle Index rebuild

2 Comments Posted by on April 12, 2011

You must have gone through my previous article on Oracle Index rebuild – 10g Vs 11g – http://avdeo.com/2011/03/17/oracle-index-rebuild-online-10g-vs-11g/ Well, there is another nice article written by a friend of mine Sumit Bhatia. He has talked about the actions and events happening while rebuilding an index online in oracle database 11g. Different wait events that we [...]

Oracle Database 11g , , , ,

Virual Index and Invisible Index

Leave a Comment Posted by on March 23, 2011

Oracle has come up with a feature called virtual index in oracle 9i. This feature allow us to test an index on a table without actually adding an index on the table. The table will be visible only in our session and will be used by our queries only (if optimizer decide it to use). [...]

Oracle Database 10g, Oracle Database 11g, Oracle Database 9i ,

Oracle Index rebuild online – 10g Vs 11g

5 Comments Posted by on March 17, 2011

An index is basically used for faster access to tables. Over a period of time the index gets fragmented because of several DMLs running on table. When the index gets fragmented, data inside the index is scattered, rows / block reduces, index consumes more space and scanning of index takes more time and more blocks [...]

Oracle Database 10g, Oracle Database 11g , ,

Oracle Database 11g new feature – Automatic Memory Management

1 Comment Posted by on January 8, 2011

Automatic Memory Management was a new feature introduced in 10g. With 10g release oracle has come up with anew parameter called sga_target which was used to automatically manage the memeory inside SGA. The components which were managed by sga_target are db_cache_size, shared_pool_size, large_pool_size, java_pool_size and streams_pool_size With 11g, Oracle went a step further to manage [...]

Oracle Database 11g , , ,

Oracle Certified RAC Expert

5 Comments Posted by on April 5, 2010

Hi All, Just to inform all my viewers.. I have cleared Oracle Database 10g: RAC Administration exam (1Z0-048). This qualifies me as Oracle Certified RAC Expert. About Exam: This Exam (1Z0-048) is one of the Certified Expert Programs. Pre-requisite for this exam is to either have OCP 10g or you can attained any approved Oracle [...]

Oracle Database 11g, Oracle RAC , ,

← Older posts

Follow

Get every new post delivered to your Inbox.

Join 156 other followers