Home » SQL & PL/SQL » SQL & PL/SQL » Statistics time determination (10.2.0.2.0 ,windows)
Statistics time determination [message #431666] Thu, 19 November 2009 00:41 Go to next message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member


Hi all,

While statistics is in progress how to determine the time taken/time left out to complete ?


Regards,
Re: Statistics time determination [message #431667 is a reply to message #431666] Thu, 19 November 2009 00:53 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The best you can have is in v$session_longops.

Regards
Michel
Re: Statistics time determination [message #431668 is a reply to message #431667] Thu, 19 November 2009 01:04 Go to previous messageGo to next message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member


can you provide me the query for this??


Thanks
Re: Statistics time determination [message #431669 is a reply to message #431668] Thu, 19 November 2009 01:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you post what you tried?

Regards
Michel
Re: Statistics time determination [message #431671 is a reply to message #431669] Thu, 19 November 2009 01:10 Go to previous messageGo to next message
Hitman11
Messages: 94
Registered: October 2009
Location: norway
Member


hi,


exec DBMS_STATS.GATHER_SCHEMA_STATS(ownname => 'TEST', estimate_percent => 30);
Re: Statistics time determination [message #431678 is a reply to message #431671] Thu, 19 November 2009 02:03 Go to previous message
Michel Cadot
Messages: 64121
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No what you tried from what I posted.
Did you at least have a look at the view description?

Regards
Michel
Previous Topic: Issue while creating Materialized View
Next Topic: Not able to see package body only able to see specfication
Goto Forum:
  


Current Time: Wed Dec 07 03:21:22 CST 2016

Total time taken to generate the page: 0.09518 seconds