Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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         &


Ïà¹ØÎĵµ£º

Oracle ÐÞ¸ÄÊý¾ÝÎļþµÄ·¾¶ºÍÃû³Æ

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

ORACLE ²é¿´Óû§ÃÜÂëÐÞ¸Äʱ¼ä

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

oracle hints

 ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬¾­³£»áÓõ½hint,ÏÂÃæÎÒÃÇÀ´½éÉÜÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracleÖÐ"HINT"µÄ30¸öÓ÷¨£º
¡¡¡¡1. /*+ALL_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯¡£
¡¡¡¡2. /*+FIRST_ROWS*/
¡¡¡¡±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÏìӦʱ¼ä,ʹ×ÊÔ´ÏûºÄ×îÐ ......

µ¼³öOracleÊý¾Ý¿â½á¹¹

µ¼³ö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. ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ