Home » SQL & PL/SQL » SQL & PL/SQL » Schema analyzed (oracle 10g)
Schema analyzed [message #355065] Wed, 22 October 2008 07:40 Go to next message
pointers
Messages: 410
Registered: May 2008
Senior Member
Hi,

How can we know wether a schema is analyzed or not..Is there any data dictionary for it.

Regards,
Pointers.
Re: Schema analyzed [message #355066 is a reply to message #355065] Wed, 22 October 2008 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
select table_name from dba_tab_columns where column_name='LAST_ANALYZED' order by 1;

Regards
Michel
Re: Schema analyzed [message #355072 is a reply to message #355065] Wed, 22 October 2008 08:24 Go to previous messageGo to next message
pointers
Messages: 410
Registered: May 2008
Senior Member
Hi micheal, i dont understand how will this answer my question..
I want to find whether or not a schema analyzed like for a single table we look at
select owner,table_name,LAST_ANALYZED from all_tables

something like this is there any way to get at schema level..

Regards,
Pointers.
Re: Schema analyzed [message #355087 is a reply to message #355072] Wed, 22 October 2008 10:41 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Execute the query and study its output.

Regards
Michel
Previous Topic: xmlelement
Next Topic: problem in ordering query
Goto Forum:
  


Current Time: Mon Dec 05 23:46:50 CST 2016

Total time taken to generate the page: 0.26425 seconds