To set 10046 for all sessions, you specify the event
clause (from below) in your init.ora. This brings it
into effect for all connections.
Note this will have a significant impact on
performance - and you'll need plenty of space in your
trace file directory.
I know in this situation its hard to change things,
but have you applied all the relevant patches to both
OS and Oracle software? Generally random drop-outs of
connections are typically more prevalent in earlier
versions of each release.
One radical thing you could try is that in my
experience, most disconnect errors occur with the cost
optimizer - you could try using rule (but this is
obviously not without considerable risk)
hth
connor
- "Baker, Barbara" <bakerb_at_rockymountainnews.com>
wrote: > Sun Solaris 2.6; Oracle 8.0.5
>
> We've been fighting a problem for several days.
> It's getting worse. And
> it's causing MAJOR heartburn. (How bad is it? It's
> SO bad that the vice
> president has been assigned the task of following IS
> staff members around to
> see what we're doing and reporting back on our
> progress to the president.
> It's real embarrassing for him when I go to the
> bathroom.)
>
> Of the 70 to 80 users we have connected to Oracle,
> several (usually around
> 12 to 15) users are disconnected from the database
> all at once with an "end
> of file on communication channel". Other users
> remain on. Not always the
> same users disconnected. No commonality that we can
> find.
>
> There's nothing in the alert log, and there are no
> trace files created.
> Oracle knows nothing about the disconnected users --
> they remain connected
> to the database from the server side 'till pmon
> comes along to clean them
> up.
>
> FINALLY, my question. Oracle has suggested that we
> turn on trace event
> 10046. I confess I've never done this before. In
> svrmgrl, I issue the
> command oradebug setorapid nnnnn, then oradebug
> event 10046 trace name
> context forever, level 12. This worked 1 time for 1
> user. It created a
> trace file in the udump directory. However, I'd
> like to set this event on
> for several users. The command executes without
> error, but no add'l trace
> files are created.
>
> What am I missing? Can I only do this for 1 user?
> Does it have something
> to do with running MTS? I tried using the setorapid
> (pid) instead of the
> setospid (spid), but it made no difference.
>
> Any ideas?
> Thanks for any help.
>
> Barb "The chipmunk" dba
>
> P.S. Yes, we do have both our SA's and network
> folks looking at the
> problem, as well as several consultants. Everyone
> is clueless.
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Baker, Barbara
> INET: bakerb_at_rockymountainnews.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music
Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Nov 13 2001 - 14:29:08 CST