Ä¿ÇÇÇâÀÌ ³ª´Â *NIX
Ä¿ÇǴнº
½Ã½ºÅÛ/³×Æ®¿÷/º¸¾ÈÀ» ´Ù·ç´Â °÷
*
HanIRCÀÇ #coffeenix ¹æ
[
Àåºñ ¹× ȸ¼± ÈÄ¿ø
]
> Forum <
IT ÀÏÁ¤
N
e
w
!
ÀÚµ¿È ÇÁ·ÎÁ§Æ®
HOME
>
µ¥ÀÌÅͺ£À̽º(database)
µµ¿ò¸»
°Ë»ö :
»çÀÌÆ®
WHOIS
À¥¼¹ö Á¾·ù
¿À¶óŬ (Oracle)
(17, ±Û 3, ÀÚ·á 22)
MySQL
(20, ±Û 12, ÀÚ·á 8)
PostgreSQL
(6, ±Û 1)
DB Æ©´×
(6, ±Û 2, ÀÚ·á 9)
DB ÇÁ·Î±×·¡¹Ö
(ÀÚ·á 1)
±×¿ÜÀÇ DB
(4, ÀÚ·á 2)
µ¥ÀÌÅͺ£À̽º Åø
(3, ÀÚ·á 2)
ORACLE ÆÁ - user º° Trace °É±â.
ÀÛ¼ºÀÏ : 2012/06/19 14:36
±Û¾´ÀÌ : ¹ü³ÃÀÌ (
http://armines.tistory.com/
)
Á¶È¸¼ö : 7046
[
ÀÌÀüȸé
/
¼öÁ¤
] ºñ¹Ð¹øÈ£ :
Trace ¸¦ °Ç´Ù°í Çϸé Å©°Ô 3°¡Áö·Î ³ª´µ¾î Áý´Ï´Ù.
1. instance level trace
2. session level trace
3. another session trace
À§ÀÇ 3°¡Áö ¹æ¹ýÀÇ °æ¿ì´Â Àüü ȤÀº ƯÁ¤ ¼¼¼Ç¿¡ ´ëÇÏ¿© trace¸¦ °Å´Â ¹æ¹ýÀ¸·Î Database¸¦ »ç¿ëÇÏ´Â »ç¿ëÀÚ¿¡ ´ëÇÑ TRACE ¹æ¹ýÀº ±âÀçµÇ¾î ÀÖÁö ¾Ê½À´Ï´Ù. (À§ 3°¡Áö ¹æ¹ýÀº ±¸±Û¸µÀ» ÇÏ½Ã¸é ½±°Ô ¹æ¹ýÀÌ ³ª¿É´Ï´Ù.) ÀÌ¿¡ Àú¿Í °°ÀÌ Æ¯Á¤ USER ¼¼¼Ç¿¡ ´ëÇÏ¿© Trace¸¦ °É±â À§ÇÑ ¹æ¹ýÀ» ã°íÀÚ ÇÏ´Â ºÐµéÀ» À§ÇØ ¾Æ·¡ »çÇ×À» Àû°í ±âÀçÅä·Ï ÇÏ°Ú½À´Ï´Ù.
4. ƯÁ¤ USER¿¡ ´ëÇÑ TRACE °É±â.
1) ·Î±×ÀÎ ÇÏ´Â »õ·Î¿î ¼¼¼Ç¿¡ TRACE °É±â(Á÷Á¢ ¾´ °Íó·³ ÀûÀ¸·Á ÇÏ¿´À¸³ª ¾ç½É»ó.. ¸µÅ©·Î ´ëü ÇÕ´Ï´Ù. »ý°¢ º¸´Ù Å°¿öµå¸¦ À߸ø ã¾Æ¼ ã±â°¡ Èûµé¾ú³×¿ä.)
- LOGON trigger ÀÌ¿ëÇϱâ
(
http://www.dbapundits.com/blog/query-script/set-trace-on-user-sessions/
)
2) ÇöÀç ½ÇÇàÁßÀÎ oracle ¼¼¼Ç¿¡ TRACE °É±â
- ÀÌ ºÎºÐÀº ã±â ã¾Ò´Âµ¥ ¾ÆÁ÷ ±¸ÇöÀ» ÇÏÁö ¸øÇØ ÃßÈÄ ±âÀç ÇÕ´Ï´Ù. ¾óÃß Çؼ®ÇØ º¸´Ï ½ÇÇàÁßÀÎ oracle ¼¼¼ÇÀ» È®ÀÎÇÏ¿© ÇØ´ç ¼¼¼Ç¿¡¸¸ Æ®·¹À̽º¸¦ °É¾îÁÖ´Â ¹æ½ÄÀä. ÀÌ°É cron¿¡ ³Ö¾î¼ 5ºÐ´ÜÀ§·Î ½ÇÇàÇؼ °è¼Ó Trace ¸¦ ³²±ä´Ù´Â ³»¿ëÀÌ´øµ¥.. À§ÀÇ "Set trace on user sessions" °ú º´ÇàÇϸé cronÀ¸·Î °è¼Ó µ¹¸± ÇÊ¿ä´Â ¾ø°Ú³×¿ä. À̺κР±¸ÇöÇØ º¸°í(1¹ø ó·³ ´Ü¼øÇÏÁö´Â ¾Ê¾Ò½À´Ï´Ù.) ÃßÈÄ¿¡ ±ÛÀ» ¿Ã¸®µµ·Ï ÇÏ°Ú½À´Ï´Ù.
ÀÛÀº µµ¿òÀÌ¶óµµ µÇ¾úÀ¸¸é ÇÏ´Â ¸¶À½ÀÌ¸ç ¿À¶óŬ Ãʺ¸ÀÚÀÇ ±ÛÀ» º¸°í ³Ê¹« È亸½ÃÁö ¾Ê¾ÒÀ¸¸é ÇÕ´Ï´Ù. ^^
Ä¿ÇǴнº Ä«Æä ÃÖ±Ù ±Û
[04/24]
º¸Çè
[04/22]
Re: OpenSSL Ãë¾àÁ¡ Á¤¸®, Logjam(·Î±×Àë)¿¡¼ Heartbleed±îÁö
[04/21]
LET¡¯S START WITH ON
[04/21]
º¸Çè
[04/20]
Á¦ÁÖ
[04/20]
±¹³»
[04/19]
Á¦ÁÖ
[04/18]
??? ?????
[04/17]
???? onion ?????? -
[04/11]
±¹°¡
[04/10]
Stride Into Dream:
[03/20]
Re: ¿Â¶óÀΰÔÀÓÀÇ Á¾ÁÖ±¹ ´ëÇѹα¹
[10/20]
Cross Compiler ±ò
[07/14]
SSL ¬¡¬°
[04/26]
Re: µµ½ºÈ¸é ¿ø°ÝÁ¶Á¾ ¿©ºÎ
N
e
w
! ÃÖ±Ù¿¡ µî·ÏÇÑ ÆäÀÌÁö
KiCad EDA Suite project (Free/Libre/Open-Source EDA Suite) (CAD)
¿ÀÇÂij½ºÄÉÀ̵å ijµå (OpenCASCADE CAD)
QCad for Windows --- GNU GPL (Free Software)
The Hello World Collection
IPMI¸¦ È°¿ëÇÑ ¸®´ª½º ¼¹ö°ü¸®
DNS ¼³Á¤ °Ë»ç
nagiosgraph ¼³Ä¡ ¹æ¹ý
Slony-I ¼³Ä¡ ¹æ¹ý (postgresql replication tool)
Qmail±â¹ÝÀÇ Anti spam ½Ã½ºÅÛ ±¸ÃàÇϱâ
clusterssh
[ ÇÔ²²ÇÏ´Â »çÀÌÆ® ]
¿î¿µÁø :
ÁÁÀºÁøÈ£(truefeel)
, ¾ß¼ö(yasu), ¹ü³ÃÀÌ, sCag
2003³â 8¿ù 4ÀÏ~