* 자료 다운로드는 정회원이상 가능합니다.
TOOL SQL Monitor ( 쿼리 캡쳐 툴)
2011.08.03 00:02
http://www.toadworld.com/Freeware/SQLMonitorFreewareDownload/tabid/812/Default.aspx
quest 사에서 나온 실행 중인 프로그램의 쿼리 잡아내는 프로그램입니다.
프로그램 개발시 쿼리 뽑아낼때 유용.
SQL Monitor is a utility that monitors Oracle, MySQL, and DB2 Client DLL calls, allowing you to capture all SQL calls a program sends to the database via the client DLLs.
Major features of SQL Monitor include:
- Supports Windows NT/2000/XP
- Supports Oracle clients version 7.3 thru 10
- Displays SQL statements that come from processes in real-time, eliminating the necessity to turn on tracing and look into poorly formatted trace file
- Allows monitoring NT services
- Displays logon attempts, both successful and unsuccessful (username, password, TNS alias, success)
- Performs syntax highlighting
- Displays values of bind variables for SQL statements
- Shows even statements that fail to execute. Displays Oracle error code and message for those statements.
- Allows you to copy and paste statements from the output to one of your SQL analyzing tools (Toad, SQL Navigator, or even SQL*Plus)
- Monitors applications like Import/Export, SQL*Loader, Server Manager (svrmgrl.exe), as well as applications written with Oracle Forms or Pro*C
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
1 | Oracle9iSQL Tuning Guide | 휘휘 | 2011.08.03 | 92879 |