Question
Answer
Oracle 10g automatic statistics job is scheduled to run every night except weekends. If discoveries are scheduled on weekends. It is suggested to change the statistics schedule to run every night, so slow performance is not observed on Mondays.
For Oracle 9i use the following for statistics
AD-HOC STATISTICS JOB:
To run the statistics job ad-hoc, log in via SQLPlus as the system account, and run the following command:
- begin DBMS_STATS.GATHER_SCHEMA_STATS (ownname => '<name of mam's oracle user>', cascade => TRUE) ; end;
Alternatively, the statistics job can be installed by running the create_statistics_job.bat script under <MAM 6.x install path>\J2F\CMDB\dbscripts\oracle or <UCMDB 7.x install path>\J2F\CMDB\dbscripts\oracle\utils with the following syntax:
- create_statistics_job.bat <schema> <password> <db alias> <hour>
- select job from user_jobs where upper(what) like '%GATHER_SCHEMA_STATS%';
exec dbms_job.run(<job number from above>);
It is recommended to run scheduled statistics job every night.
For details please use the Database Guide available with the product. Refer to Deploying and Maintaining MS SQL or Oracle Server Chapter in the document.
For MAM 6.x refer to MAMPrepare.pdf for UCMDB 7.x refer to DatabaseGuide.pdf