Buffer Cache Advice, Segment Level Statistics and Timed Statistics

Name three advisory statistics you can collect.

Question Posted / chowdary

Answer Posted / chowdary

Buffer Cache Advice, Segment Level Statistics and Timed
Statistics

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

958

how can you connect from 10g user to 11g user??

2064

What happens on checkpoint? : sql server DBA

1037

how can you enable flashback feature?

896

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3699

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2279

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3348

how can you communicate with operating system files from oracle?

984

how can you find out if a table can be redefined?

964

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

2367

What are the different sql server versions you have worked on? : sql server DBA

966

How would you extract DDL of a table without using a GUI tool?

2443

How would you go about verifying the network name that the local_listener is currently using?

3161

What would you do with an "in-doubt" distributed transaction?

1833

What are the commands used in dcl? : sql server DBA

997