oracleÔõÑùÉó²éÀú³Ì
ÓÐÎåÖÖÒªÁì¿ÉÒÔÉó²é oracle Êý¾Ý¿âÖеÄÀú³Ì£ºÊ¹Óà oracle enterprise manager (oem)ʹÓà sql ÏÂÁselect * from v$process;ʹÓòÙ×÷ϵͳÏÂÁÀýÈç linux É쵀 ps -ef | grep oracle£©Ê¹Óà oracle ÏÂÁîÐй¤¾ß£¨ÀýÈç srvctl status database£©Ê¹Óà oracle ÐÔÄÜÊÓͼ£¨ÀýÈç v$process£©
ÔõÑùÉó²é Oracle Êý¾Ý¿âÖеÄÀú³Ì
ÒªÉó²é Oracle Êý¾Ý¿âÖеÄÀú³Ì£¬Äú¿ÉÒÔʹÓÃÒÔÏÂÒªÁ죺
1. ʹÓà Oracle Enterprise Manager (OEM)
OEM ÊÇÒ»¿îͼÐνçÃ湤¾ß£¬¿ÉÒÔÓÃÓÚÖÎÀíºÍ¼àÊÓ Oracle Êý¾Ý¿â¡£Äú¿ÉÒÔͨ¹ýÒÔÏ°취ʹÓà OEM Éó²éÀú³Ì£º
·¿ª OEM ¿ØÖÆ̨¡£
ÔÚµ¼º½À¸ÖУ¬µ¥»÷ “Ä¿µÄ”¡£
ÔÚ “Ä¿µÄ” Ê÷ÖУ¬Õö¿ª “Êý¾Ý¿â” ½Úµã¡£
ÓÒ¼üµ¥»÷Òª¼àÊÓµÄÊý¾Ý¿â£¬È»ºóÑ¡Ôñ “Éó²éËùÓÐÄ¿µÄ”¡£
ÔÚ “Ä¿µÄ” Ñ¡ÏÖУ¬µ¥»÷ “Àú³Ì” Ñ¡Ï¡£
2. ʹÓà SQL ÏÂÁî
Äú¿ÉÒÔʹÓÃÒÔÏ SQL ÏÂÁîÉó²é Oracle Êý¾Ý¿âÖеÄÀú³Ì£º
SELECT * FROM v$process; ```` **3. ʹÓòÙ×÷ϵͳÏÂÁî** Äú»¹¿ÉÒÔʹÓòÙ×÷ϵͳÏÂÁîÉó²é Oracle Êý¾Ý¿âÀú³Ì¡£ÀýÈ磬ÔÚ Linux »ò UNIX ÉÏ£¬¿ÉÒÔʹÓÃÒÔÏÂÏÂÁ
µÇ¼ºó¸´ÖÆ
ps -ef | grep oracle
**4. ʹÓà Oracle ÏÂÁîÐй¤¾ß** Äú»¹¿ÉÒÔʹÓà Oracle ÏÂÁîÐй¤¾ßÉó²éÀú³Ì¡£ÀýÈ磬¿ÉÒÔʹÓÃÒÔÏÂÏÂÁ ```bash srvctl status database -d <database_name></database_name>
µÇ¼ºó¸´ÖÆ
ÆäÖÐ ÊÇÒª¼àÊÓµÄÊý¾Ý¿âµÄÃû³Æ¡£
5. ʹÓà Oracle ÐÔÄÜÊÓͼ
Oracle ÌṩÁËÐÔÄÜÊÓͼ£¬¿ÉÒÔÓÃÀ´»ñÈ¡ÓйØÊý¾Ý¿âÐÔÄܵÄÐÅÏ¢£¬°üÀ¨Àú³ÌÐÅÏ¢¡£ÀýÈ磬¿ÉÒÔʹÓÃÒÔÏÂÊÓͼ£º
v$process£ºÏÔʾÓйØÊý¾Ý¿âÀú³ÌµÄÏêϸÐÅÏ¢¡£
v$session£ºÏÔʾÓйØÊý¾Ý¿â»á»°µÄÏêϸÐÅÏ¢¡£
v$sql£ºÏÔʾÓйØÕýÔÚÖ´ÐÐµÄ SQL Óï¾äµÄÏêϸÐÅÏ¢¡£
ÒÔÉϾÍÊÇoracleÔõÑùÉó²éÀú³ÌµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡