What is STATSPACK tool?
Answers were Sorted based on User's Feedback
Answer / myway
It is basically used in performance tuning. It is used to
get input/op statistics especially being the top five
waiting events.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / pankaj
STATSPACK is a set of tools that captures and reports on
database statistics.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rajesh chadalawada
Statspack is an performance evaluation report used for
verifing load on the server,SGA utilization,wait events and
resource consuming SQL
| Is This Answer Correct ? | 0 Yes | 2 No |
what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval
How to sort output in descending order in oracle?
Is oracle an open source?
What is BBED in Oracle?
What is the difference between formal parameters and actual parameters?
How do I recompile a procedure in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
How to run create database statement?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to retrieve values from data fields in record variables?
What are the factors causing the reparsing of SQL statements in SGA?
What are the factors causing the reparsing of SQL statements in SGA?