Oracle data dictionary and dynamic performance views

Posted on 2010-02-04 filed under: Oracle (RSS) 13 views

Common data dictionary:

dba_data_files: usually used to query the information on the database file

dba_db_links: in all databases including database links, which is databaselinks.

dba_extents: a database of information on all partitions

dba_free_space: the freedom of all the table space partition

dba_indexs: all the indexes on the database description

dba_ind_columns: In all tables and clustered indexes on the column compression

dba_objects: all the objects in the database

dba_rollback_segs: rollback segment description

dba_segments: All database storage sub-paragraph

dba_synonyms: on the synonym of Information Query

dba_tables: database, a description of all the data tables

dba_tabespaces: The information on the table space

dba_tab_columns: description of all the tables, views, and gathered out

dba_tab_grants / privs: object permissions granted
dba_ts_quotas: all user table space quota

dba_users: With regard to the data for all users of information
dba_views: a database of all the text view

Commonly used dynamic performance views

v $ datafile: the database used data file information

v $ librarycache: shared pool SQL statement, the management information
v $ lock: access the database through the session, set the object lock all of the information

v $ log: from the control file to extract the information related to redo log group
v $ logfile group of the instance to reset the log file name and location information

v $ parameter: initialization parameter file, the value of all the items
v $ process: the current process of information

v $ rollname: rollback segment information,

v $ rollstat: Online rollback Statistics

v $ rowcache: in-memory data dictionary activity / performance information

v $ session: the session information

v $ sesstat: In the v $ session to report on the current session of the statistical information

v $ sqlarea: shared pool using the current cursor statistics, the cursor is a memory region that Oracle open when dealing with SQL statements.

v $ statname: in the v $ sesstat reported the meaning of the various statistics

v $ sysstat: based on the current operating system session conducted by Statistics
v $ waitstat: a database of more than one session to access the data in detail. When there is more than one session to access the same information, there may be waiting for the situation.

Summarizes how these completely different from the views and data dictionary, is not so easy to confuse. Hei hei! ! !