Home » RDBMS Server » Performance Tuning » After Collecting Statistics database is very very slow (Oracle Enterpride Edition, 9.2.0.1.0 , Windows)
After Collecting Statistics database is very very slow [message #301119] Tue, 19 February 2008 04:20 Go to next message
GaneshRamadoss
Messages: 5
Registered: February 2008
Junior Member
These days there no statistics for our database, recently we have collected the stats for our entire application schema , but after stats the query which is used to complete in 1 min has gone to 7 min. So can somebody help why is it ?

Command Used

exec dbms_stats.gather_schema_stats ('Schema_name', cascade => TRUE);

Thanks in Advance

Regards
GaneshRamadoss
Re: After Collecting Statistics database is very very slow [message #301151 is a reply to message #301119] Tue, 19 February 2008 06:02 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Try this
exec dbms_stats.gather_schema_stats ('Schema_name',method_opt=>'For all indexed columns size 250', cascade => TRUE);
Previous Topic: Improving data loading into tables
Next Topic: Negative Number for Logical Reads on Statspack Report
Goto Forum:
  


Current Time: Fri Dec 09 12:03:43 CST 2016

Total time taken to generate the page: 0.10766 seconds