Re: embeded sql with sql trace or alter session

Two possible answers :

If the question is - can I issue in a Pro*C (or whatever) program

EXEC SQL alter session set events '10046
> trace name context forever, level 8';

then yes you can.

If the question is

if I enable this trace will the wait statistics for my embedded SQL show up ?

Yes they will.

If you're having problems with this (sounds like you are, or you wouldn't be posting)

then let us know

PS : You can kick a session into trace and set specific events even if you are not in the session via the DBMS_SYSTEM packages. Depends on what you're writing, but unless it's a monitoring application I'd be thinking about the dbms_system route.

HTH- YMMV T
"Teresa" <tpreto7_at_sapo.pt> wrote in message news:6dabc692.0302271735.3d81f7fa_at_posting.google.com...
> Hi there
> I have a question in regards to embeded sql trace:
>
> is possible to do a embeded sql with alter session set events '10046
> trace name context forever, level 8';
> if this is possible can someone please let me know how?
>
> many thanks
> Teresa
Received on Mon Mar 03 2003 - 06:27:58 CST