What is the recommended interval at which to run statspack
snapshots, and why?
Answer / shiva
After we have verified that STATSPACK is installed and working, we can schedule automatic data collection. By using the statsauto.sql script we can automatically schedule an hourly data collection for STATSPACK. The statsauto.sql script contains the following directive:
SQL> execute dbms_job.submit(:jobno, 'statspack.snap;',
trunc(sysdate+1/24,'HH'), 'trunc(SYSDATE+1/24,''HH'')', TRUE, :instno);
Is This Answer Correct ? | 0 Yes | 0 No |
From the database level, how can you tell under which time zone a database is operating?
What's the benefit of "dbms_stats" over "analyze"?
How does Oracle guarantee data integrity of data changes?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
You're getting high "busy buffer waits" - how can you find what's causing it?
What are the operating modes in which database mirroring runs? : sql server DBA
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
What is a system database and what is a user database? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
Where in the Oracle directory tree structure are audit traces placed?
How would you begin to troubleshoot an ORA-3113 error?