Oracle data dictionary and dynamic performance views
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! ! !
Related Posts of Oracle data dictionary and dynamic performance views
-
ORACLE table space-related operations
sqlplus / nolog connect / as sysdba startup sqlplus / nolog connect / as sysdba SHUTDOWN IMMEDIATE If you want to use windows default date format. English is not in the configuration variables in the environment: NLS_LANG american_america.us7ASCII - ...
-
Oracle database used to maintain day-to-day command
Oracle database used to maintain day-to-day command At run-time Oracle database, DBA should run the database log and table space for the use of surveillance, early detection of problems that exist in the database. One, Oracle log file monitoring warn ...
-
Oracle10g ASM database table space maintenance
1. Default naming Oracle when using ASM + OMF management, Oracle distribution file name will automatically create the appropriate file. Our job to create table space can be simplified as follows: A command. The following are the default Oracle naming ...
-
SQL optimization (5) - commonly used test hints
First, the purpose of testing SunnyXu in accordance with the "SQL Performance adjust - summarized," commonly used to test the following four categories of hints: 1. The method of instruction optimizer hints with the aim ALL_ROWS: Based on t ...
-
use sqlldr 1 Introduction
The customer is always asked for two days to a number of temporary table to import text data, sql * loader is also not very familiar with the FREE today to sum up. General to set up two files: Control files and data files, if the data can also be les ...
-
Turning optimization oracle article
DB_BLOCK_LRU_LATCHES = 6 BUFFER_POOL_KEEP = (BUFFERS: 14000, LRU_LATCHES: 1) BUFFER_POOL_RECYCLE = (BUFFERS: 2000, LRU_LATCHES: 3) ... Note: buffer_pool_buffers = 2000 * 3 +14000 * 1 = 20000 keep the district will once again be used to retain the use ...
-
Block Oracle paragraph (reprint)
Starting today, begin reading the second oracle document b10743, "conceps"; do not know can give me a new harvest. The master was oracle's Michele Cyran characters written by people such as cow, a really good book. Alas English not well ...
-
Troubleshooting: the physical set up the backup database
Articles connected to "Fault Diagnosis: A physical backup of database", in the articles on which there is mentioned that in good physical backup of the database set up after the main database found to be unable to synchronize the archive lo ...













Leave a Reply