,´íÎó´úÂë)£»×îºóÔÚEXCEPTION ´¦when ´íÎóÃûthen 3£®Óû§×Ô¶¨ÒåÀýÍ⣬²»ÓÃEXCEPTION£¬µ±ÅжÏÌõ¼þ³ÉÊìʱÓÃraise_application_error(-20000~~~-20999£¬ÌáʾÐÅÏ¢)¡£ 13¡¢ ÅжÏÏÂÁÐÂÛÊöÊÇ·ñÕýÈ·¡£ (1) Ò»¸öÊÂÎñÖеÄijÌõSQLÃüÁîÌύʱ£¬ÆäËüSQLÃüÁî¿ÉÒÔ²»Ìá½»¡£ (2) ÔÚÒ»¸ö¹Øϵ±íÖУ¬Ö÷¼ü¿ÉΨһ±êʶһÐмǼ¡£ (3) Ò»¸ö¹Øϵ±íÖеÄÍâ¼ü±Ø¶¨ÊÇÁíÒ»±íÖеÄÖ÷¼ü¡£ (4) »Ø¹ö¿ÉÒÔÔÚÊÂÎñʧ°Üʱ£¬»Øµ½²Ù×÷ÊÂÎñÇ°µÄÊý¾Ý״̬¡£ ´ð°¸£º (1)´íÎó (2)ÕýÈ· (3)ÕýÈ· (4)ÕýÈ· 14¡¢ ÒÔÏÂÄÄЩÊֶοɱ£Ö¤Êý¾Ý¿âÖÐÊý¾ÝµÄÍêÕûÐÔºÍÒ»ÖÂÐÔ£º (1)×Ô¶¨ÒåÊý¾ÝÀàÐÍ (2)´¥·¢Æ÷ (3)Ö÷¼üºÍÍâ¼ü (4)ÊÂÎñ ´ð°¸£º (1)(2)(3)(4) £¨ÎªÊ²Ã´ÓÐ1£© 15¡¢ ʹÓô洢¹ý³Ì·ÃÎÊÊý¾Ý¿â±ÈÖ±½ÓÓÃSQLÓï¾ä·ÃÎÊÓÐÄÄЩÓŵ㣿 ´ð°¸£º´æ´¢¹ý³ÌÊÇÔ¤±àÒë¹ýµÄ£¬Ö´ÐÐʱÎðÐë±àÒ룬ִÐÐËٶȸü¿ì£»´æ´¢¹ý³Ì·â×°ÁËÒ»ÅúSQLÓï¾ä£¬±ãÓÚά»¤Êý¾ÝµÄÍêÕûÐÔÓëÒ»ÖÂÐÔ£»¿ÉÒÔʵÏÖ´úÂëµÄ¸´Óᣠ1. ¸ß¼¶ 16¡¢ ¶ÔÓÚ¾«Í¨µÄÊý¾Ý¿âϵͳÃèÊöÆäÌåϵ½á¹¹,Ö÷Òª°üÀ¨´æ´¢»úÖÆ¡¢»Ø¹ö»úÖÆ¡¢ÔËÐлúÖƵÈ. ´ð°¸£º¶Ôoracle ϵͳ¶øÑÔ,ÃèÊösgaµÄ½á¹¹; ºǫ́pmon,ckpt¡¢lgwr,smonµÈ½ø³ÌµÄ¹¦ÄÜ;±í¿Õ¼äµÄ·ÖÅä²ßÂÔ; »Ø¹ö¶ÎµÄ½á¹¹ oracleµÄsga£¨ÏµÍ³È«¾ÖÇø£©°üÀ¨µÄÖ÷ÒªÇøÓУºÊý¾Ý¿â»º´æÇø£¬ÖØ×öÈÕÖ¾»º´æÇø£¬¹²Ïí³Ø£¨Êý¾Ý×ֵ仺´æºÍ¿â»º´æ£©£¬´ó³ØµÈ¡£Êý¾Ý¿â»º´æÇøÓÃÀ´´æ·Å×î½üʹÓùýµÄÊý¾Ý¿éÖ÷ÒªºÍºǫ́½ø³ÌÖеÄÊý¾Ý¿âд½ø³Ì(DBWR)ÒÔ¼°Êý¾ÝÎļþ·¢Éú¹Øϵ£»ÖØ×öÈÕÖ¾»º´æÇøÓÃÓÚ´æ·Å²Ù×÷Êý¾Ý¿âÊý¾ÝËù²úÉúµÄÖØ×öÈÕÖ¾ÐÅÏ¢£¬ÓëÖ®ºÏ×÷µÄÓÐÖØ×öÈÕ־д½ø³Ì(LGWR)ºÍÖØ×öÈÕÖ¾Îļþ£»¹²Ïí³ØÖ÷Òª»º´æSQL/PLSQL£¬×ÊÔ´Ëø£¬¿ØÖÆÐÅÏ¢µÈ£¬ÆäÖеĿ⻺´æÖ÷Òª»º´æ±»½âÎöÖ´ÐйýµÄSQL/PLSQL¿â»º´æ¿É·ÖΪ¹²ÏíSQLºÍ˽ÓÐSQLÁ½¸öÇø£¬¹²ÏíSQLÓÃÓÚ´æ·ÅSQLÓï¾äµÄÓï·¨·ÖÎö½á¹ûºÍÖ´Ðмƻ®£¬Ë½ÓÐSQLÔòÓÃÀ´´æ·ÅÓë¾ßÌåSQLÓï¾äÖ´ÐÐÓйصİ󶨱äÁ¿£¬»á»°²ÎÊýµÈ¡£ ORACLEʵÀýµÄÁíÍâÒ»¸öÖØÒª²¿·Ö¾ÍÊÇÆäºǫ́½ø³Ì£¬Ö÷ÒªµÄºǫ́½ø³ÌÓУºÊý¾Ý¿âд½ø³Ì£¨DBWR£©£¬ÖØ×öÈÕ־д½ø³Ì£¨LGWR£©£¬ÏµÍ³¼àÊÓÆ÷£¨SMON£©£¬½ø³Ì¼àÊÓÆ÷£¨PMON£©£¬¼ì²éµã½ø³Ì£¨CKPT£©¡£DBWRÖ÷ÒªÊǶÔÊý¾Ý¿â»º´æÇøÖеÄÔàÀäÊý¾Ý½øÐÐдÈëÊý¾ÝÎļþ²Ù×÷£»LGWRÖ÷ÒªÊǽ«¶ÔÊý¾Ý¿âÊý¾Ý²Ù×÷Ëù²úÉúµÄÖØ×öÈÕÖ¾ÐÅϢдÈëµ½ÖØ×öÈÕÖ¾ÎļþÖУ»SMONÍê³ÉÓÉÓÚ·ÇÕý³£¹Ø±ÕÊý¾Ý¿âµÄÇé¿öÏÂÖØÆðÊý¾Ý¿âʱ¶ÔÊý¾Ý¿âµÄ»Ö¸´£»PMONÓÃÀ´»Ö¸´Ê§°ÜµÄÓû§½ø³ÌºÍ·þÎñ½ø³Ì£¬²¢ÊÍ·ÅÆäËùÕ¼µÄϵͳ×ÊÔ´£»CKPT¿ÉÒÔ±íʾÊý¾Ý¿âÔڴ˳ö´¦ÓÚÍêÕû״̬¡£ Âß¼´æ´¢½á¹¹£ºÊý¾Ý¿éBLOCK£¬ÇøEXTENT£¬¶ÎSEGMENT£¬±í¿Õ¼äTABLESPACE ÎïÀí´æ´¢¿Õ¼ä£º±í¿Õ¼ä£¬Êý¾ÝÎļþ£¬¿ØÖÆÎļþ£¬ÈÕÖ¾Îļþ£¬Êý¾Ý×Öµä Èí¼þÌåϵ½á¹¹¾ÍÊÇÉϱ߶ÔSGAºÍºǫ́½ø³ÌµÄÃèÊö¡£ 17 ¡¢¶ÔÓÚ¾«Í¨µÄÊý¾Ý¿âϵͳÃèÊöÆäÊý¾ÝÒ»ÖÂÐԵı£Ö¤»úÖÆ,°üÀ¨lock,ÊÂÎñÒ»ÖÂÐÔµÈ. ´ð°¸£º ÔÚ²¢·¢»·¾³ÏÂ,²ÉÓöàÖÖ»úÖƱ£³ÖÆäÊý¾ÝµÄÒ»ÖÂÐÔ,ÈçoracleϵͳÌṩµÄÊÂÎñ¼¶µÄÒ»ÖÂÐÔ¡¢Ðм¶Ëø¡¢±í¼¶ËøµÈµÈ. 18¡¢¶Ô¾«Í¨µÄÊý¾Ý¿âϵͳÃèÊöÆäÁª»ú±¸·Ý»úÖÆ¡¢»Ö¸´»úÖÆ,¿¼ºËÆä¶ÔÈÕÖ¾µÄÀí½â. ´ð°¸£º ÃèÊöÏà¹ØÊý¾Ý¿âµÄʵʱÁª»ú±¸·Ý²ßÂÔ,ÈçÊý¾Ý¿âϵͳÔÚÔËÐÐÖÐͨ¹ýºÎÖÖ·½Ê½±£Ö¤ÆäÊý¾ÝµÄʵʱ±¸·Ý, ³öÏÖÎÊÌâʱ,Ó¦²ÉÈ¡ºÎÖÖ°ì·¨´ÓÁª»ú±¸·Ý½øÐлָ´. ¶Ô¶Ôoracle¶øÑÔ,Æäarchive online ±¸·Ý·½Ê½Ó¦ÈçºÎÉèÖá¢ÐÞ¸Äʲô²ÎÊý¡¢ÈçºÎ°²Åű¸·Ý¿Õ¼äµÈµÈ. 19¡¢ ¾«Í¨µÄÊý¾Ý¿âϵͳÃèÊöÐÔÄÜÓÅ»¯·½·¨,°üÀ¨ÓÅ»¯µÄ²ßÂÔ¡¢²ÎÊý¡¢ÑéÖ¤·½·¨µÈ. ´ð°¸£º 20¡¢Truncate; Óë delete;µÄÇø±ð£¿(ÕâµÀÌâ¿ÉÒÔÑÜÉú³öºÜ¶àµÄÎÊÌâ±ÈÈ磺Ïë¿ìËÙµÄÇå³ýÒ»¸öºÜ´óµÄ±íÖеÄÊý¾ÝÓ¦¸ÃÓÃÉèô²Ù×÷£¿´ð°¸ÊÇ£ºÓ¦¸ÃÓÃtruncate¡£»¹ÓУ¬ÔÚ¶ÔÁ½¸öÏàͬ¼Í¼ÊýµÄ·Ö±ð±íʹÓÃÁËtruncate,ºÍdelete commit;ºó¶ÔÕâÁ½¸ö±í½øÐÐcount(*)ͳ¼Æ¼Ç¼Êý²Ù×÷£¬ÄǸö±íËٶȻá¿ìЩ£¿´ð°¸ÊÇ£ºÊ¹ÓÃÁËtruncateµÄ»á¿ìЩ¡£) 21¡¢Ð´Ò»¸ö¡®Óαꡯ²¢Ê¹ÓÃËü¡££¨ÕâµÀÌâÓ¦¸Ã×¢ÒâµÄÊÇ£ºÔÚʹÓÃÓαêºóÒ»¶¨Òª¼ÇµÃ¹Ø±ÕÓα꣩¡£ Declare Cursor cursor_name is Select * from tablename; Begin Open cursor_name; Loop Fetch cursor_name into bianliang; Exit when cursor_name%notfound; Sql¡¡.. End loop; Close cursor_name; End; 22¡¢ÔÚ´´½¨±íµÄʱºò»áÉèÖà pctfree 10 pctused 40 ¶ø´´½¨±íµÄË÷ÒýµÄʱºòȴûÓÐ pctused 40 ÕâÊÇΪʲô£¿ £¨ÕâµÀÌâµÄÖ÷Ҫ˼ÏëÊÇË÷Òý²»ÄÜÔÚpctused 40Éϵõ½Ê²Ã´ºÃ´¦£© 23¡¢Ê¹ÓùýµÄ×î´óµÄ±íÓжàÉÙÐмͼ£¿£¨ÕâµÀÌâ²»ÊÇ¿´Ó¦ÊÔÕߵļ¼Êõ¹ý²»¹ý¹Ø£¬¶øÊÇ¿¼²ìÓ¦ÊÔÕßÊÇ·ñÓдóÐÍÊý¾Ý¿âµÄ¹ÜÀí²Ù×÷¾Ñ飩 ²»Òª¶Ô±íµÄË÷ÒýÁнøÐк¯Êý²Ù×÷£¬ÒòΪÕâÑùϵͳ¾Í²»ÄÜʹÓÃË÷Òý£¬Ê¹²éѯ±äµÃºÜÂý£¬µ«ÊÇÔÚora8iÒÔºó¾ÍÒѾ¿ªÊ¼Ö§³Öº¯ÊýµÄË÷Òý£¬ÃÖ²¹ÁËÕâ¸ö²»×ã¡£
24¡¢ORACLEÊý¾Ý¿âÆô¶¯Óë¹Ø±ÕµÄ²½Öè Æô¶¯£ºÆô¶¯ÊµÀý¡ª-¼ÓÔØÊý¾Ý¿âÊý¾Ý¡ª¨C´ò¿ªÊý¾Ý¿â ¹Ø±Õ£º¹Ø±ÕÊý¾Ý¿â¡ª-жÔØÊý¾Ý¿âÊý¾Ý¡ª-¹Ø±ÕʵÀý 25¡¢DeleteÓëtruncateµÄÇø±ð deleteÒ»°ãÓÃÓÚɾ³ýÉÙÁ¿¼Ç¼µÄ²Ù×÷£¬¶øÇÒËüÊÇҪʹÓûعö¶Î²¢ÇÒÒª½øÐÐÏÔʾµÄÌá½»ÊÂÎñ¡£¶øtruncateÔòʹÓÃÓÚ´óÁ¿É¾³ýÊý¾Ý£¬¶øÇÒÒþʽÌá½»ÊÂÎñ£¬ÆäËÙ¶ÈÒª±ÈʹÓÃdelete¿ìµÄ¶à¡£ 26¡¢DDLºÍDML·Ö±ð´ú±íʲô£¿£¿ DDL±íʾÊý¾Ý¶¨ÒåÓïÑÔ£¬ÔÚORACLEÖÐÖ÷Òª°üÀ¨CREATE£¬ALTER£¬DROP DML±íʾÊý¾Ý²Ù×÷ÓïÑÔ£¬Ö÷ÒªµÄDMLÓÐSELECT£¬INSERT£¬UPDATE£¬DELETE 28¡¢java scriptÖж¯Ì¬Ð§¹ûʱµ÷Óõĺ¯Êý¡£ 29¡¢Êý¾Ý¿âÖÐÓÐÈô¸ÉÌõÏàͬµÄ¼Ç¼£¬É¾³ýµ½Ö»Ê£ÏÂÒ»Ìõ¼Ç¼¡£ÈçºÎ×ö£¬ÇëÓÃSQLÓï¾äͨ¹ýROW_IDÀ´Ð´³öÖ´Ðйý³Ì¡£ Delete table_name where ziduan=¡¯¡¯ and rowed<(select max(rowed) from table_name where ziduan=¡¯¡¯); 30¡¢oracleÊý¾Ý¿â±í´æ·Åµ½´ÅÅÌʲôµØ·½£¨Ê²Ã´ÎïÀí¿Õ¼äÉÏ¡ª¡ª´ó¸ÅÒâ˼£©£¿ OracleÊý¾Ý¿â±í´æ·ÅÔÚÊý¾ÝÎļþÉÏ¡£ 31¡¢OracleʹÓÃʲôÓï¾ä¸øÓû§·ÖÅäȨÏÞ£¿ GRANT TO Óï¾ä 32¡¢ÄãÔÚÏîÄ¿ÏÖ³¡£¬Óû§ÒªÇóÄãÏòÕýÔÚÔËÐеıíÖÐÌí¼ÓÒ»¸ö×ֶΣ¬Äã¸ÃÔõô×ö£¿ µÚÒ»ÖÖ·½·¨£º¹Ø±ÕÊý¾Ý¿â£¬È»ºóʹÓÃÊÜÏÞģʽ´ò¿ª£¬ÓÉsys/sysdbaÀ´½øÐÐ µÚ¶þÖÖ·½·¨£º²»¹Ø±ÕÊý¾Ý¿â£¬½«Êý¾Ý¿âÖÃÓÚ¾²Ä¬×´Ì¬ÔÚSYS/SYSDBAģʽÏÂÓÃALTER SYSTEM QUISCE RESTRICTED£¬ÕâÖÖ״̬ÏÂÖ»ÓÐSYS/SYSDBA²Å¿ÉÒÔ¶ÔÊý¾Ý¿â½øÐвÙ×÷£¬ÐÞ¸ÄÍê±ÏÖ®ºóÔÙÍ˳ö¾²Ä¬×´Ì¬ALTER SYSTEM UNQUISCE ÔÚÕâÀ︴ϰµ½ÁËÊý¾Ý¿âµÄÁ½ÖÖÌØÊâ״̬£º¾²Ä¬×´Ì¬(QUISCE)ºÍ¹ÒÆð״̬ ¾²Ä¬×´Ì¬¾ÍÊÇÖ»ÓÐÌØÊâȨÏÞµÄSYS/SYSDBA²Å¿ÉÒÔ¶ÔÊý¾Ý¿â½øÐвÙ×÷£¬Ê¹ÓÃALTER SYSTEM QUISCE RESTRICTEDÒÔºóϵͳ½«µÈºò»î¶¯×ŵĻỰÖ÷¶¯½áÊø£¬Í¬Ê±×èÖ¹½¨Á¢ÐµĻỰ£¬ÏµÍ³¹ÒÆðËùÓеÄSQLÓï¾ä£¬µÈ»Ö¸´ÒÔºóÔÙÖØ줻î»á»°Ö´ÐйÒÆðµÄSQL¡£ ¹ÒÆð״̬¾ÍÊÇϵͳ½«Êý¾Ý¿âËùÓжÔÎïÀíÎļþ£¨Êý¾ÝÎļþ£¬¿ØÖÆÎļþ£¬ÈÕÖ¾Îļþ£©µÄI/O²Ù×÷¶¼ÔÝÍ££¬µ«ÊDz¢²»½ûÖ¹·ÇD |