Home » RDBMS Server » Performance Tuning » Analyzed table (Oracle 8i)
Analyzed table [message #563164] Thu, 09 August 2012 03:46 Go to next message
shyamu
Messages: 30
Registered: September 2011
Location: HYD
Member
Hi,

How can i find the last user analysed particualr table ?

I can able to find last analyzed date, but can't able find the which user has done it.

Thanks,
Shyamu.A.
Re: Analyzed table [message #563165 is a reply to message #563164] Thu, 09 August 2012 03:58 Go to previous messageGo to next message
Michel Cadot
Messages: 67241
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
How can i find the last user analysed particualr table ?


No way unless you set audit on ANALYZE TABLE.

Regards
Michel
Re: Analyzed table [message #563296 is a reply to message #563165] Sat, 11 August 2012 10:38 Go to previous message
BlackSwan
Messages: 26722
Registered: January 2009
Location: SoCal
Senior Member
>(Oracle 8i)
V8 has been obsoleted & unsupported this whole Century.
Please join the 21st Century at your earliest convenience.
Previous Topic: How to determine slowness in I/O from AWR?
Next Topic: Query tuning help
Goto Forum:
  


Current Time: Sun Jul 12 02:44:18 CDT 2020