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 |
Explain the use of analyse option in exp command.
Explain an integrity constrains?
Explain the use of full option in exp command.
What is the difference between sharding and partitioning?
How to rename a column in an existing table?
How to set a transaction to be read only in oracle?
What is archive log in Oracle?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
How to list all indexes in your schema?
Which is better Oracle or MS SQL? Why?
what is port in oracle? how is it related to database application.
What is columnar storage what is the advantage?