delete operation take long time.
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
0