Oracle question question

xiaoxiao2021-03-06 65

1. The initial password after the Oracle installation is completed?

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 naked device in Oracle?

Naked equipment is the storage space that bypass direct access to the file system

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 parting optioning 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 changed to SQLPlus / Nolog to archive log type with SQLPLUS

9. How do I tell which machine is logged in 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 * from all_tab_columns where table_name = '??'

11. How to get a trigger, process, and function creation script?

DESC User_SourceUser_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 you want to check13. How to view the maximum number of sessions?

Select * from V $ Parameter where name like 'proc%;

SQL> SQL> Show parameter processes

Name Type Value ---------------------------------------------- -------------------------- AQ_TM_PROCESS INTEGER 1 DB_WRITER_PROCESS INTEGER 1 JOB_QUEUE_PROCESS INTEGER 4 log_archive_max_processes INTEGER 1 Processes Integer 200

Here 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 ArchiveLog.

INIT.ORA log_archive_start = TRUE

Restart Database

16. How do you get which users are using the database

Select Username from V $ session;

17. What 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 SID of the database?

Select Name from V $ Database; you can also directly view the init.ora file

19. How do I view this machine IP address via SQLPLUS on an Oracle server?

Select Sys_Context ('Userenv', 'IP_Address') from Dual;

If it is logging in to the local database, you can only return 127.0.0.1, huh, huh

20. How do I adjust the time for the database under UNIX?

Su -root Date -u 08010000

21. How to grab the MEMO type field empty information record in Oracle Table?

Select Remark From OMS_FlowRec Where Trim ('' from remark) is not null;

22. How to use the data of the BBB table to update the information of the AAA table (associated field)

Update aaa set bns_snm = (SELECT BNS_SNM from BBB WHERE AAA.DPT_NO = BB.DPT_NO) Where bbb.dpt_no is not null;

23. P4 computer installation method

Change Symcjit.dll to Sysmcjit.OLD

24. Which query server is OPS?

Select * from V $ Option;

If Parallel Server = True has OPS

25. Which is to check the permissions of each user?

Select * from DBA_SYS_PRIVS;

26. How do I move the table space?

Alter Table Table_name Move TableSpace_name;

27. How do I use the index mobile watch space?

Alter Index Index_name Rebuild TableSpace TableSpace_name;

28. How to start DBA Studio under Linux, Unix?

Oemapp DBASTUDIO

29. Is the subject of query lock?

V $ LOCK, V $ locked_Object, V $ Session, V $ SQLAREA, V $ Process;

The method of querying the latter: select s.SID session_id, s.username, decode (lmode, 0, 'none, 1,' null ', 2,' row-s (ss) ', 3,' Row-x (SX) ', 4,' Share ', 6,' 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 || '(' || 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 = "" - must be added to define a new editor, or write this in $ oracle_home / sqlplus / admin / glogin.sql to make it permanently valid.

32. Oracle generates a random function?

DBMS_Random.random

33. Query disk competition commands under Linux?

SAR -D

33. Query the CPU competitive situation command under Linux?

SAR -R

34. Query the current user object?

Select * from user_Objects;

Select * from DBA_SEGMENTS;

35. How to get an error message?

SELECT *.

36. How to get a link situation?

SELECT * FROM DBA_DB_LINKS;

37. View the status of database characters?

Select * from NLS_DATABASE_PARAMETERS;

Select * from V $ NLS_PARAMETERS;

38. Query the table space information?

Select * from DBA_DATA_FILES;

39. Oracle's intend user wants a password?

Modify SQLNET.ORA

SQLNET.AUTHENTICATION_SERVICES = (NTS)

40. What is the solution to Java.exe?

Generally, OracleoraHomExiHttpserver is changed to handle.

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';

Comments have been created.

SQL> SELECT * from user_tab_comments where comments is not null;

42. How do I check the condition 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_id43. If you set Oracle to MTS or dedicated mode?

#dispatches = "(Service = tcp)" 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 of the system?

SELECT MAX (KTuxescnw * Power (2, 32) KTuxescnb) from x $ ktuxe;

45. How do I get milliseconds in Oracle?

No support before 9i, 9i starts with TimeStamp.

9i can use Select SystimeStamp from Dual;

46. How do I get a return in the string?

Select 'Welcome to Visit' || CHR (10) || 'www.9cbs.net' from DUAL

47. How is the 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 Sort by the first (first order), the stroke (second order)

Schinese_stroke_m Sort by the stroke (first order), the first (second order)

SCHINESE_PINYIN_M Sort by Pinyin

48. Can the object name in Oracle8i use 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 add a line of NLS_DATE_FORMAT = 'YYYYMMDDH24MISS' in Init.ora

51. How do I put the small table in the KeeP pool?

ALTER TABLE XXX Storage (Buffer_Pool Keep);

52. How do I check if a Patch is installed?

Check what ORAINVENTORY53. How to make the SELECT statement automatically generate the serial number of the query result?

Select Rownum, Col from Table;

54. How do I know the tableSpace in a table in pattern?

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 can I make a backup table with the original table?

CREATE TABLE NEW_TABLE AS (SELECT * from Old_Table);

55. How do I modify Procedure under SQLPLUS?

SELECT LINE, TRIM (TEX) T from user_source where name = 'a' order by line;

56. How to remove procedure to lock it unexpected?

ALTER SYSTEM KILL Session, kill the session, but you have to check her session ID first

oral

Retreat the process again.

57. What is SQL Reference?

It is a SQL manual, including grammar, functions, etc., the document center of Oracle official website has downloads.

58. How do I view the status of the database?

Under UNIX PS-EF | GREP ORA Windows Look at the service if the service can be connected to the database

59. How to modify the primary key of a table?

Alter Table AAA Drop Constraint AAA_KEY; ALTER TABLE AAA Add Constraint AAA_KEY PRIMARY Key (A1, B1);

60. Change the size of the data file?

Use Alter Database .... DataFile ....; Handmade the size of the data file, which is damaged for the original data file.

61. How do you check in Oracle in run?

View v $ sessions table

62. How can I see how many tablespaces do you have?

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 do I find the last update time of a record?

Can be viewed with Logminer

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 {&} T', '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 be supported

69. What software is Data Guard?

Is the replacement of Standby

70. How to create a spfile?

SQL> Connect / As Sysdba SQL> SELECT * FROM V $ VERSION; SQL> CREATE PFILE from Pfile; 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 the number of memory available. 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 sum of the value of the processes of each Oracle instance, the sum of the value (remove the largest processes parameter) the number of the maximum of the 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?

SQL> conn sys / change_on_installsql> select * from v_ $ pWFILE_USERS;

73. How to back up one or more tables alone?

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 do I have a full-text search for a CLOB field?

Select * from a where dbms_lob.instr (a.a, 'k', 1, 1)> 0;

76. How do I display the current connection user?

SHOW User

77. How do I view the path to the data file?

Col File_Name Format A50SQL> SELECT TABLESPACE_NAME, FILE_ID, BYTES / 1024/1024, File_Name from DBA_DATA_FILES ORDER BY FILE_ID;

78. How to check the existing rollback segment and its status?

SQL> Col Segment Format A30Sql> SELECT Segment_Name, Owner, TableSpace_Name, Segment_ID, File_ID, Status from DBA_ROLLBACK_SEGS

79. How to change the CHECK range initially defined by a field?

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?

Display these files from 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 get an external connection?

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 a script SQL file?

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 do I test the time used by the SQL statement?

SQL> SET TIMING ON;

SQL> Select * from Tablename;

88. Is the reaction function of chr ()?

ASCII ()

SELECT Char (65) from Dual;

SELECT ASCII ('a') from Dual;

89. Connection of strings

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: /Abcd.txt;

SQL> SELECT *.

SQL> Spool OFF;

91. How to estimate the I / O number of SQL execution?

SQL> Set autotrace on;

SQL> SELECT *.

Oral

SQL> SELECT * FROM V $ fileStat;

You can view the number of IO

92. How do I change the field size under SQLPLUS?

Alter Table Table_name Modify (Field_Name Varchar2 (100));

Change the big line, change, unless it is empty)

93. How do I query a day of data?

Select * from table_name where trunc = to_date ('2003-05-02', 'YYYY-MM-DD'); 94. How do SQL statements insert 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 you modify the table name?

Alter Table Old_table_name rename to new_table_name;

96. How do I 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, SPFILED 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 into spfile. It is 9i new and is the default parameter file. After binary format startup, only PFile should

101. How to search for the first N record?

Select * from Employee WHERE ROWNUM

102. How do I know how much does the Oracle support on the machine?

SQL> CONN INTERNAL; SQL> Show parameter processs;

103. Can DB_BLOCK_SIZE can be modified?

Generally, it is not recommended.

104. How to count the total number of records of two tables?

SELECT (SELECT Count (ID) from AA) (SELECT Count (ID) from bb) Total from DUAL;

105. How do I use the SQL statement to find the nth value in a column?

Select * from (Select T. *, Dense_Rank () over (Order By Sal) where rank = n;

106. How do I add 2 years when giving an existing date? (

SELECT Add_MontHS (Sysdate, 24) from Dual;

107. What does it mean for use_ublk to negative?

IT IS "harmless".

108. What does Connect String mean?

It should be the content behind the service name in tnsnames.ora

109. How to expand the size of the Redo Log?

Create a temporary Redolog group, then switch the log, delete the previous log, and create a new log.

110. Is the TABLESPACE not greater than 4G?

no limit.

111. Return to the minimum integer value equal to N?

Select CEIL (n) from dual;

112. Returns the minimum integer value equal to N?

SELECT FLOOR (N) from Dual; 113. Returns the last day of the current month?

SELECT LAST_DAY (SYSDATE) from DUAL

114. How do you have different user data imports?

IMP system / manager file = aa.dmp fromuser = user_old baser = user_new rows = y indexes = y;

115. How do I 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. What is the function of two result sets?

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. Function of two result sets? SQL> SELECT * from bsempms_old minus select * from bsempms_new;

118. How to configure sequence?

Create SEQUENCE SEQ_CUSTID CREATE SEQUENCE SEQ_CUSTID START 1 IncremeMT by 1; CREATE TABLE CUST {Cust_ID Smallint Not Null, ...} Insert Insert Into Table Cust Values (seq_cust.nextval, ...)

Common way of writing of each part of the date

119>. Writing of the year of the 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>. Write actions at the time of time: select to_char (sysdate, 'dd') from dual;

122>. Writing at the time of time: select to_char (sysdate, 'hh24') from dual;

123>. Writing method for time point: select to_char (sysdate, 'mi') from dual;

124>. Write the secondary second: select to_char (sysdate, 'ss') from dual;

125>. Date of taking the time point: SELECT TRUNC (SYSDATE) from DUAL

126>. Writing time of time point: select to_char (sysdate, 'hh24: mi: ss') from dual;

127>. Date, time form becomes a characteristic SELECT TO_CHAR (SYSDATE) from DUAL

128>. Convert the string into a date or time form: SELECT TO_DATE ('2003/08/01') from DUAL;

129>. Type of Weekly Writings for the parameters: select to_char (sysdate, 'd') from dual;

130>. Returns the first few days of the year: select to_char (sysdate, 'ddd') from dual; 131>. Returns the number of seconds between the time values specified in midnight and parameters: select to_char (Sysdate, 'sssss') from dual;

132>. Returns the first few weeks of the first year: select to_char (sysdate, 'ww') from dual; virtual field 133. CURRVAL and NEXTVAL are created in the table Create Sequence Empseq ...; select Empseq.currval from Dual; Automatic Insert Sequence INSERT INTO EMP VALUES (Empseq.NextVal, 'Lewis', 'Clerk', 7902, Sysdate, 1200, NULL, 20);

134. Rownum sequentially sets the serial number Select * from EMP WHERE ROWNUM <10;

135. Return of Return Return SELECT ROWID, ENAME FROM EMP Where DEPTNO = 20;

136. Convert N-second 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);

137. How do I query to do a big sorting process? Select B.Tablespace, B. Segfile #, B.SEGBLK #, B. Blocks, A.SID, A.SERIAL #, A.USERNAME, A. OSUSER, A.STATUS A. SESSION A, V $ Sort_USAGE B WHERE A.SADDR = B.SESSION_ADDR Order by B.Tablespace, B.SEGFILE #, B.SEGBLK #, B.BLOCKS;

138. How do I query the SQL statement of the relatively large sorted 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 do I find repeated records? Select * from table_name where rowid! = (Select max (rowid) from table_name.col1 = d.col1 and table_name.col2 = d.col2);

140. How to delete a repeated record? Delete from table_name where rowid! = (SELECT MAX "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, increasing the size of the zone, set a high Optimal value.

143. The spatial space of the transaction requirements is not enough, and it is characterized by a table space (ORA-01560 error), the rollback segment extends to the value of the parameter maxExtents (ORA-01628) solution. Add a file to the split 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 Testcb (i in number) as begin dbms_output.put_line ('input parameter is' || to_CHAR (i));

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 run aa.plb sql> @ aa.plb;

145. How to monitor the cases? 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 the contention of the segment? 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 table space? 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.Phyword 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 b.statistic # = 39 and c.statistic # = 40;

151. How to monitor the hit rate of the Dictionary buffer in SGA? 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 to 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 do I 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 to monitor the redo log buffer hit ratio of the SGA, should be less than 1% SELECT name, gets, misses, immediate_gets, immediate_misses, Decode (gets, 0,0, misses / gets * 100) ratio1, Decode (immediate_gets immediate_misses, 0,0, immediate_misses / (immediate_gets immediate_misses) * 100) ratio2 FROM v $ latch WHERE name IN ( 'redo allocation', 'redo copy');

155. Monitor memory and hard disk sorting ratio, it is best to make it less than .10, add sort_area_size select name, value from v $ sortstat where name in ('sorts ",' sorts (disk));

156. How do I monitor the current database who is running 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 do I monitor the dictionary buffer? 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; When the value is greater than 0.5, the parameters need 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 is close to MTS_MAX_SERVERS, parameters need to increase 159. How do I know the current user ID number? SQL> show user; or sql > select user from dual;

160. How to view the debris level? SELECT segment_name table_name, count (*) Extents from dba_segments where owner not in ('sys', 'system') group by segment_name haVing count (*) = (select max (count (* )) From dba_segments group by segment_name);

162. How do we know the situation is stored in the table table space 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 in the table space? Select segment_name, count (*) from dba_extents where segment_type = 'index' and owner = '& oowner' group by segment_name;

164. How do I 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 VALUE / 60/100 VALUE FROM VALUE / 60/100 VALUE FROM V $ SESSION A, V $ Process B, V $ SESSSTAT C Where C .statistic # = 11 and c.SID = a.sid and a.paddr = b.addr Order by value desc;

165. How do I 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 $ Oracle_home / network / admin / tnsnames.ora

168. How do I know SQL * NET environment file? Take 8i as an example $ Oracle_Home / Network / Admin / SQLNET.ORA

169. How do I know the warning log file? Take 8i as an example $ oracle_home / admin / sid / bdump / sidalrt.log170. How to know the basic structure? Take 8i as an example $ oracle_home / rdbms / admin / standard.sql

171. How do I know the establishment of a data dictionary view? Take 8i as an example $ oracle_home / rdbms / admin / catalog.sql

172. How do I 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 how to build a snapshot data dictionary view? Take 8i as an example $ oracle_home / rdbms / admin / catsnap.sql This is mainly to say the optimization method of SQL statement! Mainly based on Oracle9i. 174. / * All_rows * / Indicates the Optimization method based on overhead, and obtains the best throughput, minimizes resource consumption. For example: SELECT / * ALL _ROWS * / EMP_NO, EMP_NAM, DAT_IN from bsempms where EMP_NO = 'ccbzzp';

175. / * first_rows * / Indicates that the 对语 selection is based on overhead optimization method, and obtain the best response time, minimize resource consumption. For example: SELECT / * first_ROWS * / EMP_NO, EMP_NAM, DAT_IN from bsempms where EMP_NO = 'CCBZZP';

176. / * choose * / Indicates that if there is a statistics of the access table in the data dictionary, the optimal throughput will be optimized, and the best throughput is achieved; indicating that if there is no access to the table in the data dictionary, it will be based on rules. Optimization method for overhead; for example: select / * choose * / EMP_NO, EMP_NAM, DAT_IN from bsempms where EMP_NO = 'CCBZP';

177. / * Rule * / Indicates the selection of the rules based on rules. For example: select / * rule * / EMP_NO, EMP_NAM, DAT_IN from bsempms where EMP_NO = 'ccbzzp';

178. / * Full (Table) * / Indicates the table to select a global scan method. For example: SELECT / * FULL (A) * / EMP_NO, EMP_NAM from bsempms a where EMP_NO = 'CCBZP';

179. / * RowId (Table) * / Tip Specifications indicate that the specified table is accessed according to ROWID. For example: SELECT / * ROWID (bsempms) * / * from bsempms where rowid> = 'Aaaaaaaaaaaaa' and EMP_NO = 'CCBZPP' ;

180. / * Cluster (Table) * / prompts clearly indicate the access method for selecting a cluster scan for the specified table, which is only valid for the cluster object. 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) * / Indicates the scan method for the table selection index. For example: select / * index (bsempms sex_index) Use sex_index because there is feWMALE bsempms * / from bsempms where sex = 'm'; 182. / * index_asc (Table Index_Name) * / Indicates a scanning method for the table to select index ascending. For example: SELECT / * INDEX_ASC (bsempms pk_bsempms) * / from bsempms where dpt_no = 'ccbzz';

183. / * index_combine * / Select bitmap to the specified table, if the index_combine does not provide an index as a parameter, the Boolean combination method of the graph index will be selected. For example: SELECT / * INDEX_COMBINE (bsempms Sal_Bmi HiRedate_bmi ) * / * From bsempms where Sal <5000000 and hidate

184. / * index_join (Table index_name) * / prompts Clear command Optimizer Use the index as an access path. For example: select / * index_join (bsempms Sal_hmi Hiredate_BMI) * / Sal, Hiredate from Bsempms Where Sal <60000;

185. / * index_desc (Table Index_name) * / Indicates the table selection of the scanning method of index descending order. For example: SELECT / * INDEX_DESC (bsempms pk_bsempms) * / from bsempms where dpt_no = 'ccbzz';

186. / * index_ffs (Table INDEX_NAME) * / Performs a fast full index scan for the specified table, not a full meter scan. For example: SELECT / * INDEX_FFS (bsempms in_empnam) * / * from bsempms where dpt_no = ' TEC305 ';

187. / * add_equal table index_nam1, index_nam2, ... * / prompts to clearly perform the selection of the planning, the scanning of several single colony indexes. For example: SELECT / * INDEX_FFS (bsempms in_dptno, IN_EMPNO, IN_SEX) * / * From bsempms where EMP_NO = 'ccbzz' and dpt_no = 'TDC306';

188. / * USE_CONCAT * / Converts the OR condition behind the WHER in the query to Union All, a combination query. For example: SELECT / * USE_CONCAT * / * from bsempms where dpt_no = 'TDC506' and SEX = 'M' ;

189. / * no_expand * / For the inquiry statement behind WHERE or in-list, NO_EXPAND will prevent it from extension based on the optimizer. For example: SELECT / * NO_EXPAND * / * from bsempms where dpt_no = 'TDC506 'And sex =' m ';

190. / * NOWRITE * / Prohibition of the query override to the query block. 191. / * REWRITE * / can use the view as a parameter.

192. / * Merge (Table) * / Ability to merge the respective 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) AS AVG_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 a combraciable view no longer merged. 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 * / Sequence in from FROM according to the table, Ordered Connect Oracle in this order. 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 the nested connection, 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 to other line silences 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 lines. For example: SELECT / * USE_HASH (BSEMPMS, BSDPTMS) * / * from bsempms, bsdptms where bsempms.dpt_no = BSDPTMS.DPT_NO;

198. / * DRIVING_SITE (TABLE) * / Force Different tables different from Oracle to perform query execution. For example: SELECT / * DRIVING_SITE (DEPT) * / * from bsempms, dept @ bsdptms where bsempms.dpt_no = dept .Dpt_no;

199. / * Leading (Table) * / The specified table is used as the first table in the connection. 200. / * Cache (Table) * / When full table scanning, the Cache prompts to place the retrieval block of the table. The most recent use end of the minimum list LRU in the buffer cache, for example, for example: select / * full (bsempms) cahe (bsempms) * / EMP_NAM from bsempms;

201. / * Nocache (Table) * / When a full mesh 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, for example: SELECT / * FULL (BSEMPMS) Nocahe (bsempms) * / EMP_NAM from bsempms; 202. / * Append * / Directly inserted to the table, the speed can be improved. Insert / * append * / INTO TEST1 Select * from test4; 203. / * NoAppend * / By starting routine insertion by stopping parallel mode during the insertion statement survival.

INSERT / * NoAppend * / INTO TEST1 Select * from test4; Oracle internal function articles 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; Result: 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 a string char length. SELECT Length ('Abcde') from DUAL;

210. Lower (char) all turn all the string char to lowercase. SELECT LOWER ('Abcde') from Dual;

211. LPAD (CHAR1, N, CHAR2) Filled CHAR1 with a string char2, making it a length of N. SELECT LPAD ('Abcdefg', 10'123 ') from Dual; Result:' 123ABCDEFG '212. LTRIM (CHAR, SET) Move the character in the string set from the left side of the string char, until the first one is not a character in the set. SELECT ('cdefg', 'cd') from dual; Result: 'EFG'

213. NLS_INITCAP (CHAR) Take the first character of Charity Char, the rest of the character is lowercase. SELECT NLS_INITCAP ('Abcde') from DUAL

214. NLS_LOWER (Char) All characters included in the string Char. 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) replaced 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) with string char2 Right Filter Char1 to make it a length of N. SELECT RPAD ('234', 8, '0') from DUAL;

218. RTRIM (Char, SET) Removes the character in the string set on the right side of the string, until the last one is not the character in the set. SELECT RTRIM ('Abcde', 'DE') from DUAL

219. Substr (CHAR, M, N) gets N characters starting from M. Dual-byte characters, a Chinese character, a character. SELECT SUBSTR ('Abcde', 2, 3) from Dual;

220. Substrb (CHAR, M, N) Gets N characters starting from M. Double-byte characters, one Chinese character. SELECT SUBSTRB ('Abcde', 2, 3) from Dual;

221. Translate (Char1, Char2, Char3) Replace the portion of Char2 in Char1 with Char3. Select Translate ('Abcdefgh', 'DE', 'Mn') from DUAL

222. Upper (char) All string char is all uppercase.

223. Add_months (d, n) increases N month to 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 date. SELECT LAST_DAY (SYSDATE) from DUAL

225. Month_between (D1, D2) Get the number of months between two dates. SELECT MONTH_BETWEEN (D1, D2) from DUAL;

226. Next_day (d, char) gets the date of the first Sunday named by char than the date D night. SELECT NEXT_DAY (To_Date ('2003/09/20'), 'Satday') from DUAL;

227. Rount (d, fmt) Get the most intake date 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 the string char in the FMT format. SELECT TO_DATE ('2003/09/20', 'YYYY / MM / DD') from DUAL

231. ABS (N) Gets the absolute value of N. SELECT ABS (-6) from Dual;

232. CEIL (n) Gets the most integer 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 hype sincain value of N. SELECT COSH (1) from Dual;

236. EXP (n) Gets the N power of the E of N. SELECT Exp (1) from dual;

237. Floor (n) Gets minimum integer less than or equal to N. SELECT FLOOR (5.6) from Dual;

238. ln (n) Get N of Natural logs. SELECT LN (1) from Dual;

239. LOG (M, N) Gets the logarithm of the bottom N. SELECT log (2, 8) from DUAL;

240. MOD (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) rounds 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 nose value of N. SELECT TAN (0) from DUAL;

247. Tanh (n) Gets the hyperbolic nose value of N. SELECT TANH (0) from DUAL;

248. Trunc (n, m) Gets the value of N cut off 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 sum: SELECT MAX (col1) from table1;

251. min () for the specified sum: SELECT MIN (COL1) from table1;

252. AVG () for the specified sum: SELECT AVG (COL1) from table1;

253. Sum () Calculate 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 the CHAR or VARCHAR2 value of the external syntax RowID to the internal binary syntax, the parameter char must be a string of 18 characters containing external syntax. Select Name from bsempms where rowid = Chartorowid ('AaaaafzaabaaAcp8aao '); Name: Leixue

256. Convert (CHAR, DEST_CHAR_SET, SOURCE_CHAR_SET) CONVERT converts characters from the string char to the character set of the Source_Char_set to the character set identified by the dest_char_set

SELECT Convert Convert ('grob ")' traffic 'from Pubs; Conversion: Gross257. 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 into 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 the equivalent multi-byte character. SELECT TO_MULTI_BYTE ('asfdfd') from test;

261. TO_SINGLE_BYTE (Char) converts the multi-byte characters in char. SELECT TO_SINGLE_BYTE ('asfdfd') from test;

262. Translate Using (Text USING {char_cs | nchar_cs}) Convert text Text into a database character set and national character set according to the specified conversion. The text is to be converted. Using char_cs parameter conversion text is the database character set, output data The type is varchar2. Using nchar_cs parameter conversion text is the database character set, the output data type is nvarchar2. Create Table Test (CHAR_COL Char (20), nchar_col nchar (20)); Insert Into Test Values ('Hi, N'Bye') Select * from test; 263. Dump (expr, return_format, start_position, length) Returns a varchar2 value including the information of the data type code, byte length, and the like. The return result is the current database character set, the data type is specified below The encoding of internal data types 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 parameter RETUEN_FORMAT specifies the number of returned values in accordance with the base below. Return_Format Result 8 8 System 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 longth are specified, the byte starting from start_position will be returned, Is returning an integer representation. SELECT DUMP ('ABC', 1016) from test; select dump (ename, 8, 3, 2) 'Example' from EMP W Here name = 'ccbzz'; 264. Empty_b | clob () Returns an empty LOB locator, used in initializing the LOB variable, or uses 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 alias of the actual search path on the server's file system. FILENAME Refers to the file name of the server's file system. Insert Into file_tab value (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 parameters. SELECT Least ('Harry', 'Harriot', 'Harold') 'Sample' from Table1; 268. NLS_CHARSET_DECL_LEN (Bytecnt, CSID) Returns one width NCHAR column SELECT NLS_CHARSET_DECL_LEN (200, NLS_CHARSET_ID ( 'JA16EEFDFDF')) FROM TABLE1;. 269 NLS_CHARSET_ID (TEXT) returns the corresponding NLS character set name number NLS character set ID SELECT NLS_CHARSET_D ( 'JADFDFFDF') FROM TABLE1.;

270. NLS_CHARSET_NAME (N) Returns the NLS character set name corresponding to the ID number N. SELECT NLS_CHARSET_NAME (2) from table1;

271. NVL (Expr1, Expr2) If EXPR1 is NULL, return EXPR2, otherwise return EXPR1. SELECT NAME, NVL (To_Char (COMM), 'Not Application' from table1;

272. UID Returns an integer that identifies the current database user. SELECT UID from table1;

273. USER Returns the name of the current Oracle user with a varchar2 data type. SELECT USER, UID from table1;

274. Userenv (option) Returns the current session information. Option = 'isdba' If the current is the DBA role, TRUE, otherwise false 'returns the character set of the database. Option =' sessionID 'is the current session ID . Option = 'entryid' Returns the auditable session identifier. Option = 'language' returns the ISO newspaper of the session language name. Option = 'instance' returns the current instance. SELECT Userenv ('Language') from Dual;

275. VSIZE (EXPR) Returns the number of bytes represented by 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) converts the parameter R to 16-based. SELECT REFTOHEX (C2) from table1;

278. Make_ref (Table, Key, Key ...) Creates a reference to a row in a given view object by treating 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, B) AS SELECT * from TB1; SELECT MAKE_REF (V1, 1, 3) from Pubs;

279. stddev (DistINCT | All X) stddev gives a quotation of a set of row values. Select stddev (Salary) AS Example from Employee

280. Variance (DistINCT | All X) Variance Returns the variance of all VALUE in a row. 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 sessions.

282. V $ ACTIVE_INSTANCES

Establish a mapping from the instance name to the 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

The queue of the queue in the current database.

285. V $ Archive

The information you need to make the log file required.

286. V $ archive_dest

All files for all archive logs of the current instance, and their current values, patterns, and status.

287. V $ archive_processes

Provide information for different ARCH process status for an example.

288. V $ archive_log

Control the archive log information in the file.

289. V $ BACKUP

The backup status of all online data files.

290. V $ backup_async_io

Display the information of the backup set from the control file.

291. V $ backup_corruption

Displays information about corruption from the control file backup.

292. V $ backup_datafile

Displays the backup data files and backup control files from the control file.

293. V $ backup_device

Display information about supporting the backup device.

294. V $ backup_piece

Display the information of the backup block from the control file.

295. V $ backup_redolog

Display information about the backup set archive log from the control file.

296. V $ backup_set

Display the information of the backup set from the control file.

297. V $ backup_sync_io

Display the information of the backup set from the control file.

298. V $ BGPROCESS

Describe the background process.

299. V $ BH

It is a real-time application cluster view of 9i. The number of status and probing is given to each buffer in the system's global zone.

300. V $ BSP

Displays statistics on the background process of the block server background in the cache.

301. V $ buffer_pool

Displays information about the instance buffer pool.

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 envoy the platform lock manager identifier.

305. V $ Cache_TRANSFER

In addition to only those blocks that are probed at least once, and the V $ cache function is the same.

306. V $ CIRCUIT

Contains information about the virtual circuit, 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

Display the feature 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

List the setting properties of the current dialog.

311. V $ ControlFile

List the name of the control file.

312. V $ controlfile_record_section

Displays information about the control file recording section.

313. V $ COPY_CORRUPTION

Display information of corruption in the control file.

314. V $ CR_BLOCK_SERVER

Displays statistics on the background process of the block server background 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 copy of the database file file in the control file.

318. V $ dataFile_Header

Display data file information of the header of the data file. 319. V $ db_cache_advice

Estimate 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

List all data files that make up the database.

323. V $ dblink

Query all database connections that sessions open.

324. V $ deleted_Object

The archive log is deleted in the display control file.

325. V $ dispatcher

Provide information about the schedule process.

326. V $ dispatcher_rate

Provide high quality providing rate statistics for the scheduling process.

327. V $ dlm_all_locks

List the information of all current locks.

328. V $ dlm_convert_local

The time consumed by the local lock conversion operation.

329. V $ dlm_convert_remote

The time consumed by the remote lock conversion operation.

330. V $ dlm_latch

It is Outdated, see V $ Latch

331. V $ DLM_LOCKS

These are locking messages that are blocked or block other objects known to the lock manager.

332. V $ dlm_misc

Display a variety of DLM statistics.

333. V $ DLM_RESS

Displays information about all resources known to the current lock manager.

334. V $ enabledprive

Display the granted 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

It is possible to get a buffer that the exploration failed.

339. V $ fast_start_servers

Perform information of all the subordinate operations recovered in parallel operations.

340. V $ fast_start_transactions

Transaction progress information in recovery.

341. V $ file_cache_transfer

Displays the number of blocks detected in each data file.

342. V $ file_ping

Display the number of blocks that each data file is proud.

343. V $ filestat

Contains files about read / write statistics.

344. V $ fixed_table

Display 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

You can find a lock that protects more cache.

347. V $ GES_BLOCKING_ENQUEUE

These are locking messages that are blocked or block other objects known to the lock manager.

348. V $ GES_CONVERT_LOCAL

The time consumed by the local lock conversion operation.

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

9cbs

New Post(0)