raw oracleÈ«½â
1£®Ê²Ã´½Ð×öÂãÉ豸£¿
¡¡¡¡ÂãÉ豸£¬Ò²½ÐÂã·ÖÇø£¨Ôʼ·ÖÇø£©£¬ÊÇÒ»ÖÖûÓо¹ý¸ñʽ»¯£¬²»±»Unixͨ¹ýÎļþϵͳÀ´¶ÁÈ¡µÄÌØÊâ×Ö·ûÉ豸¡£ËüÓÉÓ¦ÓóÌÐò¸ºÔð¶ÔËü½øÐжÁд²Ù×÷¡£²»¾¹ýÎļþϵͳµÄ»º³å¡£
¡¡¡¡
¡¡¡¡2£®ÈçºÎ±æ±ðÂãÉ豸£¿
¡¡¡¡ÔÚUnixµÄ/dev Ŀ¼Ï£¬ÓÐÐí¶àÎļþ£¬ÆäÖÐÓÐÁ½¸ö´óÀࣺ×Ö·ûÉ豸ÎļþºÍ¿éÉ豸Îļþ¡£
¡¡¡¡×Ö·ûÉ豸ÌØÊâÎļþ½øÐÐI/O²Ù×÷²»¾¹ý²Ù×÷ϵͳµÄ»º³åÇø£¬¶ø¿éÉ豸ÌØÊâÎļþÓÃÀ´Í¬ÍâÉè½øÐж¨³¤µÄ°ü´«Êä¡£×Ö·ûÌØÊâÎļþÓëÍâÉè½øÐÐI/o²Ù×÷ʱÿ´ÎÖ»´«ÊäÒ»¸ö×Ö·û¡£¶ø¶ÔÓÚ¿éÉ豸ÌØÊâÎļþÀ´Ëµ£¬ËüÓÃÁËcache»úÖÆ£¬ÔÚÍâÉèºÍÄÚ´æÖ®¼äÒ»´Î¿ÉÒÔ´«ËÍÒ»Õû¿éÊý¾Ý¡£ÂãÉ豸ʹÓÃ×Ö·ûÌØÊâÎļþ¡£ÔÚ/dev Ŀ¼Ï£¬Äã¿ÉÒÔ¿´µ½Ðí¶àÕâÑùµÄÎļþ¡£
¡¡¡¡
¡¡¡¡3£®Ê¹ÓÃÂãÉ豸µÄºÃ´¦
¡¡¡¡ÒòΪʹÓÃÂãÉ豸±ÜÃâÁËÔÙ¾¹ýUnix²Ù×÷ϵͳÕâÒ»²ã£¬Êý¾ÝÖ±½Ó´ÓDiskµ½Oracle½øÐд«Ê䣬ËùÒÔʹÓÃÂãÉ豸¶ÔÓÚ¶ÁдƵ·±µÄÊý¾Ý¿âÓ¦ÓÃÀ´Ëµ£¬¿ÉÒÔ¼«´óµØÌá¸ßÊý¾Ý¿âϵͳµÄÐÔÄÜ¡£µ±È»£¬ÕâÊÇÒÔ´ÅÅ̵ÄI/O ·Ç³£´ó£¬´ÅÅÌI/OÒѾ³ÆΪϵͳƿ¾±µÄÇé¿öϲųÉÁ¢¡£Èç¹û´ÅÅ̶Áдȷʵ·Ç³£Æµ·±£¬ÒÔÖÁÓÚ´ÅÅ̶Áд³ÉΪϵͳƿ¾±µÄÇé¿ö³ÉÁ¢£¬ÄÇô²ÉÓÃÂãÉ豸ȷʵ¿ÉÒÔ´ó´óÌá¸ßÐÔÄÜ£¬×î´óÉõÖÁ¿ÉÒÔÌá¸ßÖÁ40£¥£¬·Ç³£Ã÷ÏÔ¡£
¡¡¡¡¶øÇÒ£¬ÓÉÓÚʹÓõÄÊÇÔʼ·ÖÇø£¬Ã»ÓвÉÓÃÎļþϵͳµÄ¹ÜÀí·½Ê½£¬¶ÔÓÚUnixά»¤ÎļþϵͳµÄ¿ªÏúÒ²¶¼Ã»ÓÐÁË£¬±ÈÈç²»ÓÃÔÙά»¤I-node£¬¿ÕÏпéµÈ£¬ÕâÒ²Äܹ»µ¼ÖÂÐÔÄܵÄÌá¸ß¡£
¡¡¡¡
¡¡¡¡4£®ÈçºÎ¾ö¶¨ÊÇ·ñÓ¦¸ÃʹÓÃÂãÉ豸£¿
¡¡¡¡ÅжÏÊÇ·ñʹÓÃÂãÉ豸Ҫ´ÓÒÔÏ·½Ãæ½øÐп¼ÂÇ£ºÊ×ÏÈ£¬Êý¾Ý¿âϵͳ±¾ÉíÐèÒªÒѾ±»±È½ÏºÃµÄ¾¹ýÁËÓÅ»¯¡£ÓÅ»¯ÊÇÒ»ÃźÜÓÐЩ¼¼ÊõµÄ»°Ì⣬ºÜÄѼòµ¥µØ½²Êö¡£Æä´Î£¬Ê¹ÓÃUnixÃüÁîÀ´±æ±ðÊÇ·ñ´æÔÚ´ÅÅ̶Áдƿ¾±¡£±ÈÈçUnixµÄvmstat, sar µÈÃüÁ¿ÉÒԽϺõĽøÐмø±ð¡£Èç¹û¾ö¶¨²ÉÓÃÂãÉ豸£¬ÐèÒª´ÅÅÌÉÏ»¹ÓпÕÏеķÖÇø¡£·ñÔò£¬¾ÍÒªÐÂÌí´ÅÅÌ£¬»òÕ߶ÔÔÓÐϵͳÖØй滮¡£
¡¡¡¡
¡¡¡¡5£®Ê²Ã´ÏµÍ³±ØÐëʹÓÃÂãÉ豸£¿
¡¡¡¡Èç¹ûʹÓÃÁËOracle ²¢ÐзþÎñÆ÷Ñ¡ÏÔò±ØÐë²ÉÓÃÂãÉ豸À´´æ·ÅËùÓеÄÊý¾ÝÎļþ£¬¿ØÖÆÎļþ£¬ÖØ×öÈÕÖ¾Îļþ¡£Ö»ÓаÑÕâЩÎļþ·Åµ½ÂãÉ豸ÉÏ£¬²ÅÄܱ£Ö¤ËùÓÐOracle ʵÀý¶¼¿ÉÒÔ¶ÁÈ¡Õâ¸öÊý¾Ý¿âµÄÎļþ¡£ÕâÊÇÓÉUnix²Ù×÷ϵͳµÄÌØÐÔ¾ö¶¨µÄ¡£
¡¡¡¡»¹ÓÐÒ»ÖÖÇé¿öÊÇ£¬Èç¹ûÄãÏëʹÓÃÒì²½I/O£¬ÄÇôÔÚÓÐЩUnixÉÏÒ²±ØÐë²ÉÓÃÂãÉ豸¡£Õâ¸öÐèÒª²Î¿¼¾ßÌåUnixµÄÏà¹ØÎĵµ¡£
¡¡¡¡
¡¡¡¡6£®Äܹ»Ê¹ÓÃÒ»¸ö´ÅÅ̵ĵÚÒ»¸ö·ÖÇø×÷ΪÂãÉ豸Âð£¿
¡¡¡¡¿ÉÒÔ£¬µ«ÊDz»ÍƼö¡£ÔÚUnixµÄ±È½Ï¾ÉµÄ°æ±¾ÊÇÒøÐУ¬´ÅÅ̵ĵÚÒ
Ïà¹ØÎĵµ£º
Ô´´ÓÚ2007Äê04ÔÂ12ÈÕ£¬2009Äê10ÔÂ15ÈÕǨÒÆÖÁ´Ë¡£
windows xp£¬Êý¾Ý¿âoracle 10.2.0¡£1
ûÓб¸·Ý£¬»ù±¾ÉÏÊÇĬÈÏ°²×°£¬ºÃÏñ»¹²»Êǹ鵵ģʽ
Ö¢×´£ºsqlplusÖ»ÓÐsysdbaÓû§ÄܽøÈ¥£¬ÆäËûÓû§½øÈ¥Ò»¸Å±¨£ºora-01033£ºoracleÕýÔÚ³õʼ»¯»ò¹Ø±Õ
¶øÇÒsysdbaÓû§½øÈ¥Ö®ºóÄÜÖ´ÐÐselect sysdate from dual£¬µ«ÊÇÖ´ÐÐselect use ......
ÅäÖÃÒ»¸ö¹ÜÀí×ÊÁϿ⣬Æô¶¯£ºConfiguration and Migration tools/Enterprise Manager Configuration Assistant¡£ÔÚÅäÖòÙ×÷ÖÐÑ¡ÔñÅäÖñ¾µØµÄoracle management server/´´½¨Ò»¸öеÄ×ÊÁÏ¿âµµ°¸/µäÐÍ¡£ÏµÍ³½«»á´´½¨Ò»¸öÃûΪoemrepµÄÊý¾Ý¿â£¬±£´æ¹ÜÀíÐÅÏ¢£¬ÆäÖÐÄãÐèÒªÖ¸¶¨sysºÍsystemÕÊ ......
sql½Å±¾£¬Ò²¾ÍÊÇÔÚÎļþÖÐдÓÐsqlÓï¾äµÄÎļþ£¬¿ÉÒÔÔÚsqlplusÖÐÔËÐС£
ÒýÈësql½Å±¾
sqlplus Óû§Ãû/ÃÜÂë @sql½Å±¾.sql
£¨×¢Ò⣺ÔÚÓû§ÃûÃÜÂëÊäÈë½áÊøºóÒ»¶¨Òª¼Ó¿Õ¸ñÈ»ºóÔÙд@sql½Å±¾£©
OracleÖеĿÕÖµ»áµ±×÷ÎÞÇî´ó´¦Àí£¬Æäʵ¿ÕÖµ¸ù±¾¾Í²»»á´æ´¢£¬Ö»ÊÇ¿´×÷ÊÇÎÞÇî´ó¡£
OracleÖпØÖÆ´¦Àíº¯Êý NVL(×Ö¶ÎÃû£¬ ......
ʹÓÃCursor:
--²âÊÔһϣ¬½ñÌì²ÅÉêÇëʹÓÃitpub.net µÄblog
declare
RoomID Room.RoomID%Type;
RoomName Room.RoomName%Type;
cursor crRoom is
select RoomID,RoomName
from Room;
begin
open crRoom;loop;
fetch crRoom into RoomID,RoomName;
exit when crRoom%notFound;
end loop;
close crRoom;
end;
& ......