IN ORACLE MILIEU …

Beyond Knowledge

Category Archives: Database 10g Performance Tuning

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

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 ,

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

Restoring the statistics – Oracle Database 10g

Leave a Comment Posted by on November 1, 2010

Here is the small article on how to restore the statistics on a table. Sometimes we gather stats on a table which causes it to flip the plan of a query accessing that table. It can lead to a great performance for some queries but there are situations where the query performance can degrade. Certain [...]

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

Unlocking the locked table

5 Comments Posted by on January 6, 2010

Some times we get an error while running a DDL statement on a table. something like below SQL> drop table aa; drop table aa * ERROR at line 1: ORA-14452: attempt to create, alter or drop an index on temporary table already in use This happens because some other session is using this table or [...]

Database 10g Performance Tuning, Oracle Database 10g

Identifying Locks on Objects using V$LOCKS

3 Comments Posted by on June 21, 2008

Ever wondered when a user comes to you saying that he/she cannot run a DML statement, which one should be able to run with in a second. We suspect 2 reason for the same 1) Database is terribely slow (Which cannot be the case for processing a simple update) 2) Some one is holding an [...]

Database 10g Performance Tuning , , ,

Understanding Oracle Trace Utility – Oracle Database 10g

1 Comment Posted by on December 21, 2007

Overview: Some times the situation demands more information about an event. Example if we take a case of some error coming in our database because of some application. In this case its the job of developer to drill down into the application and get the exact queries those are failing. I have seen many situations [...]

Database 10g Performance Tuning

Oracle Corporate timeline

Leave a Comment Posted by on October 28, 2007

I was going through some sites and found a good information regarding the events that happened in the past and which brought up Oracle to this place. Thats being a long journey of Oracle business spreading right from database to application and middle tier architecture. Here are the brief events I have listed. 1979: Larry [...]

Database 10g Performance Tuning

Database Wait Statistics – Oracle Database 10g

2 Comments Posted by on June 29, 2007

When a SQL is submitted by a user to Oracle database, it never happens that Oracle will execute the SQL continuously at one go. Oracle process never get to work on the execution of statement without any interruptions. Often the process has to pause or wait for some event or some other resource to be [...]

Database 10g Performance Tuning

← Older posts

Follow

Get every new post delivered to your Inbox.

Join 136 other followers