OracleÊý¾Ý¿âΪʲô±äÂýÁË£¿
±¾Îijö×Ô¡¶Íø¹ÜÔ±ÊÀ½ç¡·20002ÄêµÚ8ÆÚ“¹ÊÕÏÕï¶Ï”À¸Ä¿
Ó²¼þ»·¾³£º SUN250·þÎñÆ÷£¬1G CPU , 512M Ram , 18G SCSIÓ²ÅÌ
ϵͳ»·¾³£º SUN Solaris 2.7
·þÎñ»·¾³£º Oracle 8.1.6
ÖÜÎåÎÒ·¢ÏÖOracleÊý¾Ý¿âÔÚÖ´ÐгÌÐòʱµÄÏìÓ¦ÌرðÂý£¬Õû¸öÊý¾Ý¿â·þÎñËùÔÚµÄSUN Solaris 2.7ϵͳҲÊÇÕâÑù£¬ÎÞÂÛÔËÐÐʲô³ÌÐò¶¼±ÈÍù³£ÂýÁ˺ü¸±¶£¬ÓеijÌÐòÉõÖÁÖ´Ðкó£¬Ò»Ö±´¦ÓڵȴýµÄ״̬£¬ÎÞ·¨ÔËÐУ¡
ƾ×Ô¼ºµÄÖ±¾õ£¬³öÏÖÕâÖÖÎÊÌ⣬һ°ãÊÇϵͳÖгöÏÖÁËʲôÒì³£µÄ³ÌÐò£¬ÓÚÊÇÂíÉÏÓÃpsÃüÁî²éÕÒ£¬µ«ÊÇûÓз¢ÏÖÈκηǷ¨µÄ³ÌÐò£¬Ò²Ã»ÓкڿÍÈëÇֵļ£Ïó¡£ÄÇÊDz»ÊDz¡¶¾µÄÔÒòÄØ£¿Õâ¸öÏë·¨ÔÚÄÔ×ÓÀïÒ»ÉÁ¡£¶Ô£¬ÓпÉÄÜ,UNIXϵͳÖв»ÊÇûÓв¡¶¾µÄ£¡µ«ÕâÖÖ¼¸ÂÊ·¢ÉúµÄÇé¿öÒ»°ã±È½ÏÉÙ¡£ÓÚÊÇ×Ô¼ºÂíÉÏtopÃüÁ̬²é¿´ÏµÍ³×ÊÔ´µÄʹÓÃÇé¿ö£¨¿ÉÒÔÉèÖÃtopÃüÁîµÄË¢ÐÂÂÊΪ1Ã룬²¢Ö»¼à¿ØOracleÓû§¼´Êý¾Ý¿âµÄ½ø³Ì£©£¬ÔÚSolarisϵͳÔËÐÐÃüÁîÌáʾ·ûºó¼üÈëtop»Ø³µ,È»ºóÉèÖÃtopÃüÁîµÄË¢ÐÂÂÊΪ1Ã룬¾ßÌå²Ù×÷·½·¨£ºµ±topÃüÁîÔËÐкó£¬ÇüüÅÌs¼ü£¬ÔÚÌáʾÐÅÏ¢ºóÃæÔÙÇüüÅ̵ÄÊý×Ö¼ü1ºó»Ø³µ¼´¿É£»ÔÙÉèÖÃtopÃüÁîÖ»¼à¿ØOracleÓû§µÄ½ø³Ì£¬¾ßÌå²Ù×÷·½·¨£ºµ±topÃüÁîÔËÐкó£¬ÇüüÅÌu¼ü£¬ÔÚÌáʾÐÅÏ¢ºóÔÙÇÃÈëOracle£¬È»ºó»Ø³µ¼´¿É¡£
Õâʱϵͳ½ø³ÌµÄÔËÐÐÇé¿ö»áÈçÏÂͼËùʾ£º
ÓÚÊÇÎÒ×Ðϸ²é¿´ÉÏÃæµÄµÄÔËÐнá¹û£¬¹ûÈ»ÓÐÁËÒ»¸öÖØ´óµÄ·¢ÏÖ£¬ÔÚÉÏÃæµÄͼÏñÖпÉÒԲ쿴µ½ÏµÍ³Ò»Ö±ÕýÔÚÔËÐÐµÄ 6028 ½ø³Ì£¨Í¼ÖÐ×óÁеĵÚÒ»¸öPID£©£¬·¢Ïִ˽ø³Ìռϵͳ×ÊÔ´±È½Ï´ó£¨CPUʹÓÃÂÊΪ49.41%£©£¬ÏµÍ³CPUÏÐÖÃ×ÊԴΪ0.0%,Õâ¸ö³ÌÐò¶Ô·þÎñÆ÷¶¼×÷ÁËʲôÄØ£¬ÎªÊ²Ã´µ¼ÖÂÕû¸öϵͳµÄCPU×ÊÔ´¶¼ºÄ¾¡ÁË£¿
´ø×ÅÕâ¸öÎÊÌâÓÖµ½ÍøÉÏ×ÐϸµÄ²éÁËһЩ×ÊÁÏ£¬¹¦·ò²»¸ºÓÐÐÄÈË£¬ÖÕÓÚ´ÓһЩÎÄÕÂÖлñÖª¿ÉÄÜÊÇÓÉÓÚÊý¾Ý¿âÕýÔÚÖ´ÐеÄij¸öSQLÓï¾ä¶ÔÓдóÁ¿¼Ç¼µÄÊý¾Ý±í²Ù×÷ÒýÆðµÄ¡£ÎªÁ˽øÒ»²½Ö¤Êµ£¬ÎÒÓÃSQLÓï¾ä½øÐвéѯ£¬ÒÔsystemÓû§µÇ½SQL*Plus£¬Ö´ÐÐÃüÁîÈçÏ£º
$ su -l oracle
$ sqlplus system/manager
SQL> select sql_text from v$sql
2 where address in (
3 select sql_address from v$session where sid in (
4 select sid from v$session where paddr in (
5 select addr from v$process where spid=6028)))£»
È»ºó»áÏÔʾÐÅÏ¢£º
SQL_TEXT
select bbsid,motherid,authorid,authorip,bbsdate,bbscontent,authortype,
discussed from BK_BBS where motherid=122983 order by bbsdate
¼ÌÐøÓÃÏÂÃæµÄÓï¾ä¶ÔÉÏÃæÐÅÏ¢ÖеÄBK_BBS±í½øÐвéѯ£¨×¢Ò
Ïà¹ØÎĵµ£º
Ò»¡¢Enterprise Manager 10g
ĬÈÏÇé¿öÏ£¬°²×°Oracleʱ£¬»á°²×°EM¡£ËüÊÇλÓÚÊý¾Ý¿â·þÎñÆ÷ÉϵÄHTTP·þÎñÆ÷¡£
£¨1£©Æô¶¯EM
Ҫȷ±£OracleDBConsole<SID>·þÎñÒѾÆô¶¯¡£
Æô¶¯·þÎñ£ºemctl start dbconsole
¹Ø±Õ·þÎñ£ºemctl stop dbconsole
·ÃÎÊEM£ºhttp://·þÎñÆ÷Ãû³Æ£º¶Ë¿ÚºÅ/em
¶Ë¿ÚºÅ¿ÉÔÚ$ORACLE_HOME/install/pro ......
1)½¨Á¢²Ù×÷ϵͳĿ¼e:\test£¬×¼±¸Êý¾ÝÎļþdept.txt²¢ÖÃÓÚe:\testÖ®ÏÂ
"10","ACCOUNTING","NEW
YORK"
"20","RESEARCH","DALLAS"
"30","SALES","CHICAGO"
"40","OPERATIONS","BOSTON"
2)´´ ......
ÎÒÃǶ¼¶¼ÖªµÀÔÚcontrolfileÖмǼ×Åÿһ¸öarchivelogµÄÏà¹ØÐÅÏ¢£¬µ±È»ÃÇÔÚOSÏ°ÑÕâЩÎïÀíÎļþdeleteµôºó£¬ÔÚÎÒÃǵÄ
controlfileÖÐÈÔÈ»¼Ç¼×ÅÕâЩarchivelogµÄÐÅÏ¢£¬ÔÚoracleµÄOEM¹ÜÀíÆ÷ÖÐÓпÉÊÓ»¯µÄÈÕÖ¾Õ¹ÏÖ³ö£¬µ±ÎÒÃÇÊÖ¹¤Çå³ýarchiveĿ¼ÏµÄÎļþºó£¬ÕâЩ¼Ç¼²¢Ã»Óб»ÎÒÃÇ´ÓcontrolfileÖÐÇå³ýµô£¬Ò²¾ÍÊÇoracle²¢²» ......
2009-01-02 10:02
µÇ½Éí·ÝÖ¤Ã÷²»ÕýÈ·
OracleÊý¾Ý¿âÓÐÈýÖÖ±ê×¼µÄ±¸·Ý·½·¨£¬ËüÃÇ·Ö±ðΪµ¼³ö/µ¼È루EXPORT/IMPORT£©¡¢À䱸·Ý¡¢Èȱ¸·Ý¡£µ¼³ö±¸·ÝÊÇÒ»ÖÖÂß¼±¸·Ý£¬À䱸·ÝºÍÈȱ¸·ÝÊÇÎïÀí±¸·Ý¡£
Òª½øÐб¸·ÝºÍ»Ö¸´²Ý£¬±ØÐëÔÚÁ¬½Óµ½Oracle Manager Serverºó²ÅÄܽøÐС£Èç¹ûδ´ ......
Ò»¡£ÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾ÎļþµÄ±¸·Ý1.·þÎñÆ÷ÖØ×°Á˲Ù×÷ϵͳ£¬oracleÒ²ÖØ×°ÁË¡£Èç¹ûÖØ×°µÄoracleºÍÒÔÇ°Ë𻵵ÄÊý¾Ý¿âÊÇһģһÑùµÄ½á¹¹£¬ÄÇô´ËʱµÄ»Ö¸´ÊDZȽϼòµ¥µÄ¡£
1£©É¾³ýµôн¨Êý¾Ý¿âµÄËùÓÐÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþ¡£CopyÔÊý¾Ý¿âµÄÊý¾ÝÎļþ¡¢¿ØÖÆÎļþºÍÈÕÖ¾Îļþµ½¶ÔӦĿ¼Ï¡£
  ......