Re: sqlnet trace in ProC app

First of all, make sure that timed statistics are turned on in the database and run utlbstat. The reason why you want timed statistics on is when you tkprof the trace file, you will then get the time taken to execute, parse and fetch for each statement.

Another way to turn on tracing in the program is the following statement after you log into the database: EXEC SQL EXECUTE IMMEDIATE 'alter session set sql_trace=TRUE';

HTH
Toby T.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!