Home » RDBMS Server » Performance Tuning » Statistics on tables.
Statistics on tables. [message #65156] Tue, 25 May 2004 08:44 Go to next message
Gopinath. m
Messages: 2
Registered: March 2003
Junior Member
Hi,

I have a issue with statistics in my Oracle 9.2.0.4.0. I made ESTIMATE STATISTICS on my tables.  My database needs oftenly refreshing the statistics.  If not, the queries are performing slow.  I made it to refresh twice a day.  But still then the queries are slow.  Now its becoming serious.

FYI: cost based optimizer

OS : solaris 5.9

If a query performs really very slow, when i refresh the statistics on the table and perform the same query  it comes back fast.  I dont understand why its happening..

Need ur advice

thanks in advance.

 

 

 

Gopinath. M

 

 

 
Re: Statistics on tables. [message #65157 is a reply to message #65156] Tue, 25 May 2004 13:42 Go to previous message
sverch
Messages: 582
Registered: December 2000
Senior Member
How you estimate statistics and when (before or after your tables were refreshed)?
Previous Topic: performance
Next Topic: Statspack Viewer Enterprise for Oracle10g
Goto Forum:
  


Current Time: Sat Mar 02 16:50:41 CST 2024