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 |
When a user process fails, what background process cleans up after it?
what do you understand by flashback feature of oracle?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
How to determine the service pack currently installed on SQL Server?
What command would you use to encrypt a PL/SQL application?
Give the two types of tables involved in producing a star schema and the type of data theyhold.
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
Explain how you would restore a database using RMAN to Point in Time?
currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba
What is blocking and how would you troubleshoot it?
What is transparent data encryption? : sql server DBA