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

Report message to a moderator

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: 10707
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);

Report message to a moderator

Previous Topic: Improving data loading into tables
Next Topic: Negative Number for Logical Reads on Statspack Report
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jun 27 19:02:50 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.