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

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±í½øÐвéѯ£¨×¢Ò


Ïà¹ØÎĵµ£º

OracleÓû§¹ÜÀí

 Ò»£¬OracleÊý¾Ý¿âÓû§¼ò½é
 ÔÚOracleÊý¾Ý¿âÖÐÈκζÔÏó¶¼ÊôÓÚÒ»¸öÌض¨Óû§£¬»òÕß˵һ¸öÓû§ÓëͬÃûµÄģʽÏà¹ØÁª¡£
 ÒªÁ¬½Óµ½OracleÊý¾Ý¿âÐèÒªÒ»¸öÓû§ÕÊ»§£¬¸ù¾ÝÐèÒªÊÚÓèµÄ²Ù×÷ȨÏÞ¡£
 1£¬Ä¬ÈÏÊý¾Ý¿âÓû§Ä£Ê½£º
  Sys:Êý¾Ý¿â×ֵ䣨´æ´¢±»¹ÜÀí¶ÔÏóËùÓÐÐÅÏ¢£©ºÍÊÓͼ´æ´¢ÔÚ¸ÃģʽÖС£ÏµÍ³¼¶Óû§¡£ ......

¡¾×ª¡¿Oracle Tablespace´´½¨

 Tablespace
ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®
¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä£®¡¡¡¡
  ·ÖÅä´æ ......

Oracle AWR ½éÉÜ

Oracle Database 10g ÌṩÁËÒ»¸öÏÔÖø¸Ä½øµÄ¹¤¾ß£º×Ô¶¯¹¤×÷¸ºÔØÐÅÏ¢¿â (AWR:Automatic Workload Repository)¡£Oracle ½¨ÒéÓû§ÓÃÕâ¸öÈ¡´ú Statspack¡£AWR ʵÖÊÉÏÊÇÒ»¸ö Oracle µÄÄÚÖù¤¾ß£¬Ëü²É¼¯ÓëÐÔÄÜÏà¹ØµÄͳ¼ÆÊý¾Ý£¬²¢´ÓÄÇЩͳ¼ÆÊý¾ÝÖе¼³öÐÔÄÜÁ¿¶È£¬ÒÔ¸ú×ÙDZÔÚµÄÎÊÌâ¡£Óë Statspack ²»Í¬£¬¿ìÕÕÓÉÒ»¸ö³ÆΪ MMON µÄеĺó ......

oracle 10 em

Ò»¡¢Enterprise Manager 10g
ĬÈÏÇé¿öÏ£¬°²×°Oracleʱ£¬»á°²×°EM¡£ËüÊÇλÓÚÊý¾Ý¿â·þÎñÆ÷ÉϵÄHTTP·þÎñÆ÷¡£
£¨1£©Æô¶¯EM
Ҫȷ±£OracleDBConsole<SID>·þÎñÒѾ­Æô¶¯¡£
Æô¶¯·þÎñ£ºemctl start dbconsole
¹Ø±Õ·þÎñ£ºemctl stop dbconsole
·ÃÎÊEM£ºhttp://·þÎñÆ÷Ãû³Æ£º¶Ë¿ÚºÅ/em
¶Ë¿ÚºÅ¿ÉÔÚ$ORACLE_HOME/install/pro ......

Oracle Management ServerÅäÖÃ

Oracle Management ServerÅäÖò½ÖèÈçÏ£º
1¡¢Ê¹ÓÃenterprise manager configuration assistant½¨Á¢µµ°¸×ÊÁÏ¿â
   ÆäÖпÉÑ¡Ôñн¨Ò»¸öÊý¾Ý¿âʵÀý»òÕßÔÚÒÑÓÐÊý¾Ý¿âʵÀýÖÐн¨×ÊÁϿ⣨н¨±í¿Õ¼ä£©¡£
2¡¢Æô¶¯management server
3¡¢ÔËÐÐenterprise manage console£¬Ñ¡ÔñµÇ¼µ½management server
   µÇ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ