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 &
Ïà¹ØÎĵµ£º
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 ......
¶ÔÓÚx$µÄÇé¿ö
SQL> grant select on sys.x$bh to t1;
grant select on sys.x$bh to t1
ERROR at line 1:
ORA-02030: can only select from fixed tables/views
¶ÔÓÚfixed tables/viewsÖ»ÄÜselect
Èç¹ûÏë°Ñx$bhµÄselectȨÏÞgrant¸øÆäËûÓû§Ôõô°ìÄØ,¿ÉÒÔ±äͨһÏÂ
SQL> create view xbh as select * from sys.x$ ......
½â¾ö°ì·¨£º
1.ʹÓÃOracleÓû§µÇ¼ϵͳ£¬ÔÚCMDÖÐÆôÓÃSQLPLUS
2.sqlplus /nolog
3.SQL> connect /as sysdba
¡¡¡¡¡¡ Connected.
4.SQL> alter user system account unlock;
¡¡¡¡¡¡ User altered.
Ëø¶¨Õ˺ŷ½·¨£º
1.SQL> alter user system account lock;
¡¡¡¡¡¡ & ......
ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ ......
ĬÈÏÇé¿öÏ£¬ÔÚOracleµÄÖ÷»úÉÏ£¨linuxϵͳ£©µÄOracle²Ù×÷ϵͳÓû§Ï£¬ÒÔsysÓû§µÇ½Êý¾Ý¿âʱ¿ÉÒÔ²»ÓÃÊäÈëÃÜÂëÖ±½ÓµÇ¼¡£Êµ¼ÊÉÏ£¬Ö»ÒªÊÇÊôÓÚdba×飨linux£©»òosdba×飨windows£©Ï£¬¶¼¿ÉÒÔ²»ÓÃÃÜÂë½øÐеǼ¡£ÕâÊÇÈÏÖ¤·½Ê½³ÆΪOSÈÏÖ¤¡£
ÕâÖֵǼ·½Ê½µÄ¿ØÖÆ£¬ÊÇͨ¹ý$ORACLE_HOME/network/admin/sqlnet.oraÖеģº
SQLNET.AUTH ......