SQL Performance (MOSC)

MOSC Banner

delete operation take long time.

edited Sep 7, 2013 10:55AM in SQL Performance (MOSC) 22 commentsAnswered
table has 11 lac records. 
delete operation take long time. how to get rid of this issue..?

while investigation using below SQL..

TTITLE "ITL-Waits per table (INITRANS to small)"
set pages 1000
col owner format a15 trunc
col object_name format a30 word_wrap
col value format 999,999,999 heading "NBR. ITL WAITS"
--
select owner,
       object_name||' '||subobject_name object_name,
       value
  from v$segment_statistics
 where statistic_name = 'ITL waits'
 and value > 0
order by 3,1,2;
--
col owner clear
col object_name clear
col value clear
ttitle off
/

OWNER                          OBJECT_NAME                                                        VALUE
------------------------------ ------------------------------------------------------------- ----------
REGISTRY                       SLT_STATUS_PK                                                          1
REGISTRY                       SLT_OBJECTIVE_PK                                                       2

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