OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » Analyzed table (Oracle 8i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Analyzed table [message #563164]

Thu, 09 August 2012 03:46

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.

Report message to a moderator

Re: Analyzed table [message #563165 is a reply to message #563164]

Thu, 09 August 2012 03:58

Michel Cadot
Messages: 68455
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

Report message to a moderator

Re: Analyzed table [message #563296 is a reply to message #563165]

Sat, 11 August 2012 10:38

BlackSwan
Messages: 26766
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.

Report message to a moderator

Previous Topic:	How to determine slowness in I/O from AWR?
Next Topic:	Query tuning help

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 10 08:36:30 CDT 2023