Re: 9.2.0.4 update and event 10195

"Tanel Poder" <change_to_my_first_name_at_integrid.info> schrieb im Newsbeitrag news:3f6b145c_1_at_news.estpak.ee...
>Hi!

>Comments inline.

Btw, what did you do to that message? I can'e get outlook express to quote this properly. had to quote it manually.

>There is no init.ora nor spfile parameter called "events". There is init.ora param called "event".
>You can set your spfile parameter event to following for example:
>SQL> alter system set event='10046 trace name context lifetime 10, level 1:4031 trace name HEAPDUMP level 1;name ERRORSTACK level
3' scope=spfile;
When I tried this last time it produced an error telling me I couldn't change event. Tried it again right now, worked this time. Was probably a typo although the error message was more specific, ISTR.

>However, using "events" you can set events in your running session or for all new sessions (when using alter system).
>So, both syntaxes are correct, but they do different things, one modifies spfile only, others modify some bits in SGA & PGA.

>Alter system set event ... context off, will only make that any new sessions won't have the event enabled. All existing sessions
logged on between
> "alter system .. context forever" and "alter system .. context off" will still have this event set (unless explicitly unset using
alter session). So, if you
> really want to remove the event from everyone, you should do it using dbms_system.set_ev procedure or oradebug(possibly checking
the state of
> event using read_ev first).

Ok, I understand. I'll have a look at that DMBS_SYSTEM package. I got a bit of doc at http://www.oracleadvice.com/Tips/dbms_system_v2.htm. OTOH, since I will be settin this event til the next patch corrects the CBO bug and then reboot anyway I'll probably not bother with that package and do the change in the spfile.

>[re courses]
>Search for "Oracle9i Database: Seminar Series for Oracle Server" in OE website.
Ok, got it.

Thanks a lot!
Volker Received on Fri Sep 19 2003 - 10:29:28 CDT