Dynamic Performance Views

 

Dynamic performance views are based on virtual tables

that are built from memory structures inside the database server.

That is, they are not conventional tables that reside in a database.

This is why some of them can show you data before a database is mounted or open.

 

Dynamic performance views include information about:

•Sessions

•File states

•Progress of jobs and tasks

•Locks

•Backup status

•Memory usage and allocation

•System and session parameters

•SQL execution

•Statistics and metrics

 

 

-Usage Examples

  SQL> select name from v$tempfile;

  SQL> select name from v$tablespace;

  SQL> select member from v$logfile;

  SQL> select name from v$controlfile;

 

 

 

-oracle DBA 10g workshop I-