Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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         &


Ïà¹ØÎĵµ£º

jdbcÁ¬½ÓOracle

      ËäȻѧϰJavaºÜ¾ÃÁË£¬×Ô¼ºÒ²Á¬½Ó¹ýһЩÊý¾Ý¿â£¬±ÈÈçmysqlÖ®ÀàµÄ£¬Èç½ñÄØ£¬Ò²Ñ§Ï°ÁËÒ»¶Îʱ¼äµÄOracle£¬È»¶øÄØ£¬½ñÌìÊÇÎÒµÚÒ»´ÎÁ¬½ÓOracle£¬ºÙºÙ£¬Ó¦¸Ã»¹²»ËãÌ«³Ù°É¡£
    ½ñÌìÄØ£¬Óе㱿׾£¬´ó¼ÒĪЦ£¡
    ÎÒÕâÊÇÒ»¸ö²éѯÀý×Ó
    Ê×ÏÈ£¬Ô ......

WindowsÏÂÃüÁîÐÐÆô¶¯Oracle 10g/Database Control

 
1.Æô¶¯TNS¼àÌý
C:\Documents and Settings\Administrator>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 13-7ÔÂ -2008 12:0
3:55
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Æô¶¯tnslsnr: ÇëÉÔºò...
TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Pr ......

oracle hints

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

С²ËÄñÎÊ£ºoracleÖеÄÒ»¸ö´¥·¢Æ÷ÎÊÌâ

ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ ......

Oracle job ¹ÜÀí£¨×ªÔØ£©


Oracle job ¹ÜÀí
 
 
SVRMGR> select * from dba_jobs;
³õʼ»¯Ïà¹Ø²ÎÊýjob_queue_processes
alter system set job_queue_processes=39 scope=spfile;//×î´óÖµ²»Äܳ¬¹ý1000  ;job_queue_interval = 10  //µ÷¶È×÷ҵˢÐÂƵÂÊÃëΪµ¥Î»
DBA_JOBS describes all jobs in the database.
USER_JO ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ