If we run gather schema stats and want to the progression then we can check by the below query.
SELECT *
FROM v$session_longops
WHERE opname LIKE '%Gather Schema Statistics%';
For gather table stats the opname will be like Table Scan.
We can get the unique session id and then also we can check the time required.
SELECT
SID,SERIAL#,OPNAME,TOTALWORK,START_TIME,TIME_REMAINING,ELAPSED_SECONDS,message FROM v$session_longops
WHERE SID=6844;
FROM v$session_longops
WHERE opname LIKE '%Gather Schema Statistics%';
For gather table stats the opname will be like Table Scan.
We can get the unique session id and then also we can check the time required.
SELECT
SID,SERIAL#,OPNAME,TOTALWORK,START_TIME,TIME_REMAINING,ELAPSED_SECONDS,message FROM v$session_longops
WHERE SID=6844;
Post a Comment
Post a Comment