Database Tuning (MOSC)

MOSC Banner

Query waiting on index

edited Jun 17, 2011 11:56PM in Database Tuning (MOSC) 7 commentsAnswered
 One of our developers complains that a session just hung there. I was able to catch the sql statement with the OS pid and got the execution plan. It is using index scan, but somehow, the query is waiting on the index. My database version is 10.2.0.3 on solaris 10. The table has 668042 rows in it. Below is the statement and the plan:

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
SQL_ID  5456tabbxjbwy, child number 0
-------------------------------------
SELECT /*+FIRST_ROWS INDEX_ASC(a ttiitm952100$idx3)*/
a.t$copt$1,a.t$copt$2,a.t$copt$3,a.t$copt$4,a.t$copt$5,a.t$copt$6,a.t$copt$7,a.t

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center