You can enable database client-request statement caching for selected existing SQL clients, or for all current clients, or all future clients. This is done in promon R&D 1, 18. There are other recent threads here that talk about this feature. It is available in 10.1C and later.
SQL logging files are named with the date and time stamp but they don't contain PID info like a DB log. However they do contain the server ID. You can use this to identify the server.
Example:
Code:
# cat SQL_server_1_20140204_170222_A.log
SQL LOG Section Started at 20140204_170222
SQL Environment Variable Settings:
CLASSPATH=UNDEFINED
SQL LOG CONFIGURATION
STATEMENT
SQL LOG FILE MAXIMUM SIZE: 500000000 Bytes
SQL SERVER ID: 1
20140204_170357 -627181824:
Freeing Cursor for SQL Statement: set pro_server log on with ( statement )
20140204_170357 -627181824:
Returning from sql_fn() with code: 0
20140204_170357 -627181824:
Setting Cursor for SQL Statement: select * from PUB.customer
...etc...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.