Re: RE: what causes a memory dump?
memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: RE: what causes a memory dump?
v$session.type Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Friday, September 26, 2003 12:40 PM To: Multiple recipients of list ORACLE-L memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: RE: what causes a memory dump?
Depending on the type of process which is dumping. If it's a background process (LGWR,DBWR,SMON,PMON,CKPT,RECO,CJQ,P00,D00, shared servers, archiver) it goes to bdump. If it isn't, it goes to udump. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: what causes a memory dump? memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed
RE: RE: what causes a memory dump?
ok so what causes the memory to dump? Im stumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 02:39:41 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? Depending on the type of process which is dumping. If it's a background process (LGWR,DBWR,SMON,PMON,CKPT,RECO,CJQ,P00,D00, shared servers, archiver) it goes to bdump. If it isn't, it goes to udump. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: what causes a memory dump? memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies
RE: RE: what causes a memory dump?
Cary - Love the succinct reply! Ryan - Just create a daemon process that will remove any dump files every 3 seconds. Not to worry. Just kidding. You need to review the dump file using your keen knowledge of your system in conjunction with Oracle Support and try to figure out why the application dumped. Pain is your friend. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 26, 2003 12:40 PM To: Multiple recipients of list ORACLE-L memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: RE: what causes a memory dump?
There is special mechanism that you've installed, called Oracle*Dumpster, which dumps core when you exceed warp 9. You can inspect /usr/include/signal.h to see what devious mechanisms does Oracle*Dumpster use to dump core when your process exceeds warp 9. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: what causes a memory dump? ok so what causes the memory to dump? Im stumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 02:39:41 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? Depending on the type of process which is dumping. If it's a background process (LGWR,DBWR,SMON,PMON,CKPT,RECO,CJQ,P00,D00, shared servers, archiver) it goes to bdump. If it isn't, it goes to udump. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: what causes a memory dump? memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: RE: what causes a memory dump?
i had to delete the dump file in order to log into sysdba. it took up the whole hard drive. any examples of what causes a memory dump? what is the point to a memory dump? From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 03:19:48 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? Cary - Love the succinct reply! Ryan - Just create a daemon process that will remove any dump files every 3 seconds. Not to worry. Just kidding. You need to review the dump file using your keen knowledge of your system in conjunction with Oracle Support and try to figure out why the application dumped. Pain is your friend. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 26, 2003 12:40 PM To: Multiple recipients of list ORACLE-L memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: RE: what causes a memory dump?
what is warp 9? what is the point of dumping memory? I didnt set this up. From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 03:29:43 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? There is special mechanism that you've installed, called Oracle*Dumpster, which dumps core when you exceed warp 9. You can inspect /usr/include/signal.h to see what devious mechanisms does Oracle*Dumpster use to dump core when your process exceeds warp 9. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: what causes a memory dump? ok so what causes the memory to dump? Im stumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 02:39:41 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? Depending on the type of process which is dumping. If it's a background process (LGWR,DBWR,SMON,PMON,CKPT,RECO,CJQ,P00,D00, shared servers, archiver) it goes to bdump. If it isn't, it goes to udump. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: what causes a memory dump? memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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
RE: RE: what causes a memory dump?
Ryan - The largest I've seen is 4-meg., so this is unusual. My suggestion would be to change your USER_DUMP_DEST to a drive with more free space, because the DBA's rule of life is that if an error is encountered once, it will probably be encountered again. Also check your alert log, because the error that caused the dump will be mentioned there. Try to diagnose the problem before it whacks you again. Good luck. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 26, 2003 2:45 PM To: Multiple recipients of list ORACLE-L i had to delete the dump file in order to log into sysdba. it took up the whole hard drive. any examples of what causes a memory dump? what is the point to a memory dump? From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 03:19:48 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? Cary - Love the succinct reply! Ryan - Just create a daemon process that will remove any dump files every 3 seconds. Not to worry. Just kidding. You need to review the dump file using your keen knowledge of your system in conjunction with Oracle Support and try to figure out why the application dumped. Pain is your friend. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 26, 2003 12:40 PM To: Multiple recipients of list ORACLE-L memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list
RE: RE: what causes a memory dump?
Title: RE: RE: what causes a memory dump? Dennis ... your max_dump_file_size parameter is set that's why you see max 4M. I had some 8G trace files ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: what causes a memory dump? Ryan - The largest I've seen is 4-meg., so this is unusual. My suggestion would be to change your USER_DUMP_DEST to a drive with more free space, because the DBA's rule of life is that if an error is encountered once, it will probably be encountered again. Also check your alert log, because the error that caused the dump will be mentioned there. Try to diagnose the problem before it whacks you again. Good luck. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: RE: what causes a memory dump?
Raj - Thanks, I forgot about that one. Ryan - you might want to check your value for that parameter. So Raj, was there any value to the 8-gig dump file beyond the first 4-meg of it? Or did you have an error that required you to increase the dump file size in order to diagnose it? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 26, 2003 3:20 PM To: Multiple recipients of list ORACLE-L Dennis ... your max_dump_file_size parameter is set that's why you see max 4M. I had some 8G trace files ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Friday, September 26, 2003 4:10 PM To: Multiple recipients of list ORACLE-L Ryan - The largest I've seen is 4-meg., so this is unusual. My suggestion would be to change your USER_DUMP_DEST to a drive with more free space, because the DBA's rule of life is that if an error is encountered once, it will probably be encountered again. Also check your alert log, because the error that caused the dump will be mentioned there. Try to diagnose the problem before it whacks you again. Good luck. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RE: RE: what causes a memory dump?
Title: RE: RE: what causes a memory dump? Dennis, it was a 10046^8 dump for a optimized java program ... Ha !! Couldn't make tkprof to read it though ... even with ulimit unlimited. 16 CPU, 32GB box. We have intentionally left max_dump_file_size to unlimited ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Friday, September 26, 2003 4:40 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: what causes a memory dump? Raj - Thanks, I forgot about that one. Ryan - you might want to check your value for that parameter. So Raj, was there any value to the 8-gig dump file beyond the first 4-meg of it? Or did you have an error that required you to increase the dump file size in order to diagnose it? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: RE: what causes a memory dump?
What about core dump? goes to cdump and that is the nastiest one occupying a lot of disk space. Only solution to define it not more than 5M (if i remenber correctly 10240 blocks). Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 26 Sep 2003 10:39:41 -0800 Depending on the type of process which is dumping. If it's a background process (LGWR,DBWR,SMON,PMON,CKPT,RECO,CJQ,P00,D00, shared servers, archiver) it goes to bdump. If it isn't, it goes to udump. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 1:40 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE: what causes a memory dump? memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use
Re: RE: what causes a memory dump?
nothing in the alert log. we have a script that polls it. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 26, 2003 4:09 PM Ryan - The largest I've seen is 4-meg., so this is unusual. My suggestion would be to change your USER_DUMP_DEST to a drive with more free space, because the DBA's rule of life is that if an error is encountered once, it will probably be encountered again. Also check your alert log, because the error that caused the dump will be mentioned there. Try to diagnose the problem before it whacks you again. Good luck. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 26, 2003 2:45 PM To: Multiple recipients of list ORACLE-L i had to delete the dump file in order to log into sysdba. it took up the whole hard drive. any examples of what causes a memory dump? what is the point to a memory dump? From: DENNIS WILLIAMS [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 03:19:48 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: what causes a memory dump? Cary - Love the succinct reply! Ryan - Just create a daemon process that will remove any dump files every 3 seconds. Not to worry. Just kidding. You need to review the dump file using your keen knowledge of your system in conjunction with Oracle Support and try to figure out why the application dumped. Pain is your friend. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 26, 2003 12:40 PM To: Multiple recipients of list ORACLE-L memory only dumped to the udump. it didnt dump to the bdump. how is it decided where it will be dumped? From: Mladen Gogala [EMAIL PROTECTED] Date: 2003/09/26 Fri PM 12:09:39 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: what causes a memory dump? user_dump_dest, background_dump_dest, NJ. -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, September 26, 2003 11:50 AM To: Multiple recipients of list ORACLE-L Subject: what causes a memory dump? i had one yesterday when i killed a process. Also, what parameter tells oracle where to dump? why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a 'shutdown abort' -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL