For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.
Just wondering if anyone started using Unified Audit and is willing to share their experience with it.
Which version of Oracle ?
What does v$session_wait_history show for that session.
What do you see as the state and event over a short set of queries to v$session for that sid ?
Regards
Jonathan Lewis
Sorry.
The database is 11.2.0.3 on AIX.
I'll take a look at gv$session_wait_history momentarily, we've killed the process and are restarting after giving the Access database a couple good kicks in the pants.
Justin
gv$session_wait_history is reporting events of
SQL*Net message to client
SQL*Net message from client
It does appear that the Access changes resolved the overall issue. But while Access was chugging away, I was still seeing LAST_CALL_ET getting reset with no other obvious signs of activity.
JustinCave wrote: gv$session_wait_history is reporting events of SQL*Net message to client SQL*Net message from client It does appear that the Access changes resolved the overall issue. But while Access was chugging away, I was still seeing LAST_CALL_ET getting reset with no other obvious signs of activity. Justin
JustinCave wrote:
If it was changing between FROM and TO there must have been some message coming from Access and bouncing back without an error. Possibly some sort of OCI "ping" type call that didn't involve an SQL statement.
Update: something like a "set context" or "set client identifier" perhaps; possibly a (non-SQL) rollback or commit