Sequential log of executed SQL statements
> QUESTION POSED on: 02 February 2007
Is it somehow possible to get the sequential log with details of all executed SQL statements for a certain time period (with time stamps)? We have an application which is not well-documented and for the correct parameterization we need to understand exactly the relationships between the tables and the sequence of SQL statement execution. If this is not possible, is there a known tool for something like that?
> EXPERT RESPONSE
The application needs to be coded to write to such a logfile. The UTL_FILE is very helpful for this exact task. UTL_FILE can write to the log file as the application executes. And you can code your UTL_FILE output to include a timestamp. This will require you to modify the application though.
'오라클' 카테고리의 다른 글
| View to determine backup status of tablespace (0) | 2007.02.16 |
|---|---|
| System doesn't respond to forced log switch (0) | 2007.02.14 |
| Buffer busy waits on primary key index (0) | 2007.02.14 |
| Import of dump file took 20 hours (0) | 2007.02.14 |
| oracle 9i DYNAMIC SGA (0) | 2007.02.05 |