What is the recommended interval at which to run statspack
snapshots, and why?
- 1 Answers
- 2571 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
How do you troubleshoot errors in a sql server agent job? : sql server DBA
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What authentication modes does sql server support? : sql server DBA
What are the commands used in dcl? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
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 is replication? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
Where do you find the default index fill factor and how to change it? : sql server DBA
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
What is the default fill factor value? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
