Topic : Performance Tuning

Explain an ORA-01555


Answer :

You get this error when you get a snapshot too old within rollback. It can usually be solved by increasing the undo retention or increasing the size of rollbacks. You should also look at the logic involved in the application getting the error message.

Show Answer Discuss

Name three advisory statistics you can collect.


Answer :

Buffer Cache Advice; Segment Level Statistics; & Timed Statistics

Show Answer Discuss

Where in the Oracle directory tree structure are audit traces placed?


Answer :

In unix $ORACLE_HOME/rdbms/audit; in Windows the event viewer

Show Answer Discuss

Give two methods you could use to determine what DDL changes have been made.


Answer :

You could use Logminer or Streams

Show Answer Discuss

How can you gather statistics on a table?


Answer :

The ANALYZE command.

Show Answer Discuss