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 |
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What happens if you lost a data file?
Explain about your project and its relation to the current job position you are applying to?
Difference between the “verify” and “feedback” command?
What is truncate oracle?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
What is the database name in oracle?
what are the differen between key flexifild and discriptive fiexifild.
Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.
how to retrieve data from different tables ,place this data in different excel worksheets.
why dont we assign not null constraint as table level constraint.
Explain what are the different type of segments?