Name three advisory statistics you can collect.



Name three advisory statistics you can collect...

Answer / chowdary

Buffer Cache Advice, Segment Level Statistics and Timed
Statistics

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More DB Administration Interview Questions

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,


If we issue alter database begin backup. What happens to database?

2 Answers  


i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,


Explain the difference between a data block, an extent and a segment.

2 Answers  


What authentication modes does sql server support? : sql server DBA

0 Answers  






What are the recovery models for a database? : sql server DBA

0 Answers  


How would you go about increasing the buffer cache hit ratio?

2 Answers  


Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  


Describe what redo logs are.

1 Answers  


what is the difference between hot backup n rman backup?

1 Answers   Value Labs,


Where would you look for errors from the database engine?

0 Answers   IBM,


Why would you use sql agent? : sql server DBA

0 Answers  


Categories