| queries on collecting schema statistics (oracle 9i) [message #177360] |
Wed, 14 June 2006 06:06  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
Hi All,
I have a few questions on this,
1) In your project do you collect statistics on sys or system account? We have the practice of not collecting schema statistics on sys and system accounts... probably because there have been some reports of systems suffering from performance issues after collecting statistics on sys.
2) Recommended way to go about collecting schema statistics...in oracle 9i with monitoring option and gather stale/auto, it is possible to collect statistics only on tables that have significant changes. Do you collect statistics regularly on time based event like at daily or weekly interval or do you collect statistics based on dml activities? (i.e. By turning on the monitoring option etc) In the later case have you experienced any problems related to statistics?
With thanks,
Nirav
|
|
|
|
|
|
| Re: queries on collecting schema statistics (oracle 9i) [message #177397 is a reply to message #177384] |
Wed, 14 June 2006 07:41  |
orausern
Messages: 826
Registered: December 2005
|
Senior Member |
|
|
Thank you Mahesh.
we have been using time based stats collection and i am exploring risks in switching to dml based stats collection. So I wanted to know that whether that switch can lead to any unexpected issues..
also one more question is: in oracle 9i, is it possible to turn monitoring on at the DATABASE level? (so you dont have to execute 1000's of individual statements to turn on monitoring at each table?)
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
