IN ORACLE MILIEU …

Beyond Knowledge

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

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

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

2010 in review

Leave a Comment Posted by on January 3, 2011

The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health: The Blog-Health-o-Meter™ reads Wow. Crunchy numbers The Louvre Museum has 8.5 million visitors per year. This blog was viewed about 260,000 times in 2010. If it were an exhibit at [...]

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

Oracle E-Business Suite R12 – Profiles

1 Comment Posted by on November 1, 2010

Profile Options in Oracle Application Object Library This section lists each profile option in Oracle Application Object Library. These profile options are grouped into categories based on their functional area and are available to every product in Oracle Applications. For each profile option, we give a brief overview of how Oracle Application Object Library uses [...]

Oracle Application R12 ,

Oracle Apps 11i – Profiles

Leave a Comment Posted by on November 1, 2010

Profile Options in Oracle Application Object Library This section lists each profile option in Oracle Application Object Library. These profile options are available to every product in Oracle Applications. For each profile option, we give a brief overview of how Oracle Application Object Library uses the profile’s setting. Unless otherwise noted, a profile option uses [...]

Oracle Applications 11i

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 ,

← Older posts

Newer posts →

Follow

Get every new post delivered to your Inbox.

Join 156 other followers