Stay at Home!! Be Safe!! Take Care!!

For Any queries, please mail us at support@funoracleapps.com

Finding time required for Gather Stats

2 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;





2 comments :

  1. Wow i can say that this is another great article as expected of this blog.Bookmarked this site.. reservations.com

    ReplyDelete
  2. Hi, I find reading this article a joy. It is extremely helpful and interesting and very much looking forward to reading more of your work.. buy insta likes

    ReplyDelete