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

ORACLEµ÷ÓÅÖ® ¶à»º´æ³ØÃüÖÐÂÊ£¨Õª×ÔÎÄÆ½Ê飩

ÆÀ¹ÀÊý¾Ý¸ßËÙ»º´æÐ§ÂʵÄÖ¸±êÊÇÃüÖÐÂÊ¡£¸ÃÃüÖÐÂÊͨ¹ý²éѯV$SYSSTAT ºÍ$BUFFER_POOL_STATISTICSÊÓͼ¿ÉÒԵõ½¡£Õâ¸öÊÓͼ¿ÉÒÔ
²éѯÿ¸ö»º´æ³Ø¸÷×ÔµÄÃüÖÐÂÊ¡£»º´æ³ØµÄÃüÖÐÂʵļÆËã²ÉÓÃÏÂÃæµÄ¹«Ê½:
   1-(physical_reads/(db_block_gets+consistent_gets))
   ÏÂÃæµÄSQLÓï¾ä³£ÓÃÀ´²éѯµ±Ç°¸÷¸ö»º´æ³ØµÄÃüÖÐÂÊÇé¿ö:
    SQL>select name,physical_reads,db_block_gets,consistent_gets,
        1-(physical_reads/(db_block_gets+consistent_gets))  "ÃüÖÐÂÊ"
        from v$buffer_pool_statistics;
SQL> select name,physical_reads,db_block_gets,consistent_gets,
  2          1-(physical_reads/(db_block_gets+consistent_gets))  "ÃüÖÐÂÊ"
  3          from v$buffer_pool_statistics;
NAME                 PHYSICAL_READS DB_BLOCK_GETS CONSISTENT_GETS     ??????
-------------------- -------------- ------------- --------------- ----------
DEFAULT                        3806          1541           44202 .916796013
ͨ¹ý¶ÔV$BHÊÓͼµÄ²éѯ¿ÉÒÔ»ñµÃµ±Ç°´æ·ÅÔÚSGAÖеÄËùÓÐÊý¾Ý¿éµÄ¿éID£¬ÏÂÃæÁгöÁËÁ½ÖÖ·½·¨£¬ÓÃÀ´ÕÒ³öÊý¾Ý¿â¶ÔÏó£¨±í¡¢Ë÷ÒýµÈ
¶Î¶ÔÏó£©Õ¼ÓÃÊý¾Ý»º´æµÄ״̬£¬»òÕßij¸ö¶ÎʹÓûº´æµÄÇé¿ö¡£ÏÂÁеIJéѯÓï¾äÁгöÁ˵±Ç°Êý¾Ý¸ßËÙ»º´æÖдæ·ÅµÄËùÓÐÊý¾Ý¿éµÄ¶ÎÃû£¬
ÒÔ¼°¸Ã¶ÎÔÚÊý¾Ý»º´æÖÐÊý¾Ý¿éµÄ¼ÆÊý:
  SQL>select o.object_name OBJECT_NAME,count(*) number_of_blocks
        from dba_objects o,v$BH bh
        where o.data_object_id=bh.objd
        and o.owner  not in('SYS','SYSMAN')
  


Ïà¹ØÎĵµ£º

OracleµÄrownumÔ­ÀíºÍʹÓÃ

Ô­Îijö×Ô£ºhttp://tenn.javaeye.com/blog/99339
ÔÚOracle
ÖУ¬Òª°´Ìض¨Ìõ¼þ²éѯǰNÌõ¼Ç¼£¬Óøörownum
¾Í¸ã¶¨ÁË¡£ 
select * from emp where rownum
 <= 5 
¶øÇÒÊéÉÏÒ²¸æ½ë£¬²»ÄܶÔrownum
ÓÃ">"£¬ÕâÒ²¾ÍÒâζ×Å£¬Èç¹ûÄãÏëÓÃ
 
select * from emp where rownum
&nbs ......

µÇ¼oracleÊý¾Ý¿âʱ³£ÓõIJÙ×÷ÃüÁîÕûÀí

¼oracleÊý¾Ý¿âʱ³£ÓõIJÙ×÷ÃüÁîÕûÀí
1¡¢su – oracle ²»ÊDZØÐ裬ÊʺÏÓÚûÓÐDBAÃÜÂëʱʹÓ㬿ÉÒÔ²»ÓÃÃÜÂëÀ´½øÈësqlplus½çÃæ¡£
2¡¢sqlplus /nolog »òsqlplus system/manager »ò./sqlplus system/manager@ora9i;
3¡¢SQL>connect / as sysdba ;£¨as sysoper£©»ò
connect internal/oracle AS SYSDBA ;(scott/tiger) ......

OracleÖÐNullÓë¿Õ×Ö·û´®''µÄÇø±ð

¾­²âÊÔ£¬ÔÚOracleÖУ¬¶ÔÓÚnullºÍ¿Õ×Ö·û´®'',webMethods JDBC Adapter ²éѯ³öÀ´¶¼»áÏÔʾnull.
¶øÔÚSQL SERVERÖУ¬»á·Ö±ðÏÖʵΪnullºÍ¿Õ×Ö·û´®¡£
º¬Òå½âÊÍ£º
ÎÊ£ºÊ²Ã´ÊÇNULL£¿
´ð£ºÔÚÎÒÃDz»ÖªµÀ¾ßÌåÓÐʲôÊý¾ÝµÄʱºò£¬Ò²¼´Î´Öª£¬¿ÉÒÔÓÃNULL£¬ÎÒÃdzÆËüΪ¿Õ£¬ORACLEÖУ¬º¬ÓпÕÖµµÄ±íÁ㤶ÈΪÁã¡£
ORACLEÔÊÐíÈκÎÒ»ÖÖÊý¾ ......

Ò»µãOracle±Ê¼Ç

Oracle
1£¬shutdownÖ®ºó£¬ÈçºÎÆô¶¯Êý¾Ý¿âʵÀý£¿
ͨ¹ýCMDÃüÁî·û sqlplus "sys/password as
sysdba"£¬»áÁ¬µ½Ò»¸ö¿ÕÏÐʵÀý£¬ÕâÑù¿ÉÔÙÓÃstartupÃüÁî¡£
2£¬×°ÁËÊý¾Ý¿âÖ®ºó£¬ÓÃÁËshutdown£¬ºóÓÃÁËstartupµÈÆô¶¯Ö®ºó£¬¿ÉÓÃsql
plusºÍÍøÒ³·½Ê½Á¬oracle¡£µ«ÓÃjdbcÁ¬½Ó³ö´í£¿
ÊǼàÌýÆ÷ûÆô¶¯£ºD:\oracle\product\10.1.0\Db_1\ ......

oracle Êý¾Ý¿âÄêµ×¼ì²é


oracle Êý¾Ý¿âµÄά»¤
¿ì¹ýÄêÁË£¬¸÷¼Ò¹«Ë¾¶¼Òª×¼±¸·Å¼ÙÁË£¬¸ø×Ô¼ºµÄÊý¾Ý¿â×ö¸öÌå¼ì°É£¬Ð´¸ö±¨¸æÖ®ÀàµÄ£¬ºÇºÇ¡£
¿´Á˸ö±ðÈËдµÄ ÏÈÄÃÀ´´æ×Å ÓпÕ×Ô¼º±à¸ö¡£
 
 
ÔØ×ÔoracleÖÐÎļ¼ÊõÂÛ̳¡£´ÓÕûÌåÉϽéÉÜÁËÒ»¸ödbaµÄÖ°ÔðºÍÈÎÎñµÈµÈ¡£¡¡¡¡ 
ORACLEÊý¾Ý¿â¹ÜÀíÔ±Ó¦°´ÈçÏ·½Ê½¶ÔORACLEÊý¾Ý¿âϵͳ×ö¶¨ÆÚ¼à¿Ø£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ