Oracle commonly used fool problem 1000 questions
1. Initial password after the Oracle installation? InterNal / Oracle Sys / Change_on_install system / manager scott / tiger sysman / oem_temp
2. Oracle9ias web cache's initial default user and password? Administrator / Administrator
3. How to create a database in Oracle 8.0.5? Use ORAINST. If there is a MotiF interface, you can use ORAINST / M
4. ORACLE 8.1.7 How to create a database? DBASSIST
5. How do Oracle 9i creates a database? DBCA
6. What is the bare device in Oracle? The bare equipment is the storage space that bypasses the file system directly.
7. How can Oracle distinguish between 64-bit / 32bit versions? $ SQLPLUS '/ AS SYSDBA' SQL * PLUS: Release 9.0.1.0.0 - Production on Mon Jul 14 17:01:09 2003 (c) Copyright 2001 Oracle Corporation. All Rights Reserved. Connected to: Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production with The Partitioning Option JServer Release 9.0.1.0.0 - Production SQL> SELECT * FROM V $ Version; Banner ------------- -------------------------------------------------- - Oracle9i Enterprise Edition Release 9.0.1.0.0 - Production PL / SQL Release 9.0.1.0.0 - Production Core 9.0.1.0.0 Production TNS for Solaris: Version 9.0.1.0.0 - Production NLSRTL Version 9.0.1.0.0 - Production SQL>
8. What does SVRMGR mean? SVRMGRL, SERVER MANAGER 9i is not, it has been changed to SQLPlus / Nolog to archive log type with SQLPLUS
9. How do I distinguish which machine login from Oracle? Select Machine, Terminal from V $ session;
10. What statement is used inquate? DESC TABLE_NAME You can query the structure of the table SELECT FIELD_NAME, ... from ... You can query the value of the field Select * from all_tables where table_name like '%' SELECT * ALL_TAB_COLUMNS where TABLE_NAME = '??'
11. How to get a trigger, process, and function creation script? DESC User_Source User_Triggers
12. How to calculate the size of a space occupied? select owner, table_name, NUM_ROWS, BLOCKS * AAA / 1024/1024 "Size M", EMPTY_BLOCKS, LAST_ANALYZED from dba_tables where table_name = 'XXX'; Here: AAA is the value of db_block_size; XXX is the table name you want to check 13 How do I view the maximum number of sessions? Select * from v $ parameter where name limited 'proc%'; SQL> SQL> Show parameter processes name type value -------------------------- ---------- ---------------------------------- AQ_TM_Processes INTEGER 1 DB_Writer_Proces INTEGER 1 JOB_QUE_PROCESS INTEGER 4 log_archive_max_processes INTEGER 1 Processes Integer 200 is 200 users. Select * from v $ license; where the sessions_highwater record has reached the maximum number of sessions 14. How do I check the system locked transaction time? Select * from v $ locked_Object; 15. How to run Oracle in the way ArchiveLog? Init.ora log_archive_start = True Restart Database 16. How do I get what users are using the database? SELECT UserName From V $ session; 17. How much is the maximum number of fields in the data table? The maximum number of columns in the table or view is 1000 18. How to find the database's SID? Select Name from V $ database; you can also view init . ORA file 19. How to view this machine IP address in the Oracle server? Select sys_context ('useerenv', 'ip_address') from dual; if it is logged to the local database, only 127.0.0.1 20. Unix Adjust the time of the database? Su -root Date -u 08010000 21. How to grab the MEMO type bar in Oracle Table as an empty data record? Select Remark from OMS_FlowRec Where Trim ('' from remark) is not null; 22. How to use the BBB table Update the data of the AAA table (associated field) Update aaa set bns_snm = (select bns_snm from bbb where aaa.dpt_no = bbb.dpt_no) where bbb.dpt_no is
NOT NULL; 23. P4 Computer installation method change symcjit.dll to sysmcjit.old 24. How to query Server is OPS? SELECT * from V $ Option; if Parallel Server = true has OPS 25. How to query each user ? permissions SELECT * FROM DBA_SYS_PRIVS; 26. how to move a table table space ALTER tABLE TABLE_NAME mOVE TABLESPACE_NAME;? 27. how to move the index table space ALTER iNDEX INDEX_NAME REBUILD tABLESPACE TABLESPACE_NAME;? 28. how to start the DBA STUDIO under LINUX, UNIX OEMAPP DBASTUDIO 29. The subject of the query lock is available? V $ LOCK, V $ locked_Object, V $ session, v $ sqlarea, v $ process; check the list of locks: Select S.SID session_id, S.Username, Decode (LMODE, 0, 'NONE', 1, 'NULL', 2, 'ROW-S (SS)', 3, 'ROW-X (SX)', 4, 'Share', 5, 'S / ROW -X (SSX) ', 6,' Exclusive ', to_char (lmode)) mode_held,
Decode (Request, 0, 'None', 1, 'Null', 2, 'Row-S (SS)', 3, 'ROW-X (SX)', 4, 'Share', 5, 'S / ROW -X
(SSX) ', 6,' Exclusive ', To_Char (Request)) mode_requested, o.owner ||'. '|| O.Object_name ||'
('|| o.object_type ||') ', S.TYPE LOCK_TYPE, L.ID1 LOCK_ID1, L.ID2 LOCK_ID2 FROM V $ LOCK L,
Sys.dba_Objects O, V $ session s where l.sid = s.SID and L.ID1 = O.Object_ID; 30. How to unlock? Alter System Kill Session 'SID, Serir #'; 31. How to modify the editor under SQLPLUS ? Define _Editor = "The full path of the editor" - must be added to define a new editor or write this
$ Oracle_home / sqlplus / admin / glogin.sql is permanently valid. 32. Oracle generates a random number of functions? DBMS_Random.random 33. LINUX Query disk competition status command? SAR -D 33. LINUX Query CPU competition status command? SAR -R 34. Query the current user object? Select * from user_Objects; SELECT * FROM DBA_SEGMENTS; 35. how to get the error message SELECT * FROM USER_ERRORS;? 36. how to get the link status SELECT * FROM DBA_DB_LINKS;? 37. Check the database character status SELECT * FROM NLS_DATABASE_PARAMETERS;? SELECT * FROM V $ NLS_PARAMETERS; 38. Query table space information? Select * from dba_data_files; 39. ORACLE INTERAL user wants password? Modify SQLNET.ORA SQLNET.AUTHENTICATION_SERVICES = (NTS) 40. A solution of Java.exe appears? Generally, OracleraHomexihttpserver is changed to handleable , X is 8 or 9 41. How to give a list, column incorporation? SQL> Comment on Table Table IS 'Table Note'; comments have been created. SQL> Comment on column table. Column is 'column annotation'; comment has been created. SQL> Select * from user_tab_comments where comments is not null; 42. How do I see the disks of each table space? SQL> COL TABLESPACAT A20 SQL> SELECT B.FILE_ID File ID Number, B.Tablespace_name Table Space Name, B.bytes bytes (B.Bytes-Sum (NVL (A.Bytes, 0))) is used, SUM (NVL (A.bytes, 0)) Remaining Space, SUM (NVL (A.Bytes, 0)) / (B.bytes) * 100 Remaining Percentage from DBA_FREE_SPACE A, DBA_DATA_FILES B Where A.File_ID = B.File_ID Group By B.Tablespace_name, B.File_ID, B.BYTES ORDER BY B.FILE_ID 43. If the ORACLE is set to MTS or a dedicated mode? #dispatches = "(Service = SIDXD) Plus is MTS, the comment is a dedicated mode, and the SID refers to your instance name. 44. How can I know the current SCN number? SELECT MAX (KTuxescnw * Power (2, 32) KTuxescnb) from x $ ktuxe; 45. How do I don't support it in Oracle? 9i, 9i begins with TimeStamp.
9i can use Select SystimeStamp from Dual; 46. How to get a return in the string? SELECT 'WELCOME TO VIT' || CHR (10) || How does "in Chinese sorted? Before Oracle9i, Chinese is sorted according to binary coding. In Oracle9i, in accordance with Pinyin, Ministry, Sprinkler. Set NLS_SORT value: sCHINESE_RADICAL_M According to the first (first order), sort (second order) Schinese_Stroke_m Sorts SCHINESE_PINYIN_M Sort Schinese_pinyin_m in the first order (second order), in the oracle8i in Oracle8i Chinese? Can 49. How to change the SQL * PLUS boot option in WIN? SQL * Plus own option settings We can set in $ oracle_home / sqlplus / admin / glogin.sql. 50. How to modify the default date of the ORACEL database? ALTER session set nls_date_format = 'yyyymmddhh24miss'; or can be plus a line NLS_DATE_FORMAT = 'YYYYMMDDH24MISS' 51 in Init.ra? How to put a small table in the Keep pool? Alter Table XXX Storage (Buffer_pool Keep); 52. How to check if a Patch? Check That ORAINVENTORY 53 is installed? How to make the SELECT statement automatically generate a serial number? Select Rownum, colom table; 54. How to know a table in pattern ? the tablespace select tablespace_name from user_tables where table_name = 'TEST'; select * from user_tables there is a field tABLESPACE_NAME, (oracle); select * from dba_segments where ...; 55. how to quickly do the same original table and a backup table? CREATE TABLE NEW_TABLE AS (SELECT * OLD_TABLE); 55. How to modify ProCedure? Select Line, Trim (Text) t from User_Source where name = 'a' Order by line; 56. How to remove procedure is unlocked? ALter SYSTEM KILL SESSION, kill the session, but you have to check her session ID or re-change the name to the process. 57. What is SQL Reference? Is a SQL manual, including grammar, functions, etc., Document Center of Oracle official website provides downloads.
58. How to view the status of the database? UNIX PS-EF | GREP ORA Windows under the service is whether the service is getting up; if you can connect to the database 59. How to modify the primary key of a table? AAAA_KEY; Alter Table AAA Add ConsTRAINT AAA_KEY PRIMARY Key (A1, B1); 60. Change the size of the data file? Use alter Database .... datafile ....; manually change the size of the data file, there is no damage to the original data file. 61. How do you check in Oracle in run? View V $ Sessions Table 62. How can I see how many TableSpace? Select * from DBA_TABLESPACES; 63. How do I modify the number of user connections to the Oracle database? Modify INITSID.ORA, increase the process, restart the database. 64. How to find the last update time of a record? You can use the logminer to view 65. How to read and write files in PL / SQL? The UTL_FILE package allows the user to read the operating system file via the PL / SQL. 66. How to put "&" in a record? INSERT INTO a VALUES (TRANSLATE ('at {}', 'at')); 67. How does EXP add Query parameter? Exp user / pass file = a.dmp tables (bsempms) query = '"where EMP_NO = /' s09394 / '/"; 68. About Oracle8i support Simplified and Traditional character sets? ZHS16GBK can support 69. What software is Data Guard? It is STANDBY's replacement product 70. How to create spfile? SQL> Connect / as sysdba sql> select * from v $ version; sql> create pfile from spfile; sql> create spfile from pfile = 'E: / ORA9I / Admin / Eygle / Pfile / init.ora '; files have been created. SQL> CREATE SPFILE = 'E: /ora9i/database/spfileeygle.ora' from pfile = 'e: /ora9i/admin/eygle/pfile/init.ora'; files have been created. 71. Application of kernel parameters? SHMMAX mean: This setting does not decide how much physical memory is used in Oracle database or operating system, only determines up to most
Depreciate. This setting does not affect the kernel resources of the operating system. Setting method: 0.5 * Physical memory example: SHMINFO_SHMMAX = 10485760 shmmin meaning: Shared memory minimum size. Setting method: Usually set to 1. Example: set shmsys: shminfo_shmmin = 1: SHMMNI meaning: The maximum number of memory segments in the system. Example: set shmsys: shminfo_shmmni = 100 shmseg Meaning: The number of maximum shared memory segments per user process can be used. Example: set shmsys: shminfo_shmseg = 20: semmni meaning: The maximum number of Semaphore Identifierer in the system. Setting method: Set the value of this variable to all Oracle's instances of all Oracle's instances of the processes to add 10. Example: Set Semsys: seminfo_semmni = 100 SemMns Emnity: The maximum number of EMAPHORES in the system. Setting method: This value can be calculated in the following manner: the total value of the processes of each Oracle instance
And (remove the largest processes parameter) the number of the largest processes × 2 10 × Oracle instance. Example: Set Semsys: seminfo_semmns = 200 Semmsl Meaning: The maximum number of Semaphore in a set. Setting method: Set the value of the largest processes in INITSID.ORA for 10 all Oracle instances. Example: SET SEMSYS: SEMINFO_SEMMSL = -200 72. Which users have SYSDBA, SYSOPER permission? SQL> conn sys / change_on_install sql> select * from v_ $ pWFILE_USERS; 73. How to back up one or more tables separately? EXP user / password Tables = (Table 1, ..., Table 2) 74. How to back up one or more users separately? Exp System / Manager Owner = (User 1, User 2, ..., User N) File = Export File 75. How to retrieve the CLOB field full-text search? Select * from a where dbms_lob.instr (AA, 'K', 1, 1)> 0; 76. How to display the current connection user? Show user 77. How to view the path placed by the data file? Col File_Name Format A50 SQL> SELECT TABLESPACE_NAME , File_ID, BYTES / 1024/1024, File_Name from DBA_DATA_FILES ORDER BY
File_ID; 78. How to view existing rollback segments and its status? SQL> Col Segment Format A30 SQL> Select segment_name, ooner, tablespace_name, segment_id, file_id, status from
DBA_ROLLBACK_SEGS 79. How do I change the initial defined Check range? SQL> ALTER TABLE XXX DROP CONSTRAINT CONSTRAINT_NAME; then create a new constraint again: SQL> ALTER TABLE XXX Add constraint constraint_name check (); 80. What are the Oracle common system files? These file information is displayed by the following view: V $ Database, V $ DataFile, V $ logfile v $ controlfile v $ parameter; 81. Connect Inner Join? Select a. * From bsempms A, BSDPTMS B where a.dpt_no = b. DPT_NO; 82. How to connect? Select a. * from bsempms a, bsdptms b where a.dpt_no = B.DPT_NO ( ); select a. * from bsempms a, bsdptms b wherea.dpt_no ( ) = B.DPT_NO ; 83. How to perform script SQL files? SQL> @ $ path / filename.sql; 84. How to quickly empty a big table? SQL> TRUNCATE TABLE TABLE_NAME; 85. How many database instances do you check? SQL> Select * from v $ INSTANCE; 86. How many tables do you query the database? SQL> Select * from all_tables; 87. How to test the time used by the SQL statement? SQL> Set Timing on; SQL> SELECT * from Tablename; 88. chr () Function? ASCII () SELECT Char (65) from Dual; SELECT ASCII ('a') from Dual; 89. String Self Connection Select Concat (Col1, Col2) from Table; Select Col1 || col2 from table; 90. How to Guide the results from SELECT to a text file? SQL> Spool c: /abd.txt; sql> select * from table; sql> spool off; 91. How to estimate SQL execution I / O number? SQL> set autotrace on; SQL> Select * from table; or sql> Select * from V $ fileStat; you can view the number of IO 92. How to change the field size under SQLPLUS? ALTER TABLE TABLE_NAME MODIFY (Field_Name Varchar2 (100)); changing the row, the change is small (unless it is empty) 93. How to Query your data? Select * from table_name where trunc = to_date ('2003-05-02', 'YYYY-MM-DD'); 94. How is the SQL statement inserts a full date? Create Table Bsyear (D Date);
insert into BSYEAR select to_date ( '20030101', 'yyyymmdd') rownum-1 from all_objects where rownum <= to_char (to_date ( '20031231', 'yyyymmdd'), 'ddd'); 95. If the ALTER modify table? Table Old_table_name rename to new_table_name; 96. How to get the return status value of the command? SQLCODE = 0 97. How do I know the permissions owned by the user? Select * from dba_sys_privs; 98. What is the difference between Oracle9i downloaded from the Internet? From the functional saying, Oracle has clearly defined; Oracle products downloaded from the website must not be used for commercial purposes, otherwise infringement. 99. How to determine that the database is running in archiving mode or running in non-invasive modes? Go to DBASTUDIO, History -> Database ---> Archive View. 100. SQL> Startup Pfile and IFILE, SPFILE What is the difference? Pfile is an Oracle traditional initialization parameter file, text format; ifile is similar to include in C language, it is used to introduce another file; SPFile is new in 9i and is the default parameter file, binary format; Startup should Only PFILE can only be connected. 101. How to search for the first N record? Select * from Employee WHERE ROWNUM
111. Return to the minimum value equal to Is N? SELECT CEIL (N) from Dual; 112. Returns the minimum integer value of equal to N? SELECT FLOOR (N) from Dual; 113. Return to the last day of the current month? SELECT LAST_DAY Sysdate) from Dual; 114. How to Data Imports between Different User Data? IMP System / Manager File = aa.dmp fromuser = User_old Touser = User_New Rows = Y Indexes = Y; 115. How to find the name of the primary key field of the database table? SQL> SELECT * FROM user_constraints WHERE cONSTRAINT_TYPE = 'P' and table_name = 'tABLE_NAME';? 116. plus two result sets mutual function SQL> SELECT * FROM BSEMPMS_OLD INTERSECT SELECT * FROM BSEMPMS_NEW; SQL> SELECT * FROM BSEMPMS_OLD UNION SELECT * FROM BSEMPMS_NEW SQL> SELECT * FROM BSEMPMS_OLD UNION ALL SELECT * FROM BSEMPMS_NEW;? 117. results of two sets of cross-cut function SQL> SELECT * FROM BSEMPMS_OLD mINUS SELECT * FROM BSEMPMS_NEW; 118. how to configure Sequence build sequence seq_custid create sequence seq_custid start? 1 Incrememt by 1; Time: CREATE TABLE CUST_ID Smallint Not Null, ...} Insert: Insert INTO TABLE CUST VALUES (SEQ_CUST.NEXTVAL, ...) Date of the commonly used part of the commonly used Writing 119. Write a time point: select to_char (sysdate, 'yyyy') from dual; 120. Writing of the month of time point: select to_char (sysdate, 'mm') from Dual; 121. Take Time point of view: select to_char (sysdate, 'dd') from dual; 122. Writing time at time point: select to_char (sysdate, 'hh24') from dual; 123. Writing method for time point : Select to_char (sysdate, 'mi') from dual; 124. Write actions at the time point: select to_char (sysdate, 'ss') from Dual; 125. Writing of the date of time point: select trunc (sysdate) From Dual; 126. Take the time of the time point: select to_char (sysdate, 'hh24: mi: ss') from dual; 127. Date, time form becoming a character form:
Select to_char (sysdate) from dual; 128. Converting strings into date or time form: select to_date ('2003/08/01') from Dual; 129. Return to the week's week writing: select to_char (sysdate, ' D ') from dual; 130. Return to the first few days of the year: select to_char (sysdate,' ddd ') from Dual; 131. Returns the second number of seconds between midnight and parameters Writing: Select to_char (sysdate, 'sssss') from dual; 132. Return to the first few weeks of the year: select to_char (sysdate, 'ww') from dual; virtual field 133. Currval and NextVal are created for tables Sequence Create Sequence Empseq ...; Select Empseq.currval from Dual; Numerical Insert INTO EMP VALUES (Empseq.NextVal, 'Lewis', 'Clerk', 7902, Sysdate, 1200, NULL, 20); 134. ROWNUM selection * from Emp WHERE ROWNUM <10; 135. RowId returned, ENAME FROM EMP where deptno = 20; 136. Convert N seconds to time second format? Set ServerOut on Declare N Number: = 1000000; RET VARCHAR2 (100); Begin Ret: = Trunc (N / 3600) || 'Hour' || To_Char (TO_DATE (MOD (N, 3600), 'Sssss'),' FMMI "points" SS "second" '); dbms_output.put_line (re); end; 137. How to query the process of making a relatively large sort? Select B.Tablespace, B.segfile #, B. Segblk #, B. Blocks, A.SID, A.SERIAL #, A.USERNAME, A. OSUser,
A.Status from V $ session a, v $ sort_usage b where a.saddr = b.session_addr Order By B.Tablespace, B.SEGFILE #, B.SEGBLK #, B.BLOCKS; 138. How to query to make a relatively large sort The SQL statement for the process? SELECT / * Ordered * / SQL_Text from V $ SQLText a where a.hash_value = (Select SQL_Hash_Value from V $ Session B Where B.SID = & SID AND B.SERIAL # = & Serial) Order by Piece ASC; 139. How to find repetition recording? Select * from table_name where rowid! = (Select max (rowid) from table_name d where table_name.col1 = d.col1 and table_name.col2 = d.col2); 140. How to delete repeat records? Delete from table_name where rowid! = (SELECT MAX (ROWID) from Table_Name D Where Table_Name.col1 = D.COL1 and TABLE_NAME.COL2 = D.COL2); 141. How to quickly compile all views? SQL> Spool View1.sql SQL> SELECT 'ALTER View' || TName || 'Compile;' from Tab; SQL> Spool Off and execute View1.sql. SQL> @ view1.sql; 142. ORA-01555 Snapshot Too OLD solution Adds the value of MineXtents, adds a high Optimal value. 143. The spatial space of the transaction requirements is not enough, and it is manifested as a table space (ORA-01560 error), and the rollback segment extends to the parameter maxExtents
Value (ORA-01628) solution. Add a file to the split segment table space or make the existing file be large; increase the value of MaxExtents. 144. How to encrypt the Oracle stored procedure? The following stored procedure content is placed in the aa.sql file Create or Replace Procedure TestCCB (i in number) as begin dbms_output.put_line ('input parameter is' || to_Char (i)); end; sql> wrap iname = a.sql ; PL / SQL Wrapper: Release 8.1.7.0.0 - Production on Tue Nov 27 22:26:48 2001 Copyright (c) Oracle Corporation 1993, 2000. All Rights Reserved. Processing aa.sql to aa.plb runs AA.plb SQL> @ aa.plb; 145. How to monitor the wait for example? Select Event, SUM (Decode (Wait_Time, 0, 0, 1)) "Prev", SUM (Decode (Wait_time, 0, 1, 0)) "Curr", count (*) "Tot" from v $ session_wait group by Event ORDER BY 4; 146. How to return to the paradigm? Select Name, Waits, Gets, Waits / Gets "Ratio" from v $ ROLLSTAT C, V $ ROLLNAME D Where C.USN = D.USN; 147. How to monitor the I / O ratio of tablespace? Select B.TablesPACE_NAME NAME, B.FILE_NAME "File", A.Phyrds Pyr, A.Phyblkrd PBR, A.PhyWRTS PYW, A.PHYBLKWRT PBW from V $ Filestat A, DBA_DATA_FILES B Where A.File # = B.File_ID ORDER By B.TablesPACE_NAME; 148. How to monitor the I / O ratio of the file system? Select Substr (C.File #, 1, 2) "#", Substr (C.Name, 1, 30) "Name", C.Status, C.Bytes, D. Phyrds,
D.PhyWRTS from V $ DataFile C, V $ filestat d where c.file # = D.File #; 149. How do I find all indexes under a user? select user_indexes.table_name, user_indexes.index_name, uniqueness, column_name from user_ind_columns, user_indexes where user_ind_columns.index_name = user_indexes.index_name and user_ind_columns.table_name = user_indexes.table_name order by user_indexes.table_type, user_indexes.table_name, user_indexes.index_name, column_position; 150. How to monitor SGA's hit rate? Select A.Value B.Value "Logical_Reads", C.Value "Phys_Reads", Round (100 * (A.Value B.Value) -c.value) / (A.Value B.Value) " Buffer Hit Ratio "from V $ sysstat a, v $ sysstat b, v $ sysstat c where a.statistic # = 38 and c.statistic # = 39 and C.Statistic # = 40; 151. How to monitor D Dictionary buffer in SGA Hit rate? Select Parameter, Gets, GetMisses, getMisses / (Gets GetMisses) * 100 "Miss Ratio", (1- (SUM (getMisses) / (SUM (Gets) SUM (GetMisses))) * 100 "Hit Ratio" from V $ ROWCACHE WHERE GETS GETMISSES <> 0 group by parameter, gets, getmisses; 152. How should I monitor the hit rate of the CCD in SGA, should it be less than 1%? Select SUM (Pins) "Total Pins", SUM (Reloads) "Total Reloads", SUM (RELOADS) / SUM (PINS) * 100 Libcache from V $ librarycache; select sum (pinhits-reloads) / sum (pins "HIT Radio, SUM (RELOADS) / SUM (PINS) "Reload Percent" from v $ librarycache; 153. How to display the category and size of all database objects? select count (name) num_instances, type, sum (source_size) source_size, sum (parsed_size) parsed_size, sum (code_size) code_size, sum (error_size) error_size, sum (source_size) sum (parsed_size) sum (code_size) sum ( ERROR_SIZE) SIZE_REQUIRED from DBA_OBJECT_SIZE GROUP BY TYPE ORDER BY 2;
154. Monitor the hit rate of the SGA medium-red log cache, should be less than 1% SELECT NAME, GETS, MISSES, IMMEDIATE_GETS, IMMEDIATE_MISS, DECODE (Gets, 0, 0, Misses / Gets * 100) Ratio1, Decode (IMMEDIATE_GETS IMMEDIATE_MISSESSESSES , 0, 0, IMMEDIATE_MISS / (IMMEDIATE_GETS IMMEDIATE_MISS * 100) Ratio2 from v $ latch where name in ('redo allocation "; 155. Monitor memory and hard drive sorting ratio, it is best to make it less than .10, increase sort_area_size select name, value from v $ sysstat where name in ('sorts (memory)', 'sorts (data); 156. How to monitor the current database who runs what SQL statement? Select OSuser, Username, SQL_Text from V $ Session A, V $ SQLText B where A.sql_address = B.Address Order by Address, Piece; 157. How to Monitor Dictionary Buffers? SELECT (SUM (Pins - Reloads)) / SUM (Pins "LIB Cache" from v $ librarycache; select (sum (gets - getmisses - usage - fixed) / sum (gets) "Row Cache" from v $ rowcache; Select SUM (Pins) "Executions", SUM (RELOADS) "Cache Misses While Executing" from V $ librarycache; the latter except for the former, this ratio is less than 1%, close to 0% is good.
Select Sum (Gets) "Dictionary Gets", SUM (GetMisses) "Dictionary Cache Get Misses" from V $ ROWCACHE 158. Monitor MTS SELECT Busy / (Busy IDle) "Shared Servers Busy" from V $ Dispatcher; this value is greater than 0.5 When parameter needs to increase Select SUM (Wait) / SUM (Totalq) "Dispatcher Waits" from v $ queue where type = 'dispatcher'; select count (*) from v $ dispatcher; select servers_highwater from v $ mts; servers_highwater close When MTS_MAX_SERVERS, the parameter needs to increase 159. How do I know the ID number of the current user? SQL> Show user; or SQL> SELECT User from dual; 160. How to view a table with high degree of fragmentation? Select segment_name table_name, count (*) Extents from DBA_SEGMENTS WHERE OWNER NOT IN ('sys', 'system') Group by segment_name haVing count (*) = (select max) from dba_segments group by segment_name); 162. How to know the store in the table space case? select segment_name, sum (bytes), count (*) ext_quan from dba_extents where tablespace_name = '& tablespace_name' and segment_type = 'TABLE' group by tablespace_name, segment_name
163. How do I know the storage situation index in the table space? Select segment_name, count (*) from dba_extents where segment_type = 'index' and owner = '& Owner' Group by segment_name; 164, how do you know how many users using CPU? 11 is CPU Used by this session select A.SID, SPID, STATUS, SUBSTR (A.Program, 1, 40) PROG, A.TERMINAL, OSUSER, VALUE / 60/100 VALUE FROM V. SESSION A, V $ Process B , v $ sesstat c where c.statistic # = 11 and c.SID = a.sid and a.paddr = b.addr order by value desc; 165. How to know the listener log file? Take 8i as an example $ Oracle_Home / Network /Log/listener.log 166. How to know the listener parameter file? Take 8i as an example $ Oracle_Home / Network / Admin / Listener.ora 167. How do I know TNS connection file? Take 8i as an example $ Oracle_Home / Network / Admin / TNSNames. ORA 168. How to know the SQL * NET environment file? Take 8i as an example $ Oracle_Home / Network / Admin / SQLNET.ORA 169. How do you know the warning log file? Take 8i as an example $ Oracle_Home / Admin / Sid / bdump / Sidalrt.log 170 How do I know the basic structure? Take 8i as an example $ Oracle_Home / Rdbms / Admin / Standard.sql 171. How to know the establishment of a data dictionary view? Take 8i as an example $ Oracle_home / rdbms / admin / catalog.sql 172. How to know the establishment of an audit Data Dictionary View Take 8i as an Example $ ORACLE_HOME / RDBMS / Admin / Cataudit.sql 173. How do I know the establishment of a snapshot data dictionary view? Take 8I as an example $ ORACLE_HOME / RDBMS / Admin / CatSnap.sql SQL statement Optimization method 174. / * All_ Rows * / Indicates that the selection of the overhead optimization method and obtains the best throughput, minimizing resource consumption. For example: SELECT / * ALL _ROWS * / EMP_NO, EMP_NAM, DAT_IN FROM BSEMPM WHERE EMP_NO = 'ccbzz'; 175. / * first_rows * / Indicates the Optimization Method Based on Overhead, and Get the Best Response Time , Minimize resource consumption.
For example: SELECT / * first_ROWS * / EMP_NO, EMP_NAM, DAT_IN FROMPMPM WHERE EMP_NO = 'ccbzz'; 176. / * choose * / Indicates that if there is a statistics of the visiting table in the data dictionary, it will be based on the optimization method of overhead. And get the best throughput; indicate that if there is no statistics of the table in the data dictionary, it will be based on the optimization method of rule overhead; for example: select / * choose * / EMP_NO, EMP_NAM, DAT_IN from bsempms where EMP_NO = 'CCBZZP' 177. / * Rule * / Indicates the selection of rules based on rules. For example: SELECT / * RULE * / EMP_NO, EMP_NAM, DAT_IN FROM BSEMPM WHERE EMP_NO = 'CCBZP'; 178. / * Full (Table) * / Indicates that the table selects a global scan method. For example: SELECT / * FULL (A) * / EMP_NO, EMP_NAM from bsempms a where emp_no = 'ccbzz'; 179. / * rowid (Table) * / prompt clearly indicates that the specified table is accessed according to ROWID. For example: SELECT / * ROWID (BSEMPMS) * / * from bsempms where rowid> = 'AAAAAAAAAAAAAA' and EMP_NO = 'ccbzz'; 180. / * Cluster (Table) * / prompt clearly indicates that the specified table selects cluster scanning Access method, it is only valid for cluster objects. For example: SELECT / * CLUSTER * / BSEMPMS.EMP_NO, DPT_NO FROM BSEMPMS, BSDPTMS WHERE DPT_NO = 'TEC304' AND BSEMPMS.DPT_NO = BSDPTMS.DPT_NO; 181. / * INDEX (TABLE INDEX_NAME) * / selection index table shows that Scanning method. For example: SELECT / * INDEX (bsempms sex_index) USE SEX_INDEX BECAUSE The are feWMALE BSEMPMS * / FROM
Bsempms where sex = 'm'; 182. / * index_asc (Table Index_name) * / Indicates the table to select the scanning method of the index ascending order. For example: select / * index_asc (bsempms pk_bsempms) * / from bsempms where dpt_no = 'ccbzz'; 183. / * index_combine * / to select a bitmap to the specified table, if the index_combine is not available, the index is provided as a parameter, The Boolean combination of the graph index will be selected. For example: SELECT / * INDEX_COMBINE (BSEMPMS SAL_BMI HIREDATE_BMI) * / * FROM BSEMPMS WHERE SAL <5000000 AND HIREDATE AND dPT_NO = 'TDC306'; 188. / * Use_concat * / Convert the OR condition behind WHER in the query to a combination query of Union All. For example: SELECT / * USE_CONCAT * / * from bsempms where dpt_no = 'tdc506' and sex = 'm'; 189. / * no_expand * / NO_EXPAN's query statement after WHERE or in-list, no_expand will block it The optimizer is expanded based on the optimizer. For example: select / * no_expand * / * from bsempms where dpt_no = 'tdc506' and sex = 'm'; 190. / * NOWRITE * / Do not rewrite the query of the query block. 191. / * rEWRITE * / You can use the view as a parameter. 192. / * Merge (Table) * / Ability to merge the various queries of the view. For example: SELECT / * MERGE (V) * / a.emp_no, a.emp_nam, b.dpt_no from bsempms A (SELET DPT_NO, AVG (SAL) asavg_sal from bsempms b Group by dpt_no) V where a.dpt_no = v. DPT_NO and A.SAL> V.AVG_SAL; 193. / * No_merge (Table) * / For views with merger no longer merge. For example: SELECT / * NO_MERGE (V) * / a.emp_no, a.emp_nam, b.dpt_no from bsempms A (Selet DPT_NO, AVG (SAL) AS Avg_sal from bsempms b group by dpt_no) v where a.dpt_no = v.dpt_no and a.sal> v.avg_sal; 194. / * Ordered * / ORDERED makes Oracle according to this order according to the order in the FROM Its connection. For example: select / * ordered * / a.col1, b.col2, c.col3 from table1 a, table2 b, table3 c where a.col1 = b.col1 AND B.COL1 = C.COL1; 195. / * USE_NL (Table) * / Connect the specified table with the row of nested connections, and use the specified table as the internal table. For example: select / * ordered use_nl (bsempms) * / bsdptms.dpt_no, bsempms.emp_no, bsempms.emp_nam from bsempms BSDPTMS WHERE BSEMPMS.DPT_NO = BSDPTMS.DPT_NO; 196. / * Use_merge (Table) * / Connect the specified table with other line sources by combining the sort connection. For example: SELECT / * USE_MERGE (BSEMPMS, BSDPTMS) * / * from bsempms, BSDPTMS WHERE BSEMPMS.DPT_NO = BSDPTMS.DPT_NO; 197. / * Use_hash (Table) * / Connect the specified table with other row sources through a hash connection. For example: SELECT / * USE_HASH (BSEMPMS, BSDPTMS) * / * from bsempms, bsdptms wherebsempms.dpt_no = bsdptms.dpt_no; 198. / * driving_site (Table) * / Force Different tables selected by Oracle carried out. For example: SELECT / * DRIVING_SITE (DEPT) * / * from bsempms, dept @ bsdptms where bsempms.dpt_no = dept.dpt_no; 199. / * Leading (Table) * / Use the specified table as the header in the connection order. 200. / * Cache (TABLE) * / When a full-table scan is performed, the Cache prompts to place the retrieval block of the table in the buffer cache, the most recent use of the least list of LRUs in the buffer cache, such as: SELECT / * FULL (BSEMPMS) Cahe (bsempms) * / EMP_NAM from bsempms; 201. / * Nocache (Table) * / When full menu scan, Cache prompts to place the retrofit block of the table in the buffer cache recently used the most recent list of LRUs For example: SELECT / * FULL (BSEMPMS) Nocahe (bsempms) * / EMP_NAM from bsempms; 202. / * Append * / Directly inserted to the table, it can improve the speed. INSERT / * APPEND * / INTO TEST1 Select * from test4; 203. / * noAppend * / By starting conventional insertion by stopping parallel mode during the insertion statement survival. INSERT / * NoAppnd * / INTO TEST1 Select * from test4; Oracle internal function 204. How to get the first character of the string? ASCII (char) Select ASCII ('Abcde') from Dual; Result: 65 205 How to get a value N specified characters? Chr (n) SELECT CHR (68) from Dual; D 206. How to connect two strings? Concat (Char1, char2) Select Concat ('ABC', 'DEFGH') From Dual; Result: 'Abcdefgh' 207. How to replace the values in the column as a string? Decode (char, n1, char1, n2, char2 ...) Select Decode (day, 1, 'sun', 2, ' MON ') from Dual; 208. INitcap (char) The first character of the string char is uppercase, the rest is lowercase. Select Initcap ('Abcde') from Dual; 209. Length (char) takes the length of a string char. Select Length ('Abcde') from Dual; 210. Lower (Char) All string Char is all lowercase. Select Lower ('Abcde') from Dual; 211. LPAD (CHAR1, N, CHAR2) with string char2, filled CHAR1, so that it is N. SELECT LPAD ('Abcdefg', 10'123 ') from Dual; Result:' 123Abcdefg '212. Ltrim (Char, SET) Moves the character in the string set from the left side of the string char, until the first is not set The character is character. SELECT ('cdefg', 'cd') from Dual; Result: 'EFG' 213. NLS_INITCAP (CHAR) Take the first character of Charity Char, the rest of the characters are lowercase. SELECT NLS_INITCAP ('Abcde') from Dual; 214. NLS_Lower (Char) All characters included in the string CHAR are written. SELECT NLS_LOWER ('aaaa') from Dual; 215. NLS_UPPER (CHAR) All characters included in the string CHAR. SELECT NLS_UPPER ('AAAA') from Dual; 216. Replace (Char1, Char2, Char3) replaces the column of each column value of CHAR2 with a string Char3, which is placed in Char1. SELECT Replace (EMP_NO, '123', '456') from Dual; 217. RPAD (CHAR1, N, CHAR2) Use string char2 to right, so that it is N. SELECT RPAD ('234', 8, '0') from Dual; 218. RTRIM (Char, SET) Remove characters in the string set on the string char to the right, until the last one is not a character. SELECT RTRIM ('Abcde', 'DE') from Dual; 219. Substr (CHAR, M, N) Get N characters starting from M. Double-byte characters, one Chinese character. Select Substr ('Abcde', 2, 3) from Dual; 220. Substrb (CHAR, M, N) Get n characters starting from M. Double-byte characters, one Chinese character. Select Substrb ('Abcde', 2, 3) from Dual; 221. Translate (CHAR1, CHAR2, CHAR3) replaces the portion of Char2 in char1 with char3. Select Translate ('Abcdefgh', 'DE', 'Mn') from Dual; 222. Upper (char) All string char is uppercase. 223. add_months (d, n) increases N months to the D date. SELECT Add_MontHS (Sysdate, 5) from Dual; 224. Last_day (d) Get the date of the last day of the month containing the d dates. SELECT LAST_DAY (SYSDATE) from Dual; 225. Month_between (D1, D2) Gets the number of months between two dates. SELECT MONTH_BETWEEN (D1, D2) from Dual; 226. Next_Day (D, Char) Get the date Date Date Date Date Date Date Date. Select next_day (to_date ('2003/09/20'), 'Satday') from Dual; 227. Rount (D, FMT) Get the most intake date that is rounded by the specified mode FMT. SELECT ROUNT ('2003/09 / 20', month "from dual; 228. Sysdate gets the date and time of the current system. Select sysdate from dual; 229. to_CHAR (D, FMT) converts the date D to the FMT string. Select to_char (sysdate, 'yyyy / mm / dd') from Dual; 230. To_date (char, fmt) Converts string char to the FMT format. Select TO_DATE ('2003/09/20') from Dual; 231. ABS (N) Gets the absolute value of n. SELECT ABS (-6) from Dual; 232. CEIL (N) Gets greater integersion greater than or equal to N. SELECT CEIL (5.6) from Dual; 233. COS (N) Gets the cosine value of n. SELECT COS (1) from Dual; 234. SiN (n) Gets the sine value of n. Select sin (1) from dual; 235. Cosh (n) Gets the hyperbolic cosine value of n. Select Cosh (1) from Dual; 236. EXP (n) Gets N power of N of N. SELECT Exp (1) from Dual; 237. Floor (n) Gets minimum integers that are less than or equal to N. SELECT FLOOR (5.6) from Dual; 238. ln (n) Gets Natural logarithm of N. SELECT LN (1) from Dual; 239. LOG (M, N) Gets the log of the bottom N by m. SELECT log (2, 8) from Dual; 240. M, N) Gets the remainder of M divided by N. SELECT MOD (100, 7) from Dual; 241. Power (M, N) Gets the N power of M. SELECT POWER (4, 3) from Dual; 242. Round (n, m) Rounded N to M bits after the decimal point. SELECT (78.87653, 2) from Dual; 243. Sign (n) When n <0, get -1; when n> 0, get 1; when n = 0, get 0; SELECT SIGN (99) from DUAL 244. SINH (n) Gets the dual sine value of N. SELECT SINH (1) from Dual; 245. Sort (n) Gets the square root of N, n> = 0 Select Sort (9) from Dual; 246. TAN (N) Gets the northate value of n. SELECT TAN (0) from Dual; 247. Tanh (n) Gets the hyperbolic positive cut value of n. SELECT TANH (0) from Dual; 248. Trunc (n, m) Gets the value of N truncated in the M bit. SELECT TRUNC (7.7788, 2) from Dual; 249. count () calculates the number of records that meet the conditions. SELECT Count (*) from table1 where col1 = 'aaa'; 250. max () for the specified column. SELECT MAX (COL1) from table1; 251.min () for the specified columns. SELECT Min (COL1) from table1; 252. AVG () for the specified sum. SELECT AVG (COL1) from table1; 253. Sum () Calculates the sum. SELECT SUM (COL1) from Dual; 254. TO_NUMBER (CHAR) Convert characters to values. Select TO_NUMBER ('999') from dual; 255. ChartorowId (char) converts CHAR or VARCHAR2 numerical values containing external syntax ROWID to internal binary syntax, parameter char must be ROWID that contains external syntax The 18-character string. SELECT NAME FROM BSEMPMS WHERE ROWID = CHARTOROWID ( 'AAAAfZAABAAACp8AAO'); NAME: LEIXUE 256. CONVERT (CHAR, DEST_CHAR_SET, SOURCE_CHAR_SET) CONVERT CHAR string of characters from the character set converter source_char_set identified by character set identification SELECT dest_char_set Convert ('grob', 'US7ASCII', 'WE8HP') 'CONVERSION' FROM PUBS; Conversion: Gross 257. Hextoraw (char) converts the hexadecimal char to a RAW value. INSERT INTO BSEMPMS (Raw_Column) SELECT HEXTORAW ('7d') from test; 258. RawToHex (RAW) converts the RAW value to a CHAR value containing hexadecimal. Select Rawtohex (Raw_Column) 'Conversion' from bsempms; Conversion: 7d 259. RowidTochar (RowID) Converts a ROWID value to a VARCHAR2 data type. Select Rowid from bsempms where rowidtochar (rowid) Like '% br1AAB%'; 260. TO_MULTI_BYTE (CHAR) converts the single byte in the char to equivalent multi-byte characters. SELECT TO_MULTI_BYTE ('asfdfd') from test; 261. To_single_byte (char) converts multiple bytes in char to equivalent single-byte characters. SELECT TO_SINGLE_BYTE ('asfdfd') from test; 262. Translate using (Text using {char_cs | nchar_cs}) converts text Text into a database character set and national character set in the specified conversion mode. Where Text is to be converted. Using char_cs parameter conversion Text is a database character set, and the output data type is VARCHAR2. Using nchar_cs parameter conversion Text is a database character set, and the output data type is NVARCHAR2. Create Table Test (CHAR_COL CHAR (20), nchar_col nchar (20)); Insert Into Test Values; Select * from test; 263. Dump (expr, return_format, start_position, length) Returns one Contains data type code, byte length, etc. VARCHAR2 value. Return results are current database character sets, data types The encoding of the internal data type specified is returned as a number: Code Data Type 0 VARCHAR2 1 Number 8 Long 12 Date 23 RAW 24 Long Raw 69 RowID 96 Char 106 MSSLabel Parameters Retuen_Format Specifies the number of returned by the base number below. RETURN_FORMAT RESULT 8 8 Binary 10 10 Enter 16 16 Enter 17 Single Character indicates that if the parameter return_format is not specified, press the decimal representation to return. If the parameter start_position and length are specified, the byte starting from start_position starts to the length of the length will be returned, and the default is to return an integer representation. Select Dump ('ABC', 1016) from test; select dump (ename, 8, 3, 2) 'Example' from Emp where name = 'ccbzzp'; 264. EMPTY_B | Clob () Returns an empty LOB locator, Used in initializing the LOB variable, or in Insert and Update declaration to initialize the LOB column or set it empty. INSERT INTO TABLE1 VALUES (EMPTY_BLOB ()); Update Table1 Set Clob_col = EMPTY_BLOB (); 265. BFileName ('Directory', 'FileName') Returns a BFile locator, the associated binary LOB physical file on the server's file system. Directory Directory refers to the file in the server The alias of the actual search path is actually searching. FileName refers to the file name of the server's file system. INSERT INTO FILE_TAB VALUES (BFileName ('LOB_DIR', 'Image1.gif'); 266. GreateSt (expr, expr, ...) Greatest returns the maximum value of the parameter. Select Greatest ('Harry', 'Harriot', 'Harold') 'Sample' from Table1; 267. Least (expr, expr, ...) Least Returns the minimum value of the parameter. Select Least ('Harry', 'Harriot', 'Harold') 'Sample' from Table1; 268. NLS_CHARSET_DECL_LEN (Bytecnt, CSID) Returns a width of a NCHAR column. SELECT NLS_CHARSET_DECL_LEN (200, NLS_CHARSET_ID ('JA16EEFDFDF')) from table1; 269. NLS_CHARSET_ID (TEXT) Returns the number of NLS character set IDs corresponding to NLS character set names. SELECT NLS_CHARSET_D ('jadfdffdf') from table1; 270. NLS_CHARSET_NAME (n) Returns NLS character set name corresponding to ID number N. SELECT NLS_CHARSET_NAME (2) from table1; 271. NVL (expr1, expr2) If EXPR1 is NULL, return EXPR2, otherwise returns EXPR1. SELECT NAME, NVL (TO_CHAR (COMM), 'NOT Application') from table1; 272. UID Returns an integer that uniquely identifies the current database user. Select Uid from table1; 273. USER Returns the name of the current Oracle user with the varchar2 data type. SELECT User, Uid from table1; 274. Userenv (option) Returns the current session information. Option = 'isdba' If the current DBA role is current, true, otherwise false. Option = 'language' Returns the character set of the database. OPTION = 'sessionID' is the current session identifier. Option = 'entryID' Returns the auditable session identifier. OPTION = 'lang' is an ISO news that returns a session language name. Option = 'instance' returns the current instance. Select Userenv ('Language') from Dual; 275. VSIZE (EXPR) Returns the number of bytes represented inside the EXPR. Select Name, vsize (name) from table1; 276. Deref (e) Returns the object reference of the parameter E. SELECT Deref (C2) from table1; 277. REFTOHEX (R) Convert parameter R to 16. SELECT REFTOHEX (C2) from Table1; 278. make_ref (Table, Key, Key ...) Creates a reference to a row in a given view object by using a given key as a primary key. Create Type T1 As Object (A Number, B Number); Create Table TB1 (C1 Number, C2 Number, Primary Key (C1, C2)); Create View V1 of T1 with Object Oid (A, AS SELECT * FROM TB1; SELECT Make_ref (V1, 1, 3) from PUBS; 279. stddev (DistINCT | ALL X) stddev gives a standard deviation of a set of row values. Select stddev (Salary) AS Example from Employee; 280. Variance (discInct | all x) Variance returns a variance of all Value in a group. Select variance (Salary) AS Example from Employee; 9i Management V $ View 281. V $ Access Displays objects in the currently locked database and is accessing their session. 282. V $ active_instances establishes a mapping from an instance name to instance number to all instances that appear in the currently installed database. 283. V $ active_SESS_POOL_MTH All active session resource allocation methods. 284. V-$ AQ current database queue . 285. V $ Archive archive information in the redo log file. 286. V $ Archive_Dest's file files for all archive logs of the current instance, and their current value, mode, status. 287. V $ archive_processes is available for an instance Information about different ARCH processes. 288. V $ archive_log Control file archive log information in the file. 289. V $ BACKUP's backup status of all online data files. 290. V $ backup_async_io Displays the backup set from the control file. 291 . V $ backup_corruption Displays information from corruption from the control file. 292. V $ backup_datafile Displays the information of the backup data file and backup control files from the control file. 293. V $ backup_device Display information about supporting the backup device 294. V $ backup_piece Displays the information of the backup block from the control file. 295. V $ backup_redolog from Control files Display information about the backup set archive log. 296. V $ backup_set Displays information from the backup set from the control file. 297. V $ backup_sync_io Displays information from the backup set from the control file. 298. V $ bgprocess describes the background process. 299. V $ BH is a real-time application cluster view of 9i. The status and probe is given to each buffer in the system's global zone. 300. V $ BSP displays statistics on the background process of the buffer server. 301. V $ buffer_pool Displays information about instance buffer pools. 302. V $ buffer_pool_statistics Displays information about the instance buffer pool. 303. V $ Cache contains head information of each block in the SGA of the current instance. 304. V $ cache_lock contains head information of each block in the SGA of the current instance. And v $ cache is very similar, except for the special envoys. 305. V $ Cache_Transfer except only those blocks that have been probably detected, and the V $ cache function is the same. 306. V $ Circuit contains information about the virtual circuit, which is the user through the scheduler and server to all connections. 307. V $ Class_ping Displays the number of probed blocks in each block class. 308. V $ Compatibility Displays the features used by the database instance, prevent the database from going back to the early versions. 309. V $ CompatSeg Displays the permanent feature used by the database instance, prevent the database from going back to the early versions. 310. V $ context lists the setting properties of the current dialog. 311. V $ ControlFile lists the names of the control file. 312. V $ controlfile_record_section Displays information about the control file record. 313. V $ COPY_CORRUPTION Displays information about corruption of data files in the control file. 314. V $ CR_BLOCK_SERVER Displays statistics on the back-end process in the cache. 315. V $ database contains information about the database in the control file. 316. V $ dataFile contains information about database files in the control file. 317. V $ dataFile_copy contains information about the database file copy in the control file. 318. V $ dataFile_Header Displays data file information on the header of the data file. 319. V $ db_cache_advice estimates the amount of physical read according to the size of the cache. 320. V $ db_Object_cache caches the database object in the library cache. 321. V $ db_pipes Displays the currently depicted pipes in the instance. 322. V $ dbfile lists all data files that make up the database. 323. V $ DBLINK query all database connections opened by sessions. 324. V $ deled_Object Displays the archive log in the control file. 325. V $ Dispatcher provides information about the dispatch process. 326. V $ dispatcher_rate provides high quality providing rate statistics for the scheduling process. 327. V $ dlm_all_locks lists information about all the locks. 328. V $ dlm_convert_local time consumes the local lock conversion operation. 329. V $ dlm_convert_remote consumes time consumed by remote lock conversion operation. 330. V $ dlm_latch It is an outdated, see V $ latch 331. V $ dlm_locks These are locking messages that are blocked or block other objects known by the lock manager. 332. V $ dlm_misc shows a variety of DLM statistics. 333. V $ DLM_RESS Displays information about all resources known to the current lock manager. 334. V $ enabledPrive Displays the privileged privilege. 335. V $ enqueue_lock Displays all locks owned by the queuing object. 336. V $ Event_Name contains information waiting for the event. 337. V $ execution displays information in parallel execution. 338. V $ FALSE_PING may get a buffer that the probe failed. 339. V $ found_start_servers Performs information of all the subordinate operations restored in parallel. 340. V $ fast_start_transactions Subsequent transaction progress information. 341. V $ file_cache_transfer Displays the number of blocks detected in each data file. 342. V $ file_ping Displays the number of blocks that each data file is proud. 343. V $ fileStat contains files about read / write statistics. 344. V $ fixed_table Displays all dynamic performance tables and views and export tables in the database. 345. V $ fixed_view_definition Displays the definition of all fixed views. 346. V $ GC_ELEMENTS_WITH_COLLISIONS can find locks that protect more cache. 347. V $ GES_BLOCKING_ENQUEUE These are lock information that is blocked or blocking other objects known to the lock manager. 348. V $ GES_CONVERT_LOCAL Local Lock Conversion Operation ERN Moderator Posting: 2294 From: Zhongshan in Guangdong in 2003-11-24 17:05 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------------------------------------------- 349. V $ GES_CONVERT_REMOTE The time consumed by the remote lock conversion operation. 350. V $ GES_ENQUEUE Displays all the locks you know by the current lock administrator. 351. V $ GES_LATCH See V $ latch 352. V $ GES_RESOURCE Displays information about all resources known to the current lock manager. 353. V $ GES_STATISTICS Displays a variety of DLM statistics. 354. V $ global_blocked_locks Displays a global block lock. 355. V $ global_transaction displays information about currently activated global transactions. 356. The V $ HS_AGENT identifies a collection of HS agents currently running on a given host. 357. V $ HS_SESSION Oracle server open HS session set. 358. V $ indexed_fixed_column Displays the column in the dynamic performance table of the index (X $ table). 359. V $ INSTANCE displays the status of the current instance. 360. V $ INSTANCE_RECOVERY is used to monitor the limit mechanism for executing the user to specify the number of recovery times. 361. V $ latch is a statistic for non-double pro. 362. V $ latch_children About the statistics of the subcontractic lock. 363. V $ latch_misses attempts to get a simple lock failure. 364. V $ latch_parent contains a statistic about the simple lock of the parents. 365. V $ LatchHolder information of the current simple lock holder. 366. V $ latchname contains information about the unlocking unlocking name of the simple lock in V $ latch. 367. V $ librarycache About cache performance and activity statistics. 368. V $ License license restrictions. 369. V $ loadCSTAT contains SQL * Loader statistics compiled in a direct load execution process. 370. V $ LOCK Current Lock held by Oracle. 371. V $ LOCK_AACTIVITY Displays the current instance of DLM lock operation activity. 372. V $ lock_Element Each cached PCM lock has an entry in V $ LOCK_ELEMENTS. 373. V $ locked_Object lists all locks obtained by each business. 374. V $ loc_with_collisions You can query the lock of the protective multi-buffer. 375. V $ log Controls information about log files in the file. 376. V $ log_history Controls the history information of the log file in the file. 377. V $ logfile contains information about redo log files. 378. V $ loghist Controls the log history information of the log file in the file. 379. V $ logmnr_contents log history. 380. V $ logmnr_dictionary log history information. 381. V $ logmnr_logs log information. 382. V $ logmnr_parameters log information. 383. V $ MTS contains information about adjusting multithreaded servers. 384. V $ mystat The statistic of the current session. 385. V $ nls_parameters Current NLS parameter information. 386. V $ nls_valid_values lists the valid values of all NLS parameters. 387. V $ Object_Dependency can determine which object is relying on the package, process or cursor currently loaded in the shared pool. 388. V $ Object_USAGE to monitor the use of the index. 389. V $ obsolete_parameter lists the old parameters. 390. V $ OFFINE_RANGE Displays offline information from the data file in the control file. 391. V $ Open_CURSOR lists the cursors of each session that is currently open and parsed. 392. V $ Option lists the status of Oracle service installation. 393. V $ parallel_degree_limit_mth Displays all effective way to limit resource allocation. 394. V $ Parameter lists information about initialization parameters. 395. V $ Parameter2 lists the parameters and parameter values that currently affect the session. 396. V $ PGASTAT lists Oracle Memory Use Statistics. 397. V $ ping is the same as V $ Cache. 398. V $ PQ_SESSTAT lists the statistics of the parallel query session. 399. V $ pq_slave An instance of each active parallel execution server statistic. 400. V $ PQ_SYSSTAT lists the statistics of the system in parallel query. 401. V $ pq_tqstat contains a statistic on parallel execution operations. Help measuring unbalanced issues in a query. 402. V $ Process contains information about the current activity process. 403. V $ proxy_archiveDLog contains a description of the archive log backup file that has a new feature called a copy of the Proxy. 404. V $ proxy_datafile contains a description of data files and control file backups that have a new feature called a PROXY copy. 405. V $ PWFILE_USERS lists users who are granted SYSDBA and SYSOPER privileges. 406. V $ PX_PROCESS contains information about the session that is running in parallel. 407. V $ px_process_sysstat contains information about sessions that are running in parallel. 408. V $ PX_Session Contains information about the session that is running in parallel. 409. V $ PX_SSSTAT contains information about the session that is running in parallel. 410. V $ queue contains information about multithreaded messages. 411. V $ queueing_mth Displays all available query resource allocation methods. 412. V $ Recover_File Displays the status of the file that requires the recovery. 413. V $ Recovery_File_Status contains a line of information on each data file for each recovery command. 414. V $ recovery_log lists information that requires archive logs that requires media recovery. This information comes from V $ log_history 415. V $ Recovery_Process can be used to track database recovery operations so that they will not be terminated. It is also used to estimate the time required to complete this operation in the process. 416. V $ recovery_status contains the statistics of the current recovery process. 417. V $ REQDist lists the statistics of histograms of the MTS scheduler request. 418. V $ reserved_words gives a list of keywords used by the PL / SQL compiler. 419. V $ Resource contains resource names and address information. 420. V $ resource_limit Displays information about the global resource usage of system resources. 421. V $ rollname lists information about all online backlivers. 422. V $ ROLLSTAT contains the statistics of the rollback segment. 423. V $ rowcache Displays statistics for the active data dictionary. 424. V $ rowcache_parent Displays information about all dual-pro objects in the data dictionary. 425. V $ ROWCACHE_SUBORDINATE Displays information about the dependent object in the data dictionary. 426. V $ RSRC_CONSUMER_GROUP Displays the data associated with the current active resource consumer user group. 427. V $ RSRC_CONSUMER_GROUP_CPU_MTH Displays all the allocation methods of all available resources for the resource consumer user group. 428. V $ RSRC_PLAN Displays the name of all current active resource scenarios. 429. V $ RSRC_PLAN_CPU_MTH Displays all available CPU resource allocation methods for the resource scheme. 430. V $ sess_io lists I / O statistics for each user session. 431. V $ session lists the session information of each session. 432. V $ session_connect_info Displays information about the network connection of the current session. 433. V $ session_cursor_cache Displays information about the cursor usage of the current session. 434. V $ session_event lists information on a session waiting for an event. 435. V $ session_longops Displays a state of a long run operation. 436. V $ session_Object_cache Displays the statistics of the object cache of the current user-talk on the local server. 437. V $ session_wait lists resources or events that are waiting for the event session. 438. V $ SESSTAT lists the user session statistics. 439. V $ SGA contains presidential measurements in the system global zone. 440. V $ SGASTAT contains details of the system's global zone. 441. V $ shared_pool_reserved lists the statistics that can help you adjust the pool and space in the shared pool. 442. V $ shared_server contains information about the shared server process. 443. V $ shared_server_monitor contains information about debugging the shared server process. 444. V $ sort_segment contains information about each sort segment in a given instance. 445. V $ SPPARAMETER lists the contents of the spfile. 446. V $ SQL lists the statistics of the SQL shared area. 447. V $ SQL_BIND_DATA If the data is available in the server, it will give each different connection variable in each cacker that queries this view. The actual connection data sent by the account. 448. V $ SQL_BIND_METADATA Displays each of the different connection variables in each cacker owned by the session of this view, displays the connection metadata provided by the client. 449. V $ SQL_CURSOR displays Debug information for each cursor associated with the session of this view. 450. V $ SQL_PLAN contains execution plan information that is loaded into the library cache. 451. V $ SQL_SHARED_CURSOR why a specific sub-standard does not explain the sharing of a subquery existing. 452. V $ SQL_SHARED_MEMEORY information about the cursor of the shared memory. 453. V $ SQL_REDIRECTION identifies the SQL statement of the reset direction. 454. V $ SQL_WORKAREA shows the workspace information used by the SQL cursor. 455. V $ SQL_WORKAREA_ACTIVE contains the inter-office information of the workspace that is currently allocated by the system. 456. V $ SQLAREA shares SQL statistics. 457. V $ SQLText contains SQL statement text that belongs to the shared SQL cursor in SGA. 458. V $ SQLTEXT_WITH_NEWLINES cannot be used instead of the new row system with a space, and the V $ SQLText functionality is the same. 459. V $ STATNAME Displays the decoding statistical name of the statistic in the V $ SESSTAT and V $ SYSTAT table. 460. V $ SUBCACHE Displays information about the dependent cache currently loaded in the library cache. 461. V $ sysstat lists system statistics. 462. V $ SYSTEM_CURSOR_CACHE system range information. 463. V $ SYSTEM_EVENT contains all information waiting for an event. 464. V $ SYSTEM_PARAMETER contains system parameter information. 465. V $ SYSTEM_PARAMETER2 The value of the currently affected parameters and parameters in the Oracle instance. 466. V $ TABLESPACE Controls Information in Tablepaces in the File. 467. V $ TEMP_CACHE_TRANSFER Displays the number of checked blocks in each data file. 468. V $ TEMP_EXTENT_MAP Displays status information of each unit of all temporary tablespaces. 469. V $ TEMP_EXTENT_POOL Displays the status of the temporary spatial cache used by a given instance. 470. V $ TEMP_PING Displays the number of blocks that detect each data file. 471. V $ TEMP_SPACE_HEADER Displays the aggregation information of each file in each temporary table space, involving how many spaces currently used in each space first. 472. V $ TEMPFILE shows information about temporary files. 473. V $ TEMPORARY_LOBS Displays temporary LOB. 474. V $ TEMPSTAT contains statistics for file read / write. 475. V $ thread contains thread information in the control file. 476. V $ TIMER lists the time at 1% seconds. 477. V $ TIMEZONE_NAMES lists the legal time zone name. 478. V $ TRANSACTION lists the activity transactions in the system. 479. V $ transaction_enqueue Shows the lock owned by the transaction status object. 480. V $ TYPE_SIZE lists the size of different database components to estimate the capacity size of data blocks. 481. V $ undostat Displays a historical statistics to display how the system works. 482. V $ Version lists the version number of the core library component in the Oracle server. 483. V $ VPD_POLICY lists all security policies related to the cursors currently in the library. 484. V $ WaitStat lists the data dictionary DBA view of block competition statistics 9i management DBA view 485. DBA_2PC_NeighBors contains connection information for the introduction or flow of unprecedented transactions. 486. DBA_ALL_TABLES Displays a description of all tables in the database. 487. DBA_Application_Roles All validation policies with function definitions. 488. DBA_ASSociations Displays the user-defined statistics. 489. DBA_AUDIT_EXISTS lists the audit trails generated by Audit NOTSTS and AUDIT EXISTS. 490. DBA_AUDIT_OBJECT Audit Track Record of all objects in the system. 491. DBA_AUDIT_SESSION lists all audit tracking information about Connect and Disconnect. 492. DBA_AUDIT_STATEMENT lists the audit tracking information about Grant, Revoke, Audit, NoAudit, ALTER System statement. 493. DBA_Audit_trail lists all audit trace entries. 494. DBA_BLOCKERS lists all sessions that are waiting for a session holding lock, but not they are waiting for a lock. 495. DBA_BASE_TABLE_MVIEWS Describes all materialized views in the database. 496. DBA_CATALOG lists all databases, views, synonyms, and sequences. 497. DBA_CLU_COLUMNS lists the mappings of the table to the aggregation column. 498. DBA_Cluster_hash_expressions list all aggregated hash Hash functions. 499. DBA_ClUnsters contains a description of all aggregations in the database. 500. DBA_COL_COMMENTS Note All the columns of all tables and views. 501. DBA_COL_PRIVS lists all privileges granted in the database. 502. DBA_COLL_TYPES Displays all named collection types in the database. 503. DBA_CONS_COLUMNS is included in the constraint definition information. 504. DBA_CONSTRAINTS definitions of all tables constraints. 505. DBA_CONTEXT information for all context namespace. 506. Information of DBA_DATA_FILES database files. 507. All database links in the DBA_DB_LINKS database. 508. All DDL locks held by the DBA_DDL_LOCKS database. 509. DBA_DependenCIES Lists dependence between objects. 510. DBA_DIM_ATTRIBUTES represents the relationship between the level and functional dependencies. 511. DBA_DIM_JOIN_KEY represents the connection between two dimensions. 512. DBA_DIM_LEVEL_KEY represents a column of a dimension. 513. DBA_DIM_LEVELS represents a dimension. 514. DBA_DIMENSIONS represents the object. 515. DBA_Directories provide information about all objects of the database. 516. DBA_DML_LOCks lists all DML locks in the database, and the request for a DML lock. 517. DBA_ERRORS lists the current error of all stored objects in the database. 518. DBA_EXP_FILES contains information for exporting files. 519. DBA_EXP_OBJECTS lists objects exported in an incremental manner. 520. DBA_EXP_VERSION contains the version number of the final export session. 521. DBA_EXTENTS lists information that makes up all segments in the database. 522. DBA_EXTERNAL_TABLES describes all external tables in the database. 523. DBA_FREE_SPACE lists the idle partitions in all tablespaces. 524. DBA_FREE_SPACE_COALESCED contains statistics in the merge space in the tablespace. 525. Synonym of DBA_HISTOGRAMS DBA_TAB_HISTOGRAMS. 526. DBA_IND_COLUMNS is included in the description of the columns that make up the index in all tables and aggregates. 527. DBA_IND_EXPRESSIONS is included in all tables and gathered expressions. 528. DBA_IND_PARTITIONS For each index partition, describing the partition information of the partition stage, the partition storage parameters, and various partition statistics determined by Analyze. 529. DBA_IND_SUBPARTITIONS The current user has every index partition, describing partition information, partition storage parameters, and various partition statistics determined by Analyze. according to. 530. Description of all indexes in the DBA_Indexes database. 531. The DBA_Indextype_comments all user-defined index types in the database. 532. DBA_INDEXTYPE_OPERATORS lists all operators supported by the index type. 533. DBA_INDEXTYPES All index types. 534. All internal triggers in the DBA_Internal_Triggers database. 535. All jobs in the DBA_JOBS database. 536. DBA_JOBS_RUNING All currently running jobs in the database. 537. DBA_JOIN_IND_COLUMNS Describes all connection conditions in the database. 538. DBA_KGLLOCK lists all locks and Pins on the KGL object. 539. DBA_Libraries lists all the libraries in the database. 540. DBA_LOB_PARTITIONS is included in the user accessible JOB. 541. DBA_LOB_SUBPARTITIONS Displays partition-level properties in the LOB data subordinate partition. 542. DBA_LOBS is included in all tables. 543. DBA_LOCK_INTERNAL contains a row of information that holds the lock or simple lock, and the one-line information of each unrequited request. 544. DBA_LOCKS lists the locks or simple locks held in the database, and each unrequited request information. 545. DBA_LOG_GROUP_COLUMNS describes information about all columns in the database specified in the log group. 546. Description of the method parameters of the type of type DBA_METHOD_PARAMS database. 547. Description of all types of method results in the DBA_METHOD_RESULTS database. 548. DBA_MVIEW_AGGREGATES The packet function that appears in the SELECT list of the instantiation view. 549. DBA_MVIEW_ANALYSIS represents the potentially supported query override. 550. DBA_MVIEW_LOG_FILTER_COLS lists all columns in the logging view log. 551. DBA_MVIEW_REFRESH_TIMES describes the refresh time of all materialized views in the database. 552. DBA_MViews describe all materialized views in the database. 553. DBA_NESTED_TABLES Description of the nested table in all tables. 554. DBA_OBJ_AUDIT_OPTS lists the audit options for all users of the user. 555. DBA_OBJECT_SIZE lists the size representation of various objects. 556. DBA_Object_tables Displays a description of all object tables in the database. 557. DBA_OBJECTS lists all objects in the database. 558. DBA_opAncillary lists additional information for operating the connectors. 559. DBA_oparguments lists the parameter information of the operator. 560. DBA_ORPHAN_KEY_TABLE reports the key values in the index of bad blocks in the base table. 561. DBA_outline_hints lists the prompts that make up the profile. 562. DBA_outlines lists information about the outstanding information. 563. DBA_PART_COL_STATISTISTICS Column statistics and histogram information of all partition tables. 564. DBA_PART_HISTOGRAMS All histogram data of the histogram all table partitions. 565. DBA_PART_INDEXES Object-level partition information for all partition indexes. 566. DBA_PART_KEY_COLUMNS partition key of all partition objects. 567. DBA_PART_LOBS describes the table-level information of the partition LOB. 568. DBA_PART_TABLES lists the object-level partition information of all partition tables. 569. DBA_PARTIAL_DROP_TABS describes the table that deletes. 570. DBA_PENDING_TRANSACTIONS provides information about the unfinished transaction. 571. DBA_POLICIES lists all security policies in the database. 572. DBA_PRIV_AUDIT_OPTS passes the current system privileges through the system and the user audit. 573. DBA_PROCEDURES All functions and processes and their related properties. 574. DBA_PROFILES Displays all startup files and restrictions. 575. DBA_PROXIES Displays information about all proxy connections in the system. 576. DBA_PUBLISHED_COLUMNS describes all tables where there is a source. 577. DBA_QUEUE_SCHEDULES describes the current propagation information. 578. DBA_QUEUE_TABLES describes the name and type of the queue in all queues created in the database. 579. DBA_QUEUES describes the operational characteristics of each queue in the database. 580. DBA_RCHILD lists all subgroups in any refresh group. 581. DBA_REFRESH lists all refresh groups. 582. DBA_REFRESH_CHILDREN lists all objects in the refresh group. 583. The REF column and REF attribute in the object type column of all tables in the DBA_REFS database. 584. DBA_REGISTERED_MVIEW_GROUPS lists the materialized view of all restructuring in this location. 585. DBA_REGISTERED_MVIEWS database all registered materialized views. 586. DBA_REGISTERED_SNAPSHOT_GROUPS lists all snapshot registration groups in the site. 587. DBA_REGISTERED_SNAPSHOTS Retrieves information about the remote snapshot of the local table. 588. DBA_REPAIR_TABLE discovered any damage found through the DBA_REPAIR.CHECK_OBJECT process. 589. DBA_RESUMABLE lists the recoverable statements executed in the system. 590. DBA_RGROUP lists all refresh groups. 591. DBA_ROLE_PRIVS lists the roles granted to the user role. 592. All roles exist in the DBA_Roles database. 593. DBA_ROLLBACK_SEGS contains a description of the rollback segment. 594. DBA_RSRC_CONSUMER_GROUP_PRIVS lists all licensed resource administrators, users, and roles. 595. DBA_RSRC_CONSUMER_GROUPS All resource consumer groups in the database. 596. DBA_RSRC_MANAGER_SYSTEM_PRIVS lists all users and roles that have been granted to the resource administrator system privilege. 597. The indication of all resource plans existing in the DBA_RSRC_PLAN_DIRECTIVES database. 598. All resource plans existing in the DBA_RSRC_PLANS database. 599. DBA_SEGMENTS assigns storage information for all database segments. 600. Description of all sequences in the DBA_SEQUENCES database. 601. DBA_SNAPSHOT_LOG_FILTER_COLS lists all filters recorded on the snapshot log. 602. DBA_SNAPSHOT_LOGS All snapshot logs in the database. 603. DBA_SNAPSHOT_REFRESH_TIMES lists the number of snapshots. 604. All snapshots in the DBA_SNAPSHOTS database. 605. Source of all storage objects in the DBA_Source database. 606. DBA_Source_Tables allows the issuer to view all existing source tables. 607. DBA_SQLJ_TYPE_ATTRS All properties about the SQLJ object in the database. 608. DBA_SQLJ_TYPE_METHODS Database All Types of Types. 609. DBA_SQLJ_TYPES Database All about SQLJ Object Type Information. 610. DBA_STMT_AUDIT_OPTS describes the current system audit options that pass the system and audited by the user. 611. DBA_STORED_SETTINGS lists the permanent parameter setting information of the storage PL / SQL unit that performs privileges. 612. DBA_SUBPART_COL_STATISTICS lists the column statistics and histogram information of the form partition. 613. DBA_SUBPART_HISTOGRAMS lists the actual data of the straight graph in the form partition. 614. DBA_SUBPART_KEY_COLUMNS allows the issuer to view all the columns of all of their predetermined issuance. 615. DBA_SUBPART_TABLES Allows the issuer to view all the issues they are ready. 616. DBA_SUBSCRIPTIONS allows the issuer to view all scheduled. 617. All synonyms in the DBA_SYNONYMS database. 618. DBA_SYS_PRIVS grants system privileges for users and roles. 619. DBA_TAB_COL_STATISTICS contains column statistics and histogram information in the DBA_TAB_COLUMNS view. 620. DBA_TAB_COLUMNS All tables, views, and aggregated description columns. 621. Detained in the DBA_TAB_Comments database Note. 622. DBA_TAB_HISTOGRAMS The histogram of all listings. 623. DBA_TAB_MODIFICATIONS Displays the modified table after all the last statistics in the database. 624. DBA_TAB_PARTITIONS The partition of the table describes its partition-level partition information, partition storage parameters, and various partition statistics determined by Analyze. 625. DBA_TAB_PRIVS lists the system privileges granted to the user's role. 626. DBA_TAB_SUBPARTITIONS The subsector of the table describes its partition level partition information, partition storage parameters, and various partition statistics determined by Analyze. ERN Moderator Posting: 2294 From: Zhongshan in Guangdong in 2003-11-24 17:05 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ ---------------------------------------------- 627. DBA_TABLES database Description of all related tables. 628. DBA_TABLESPACES Description of All Table Spaces. 629. DBA_TEMP_FILES database temporary file information. 630. All messaging information in the DBA_TRANSFORMATIONS database is delivered. 631. DBA_TRIGGER_COLS Usage of all trigger columns. 632. All triggers in the DBA_TRIGGERS database. 633. DBA_TS_QUOTAS All users' table space limit. 634. The properties of the DBA_TYPE_ATTRS database type. 635. DBA_TYPE_METHODS Describes all types of methods in the database. 636. All abstract data types in the DBA_TYPES database. 637. DBA_UNDO_EXTENTS submission time in the revoked table space. 638. DBA_UNUSED_COL_TABS Description of all unused columns. 639. DBA_UPDATABLE_COLUMNS Description of the column that can be updated by the database administrator in a connection view. 640. DBA_USERS database All user information. 641. DBA_USTATS current user information. 642. The text of the DBA_VARRAYS user can access. 643. The text of all views in the DBA_VIEWS database. 644. DBA_Waiters lists all sessions that are waiting for a lock, and lists the sessions that are blocking them from getting the lock. 9i Management Data Dictionary User View 645. USER_ALL_TABLES contains a description of the table available to the user. 646. USER_ARGUMENTS lists the parameters in the object accessible to the user. 647. User_Associations' user-defined statistics of the relevant objects of the current user. 648. User_audit_Object About the statement audit tracking record. 649. USER_AUDIT_SESSION About all audit trace records for users to connect or disconnect. 650. User_Audit_Statement lists the audit trace entries for the Grant, Revoke, Audit, NoAudit, Alter System statements issued by the user. 651. USER_AUDIT_TRAIL related to the user-related audit trace entries. 652. User_base_table_mviews The materialized view of all the useful view logs currently owned by the user. 653. User_catalog users have tables, views, synonyms, and sequences. 654. User_clu_columns User Table List of Mappings. 655. USER_CLUSTER_HASH_EXPRESSIONSSSIONSSSION All aggregates and hash functions can be accessed. 656. Description of the user's aggregation of the user_clusters. 657. User_col_comments lists the comments on the columns of the user table or view. 658. User_col_privs lists the authorizations on the column, and the user is owner, grant, or being granted. 659. USER_COL_PRIVS_MADE lists all authorizations on the columns of the user. 660. User_col_privs_recd Lists the authorization on the column, and the user is granted. 661. USER_COLL_TYPES user named collection type. 662. User_Cons_Columns The column information in the confinement definition of the user. 663. The constraint definition on the user_constraints user table. 664. User_db_links database chain information. 665. User_Dependencies Dependencies between users' objects. 666. USER_DIM_ATTRIBUTES The relationship between the current user mode under the level and functional dependencies. 667. User_dim_child_of The current user has a hierarchical relationship of 1 to N-dimensional water. 668. USER_DIM_HIERARCHIES The level of the current user has the level. 669. User_dim_join_Key The connection between the current users has. 670. User_dim_level_key The current user has a level of a level. 671. User_dim_levels The current user has a remote. 672. USER_DIMENSIONS Current User Mode Underwriting Object. 673. The current error on all storage objects of the user_errors user. 674. USER_EXTENTS is a range of segments of the user object. 675. User_External_Tables All external objects of the current user have. 676. USER_FREE_SPACE User Acquires the idle range in the table space. 678. User_histograms This view is the synonym of user_histograms. 679. User_ind_columns User Index and Columns on the Table. 680. user_ind_expressions The current user has an expression based on the function based index. 681. USER_IND_SUBPARTITIONS The current user has the properties of each of the field partitions, partition level information, storage parameters of the subsector, and various partition statistics determined by Analyze. 682. User_indexes Description of the index owned by the user. 683. User_Indextype_comments All comments for user-defined index types owned by users. 684. User_Indextype_operators All operations of the current user have the type of index. 685. User_Indextypes All index types of the current user have. 686. User_internal_triggers The internal trigger on all tables currently owned. 687. User_jobs users have all jobs. 688. user_join_ind_columns All connect conditions in the database owned by the user. 689. USER_LIBRARIES lists all libraries owned by users. 690. USER_LOB_PARTITIONS The partition level attribute in the LOB data subordinate of the current user. 691. USER_LOBS Displays the LOB contained in the user table. 692. user_log_group_columns The current user has the column specified in the log. 693. The log group definition of all tables owned by the user_log_groups database. 694. User_Method_Params The method parameters of the user type currently owned. 695. USER_MVIEW_AGGREGATES The group function that appears in the SELECT list of the aggregation instantiation view. 696. USER_MVIEW_AALYSIS All materialized views of the current user can potentially support query rewrites and have additional information available for application analysis. 697. USER_MVIEW_DETAIL_RELATIONS represents a naming detail relationship. 698. User_mview_joint describes the connection between two columns in the WHERE clause of an instantiated view. 699. USER_MVIEW_KEYS The materialized view is based on the current user mode column or expression in the SELECT list. 700. User_MView_Refresh_Times Denomes All materialized views of the current user in the database. 701. All materialized views of the current user in the USER_MVIEWS database. 702. User_nested_tables The nested table in the table owned by the user. 703. User_obj_audit_opts The audit options for the tables and views of the user. 704. USER_OBJECT_SIZE The size of the PL / SQL object owned. 705. User_Object_Tables The object table owned by the user. 706. User_Object user owns the object. 707. User_opancillary The auxiliary information of the current user has the operation. 708. User_oparguments The argument information of the current user has the operation. 709. User_opbindings The binding of the current user has the operation. 710. USER_OPERATOR_COMMENTS All comments for user-defined operations with users. 711. User_operators All the operations of the current user have. 712. User_outline_HINTS The current user has a hint setting. 713. User_outlines The current user has all the profiles. 714. User_part_col_statistics Column statistics and histogram data of the table partitions owned by the user. 715. User_Part_Histograms Currently user accessible table partitions upper pillar data. 716. User_Part_Key_Columns The partition key column of the partition object owned by the user. 717. USER_PART_INDEXES All partitions of all partitions currently have all partition information. 718. User_Part_lobs The table-level information of the current user's partition large objects. 719. USER_PART_TABLES Object-level partition information of the current user owned. 720. User_partial_drop_tabs There are some tables in the current user mode to delete all tables. 721. User_password_limits Assign the password parameter file to the user. 722. USER_POLICIES The current security policy of all objects have. 723. USER_PROCEDURES All functions and faults of the current user have and their related properties. 724. USER_PROXIES Current user is allowed to connect connection information. 725. USER_PUBLISHED_COLUMNS describes all existed source columns with privileges. 726. User_queue_schedules About the queue schedule. 727. user_queue_tables only describes the queues in the queue created in the user mode. 728. All refresh groups in each queue in the user_Queues user mode. 729. User_Refresh's current user has all the refreshes groups. 730. User_refresh_children lists all objects in the refresh group. 731. User_Refs The REF column and the REF attribute in the object type column of the user table. 732. USER_REGISTERED_MVIEWS The current user has all registered materialized views. 733. User_registered_snapshots The current user has all registered snapshots. 734. USER_RESOURCE_LIMITS current user's resource limit. 735. User_resumable lists the recoverable statements that the current user performs. 736. USER_ROLS_PRIVS lists the roles granted to the user. 737. User_rsrc_consumer_group_privs lists all resource consumption groups granted to the user. 738. User_rsrc_manager_system_privs lists all users who have been awarded the system privilege to the DBMS_Resource_manager package. 739. User_SEGMENTS lists the storage allocation information of the database segment belonging to the user object. 740. Description of user sequences of User_Sequences. 741. User_snapshot_logs All Snapshot Logs I have. 742. User_snapshot_refresh_times snapshot refresh number of times. 743. User_snapshots users can view snapshots. 744. User_source is a text source for all storage objects of the user. 745. User_sorce_tables allows you to see all existing source tables with predetermined privileges. 746. USER_SQLJ_TYPE_ATTRS The current user has all the properties of the SQLJ object. 747. User_sqlj_type_meths The current user has the type method. 748. User_SQLJ_Types The current user has information about SQLJ object type information. 749. USER_STORED_SETTINGS Current user's storage PL / SQL unit Permanent parameter setting. 750. User_SubPart_col_statistics Displays column statistics and column graphics information of the sub-partition of the sub-partition object owned by the user. 751. User_subpart_histograms Displays the actual histogram data of the histogram of the histogram of the current user owned. 752. User_subpart_key_columns Displays the current user Column statistics and histogram information of the subsequent zone of the child partition object. 753. User_subscribed_columns allows the issuer to view all the columns of all predetermined issues. 754. user_subscribed_tables allows the issuer to view all scheduled tables. 755. USER_SUBSCRIPTIONS allows the issuer to view all scheduled. 756. User_sysnonyms The private synonym of the current user has. 7 57. User_sys_privs grants the user's system privilege. 758. user_tab_col_statistics contains column statistics and histogram information in the USER_TAB_COLUMNS view. 759. User_TAB_COLUMNS user table or view or the information on the column on the aggregation. 760. USER_TAB_COMMENTS users have comments on tables or views. 761. User_Tab_histograms The column graph on the column of the user table. 762. USER_TAB_MODIFICATIONS has been modified after all last statistics have owned. 763. USER_TAB_PARTITIONS The name, storage attribute, the name of each of the sheets owned by the user, the table and the partition name. 764. Privileges on the USER_TAB_PRIVS object. 765. USER_TAB_PRIVS_MADE The user has all the privileges on the object. 766. USER_TAB_PRIVS_RECD contains privileges on the object, and the user is awarded. 767. USER_TAB_SUBPARTITIONS The name of each sub-partition owned by the user, stores attribute, its list, and partition name. 768. Description of the relationship table owned by the user_tables. 769. User_Tablespaces Description of Acquisition of Table Spaces. 770. USER_TRANSFORMATIONS The transition information of a specific user. 771. User_Trigger_cols Usage in User Triggers. 772. Description of the user_triggers user trigger. 773. User_Types Table in the table. 774. The properties of the user_type_attrs user's type. 775. USER_TS_QUOTAS user's table space limit. 776. User_Methods user method type. 777. User_unused_col_tabs contains all the tables that are not used. 778. User_UPDATABLE_COLUMNS Description of the column that the user can modify in the connection view. 779. User_Users current user information. 780. User_USTATS The user-defined statistics owned by the user. 781. User_Varrays users have all arrays. 782. User_Views The text of the user has the text. 9i Management Data Dictionary ALL View 783. All_all_tables users can access all tables. 784. All_Arguments all parameters of the user accessible objects. 785. All_Associations user-defined statistics. 786. All_base_table_mViews Acquisition All materialized view information. 787. All_catalog users can access all tables, synonyms, territory and sequences. 788. All_cluster_hash_expressions User Acquisition of the aggregated Hash function. 789. All ALL_CLUSTERS users can access all aggregates. 790. ALL_COL_COMMENTS user accessible table or view. 791. All_col_privs lists the authorizations, users or public is awarded. 792. All_col_privs_made lists the authorizations on the column, the user is the owner or authorized. 793. All_col_privs_recd lists the authorizations, users or public is the licenser. 794. All_coll_types User Acquired Named Collection Types. 795. All_cons_columns contains information that can be available in the constraint definition. 796. All_constraints lists the constraint definitions on the ready table. 797. All_context shows the upper and lower questions of the activity. 798. All_db_links user accessible data chain. 799. All_def_audit_opts contains the default object audit options applied when the object is established. 800. All_dependencies Dependencies between users accessible objects. 801. All_dim_hierarchies Displays the level of dimension. 802. All_dim_join_KEY describes the connection between the two dimensions. 803. All_dim_level_key describes the column of the dimension. 804. All_dim_levels describes the dimension level. 805. All_dimensions contains information about dimensional objects. 806. All_directories Description of all directory for users accessible. 807. All_ERRORS users can access the current error on all objects. 808. All_external_tables Users Acquiible External Table. 809. All_histograms is equal to all_tab_histograms alias. 810. All_ind_columns User Acquisition Index Columns. 811. All_ind_expressions The function index expression on the table can access. 812. All_ind_partitions describes the partition information of the partition level. 813. All_ind_subpartitons describes the partition information of the sub-partition level for the index sub-partition. 814. ALL_INDEXES The index description of the user can access. 815. All_indextype_commnets User Acquired User-Defined Index Types. 816. All_indextype_operators Displays all operators supported by the index type. 817. All_indextypes Displays all index types. 818. All_internal_triggers can access the internal trigger. 819. All jobs in the all_jobs database. 820. All_join_ind_columns describes the connection criteria that you access bitmap connection index. 821. All_libraries users can access all libraries. 822. All_lob_partitions User Acquirable Table contains LOB. 823. All_lob_subPartitions Displays the partition level of the LOB data sub-partition. 824. All_lobs User Acquirable Table contains LOB. 825. All_log_group_columns User Acquisition Defines Columns in the Log Group. 826. All_log_groups User Acquisition Log Group Definitions. 827. All_method_Params User Acquisition Type Method Parameters. 828. ALL_METHOD_RESULTS The method of the user accessible type. 829. All_mview_aggregates The group function appearing in the SELECT list of the materialized view of the total class. 830. All_mview_analysis describes the materialized view that may support query rewriting and have additional information available for application analysis, but does not include remote and non-static. 831. All_mview_detail_relations Describes the naming detail relationship of the materialized view from the list of the ALO. 832. All_mview_joins Describe the two columns between the physicalized view WHERE clause. 833. All_mview_keys Description The Naming Detail Relationship between the List of the Property Chemical View from, or indirectly be referenced by the FROM list. 834. All_mView_refresh_times User Acquired materialized view refresh time. 835. All_mviews users can access all materialized views. 836. All_nested_tables The nested table in the table can access. 837. All_Object_Tables Description of the user accessible object table. 838. All_opancillary Displays the auxiliary information of the operator. 839. All_oparguments Displays the change of the operation bundle. 840. All_opbindings Display operator bundle. 841. All_operator_comments All comments for users accessible user-defined operations. 842. All_operators User Acquisition Operator. 843. All_outline_HINTS The user can access the prompt. 844. All_outlines users can access all overview. 845. All_part_col_statistics's column statistics and histogram information of the user accessible table partition. 846. All_part_histograms The columnar data of the user can access. 847. All_Part_Indexes Currently user accessible object-level partition information for all partition indexes. 848. All_part_key_columns The partition key value of the current user can access. 849. All_part_lobs Currently user accessible partition LOB table-level information. 850. All_part_tables Object-level partition information of the current user accessible partition table. 851. All_partial_drop_tabs Currently user accessible tables with local delete tables. 852. All_policies All strategies on all tables and views of the current user can access. 853. All_procedures list all functions and procedures and related properties. 854. All_published_columns describes the source list of the existence of privileges. 855. All_Queue_Tables All queues of the current user accessible queue table. 856. All_Queues Displays queue information that users have in groups or privileges. 857. All_Refresh Current user accessible groups. 858. All_refresh_children lists all objects in the refresh group. 859. All_refresh_dependencies Displays the dependent detail or container table name for all summary or snapshots in the current mode. 860. All_Refs The Ref column and the REF attribute in the object type column that the current user can access. 861. All_registered_mviews All materialized views of the current user accessible. 862. All_registered_snapshots lists all registered snapshots. 863. All_sequences currently accessible all sequences. 864. All_snapshot_logs Currently User Acquisition Properties View Log. 865. all_snapshot_refresh_times snapshot refresh number. 866. All_source The text source of all storage objects that you can access by users. 867. All_source_tables allows the issuer to view all existing source tables. 868. All_sqlj_type_attrs You can access all properties about the SQLJ object. 869. All_sqlj_type_meth 4 The current user can access type method. 870. All_sqlj_types Current User Acquirable About SQLJ Object Type Information. 871. All_stored_settings The current user has its permanent parameter setting for the storage PL / SQL unit that performs privileges. 872. All_subpart_col_statistics contains column statistics and column information for user_tab_columns. 873. All_subpart_histograms Displays the actual histogram information of the histogram of the pillar map of the form. 874. All_subpart_key_columns Displays the subspace value of the table using the composite range / hash method partition. 875. All_subscribed_columns allows the issuer to view all the columns they are predetermined. 876. All_subscribed_tables allows the issuer to view all the tables they are-all. 877. All_subscriptions allows the issuer to view all of their reservations. 878. All_sumdelia User Acquired direct path loading entries. 879. All_synynyms users can access all synonyms. 880. All_tab_col_statistics contains column statistics and column information for all_tab_columns. 881. All_tab_columns users can access all tables, views, and aggregated columns. 882. All_tab_comments The user can access the comments in the views in the view. 883. All_tab_histograms User Acquirable Table and Culture Information in the View. 884. All_tab_modifications User Acquired last statistics have been modified after the table. 885. All_tab_privs lists licenses on objects, users or public users are granted. 886. All_tab_privs_made lists the authorization of the user's authorization and user object. 887. All_tab_privs_recd Lists authorizations on the object, users, and public are granted. 888. All_tab_subpartitions The name of each tab partition that the user can access is stored attribute, the table and partition name it belongs. 889. ALL_TABLES The description of the user accessible relationship table. 890. All_triggers users have triggers. 891. ALL_TRIGGER_COLS The column and usage of the trigger owned by the user. 892. ALL_TYPE_ATTRS The attribute of the type of user accessible. 893. ALL_TYPE_METHODS method of user accessibility type. 894. All_types User Acquisition Types. 895. All_unused_col_tabs contains all tables that are not used. 896. All_UPDATABLE_COLUMNS contains all the descriptions of all columns that can be modified in the Mo Connection view. 897. Information of all users in the All_Users database. 898. All_ustats Users can access user-defined statistics. 899. All arrays of all_varrays users can access. 900. All_views The text of the user accessible view. Oracle9i's Data Dictionary 901. CHAINED_ROWS The output of the analyze command with the List chained rows clause. 902. chainge_sources allows the issuer to view existing changes resources. 903. Change_SETS allows the issuer to view an existing change setting. 904. Change_Tables allows the issuer to view an existing change table. 905. Code_pieces Oracle Access This view is used to create a view about the size of the object. 906. Code_size Oracle Access This view is used to create a view about an object size. 907. cols user_tab_columns synonym. 908. Column_Privileges lists the authorization status on the column. 909. Database_properties lists the names of the currently default temporary table space. 910. DBMS_Alert_info Description Registered warning. 911. DBMS_LOCK_ALLOCATED describes the locks assigned by the user. 912. DePtree has information that UTLDTree.sql creates, enclose the object dependent tree. 913. Dict_columns contains a description of the data dictionary table and view column. 914. Dictionary contains a description of the data dictionary table and view columns. 915. Error_Size Oracle Access This view is used to create a view of the object size. 916. Exceptions contains a violation of complete constraints. 917. File_locks Real-time application cluster view, display the PCM lock image of the specified data file in GC_FILES_TO_LOCKS. 918. File_ping real-time application cluster view, display the number of blocks connected to each data file. 919. Global_name The global name of the current database. 920. HS_all_caps contains all compatibility information about non-Oracle (FDS) data storage. 921. HS_all_dd contains data dictionary information about non-Oracle (FDS) data. 922. HS_all_inits contains initialization parameter information about non-Oracle (FDS) data storage. 923. HS_BASE_CAPS contains basic performance information about non-Oracle (FDS) data storage. 924. HS_BASE_DD Displays information about the basic data dictionary. 925. HS_CLASS_CAPS contains class specified performance information belonging to non-Oracle (FDS) data store. 926. HS_CLASS_INIT contains information about non-Oracle (FDS) classes. 927. HS_EXTERNAL_Object_Privilege The information containing privileges on the object granted to the user. 928. HS_External_Objects contains information about all distributed external objects that Oracle servers. 929. HS_FDS_CLASS contains information about legitimate non-Oracle (FDS) classes. 930. HS_FDS_INST contains information about the legal non-Oracle (FDS) instance. 931. HS_INST_CAPS contains the performance information specified by the instance. 932. HS_INST_DD Displays information about non-Oracle (FDS) instance specific data dictionary translation. 933. HS_INST_INIT Displays information about the initialization parameters specified by the non-Oracle (FDS) instance. 934. IdePtree lists the dependence on the tree. 935. INDEX_HISTOGRAM contains information about the analysis index ... Validate structure command. 936. INDEX_STATS contains information about the Analyze Index ... Validate structure command. 937. NLS_DATABASE_PRAMETERS lists permanent NLS parameter information in the database. 938. NLS_INSTANCE_PARETERS lists permanent NLS parameter information in the instance. 939. NLS_Session_Parameters lists permanent NLS parameter information in the session. 940. Parsed_pieces Oracle Access This view is used to create a view of the object size. 941. Parsed_size Oracle Access This view is used to create a view about the size of the object. 942. PLAN_TABLE EXPLAN PLAN statement results table. 943. Pluggable_set_check contains an insertable settings check. 944. Product_component_version contains version and status information that make up the product. 945. Proxy_users describes those users who can assume other user identities. 946. PSTubTBL contains information on the root generated by the PSTUB, so that Oracle Form3.0 customers can call the stored procedures in the Oracle database. 947. Public_Deptendency lists the dependence of the object. 948. PubucSyn includes information on the common synonym. 949. Queue_Privileges Shows those privilege awarded a high-level query object to a session. 950. Resource_cost lists the overhead of each resource. 951. Resource_map contains a description of the resource. 952. Role_Role_privs contains role information granted other roles. 953. Role_sys_privs contains information about system privileges granted to the role. 954. Role_Tab_Privs contains information about the grant of a grant. 955. Session_Context lists the properties and value settings of the current session. 956. Session_privs lists the privileges available to users. 957. Session_roles lists the roles currently enabled by the user. 958. Source_size Oracle Access this view to create a view about the object size.
