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

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µÄ±È½Ï¾ÉµÄ°æ±¾ÊÇÒøÐУ¬´ÅÅ̵ĵÚÒ


Ïà¹ØÎĵµ£º

oracle management server£¨oms£©Æô¶¯ÎÊÌâ

 
      ÅäÖÃÒ»¸ö¹ÜÀí×ÊÁϿ⣬Æô¶¯£ºConfiguration and Migration tools/Enterprise Manager Configuration Assistant¡£ÔÚÅäÖòÙ×÷ÖÐÑ¡ÔñÅäÖñ¾µØµÄoracle management server/´´½¨Ò»¸öеÄ×ÊÁÏ¿âµµ°¸/µäÐÍ¡£ÏµÍ³½«»á´´½¨Ò»¸öÃûΪoemrepµÄÊý¾Ý¿â£¬±£´æ¹ÜÀíÐÅÏ¢£¬ÆäÖÐÄãÐèÒªÖ¸¶¨sysºÍsystemÕÊ ......

Oracle substr ºÍ instr µÄÓ÷¨

INSTR·½·¨µÄ¸ñʽΪ
INSTR(Ô´×Ö·û´®, Ä¿±ê×Ö·û´®, ÆðʼλÖÃ, Æ¥ÅäÐòºÅ)
ÀýÈ磺INSTR('CORPORATE FLOOR','OR', 3, 2)ÖУ¬Ô´×Ö·û´®Îª'CORPORATE FLOOR', Ä¿±ê×Ö·û´®Îª'OR'£¬ÆðʼλÖÃΪ3£¬È¡µÚ2¸öÆ¥ÅäÏîµÄλÖá£
ĬÈϲéÕÒ˳ÐòΪ´Ó×óµ½ÓÒ¡£µ±ÆðʼλÖÃΪ¸ºÊýµÄʱºò£¬´ÓÓұ߿ªÊ¼²éÕÒ¡£
ËùÒÔSELECT INSTR('CORPORATE FLOOR' ......

OracleÃüÁî1

 OracleÃüÁîÈ«¼¯
µÚÒ»Õ£ºÈÕÖ¾¹ÜÀí
µÚ¶þÕ£º±í¿Õ¼ä¹ÜÀí
µÚÈýÕ£º±í
µÚËÄÕ£ºË÷Òý
µÚÎåÕ£ºÔ¼Êø
µÚÁùÕ£ºLOADÊý¾Ý
µÚÆßÕ£ºreorganizing data
µÚ°ËÕ£º managing password security and resources
µÚ¾ÅÕ£ºManaging users
µÚʮգºmanaging privileges
µÚʮһÕ£º manager role
µÚÊ®¶þÕÂ: BACKUP and RECOV ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ