Barb, Some things to check:
(a) Swap area becoming full - if this is pointing to /tmp, this could result in erratic problems. (b) What does 'vmstat' state in terms of memory usage/mem free/swap IO? (c) File table/process table overflows - this is usually seen in retrospect from 'sar' output Strange things have been known to happen - typically resulting in ORA-0311 - when some OS limit is reached. I would look at the OS and network rather than at Oracle at this point of time. You should then search Metalink for a combination of 8.0.5 and ORA-0311. 10046 is nothing but SQL_TRACE - level 12 will really eat up 'udump' space. You will need to set this in the init.ora and bounce the db. John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Listen to great commercial-free christian music 24x7 at www.klove.com ** The opinions and statements above are entirely my own and not those of my employer or clients ** > -----Original Message----- > From: Baker, Barbara [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 13, 2001 11:51 AM > To: Multiple recipients of list ORACLE-L > Subject: User disconnects (ora-0311) and tracing > > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
