Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: get package variables for every session
malishich wrote:
> You want to say, that there are no place in Oracle where i can find
> theese session data?
> May be I can turn on SQL auditing and query somthing from v$session and
> sys.aud$, combining by date of logon and alive-state of session. Then,
> after getting audited SQL text, try parse it to read....
>
> Any other suggestions, with regard to that I can not change the method
> of setting these variables (many clients on different platforms and
> hard to recompile them).
>
Hi,
The only place where you might find something about this is in v$sql,
and that is if you're lucky (i.e. the statements are still in the cache).
As for using auditing it won't do (no audit on pl/sql).
rgds
Received on Mon May 16 2005 - 05:12:54 CDT