ORACLE¹ØÓÚÊý¾Ý×ÖµäµÄÀ§»ó~
×î½üÔÚÂÛ̳ÉÏÒ»Ö±¿´µ½ÓÐÅóÓѶÔÊý¾Ý×ÖµäÀïµÄÄÚÈݸ㲻̫Çå³þ£¬±ÈÈç˵V$¡¢V_$¡¢GV$µÈµÈ£¬µ½µ×ÄĸöÊÇͬÒå´Ê£¬ÄĸöÊÇÊÓͼ£¬Äĸö»ùÓÚÄĸö´´½¨¡£½ñÌìÕýºÃ¿´µ½¸Ç¹úÇ¿µÄ¡¶ÉîÈëdz³öORACLE¡·µÚÈýÕ½²µ½Õâ·½ÃæÄÚÈÝ£¬×ܽáһϣ¬Ò²·½±ã´ó¼Òѧϰ¡£
Êý¾Ý×ÖµäÓÉËIJ¿·Ö×é³É£º
1¡¢ÄÚ²¿RDBMS(X$)±í
X$ÊÇOracleÊý¾Ý¿âµÄºËÐIJ¿·Ö£¬ÕâЩ±íÓÃÓÚ¸ú×ÙÄÚ²¿Êý¾Ý¿âÐÅÏ¢£¬Î¬»¤Êý¾Ý¿âµÄÕý³£ÔËÐС£X$±íÊǼÓÃܵģ¬Oracleͨ¹ýX$±í½¨Á¢ÆðÆäËû´óÁ¿ÊÓͼ£¬ÌṩÓû§²éѯ¹ÜÀíÊý¾Ý¿âÖ®Óá£X$±íÊÇOracleÊý¾Ý¿âµÄÔËÐлù´¡£¬ÔÚÊý¾Ý¿âÆô¶¯Ê±ÓÉOracleÓ¦ÓóÌÐò¶¯Ì¬´´½¨¡£Oracle²»ÔÊÐísysdbaÖ®ÍâµÄÓû§Ö±½Ó·ÃÎÊX$±í£¬ÏÔʾÊÚȨ²»±»ÔÊÐí¡£
·¢ÏÖ¡¢¹Û²ì¡¢Ñо¿X$±íµÄÒ»¸öºÃ·½·¨ÊǽèÓÃOracleµÄAutotrace¹¦ÄÜ£¬µ±²éѯһЩ³£ÓÃÊÓͼʱ£¬¿ÉÒÔͨ¹ýautotrace¹¦ÄÜ·¢ÏÖÕâЩviewµÄµ×²ã±í¡£
SQL> set autotrace trace explain
SQL> select * from v$parameter;
Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT ptimizer=CHOOSE
1 0 MERGE JOIN
2 1 FIXED TABLE (FULL) OF 'X$KSPPCV'
3 1 FILTER
4 3 SORT (JOIN)
5 4 FIXED TABLE (FULL) OF 'X$KSPPI'
½éÉÜX$KVIT£¬Ãû³Æº¬ÒåΪ£º[K]ernel Layer Performance Layer [V] [I]nformation tables [T]ransitory Instance parameters£¬Õâ¸öÊÓͼ¼Ç¼µÄÊǺÍʵÀýÏà¹ØµÄһЩÄÚ²¿²ÎÊýÉèÖá£
SQL> select kvittag,kvitval,kvitdsc from x$kvit;
KVITTAG KVITVAL KVITDSC
---------- ---------- -------------------------------------------------------
kcbnbh 3000 number of buffers
kcbldq 25 large dirty queue if kcbclw reaches this
kcbdsp 25 Max percentage of LRU list dbwriter can scan for dirty
kcbfsp &
Ïà¹ØÎĵµ£º
Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æȨËùÓÐ 1985-2001 Microsoft Corp.
C:\Documents and Settings\Admin>sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 20 19:31:44 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g E ......
SQL> show user
USER is "SYS"
SQL> create user t1 identified by t1;
create user t1 identified by t1
*
ERROR at line 1:
ORA-01920: user name 'T1' conflicts with another user or role name
SQL> drop user t1 cascade;
User dropped.
SQL> create user t1 identified by t1;
Us ......
ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬¾³£»áÓõ½hint,ÏÂÃæÎÒÃÇÀ´½éÉÜÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracleÖÐ"HINT"µÄ30¸öÓ÷¨£º
¡¡¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯¡£
¡¡¡¡2. /*+FIRST_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÏìӦʱ¼ä,ʹ×ÊÔ´ÏûºÄ×îÐ ......
µ¼³öOracleÊý¾Ý¿â½á¹¹
1.·½·¨Ò»£ºÖ±½ÓдsqlÓï¾ä
//»ñÈ¡Ò»¸öSCHEMAϵÄËùÓн¨±íºÍ½¨Ë÷ÒýµÄÓï·¨£¬ÒÔscottΪÀý£º
spool portal_schema.sql
SELECT DBMS_METADATA.GET_DDL('TABLE',u.table_name)
from USER_TABLES u;
SELECT DBMS_METADATA.GET_DDL('INDEX',u.index_name)
from USER_INDEXES u;
spool off;
2. ......