IN ORACLE MILIEU …

Beyond Knowledge

Category Archives: Oracle Database 10g

Oracle SQL Plan Management – Part 1

3 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 , , , ,

Exchange Partition in Oracle

5 Comments Posted by on March 30, 2011

Some times we faced a need to convert our existing table from non-partition table to a partition table or vice-versa. Or moving a partition of one partition table to another partition. Or make one of the table as a partition of some partition table. Or make a partition of one of the partition table as [...]

Oracle Database 10g, Oracle Database 9i , ,

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 , ,

WARNING: inbound connection timed out (ORA-3136)

Leave a Comment Posted by on March 17, 2011

Many times I faced this issue “WARNING: inbound connection timed out (ORA-3136)” in alert log and if you are using data guard, then you can see that dgmgrl status will show failed because standby is not able to sync up with primary. The “WARNING: inbound connection timed out (ORA-3136)” in the alert log indicates that [...]

ORA Errors, Oracle Database 10g , , ,

Checking Database Growth Trend

6 Comments Posted by on January 7, 2011

One of the simple way to find the growth of the database is using v$datafile view. following is the simple query and its output which gives the growth trend in month and year

Oracle Database 10g , ,

Analyze Index Vs. Gather_Index_Stats – Oracle Database 10gp

Leave a Comment Posted by on November 1, 2010

One of the difference I noticed about analyze index command and gather_index_stats procedure is that when we use analyze index command if updates the index statistics with number of leaf blocks equals the number of leaf blocks below HWM. However if we use gather_index_stats statistics shows number of leaf blocks equals number of leaf blocks [...]

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

Row Chaining and Migeration

Leave a Comment Posted by on November 1, 2010

Overview If you notice poor performance in your Oracle database Row Chaining and Migration may be one of several reasons, but we can prevent some of them by properly designing and/or diagnosing the database. Row Migration & Row Chaining are two potential problems that can be prevented. By suitably diagnosing, we can improve database performance. [...]

Database 10g Performance Tuning, Oracle Database 10g ,

Oracle Database Lite 10g (OLite 10g)

Leave a Comment Posted by on November 1, 2010

Introduction Oracle Database Lite 10g extends the power of grid computing to a mobile workforce with a complete, integrated, secure database for building, deploying, and managing mobile applications for a broad range of mobile devices. Oracle Database Lite 10g enables persistent access to critical information and applications without requiring continuous connectivity to back-end enterprise systems. [...]

Oracle Database 10g ,

Multiple Database Block Sizes and the Buffer Cache

Leave a Comment Posted by on November 1, 2010

In oracle 10g we can have multiple block sizes at the same time. When a tablespace is created we can assign a block size for the objects that will be created in that tablespace. The DB_BLOCK_SIZE parameter in your initialization parameter file determines the size of your standard block size in the database and frequently [...]

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

← Older posts

Follow

Get every new post delivered to your Inbox.

Join 136 other followers