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 |
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is sequence?
What is the usage of analyze command in oracle?
Can we call a trigger inside a function and function inside a trigger? Give example.
Display Odd/ Even number of records?
What is a nvl function? How can it be used?
Explain the use of inctype option in exp command.
Q1:code to connect to sql server(database) through jdbc application. Q2:code to connect to Mysql(database) through jdbc application. Q3:code to connect to oracle(database) through jdbc application.
What is a connect identifier?
What is oracle open database communication (odbc)?
What would you use to improve performance on an insert statement that places millions of rows into that table?
What are the advantages of oracle 12c?