Thank you, Henry, but that still does not excuse my stupidity and being superficial. I need to learn more about Oracle internals, and that's something which is NOT taught at schools. So I try to learn it from you, guys, and much appreciate this opportunity. Anyway, I've been successful, too, so I was benevolently forgiven. Best regards, Sergey
-----Original Message----- Sent: Wednesday, January 30, 2002 11:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Session_wait Sorry, I guess I was reading too quickly also. I saw the 10046 and skimmed the rest. I assumed a session trace and didn't check the syntax. I'll try to be more careful before responding in the future. Henry -----Original Message----- Sent: Wednesday, January 30, 2002 11:56 AM To: Multiple recipients of list ORACLE-L On Wed, 30 Jan 2002, Babich , Sergey wrote: > However, I made the following entry into initXXXX.ora file: Event=" > 10046 trace name errorstack level 12" and it rebooted over the > weekend. Then I got a call from my boss on Monday morning (I was > home sick) letting me know the system had come to a crawl and was > producing a trace file every minute or so. Eventually, after some > speculations, I told him to rem out that entry and reboot. That > resolved the issue, but left me puzzled. Oh, boy, I couldn't understand who would tell you to do that on a production system, so I looked back in the archives and found this exchange: Sergey writes: > Since I didn't expect that to happen, I had just SQL trace turned on > for that particular session. Do you suggest entering event="10046 > trace name errorstack level 12" into initXXXX.ora? Henry writes: > Couldn't hurt. Also why not do some deltas of your session > statistics (before and after snapshots) I wish I had been paying more attention when this exchange was happening, as I would have said something. It can and does hurt, and you should never set such an event system wide. Furthermore, the event syntax makes no sense. I don't know where you got the syntax for the event, but it is really wrong. What you are essentially asking for is for every process to dump a full errorstack (call stack trace, argument/register address dump, cursor dump, heap dump and PGA dump), every time a process starts up (same as setting 'immediate trace name errorstack...'). Furthermore, this event does not produce a 10046 trace. It just gives you an errorstack. The correct syntax for a 10046 trace is: 10046 trace name context forever, level <level> This should probably not be set instance-wide in the init.ora in a production system. It uses large amounts of resources. Oracle Support has from time to time tried to convince me to set this event instance-wide, but they are mistaken and misguided. It should be set in the session you want to trace, either using 'alter session set events,' 'dbms_system.set_ev(),' or 'oradebug event...' The correct syntax for an errorstack is: [immediate|<errno>] trace name errorstack, level <level> This can be set safely at the instance (init.ora) level if you have it dump on error. If you have it dump on setting the event, as you did, ever server process will have to do this dump when it starts, bringing even a moderately utilized system to its knees. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Henry Poras 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: Babich , Sergey 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).
