| Analyze schema [message #393220] |
Fri, 20 March 2009 15:02  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Hello All,
I need to analyze the schema .When I gave this
EXEC DBMS_STATS.gather_schema_stats('CRG', estimate_percent => 30);
It's taking more than 30 mins for now. I don't know if it got hanged . Can i cancel the operation and do it all over or is there any other command for analyzing the schema.
Kindly help .
|
|
|
|
|
|
| Re: Analyze schema [message #393229 is a reply to message #393221] |
Fri, 20 March 2009 15:24  |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
Only very few tables and indexes have got the new analyzed date which I could find from
> select table_name,last_analyzed from user_tables;
And now it's 1 hour. Can I cancel that operation and give the syntax all over .
Is there anything wrong with the syntax.
I heard that dbms_stats is much faster that dbms_utility , but this is taking a long time .
Please help me out .
[Updated on: Fri, 20 March 2009 15:27] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Analyze schema [message #393238 is a reply to message #393235] |
Fri, 20 March 2009 15:46 |
rsreddy28
Messages: 295
Registered: May 2007
|
Senior Member |
|
|
There are around 500 tables and 1000 Indexes. But as I told you earlier now it's near to 2 hours that I gave that syntax .
When I gave
SQL> select table_name,last_analyzed from user tables;
I could see very few tables that got analyzed and other tables are totally blank.
And as of now nobody is working on this now. I did the same last time , it hardly took 30 mins . Don't where it's going wroing.
Kindly help me out.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
