Home » Other » General » schema stats gather (win2k3 server 32bit)
schema stats gather [message #507213] Fri, 13 May 2011 03:21 Go to next message
rajubbm
Messages: 2
Registered: May 2011
Location: Mumbai
Junior Member
hi
can we increase the performance of the database by gathering schema stats regularly? is it recommended to gather schema stats after every week? pls help
Re: schema stats gather [message #507214 is a reply to message #507213] Fri, 13 May 2011 03:36 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Oracle 10g and 11g gather stats automatically every night.
If you're running an older version you should upgrade anyway.
Re: schema stats gather [message #507219 is a reply to message #507213] Fri, 13 May 2011 04:24 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please read OraFAQ Forum Guide.
Always post your Oracle version, with 4 decimals.

Regards
Michel

Re: schema stats gather [message #507491 is a reply to message #507219] Mon, 16 May 2011 05:41 Go to previous messageGo to next message
rajubbm
Messages: 2
Registered: May 2011
Location: Mumbai
Junior Member
Hi,
I am new to oracle DBA. My database version is oracle 10g(10.2.0.4)As per your advice Oracle 10g and 11g gather stats automatically every night.
But my doubt is whether it gathers schema stats for sys schema or all schema(consists of user objects) for whole database? pls help
Re: schema stats gather [message #507505 is a reply to message #507491] Mon, 16 May 2011 06:36 Go to previous message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/stats.htm#sthref1068
Previous Topic: base tables....In oracle Version 6 or 7
Next Topic: Convert oracle dmp file into ms access.
Goto Forum:
  


Current Time: Thu Mar 28 14:15:38 CDT 2024