Home » SQL & PL/SQL » SQL & PL/SQL » Analyze table
icon5.gif  Analyze table [message #238264] Thu, 17 May 2007 04:30 Go to next message
Messages: 24
Registered: March 2007
Junior Member
Hi everyone, i've been thinking.

While my jobs is inserting or updating data into table named TB1, can i analyze table TB1?

Thank you
Re: Analyze table [message #238267 is a reply to message #238264] Thu, 17 May 2007 04:42 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot use ANALYZE (you can but there are locks and some are queued) but you can use DBMS_STAT package.

Actually, it depends on the version and the analyze you want. In 10.2, analyze no more take lock to get statistics (I don't remember when this behaviour started). But it still gets locks if you use other options, "validate structure" for instance.


[Updated on: Thu, 17 May 2007 04:50]

Report message to a moderator

Previous Topic: NOLOCK?
Next Topic: SQL query do not show all records ...
Goto Forum:

Current Time: Wed Aug 23 22:12:58 CDT 2017

Total time taken to generate the page: 0.04970 seconds