Interested to Buy Any Domain ? << Click Here >> for more details...
What is STATSPACK tool?
- 3 Answers
- 9388 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
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?
How do you ensure database security?
what are the default admin accounts in Oracle 10g ?
What is where clause in oracle?
Explain an index segment?
What is transport network substrate (tns) in oracle?
What WHERE CURRENT OF clause does in a cursor?
What is rowid and rownum in oracle?
Explain the use of owner option in exp command.
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
how to use sequence and what use of sequence cache
What are a query and state the different types of queries and their uses?
Oracle General 
