|
|
[ÀϹÝ] [Æ©´×] CPU¸¦ °úµµÇÏ°Ô Â÷ÁöÇÏ°í ÀÖ´Â SESSION°ú SQL¹® |
|
È£¼® ´Ô²²¼ ¾´ ±ÛÀÔ´Ï´Ù - 121.¢½.39.7 |
ÀÐÀ½:3189 |
|
|
cpu°úµµ SQL.zip (2.5K) _ Down:34 | |
Bulletin no : 12212
Product : ORACLE_SERVER
CPU¸¦ °úµµÇÏ°Ô Â÷ÁöÇÏ°í ÀÖ´Â SESSION°ú SQL¹® TRACKING
--------------------------------------------------------------------------------
CPU¸¦ °úµµÇÏ°Ô Â÷ÁöÇÏ°í ÀÖ´Â SESSION°ú SQL¹® TRACKING
====================================================
STEP 1) CPU¸¦ °úµµÇÏ°Ô Â÷ÁöÇÏ°í ÀÖ´Â ProcessÀÇ PID¸¦ È®ÀÎÇÑ´Ù.
ÀÌ°ÍÀº OS Utility(TOPµî)¸¦ »ç¿ëÇÏ¿© È®ÀÎÇÒ ¼ö ÀÖ´Ù.
SETP 2) ÀÏ´Ü PID¸¦ È®ÀÎÇÏ¿´À¸¸é ÀÌ Process°¡ ¼öÇàÇÏ°í ÀÖ´Â SessionÀ» ã¾Æ¾ß
ÇÑ´Ù
SQL> select a.sid, a.serial#
from v$session a, v$process b
where a.paddr= b.addr and b.spid= PID;
À§¿¡¼ PID´Â step 1¿¡¼ È®ÀÎÇÑ PID¸¦ ±â¼úÇÑ´Ù.
SessionÀ» ãÀ¸¸é v$sessionÀÇ ´Ù¸¥ columnµéÀ» ÅëÇÏ¿© ÇöÀç ÀÌ
session¿¡ ´õ ¸¹Àº Á¤º¸¸¦ ¾Ë ¼ö ÀÖ´Ù.
STEP 3) SessionÀ» ã¾ÒÀ¸¸é ÀÌ Session ¿¡¼ ¾î¶°ÇÑ SQL¹®ÀÌ ¼öÇàµÇ´ÂÁö¸¦
¾Ë¾Æ³»¾ß ÇÑ´Ù.
SQL> set long 10000
SQL> select a.sql_text
from v$sqltext a, v$session b
where a.address=b.sql_address and
a.hash_value=b.sql_hash_value and
b.sid= SID_NUMBER
order by a.piece;
À§¿¡¼ SID_NUMBER´Â step 2¿¡¼ ¾òÀº sidÀÔ´Ï´Ù.
STEP 4) SQL¹®ÀÇ ÀûÇÕ¼ºÀ» ÆÇ´Ü
--------------------------------------------------------------------------------
Oracle Korea Customer Support Technical Bulletins
1) CPU¸¦ °úµµÇÏ°Ô Â÷ÁöÇÏ°í ÀÖ´Â ProcessÀÇ PID¸¦ È®ÀÎÇÑ´Ù.
ÀÌ°ÍÀº OS Utility(TOPµî)¸¦ »ç¿ëÇÏ¿© È®ÀÎÇÒ ¼ö ÀÖ´Ù.
2) ÀÏ´Ü PID¸¦ È®ÀÎÇÏ¿´À¸¸é ÀÌ Process°¡ ¼öÇàÇÏ°í ÀÖ´Â SessionÀ» ã¾Æ¾ß
ÇÑ´Ù
==> pid_session.sql
3) SessionÀ» ã¾ÒÀ¸¸é ÀÌ Session ¿¡¼ ¾î¶°ÇÑ SQL¹®ÀÌ ¼öÇàµÇ´ÂÁö¸¦
¾Ë¾Æ³»¾ß ÇÑ´Ù.
==> session_sql.sql
À§¿¡¼ SID_NUMBER´Â step 2¿¡¼ ¾òÀº sidÀÔ´Ï´Ù.
STEP 4) SQL¹®ÀÇ ÀûÇÕ¼ºÀ» ÆÇ´Ü
==> sql_owner.sql
==> user_ind.sql
==> @?/rdbms/admin/utlxplp.sql
|
|
|
|
|
|