What is the recommended interval at which to run statspack
snapshots, and why?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
what is logical system in sap basis
what are the types of connection load-balancing?
What the different topologies in which replication can be configured? : sql server DBA
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
what do you understand by fine-grained auditing?
How can you control the amount of free space in your index pages? : sql server DBA
What are the different types of indexes available in sql server? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you schedule a job in database?
What types of replication are supported in sql server? : sql server DBA
what is asm?
Explain about your sql server dba experience? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA