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 are the data types in oracle?
How to invoke the data pump import utility?
17. Display the order number and average item cost for each order.
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
What is integrity and what is constraint??Explain with example
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example
How do I uninstall oracle client from windows?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.
Describe an oracle table?
List out the components of logical database structure of oracle database.