NaturalOracle DataGaurd tutorial Series Coming Soon!! Natural
For Any queries, please mail us at support@funoracleapps.com

Finding time required for Gather Stats

No comments
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;





No comments :

Post a Comment