OraFAQ Forum: Performance Tuning » AUDIT ANALYZE TABLE on 9i database?

Home » RDBMS Server » Performance Tuning » AUDIT ANALYZE TABLE on 9i database? (9.2.0.8)

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

AUDIT ANALYZE TABLE on 9i database? [message #503815]

Tue, 19 April 2011 15:24

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

I trying to help some DBAs I support to get a handle on statistics collectionn in their data warehouses. It seems developers have created several ANALYZE TABLE jobs but the code for these is not stored as PLSQL in the database and thus it is problematic for statistics collection. Even if we collect stats that way we want, these jobs kick in and overlay the statistics we collect every day.

What suggestions can you guys provide to find and stop these ANALYZE TABLE commands from happening?

Is there a way to AUDIT ANALYZE TABLE? I can't find it anywhere.

Is there a way to gobally turn of ANALYZE TABLE in a 9i database?

Kevin

Report message to a moderator

Re: AUDIT ANALYZE TABLE on 9i database? [message #503821 is a reply to message #503815]

Tue, 19 April 2011 23:08

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Same answer for both question DDL trigger on ANALYZE.

Regards
Michel

Report message to a moderator

Re: AUDIT ANALYZE TABLE on 9i database? [message #503911 is a reply to message #503821]

Wed, 20 April 2011 06:08

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

Thanks. I could not find this when I went searching. Just what I expected should have been there.

Kevin

Report message to a moderator

Previous Topic:	High CPU Utilization in RAC and Log file sequential Read Event
Next Topic:	Kill the process

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Nov 24 21:02:35 CST 2024