Interested to Buy Any Domain ? << Click Here >> for more details...
What is the recommended interval at which to run statspack
snapshots, and why?
- 1 Answers
- 3344 Views
- I also Faced
- E-Mail Answers
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
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
What purpose does the model database server? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
How do you open a cluster administrator? : sql server DBA
What is fill factor? : sql server DBA
What is replication? : sql server DBA
how can you create a user-defined lock?
what is ora 24313?what is the procedure to exclude that error?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What are the commands you'd issue to show the explain plan for "select * from dual"?
What the different topologies in which replication can be configured? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Can you redefine a table online?
which background process invoke at the time of upgradation tell me???
