Hi,
There is an etl job within the system which drops partitions from a partitioned table then updates global indexes.
Often we use sql similar to below to determine progress of some sqls.
Donnot see this running when look at sql below but looks to be when look in oracle enterprise manager
Using 11.2.0.3
select distinct v.SID, v.SQL_ID, vs.SQL_TEXT
from v$sql_plan_monitor v,v$sql vs
where
v.STATUS = 'EXECUTING'
and
v.SQL_ID = vs.SQL_ID
Is there a way to determine how far it has got in terms of percentage complete?
Thanks