| dbms_stats.gather_system_stats [message #179988] |
Thu, 29 June 2006 10:34  |
alanm
Messages: 284
Registered: March 2005
|
Senior Member |
|
|
Hi All,
Can anyone please explain the parameter 'interval'. I have had a look on metalink and not had much success. I am assuming it is a time interval but not sure if it is hours, mins or seconds.
If anyone has a link to documentation, that would be appreciated.
regards
Alan
|
|
|
|
|
|
| Re: dbms_stats.gather_system_stats [message #179993 is a reply to message #179988] |
Thu, 29 June 2006 10:54  |
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
|
Senior Member |
|
|
| Quote: |
NOWORKLOAD: Will capture characteristics of the I/O system. Gathering may take a few minutes and depends on the size of the database. During this period Oracle will estimate the average read seek time and transfer speed for the I/O system. This mode is suitable for the all workloads. Oracle recommends to run GATHER_SYSTEM_STATS ('noworkload') after creation of the database and tablespaces. To fine tune system statistics for the workload use 'START' and 'STOP' or 'INTERVAL' options. If you gather both 'NOWORKLOAD' and workload specific (statistics collected using 'INTERVAL' or 'START' and 'STOP' ), the workload statistics will be used by optimizer. Collected components: cpuspeednw, ioseektim, iotfrspeed.
INTERVAL: Captures system activity during a specified interval. This works in combination with the interval parameter. You should provide an interval value in minutes, after which system statistics are created or updated in the dictionary or stattab. You can use GATHER_SYSTEM_STATS (gathering_mode=>'STOP') to stop gathering earlier than scheduled. Collected components: maxthr, slavethr, cpuspeed, sreadtim, mreadtim, mbrc.
START | STOP: Captures system activity during specified start and stop times and refreshes the dictionary or stattab with statistics for the elapsed period. Interval value is ignored. Collected components: maxthr, slavethr, cpuspeed, sreadtim, mreadtim, mbrc.
interval
Time, in minutes, to gather statistics. This parameter applies only when gathering_mode='INTERVAL'.
|
plsql packages and types reference
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
