°æ°í ·Î±× ÆÄÀÏ
¿À¶óŬ ÀνºÅϽº°¡ ½ÇÇàµÇ´Â µ¿¾È ¿À·ù°¡ ¹ß»ýÇϸé, ¸Þ½ÃÁö°¡ °æ°í
·Î±× ÆÄÀÏ¿¡ ¾²¿©Áý´Ï´Ù. µ¥ÀÌÅͺ£À̽º¸¦ ½ÃÀÛÇÏ´Â µ¿¾È, °æ°í ·Î±× ÆÄÀÏÀÌ Á¸ÀçÇÏÁö ¾Ê´Â´Ù¸é, ¿À¶óŬ ¼¹ö°¡ °æ°í ·Î±× ÆÄÀÏÀ»
»ý¼ºÇÕ´Ï´Ù.
µ¥ÀÌÅͺ£À̽ºÀÇ °æ°í ·Î±× ÆÄÀÏÀº ½Ã°£ ¼øÀ¸·Î ÀÛ¼ºµÈ ¸Þ½ÃÁö ¹× ¿À·ù ·Î±×ÀÔ´Ï´Ù. ¿À¶óŬ ¼¹ö´Â °æ°í ·Î±× ÆÄÀÏÀ» ÀÌ·¯ÇÑ Á¤º¸¸¦ Ãâ·ÂÇϱâ À§ÇÑ ´ëü¹æ¹ýÀ¸·Î¼ »ç¿ëÇÕ´Ï´Ù.
¹é±×¶ó¿îµå ÇÁ·Î¼¼½º ÃßÀû ÆÄÀÏ
¹é±×¶ó¿îµå
ÇÁ·Î¼¼½º¿¡ ÀÇÇØ ¿À·ù°¡ ŽÁöµÇ¸é, Á¤º¸´Â ÃßÀû ÆÄÀÏ¿¡ ½×ÀÔ´Ï´Ù.
»ç¿ëÀÚ ÃßÀû ÆÄÀÏ
ÃßÀû ÆÄÀÏÀº ¹®Àå ó¸® µ¿¾È ÀÚ¿ø ¼Òºñ ³»¿ëÀ» Ãâ·ÂÇϱâ À§ÇÏ¿©
»ç¿ëÀÚ ¿äû¿¡ µû¶ó ¼¹ö ÇÁ·Î¼¼½º¿¡
ÀÇÇØ »ý¼ºµÉ ¼ö ÀÖ½À´Ï´Ù.
¿À¶óŬ ´ë±â À̺¥Æ®
¹®Á¦ ÇØ°áÀ» ¼öÇàÇÏ°í ÀÖ´Â °æ¿ì, ÇÁ·Î¼¼½º°¡ ÀÚ¿øÀ» ±â´Ù·Á¿Â
½Ã°£À» ¾Ë ÇÊ¿ä°¡ ÀÖ½À´Ï´Ù. ´ë±â À̺¥Æ® ¸ñ·ÏÀº ¿À¶óŬ ¼¹ö¿¡ ÀÖ½À´Ï´Ù.
ÀϺΠµñ¼Å³Ê¸® ºä´Â ´ë±âÇØ¾ß ÇÏ´Â ¼¼¼Ç¿¡ ´ëÇÑ À̺¥Æ®¸¦
Ç¥½ÃÇÕ´Ï´Ù.
Oracle Enterprise Manager(¿À¶óŬ ¿£ÅÍÇÁ¶óÀÌÁî °ü¸®ÀÚ)
À̺¥Æ®
OEMÀÇ À̺¥Æ® °ü¸®ÀÚ¸¦ »ç¿ëÇÏ¿© À̺¥Æ® ¼¼Æ®¸¦ µî·ÏÇؼ ü°èÀûÀÎ ¹®Á¦¸¦ ŽÁöÇÒ ¼ö ÀÖ½À´Ï´Ù.
µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ°¡ °æ°í ·Î±× ÆÄÀÏÀ» Á¤±âÀûÀ¸·Î °Ë»çÇÏ¿© ¹®Á¦°¡ ½É°¢ÇØÁö±â Àü¿¡ ¹®Á¦¸¦ ŽÁöÇÏ´Â °ÍÀº Áß¿äÇÑ ÀÏÀÔ´Ï´Ù.
´ÙÀ½Àº °æ°í ·Î±× ÆÄÀÏ¿¡ ±â·ÏµÇ´Â Á¤º¸ÀÔ´Ï´Ù:
- ³»ºÎ ¿À·ù(ORA-600) ¹× ºí·Ï ÆļÕ
¿À·ù(ORA-1578)
- µ¥ÀÌÅͺ£À̽º ±¸Á¶¿Í ÆĶó¹ÌÅÍ¿¡ ¿µÇâÀ» ¹ÌÄ¡´Â ÀÛ¾÷°ú, CREATE DATABASE, STARTUP,
SHUTDOWN, ARCHIVE
LOG, RECOVER¿Í °°Àº ¹®Àå
- ÀνºÅϽº°¡ ½ÃÀÛÇÒ ¶§ÀÇ ºñ µðÆúÆ® ÃʱâÈ ÆĶó¹ÌÅÍÀÇ °ª
Starting up ORACLE RDBMS Version: 8.0.4.0.0
System
parameters with non-default
values:
processes
= 50
timed_statistics =
TRUE
shared_pool_size = 3500000
control_files =
/home/disk3/user30/DATA/DISK1/control01.con,
/home/disk3/user30/DATA/DISK2/control02.con
db_block_buffers =
200
log_buffer =
8192
log_checkpoint_interval =
10000
db_files
=
20
db_file_multiblock_read_count =
8
dml_locks =
100
sequence_cache_entries =
10
sequence_cache_hash_buckets =
10
db_name =
U30
background_dump_dest =
/home/disk3/user30/BDUMP
user_dump_dest =
/home/disk3/user30/UDUMP
max_dump_file_size =
10240
core_dump_dest =
/home/disk3/user/CDUMP
PMON started with pid
= 2
DBWO
started with pid =
3
LGWR started with pid
= 4
CKPT started
with pid = 5
SMON
started with pid =
6
RECO started with pid
= 7
Fri Jan 23
01:51:55 1998
create database ptw01
controlfile reuse
datafile ¡®/home/disk3/user30/DATA/DISK1/sys01.dbf¡¯ size
20m
logfile ¡®/home/disk3/user30/DATA/DISK3/log1.rdo¡¯ size
300k,
¡®/home/disk3/user30/DATA/DISK3/log2.dbf¡¯
size 300k
Fri Jan 23 02:51:55 1998
ORA-1501 signalled during: create
database ptw01
controlfile reuse
datafile ¡®...
Fri Jan 23 02:51:55
1998
alter database open
ORA-1507 signalled during: alter database
open...
Fri Jan 23 02:54:20 1998
Shutting down instance
(normal)
License high water mark = 1
Fri Jan 23 02:54:20 1998
ALTER
DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATBASE CLOSE
NORMAL...
- Á¦¾îÆÄÀÏ ¹× ¿Â¶óÀÎ Å×ÀÌºí½ºÆäÀ̽º ¹é¾÷
Mon Feb 9 03:14:11 1998
alter tablespace user_data
begin backup
Mon Feb 9 03:14:11 1998
ORA-1123 signalled during: alter
tablespace user_data gegin
backup
...
- ¸®µÎ ·Î±× ÆÄÀÏÀÌ
³Ê¹« »¡¸® ³Ñ¾î°¨À¸·Î ÀÎÇÑ Ã¼Å©Æ÷ÀÎÆ®ÀÇ ¹Ì¿Ï·á
Thread 1
advance to log sequence 1597
Current log# 2 seq# 1597 mem# 0:
/users/cours/tun8_08/DATA/DISK3/log2a.rdo
Thread 1
cannot allocate new log, sequence 1598
Checkpoint not
complete
- Å×ÀÌºí½ºÆäÀ̽ºÀÇ »ý¼º
Fri Jan 23 02:54:37 1998
create tablespace SYSTEM
datafile ¡®/home/disk3/user30/DATA/DISK1/sys01.dbf¡¯ size 20m
default storage
(initial 10K nest 10K) online
Fri Jan 23 02:54:47 1998
Completed: create
tablespace SYSTEM datafile ¡®/home/disk3/user30/DATA/DISK1/sys01.dbf¡¯
create
tablespace rbs
datafile ¡®/home/disk3/user30/DATA/DISK2/rbs01.dbf¡¯ size
30m
Fri Jan 23 03:08:53 1998
Completed: create tablespace rbs datafile
¡®/home/disk3/user30/DATA/DISK2/rbs01.dbf¡¯
- ·Ñ¹é ¼¼±×¸ÕÆ®ÀÇ »ý¼º ¹× ¼öÁ¤
Fri Jan
23 02:54:47 1998
create rollback segment SYSTEM tablespace SYSTEM
storage
(initial 50K next 50K)
Completed: create rollback segment SYSTEM tablespace
SYSTEM
Fri Jan 23 03:09:30 1998
Alter rollback segment rbs01
online
Completed: alter rollback segment rbs01 online
Fri Jan 23 03:09:34
1998
ÀÌ ÆÄÀÏÀº Á¡Â÷ Áõ°¡ÇÏ¿© µð½ºÅ© °ø°£À» Â÷ÁöÇϹǷÎ, ÀÚÁÖ ÀÌ ÆÄÀÏÀ» º¹»çÇÏ¿© »èÁ¦Çϰųª, ÁÖ±âÀûÀ¸·Î Á¤¸®ÇϽʽÿÀ.
´ÙÀ½ÀÇ init.ora ÆĶó¹ÌÅÍ´Â °æ°í ·Î±× ÆÄÀÏÀÇ À§Ä¡¸¦ Á¦¾îÇÕ´Ï´Ù:
BACKGROUND_DUMP_DEST
UNIX¿¡¼ µðÆúÆ® °ªÀº $ORACLE_HOME/rdbms/logÀÌ°í ÆÄÀÏ À̸§Àº
alert_<SID>.logÀÔ´Ï´Ù.
NT¿¡¼, µðÆúÆ® °ªÀº %ORACLE_HOME%\Rdbms80\TraceÀÌ°í, ÆÄÀÏ À̸§Àº
<sid>ALRT.LOGÀÔ´Ï´Ù.
¿¹: UNIX ls ¸í·É¾îÀÇ ÀϺΠÃâ·Â °á°ú
$ ls -l
/ora/ora804/rdbms/log
-rw-r-r-- 1 ora804 dba
43617 Jan 22 08:32 alert_ORA78.log
-rw-r-r-- 1
ora804 dba 24263 Jan 22 08:31 alert_RCAT.log
¹é±×¶ó¿îµå ÇÁ·Î¼¼½º ÃßÀû ÆÄÀÏ Á¦¾î
´ÙÀ½ÀÇ init.ora ÆĶó¹ÌÅÍ´Â ¹é±×¶ó¿îµå
ÇÁ·Î¼¼½º ÃßÀû ÆÄÀÏÀÇ À§Ä¡¸¦ Á¦¾îÇÕ´Ï´Ù:
BACKGROUND_DUMP_DEST
UNIX¿¡¼ µðÆúÆ® °ªÀº
$ORACLE_HOME/rdbms/logÀÌ°í ÆÄÀÏ À̸§Àº SID_processname_PID.trcÀÔ´Ï´Ù.
NT¿¡¼, µðÆúÆ® °ªÀº
%ORACLE_HOME%\Rdbms80\Trace ÀÌ°í, ÆÄÀÏ À̸§Àº sidPROCESSNAME.TRCÀÔ´Ï´Ù.
¿¹: UNIX
ls ¸í·É¾îÀÇ ÀϺΠÃâ·Â °á°ú
$
ls -l /ora/ora804/rdbms/log
-rw-r----- 1 ora804
dba 682 Dec 19 16:09 ora78_ckpt_27742.trc
-rw-r-----
1 ora804 dba 682 Dec 19 16:09
ora78_lgwr_27736.trc
-rw-r----- 1 ora804 dba 679 Dec
19 16:34 rcat_smon_29430.trc
¿¹: NT ¹é±×¶ó¿îµå ÃßÀû
ÆÄÀÏ djSMON.TRCÀÇ ÀϺΠÃâ·Â °á°ú
Fri Jan 23
07:09:19 1998
*** SESSION ID: (5.1) 1998.01.23.07.09.19.633
SMON:
following errors trapped and ignored:
ORA-00604: error occurred at recursive
SQL level 1
ORA-00376: file 1 cannot be read at this time
ORA-01110: data
file 1: ¡®C:\ORANT\DATABASE\SYS01DJ.DBF¡¯
»ç¿ëÀÚ ÃßÀû ÆÄÀÏ
»ç¿ëÀÚ ÃßÀû ÆÄÀÏÀº ¶ÇÇÑ »ç¿ëÀÚ³ª DBA ¿äû¿¡ µû¶ó ¼¹ö ÇÁ·Î¼¼½º¿¡ ÀÇÇÏ¿© »ý¼ºµÉ ¼ö
ÀÖ½À´Ï´Ù.
ÀνºÅϽº ·¹º§ ÃßÀû
ÀÌ ÃßÀû ·Î±ëÀº ÃʱâÈ ÆĶó¹ÌÅÍ SQL_TRACE¸¦ ÅëÇØ È°¼º
¶Ç´Â ºñÈ°¼ºÀ¸·Î µË´Ï´Ù.
µðÆúÆ® °ªÀº FALSEÀÔ´Ï´Ù.
¼¼¼Ç ·¹º§ ÃßÀû
´ÙÀ½ ¹®ÀåÀ¸·Î ƯÁ¤ ¼¼¼Ç¿¡ ´ëÇÑ ÃßÀû ÆÄÀÏ¿¡ ±â·ÏÇÒ ¼ö
ÀÖ½À´Ï´Ù:
SQL> EXECUTE
dbms_system.set_sql_trace_in_session (8, 12, TRUE);
¿©±â¿¡¼, 8°ú 12´Â ¿¬°áµÈ »ç¿ëÀÚÀÇ SID¿Í SERIAL#ÀÔ´Ï´Ù.
DBMS_SYSTEM ÆÐÅ°Áö´Â UNIX¿¡¼
$ORACLE_HOME/rdbms/admin/prvtutil.plb ½ºÅ©¸³Æ®(NT¿¡¼´Â
%ORACLE_HOME%\Rdbms80\Admin\Prvtutil.plb ½ºÅ©¸³Æ®)¿¡¼ »ý¼ºµË´Ï´Ù. ½ºÅ©¸³Æ®´Â catproc.sqlÀÌ ½ÇÇàµÉ ¶§
ÀÚµ¿À¸·Î ½ÇÇàµË´Ï´Ù.
´ÙÀ½ ¹®ÀåÀ» »ç¿ëÇÏ¿©, ¿¬°áµÈ »ç¿ëÀÚÀÇ ¼¼¼Ç¿¡ ´ëÇÑ ÃßÀû ÆÄÀÏ¿¡ ±â·ÏÇÒ ¼ö
ÀÖ½À´Ï´Ù:
SQL> ALTER
SESSION SET sql_trace=TRUE;
»ç¿ëÀÚ ÃßÀû ÆÄÀÏ Á¦¾î
´ÙÀ½
ÃʱâÈ ÆĶó¹ÌÅÍ´Â »ç¿ëÀÚ ÃßÀû ÆÄÀÏÀÇ À§Ä¡¿Í Å©±â¸¦ Á¦¾îÇÕ´Ï´Ù:
- USER_DUMP_DEST : »ç¿ëÀÚ ¶Ç´Â DBAÀÇ ¿äû¿¡ µû¶ó »ý¼ºµÉ
ÃßÀû ÆÄÀÏÀÇ À§Ä¡ Á¤ÀÇ
- MAX_DUMP_FILE_SIZE : O/S ºí·Ï¿¡ ÁöÁ¤µÇ¾î, »ç¿ëÀÚ
ÃßÀû ÆÄÀÏÀÇ Å©±â Á¦ÇÑ
UNIX¿¡¼ µðÆúÆ® °ªÀº $ORACLE_HOME/rdbms/logÀÌ°í ÆÄÀÏ À̸§Àº
SID_ora_PID.trc ÀÔ´Ï´Ù.
NT¿¡¼, µðÆúÆ® °ªÀº %ORACLE_HOME%\Rdbms80\Trace °í, ÆÄÀÏ À̸§Àº
oraPID.TRC ÀÔ´Ï´Ù.
¿¹: ¼¼¼Ç¿¡¼ ÃßÀû °¡´É
SQL> alter session set
sql_trace=true;
Session
altered.
SQL> select id, last_name from
scott.s_emp
2* where id =
40;
ID
LAST_NAME
-------
---------------------
40
Dumas
SQL>
¿¹: »ç¿ëÀÚ ÃßÀû ÆÄÀÏÀÇ ÀϺΠÃâ·Â °á°ú
$ cd $ORACEL_HOME/rdbms/log
$ ls
-l
total 26
-rw-r-r-- 1 oracle dba
12307 feb 9 03:32 u30_ora_19280.trc
$ more
u30_ora_19280.trc
=====================
PARSING IN
CURSOR#1 len=49
dep=0 uid=25 oct=3 lid=25 tim=31496536
hv=4182141062
ad=¡¯801a0394¡¯
select id, last_name from
scott.s_emp
where id=40
END OF
STMT
PARSE
#1:c=11,e=31,p=5,cr=42, cu=1, mis=1,
r=0, dep=0, og=4, tim=31496536
EXEC#1:c=0,e=0,p=0,cr=0,cu=0,
mis=0, r=0, dep=0, og=4,
tim=31496536
FETCH#1:c=0,e=4,p=4,cr=4,cu=0,mis=0, r=1, dep=0,
og=4, tim=31496542
FETCH#1:c=0,e=0,p=,cr=0,cu=0, mis=0, r=0,
dep=0, og=4, tim=31496567
¿¹: UNIX ls ¸í·É¾îÀÇ ÀϺΠÃâ·Â °á°ú
$ ls -l
/ora/ora804/rdbms/log
-rw-r---- 1 ora804 dba 2616 Dec 23
11:57 ora78_ora_1454.trc
-rw-r---- 1 ora804 dba 373310 Dec
23 10:12 ora78_ora_15819.trc
-rw-r---- 1 ora804 dba 356718
Dec 22 15:35 ora78_ora_1918.trc
ÁÖÀÇ: MAX_DUMP_FILE_SIZE¿Í USER_DUMP_DEST ÆĶó¹ÌÅ͵éÀº µ¿ÀûÀÎ ÃʱâÈ ÆĶó¹ÌÅ͵éÀÔ´Ï´Ù.
À̺¥Æ® ¸ñ·Ï
¿À¶óŬ ¼¹ö¿¡´Â ¹é°¡Áö ÀÌ»óÀÇ ´ë±â À̺¥Æ®°¡ ÀÖ½À´Ï´Ù.
À̵é
À̺¥Æ®´Â V$EVENT_NAME ºä¿¡ ÀÖ½À´Ï´Ù.
´ë±â À̺¥Æ®¸¦ ¼³¸íÇÏ´Â ÆĶó¹ÌÅÍ
¿¹1: "¹öÆÛ »ç¿ëÁß ´ë±â" À̺¥Æ®´Â ¹öÆÛ¸¦ »ç¿ëÇÒ
¼ö ÀÖÀ» ¶§°¡Áö ±â´Ù¸³´Ï´Ù. ÀÌ À̺¥Æ®´Â ¹öÆÛ°¡ ´Ù¸¥ ¼¼¼Ç¿¡ ÀÇÇÏ¿© ¹öÆÛ Ä³½¬·Î ÀÐÇôÁö°í(¼¼¼ÇÀÌ Àб⸦ ¿Ï·áÇϱâ À§ÇÏ¿© ´ë±â »óÅ¿¡ ÀÖ´Â °æ¿ì)
Àְųª, ¹öÆÛ°¡ ¹öÆÛij½¬¿¡ ÀÖÁö¸¸ ȣȯ ¸ðµå°¡ ¾Æ´Ò ¶§(Áï, ÀϺΠ´Ù¸¥ ¼¼¼ÇÀÌ ¹öÆÛ¸¦ º¯°æÇÏ°í ÀÖ´Â °æ¿ì) ¹ß»ýÇÕ´Ï´Ù.
ÀÌ
À̺¥Æ®´Â 3°³ÀÇ ÆĶó¹ÌÅÍ·Î ¿Ï·áµË´Ï´Ù:
- file# °ú block#: ¿À¶óŬ ¼¹ö°¡ ±â´Ù¸± ÇÊ¿ä°¡ ÀÖ´Â ºí·Ï¿¡ ´ëÇÑ ÆÄÀÏ ¹øÈ£¿¡
ÀÇÇÏ¿© ½Äº°µÇ´Â µ¥ÀÌÅÍÆÄÀÏ ³»ÀÇ ºí·Ï ¹øÈ£
- id : ¹öÆÛ »ç¿ëÁß ´ë±â À̺¥Æ®´Â ¼¼¼Ç ³»ÀÇ ¼·Î ´Ù¸¥ À§Ä¡¿¡¼ È£Ãâ µÉ ¼ö
ÀÖ°í, Ä¿³ÎÀÇ °¢ À§Ä¡´Â ¼·Î ´Ù¸¥ ÀÌÀ¯¸¦ ÁöĪÇÏ°í ÀÖ½À´Ï´Ù. ID´Â À̺¥Æ®¸¦ È£ÃâÇÏ´Â ¼¼¼ÇÀÇ À§Ä¡¸¦ °¡¸®Åµ´Ï´Ù.
¿¹2: "·Î±× ÆÄÀÏ º¯°æ(¹Ì¿Ï·á üũÆ÷ÀÎÆ®)" À̺¥Æ®´Â ¼¼¼ÇÀÌ ´ÙÀ½ ·Î±×·Î wrap µÉ ¼ö ¾ø±â ¶§¹®¿¡ ·Î±× º¯°æÀ» ±â´Ù¸³´Ï´Ù.
ÀÌ ·Î±×¿¡ ´ëÇÑ Ã¼Å©Æ÷ÀÎÆ®°¡ ¿Ï·áµÇÁö ¾Ê¾Ò±â ¶§¹®¿¡ wrapµÉ ¼ö ¾ø½À´Ï´Ù.
ÀÌ À̺¥Æ®´Â ÆĶó¹ÌÅÍ°¡ ¾ø½À´Ï´Ù.
ÀϹÝÀûÀÎ
´ë±â À̺¥Æ®
-Free Buffer Wait
-Latch
Free
-Buffer Busy Waits
-Db file
sequential read
-Db File Scattered
Read
-Db File Parallel Write
-Undo Segment Tx
Slot
-Undo Segment Extension
Àüü ¸ñ·ÏÀÌ ÇÊ¿äÇÑ °æ¿ì, Oracle8
Reference(Âü°í ¼Àû), ¸±¸®Áî 8.0.4¸¦ ÂüÁ¶ÇϽʽÿÀ.
´ë±â ¼¼¼ÇÀÇ Åë°è °á°ú
ÀÚ¿øÀ» ±â´Ù·Á¾ß Ç߰ųª ÇöÀç ±â´Ù¸®°í ÀÖ´Â ¼¼¼ÇÀÇ Åë°è
°á°ú´Â V$SESSION_EVENT¿Í V$SESSION_WAIT ºä¿¡ ÀúÀåµË´Ï´Ù.
¸ðµç ¼¼¼Ç¿¡ ´ëÇØ °è»êµÈ Åë°è´Â
V$SYSTEM_EVENT¿¡ ÀúÀåµË´Ï´Ù
V$SYSTEM_EVENT ºä
V$SYSTEM_EVENT´Â ÀνºÅϽº°¡ ½ÃÀÛÇÑ ¶§ºÎÅÍ Æ¯Á¤ À̺¥Æ®¿¡ ´ëÇÑ ÃÑ ´ë±â ¼ö¸¦ ³ªÅ¸³À´Ï´Ù.
¹®Á¦°¡ ÀÖÀ» °æ¿ì, ÇÁ·Î¼¼½º°¡ ÀÚ¿øÀ» ±â´Ù¸®°í ÀÖ´Â ½Ã°£À» ¾Ë ÇÊ¿ä°¡ ÀÖÀ» °ÍÀÔ´Ï´Ù. µû¶ó¼, ½Ã½ºÅÛÀÇ ¼Óµµ°¡ ´À·ÁÁú
¶§¸¶´Ù ÀÌ ºä¸¦ ÁúÀÇÇÏ´Â °ÍÀÌ À¯¿ëÇÕ´Ï´Ù.
V$SYSTEM_EVENT ºä´Â ´ÙÀ½ ¿À» Æ÷ÇÔÇÕ´Ï´Ù:
V$SESSION_EVENTºä
V$SESSION_EVENT ºä´Â ¼¼¼Çº°·Î µ¿ÀÏÇÑ
Á¤º¸¸¦ ³ªÅ¸³»¸ç, ¾Õ ÆäÀÌÁö¿¡ ³ª¿µÈ ¿ ÀÌ¿Ü¿¡ ¼¼¼ÇÀ» ½Äº°Çϱâ À§ÇÑ SID¿ë º°µµ ¿À» Æ÷ÇÔÇÕ´Ï´Ù.
ÁÖ: ÀÌµé ºä¸¦
Á÷Á¢ ÁúÀÇÇÏ¿© ½Ã½ºÅÛÀÌ ½ÃÀÛÇÑ ¶§ºÎÅÍ ½Ã½ºÅÛ¿¡ °üÇÑ ¸ðµç °ÍÀ» ¾Ë ¼ö ÀÖ½À´Ï´Ù.
V$SESSION_WAIT ºä
ÀÌ ºä´Â È°µ¿ ¼¼¼ÇÀÌ ±â´Ù¸®°í ÀÖ´Â ÀÚ¿øÀ̳ª À̺¥Æ®ÀÇ
¸ñ·ÏÀ» ³ªÅ¸³À´Ï´Ù.
¿ ¼³¸í
- SID: ¼¼¼Ç
½Äº°ÀÚ
- SEQ# : ´ë±â¸¦ ½Äº°ÇÏ´Â ½ÃÄö½º ¹øÈ£
- EVENT:
±â´Ù¸®°í ÀÖ´Â ÀÚ¿øÀ̳ª À̺¥Æ®
- P1TEXT: V$EVENT_NAME ºä¿¡ ´ëÇÏ¿© ¼³¸íµÈ
PARAMETER1¿¡ ÇØ´çµÇ´Â ù¹ø° Ãß°¡ ÆĶó¹ÌÅÍÀÇ ¼³¸í
- P1: ù¹ø° Ãß°¡ ÆĶó¹ÌÅÍ
°ª
- P1RAW: 16Áø¼ö·Î Ç¥ÇöµÈ ù¹ø° Ãß°¡ ÆĶó¹ÌÅÍ
°ª
- P2TEXT: V$EVENT_NAME ºä¿¡ ´ëÇÏ¿© ¼³¸íµÈ PARAMETER2¿¡
ÇØ´çµÇ´Â µÎ¹ø° Ãß°¡ ÆĶó¹ÌÅÍÀÇ ¼³¸í
- P2: µÎ ¹ø° Ãß°¡ ÆĶó¹ÌÅÍ
°ª
- P2RAW: 16Áø¼ö·Î Ç¥ÇöµÈ µÎ ¹ø° Ãß°¡ ÆĶó¹ÌÅÍ
°ª
- P3TEXT: V$EVENT_NAME ºä¿¡ ´ëÇÏ¿© ¼³¸íµÈ PARAMETER3¿¡ ÇØ´çµÇ´Â
¼¼¹ø° Ãß°¡ ÆĶó¹ÌÅÍÀÇ ¼³¸í
- P3: ¼¼ ¹ø° Ãß°¡ ÆĶó¹ÌÅÍ
°ª
- P3RAW: 16Áø¼ö·Î Ç¥ÇöµÈ ¼¼ ¹ø° Ãß°¡ ÆĶó¹ÌÅÍ
°ª
- WAIT_TIME
°ª |
¼³¸í |
> 0 |
¼¼¼ÇÀÇ ¸¶Áö¸· ´ë±â ½Ã°£ |
= 0 |
¼¼¼ÇÀÌ ÇöÀç ´ë±â ÁßÀÓ |
= -1 |
°ªÀÌ 100ºÐÀÇ 1ÃÊ ÀÌÇÏ |
= -2 |
½Ã½ºÅÛÀÌ Å¸ÀÌ¹Ö Á¤º¸¸¦ Á¦°øÇÒ ¼ö ¾øÀ½ |
- SECONDS_IN_WAIT: ±â´Ù¸®´Â À̺¥Æ®ÀÇ ½Ã°£(ÃÊ)
-
STATE: WAITING, WAITED UNKNOWN TIME, WAITED SHORT TIME(100ºÐÀÇ 1ÃÊ ÀÌÇÏ), WAITED
KNOWN TIME (ÀÌ °ªÀº WAIT_TIME Çà¿¡ ÀúÀåµÊ)
ÁÖÀÇ: ÆĶó¹ÌÅÍÀÇ ¸ðµç ¿(column)ÀÌ ¸ðµç À̺¥Æ®¿¡ ´ëÇÏ¿© »ç¿ëµÇ´Â °ÍÀº ¾Æ´Õ´Ï´Ù.
TIMED_STATISTICS ÃʱâÈ ÆĶó¹ÌÅÍ
ÇØ´ç ¿¿¡ °ªÀ» ¾ò±â À§Çؼ´Â
TIMED_STATISTICS ÆĶó¹ÌÅ͸¦ TRUE·Î ¼³Á¤ÇÕ´Ï´Ù. ÀÌ ÆĶó¹ÌÅÍ´Â µ¿ÀûÀÎ ÃʱâÈ ÆĶó¹ÌÅÍÀÔ´Ï´Ù.
¹®¸Æ |
ÂüÁ¶ |
ÃʱâÈ ÆĶó¹ÌÅÍ |
BACKGROUND_DUMP_DEST |
µ¿ÀûÀÎ ¼º´É ºä |
V$PARAMETER |
µ¥ÀÌÅÍ µñ¼Å³Ê¸® ºä |
None |
¸í·É¾î |
ALTER SESSION SET SQL_TRACE |
ÆÐÅ°ÁöµÈ ÇÁ·Î½ÃÀú ¹× ÇÔ¼ö |
DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION |
½ºÅ©¸³Æ® |
prvtutil.sql |