Topic : Performance Tuning

How do you disable monitoring of a table?


Answer :

Alter table tablename no monitoring

Show Answer Discuss

How do you check the status of the table whether monitoring or not?


Answer :

Select table_name; monitoring from dba_table where owner='scott;

Show Answer Discuss

Assume you work in an xyz company as senior DBA and on your absence your back up DBA has corrupted all the control files while working with the ALTER DATABASE BACKUP CONTROLFILE command. What do you do?


Answer :

- As long as all data files are safe and on a successful completion of BACKUP control file command by your Back up DBA you are in safe zone.
- We can restore the control file by performing following commands
1. CONNECT INTERNAL STARTUP MOUNT
2

Show Answer Discuss

Name some of the important dynamic performance views used in Oracle.


Answer :

- V$Parameter
- V$Database
- V$Instance
- V$Datafiles
- V$controlfiles
- V$logfiles

Show Answer Discuss

How would you go about generating an EXPLAIN plan?


Answer :

Create a plan table with utlxplan.sql.
Use the explain plan set statement_id = ?tst1? into plan_table for a SQL statement
Look at the explain plan with utlxplp.sql or utlxpls.sql

Show Answer Discuss