cdump, bdump, udump
Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
RE: cdump, bdump, udump
Title: RE: cdump, bdump, udump I used to be of the same school of thought as you. But on Solaris 2.7 with Oracle v8.1.7 I have seen the various processes hang on to the old log for days if I "mv alertSID.log alertSID.log.old ; touch alertSID.log" 7113:oracle@e6500a> ls -Fla /dw01/app/oracle/admin/BART/bdump/alert_BART.log -rw-r--r-- 1 oracle oinstall 484498 May 14 16:12 /dw01/app/oracle/admin/BART/bdump/alert_BART.log 7113:oracle@e6500a> fuser /dw01/app/oracle/admin/BART/bdump/alert_BART.log /dw01/app/oracle/admin/BART/bdump/alert_BART.log: 28913o 28911o 28909o 28907o 28905o 28902o 28900o 28898o 28896o 7113:oracle@e6500a> ps -ef | egrep "PID|28913|28911|28909|28907|28905|28902|28900|28898|28896" | grep -v grep UID PID PPID C STIME TTY TIME CMD oracle 28898 1 0 15:55:56 ? 0:00 ora_dbw0_BART oracle 28905 1 0 15:55:57 ? 0:00 ora_smon_BART oracle 28911 1 0 15:55:58 ? 0:00 ora_p000_BART oracle 28909 1 0 15:55:57 ? 0:00 ora_arc0_BART oracle 28907 1 0 15:55:57 ? 0:00 ora_reco_BART oracle 28902 1 0 15:55:56 ? 0:00 ora_ckpt_BART oracle 28913 1 0 15:55:58 ? 0:00 ora_p001_BART oracle 28900 1 0 15:55:56 ? 0:00 ora_lgwr_BART oracle 28896 1 0 15:55:56 ? 0:00 ora_pmon_BART -Original Message- From: Terry Ball [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 25, 2001 1:32 PM To: Multiple recipients of list ORACLE-L Subject: Re: cdump, bdump, udump With the alert.log you are incorrect. Oracle only get a handle on the file when it writes to it. The rest of the time, it does not need nor keep a handle on the alert.log. You can move or delete the file and neither Oracle nor the OS care. A new alert.log will be created as soon as Oracle needs to write to one. Terry Ron Rogers wrote: > Team, > Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't "see". The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null > alert.log. > Just a house keeping note. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > Sinardy, > > First, I suggest you find some time and sit down and READ the Oracle > documentation. Otherwise you are going to get a large number of "RTFM" > emails, and some flaming as well. > > Now.. the alert log is created (if it does not already exist) or written to > every time Oracle wants to record an event that has happened in the > database/instance. So log switches will be in there, database shutdown and > startup messages, errors dealing with the infrastructure of the database > (failure to extend a rollback segment, failure to get space in the temp > segment, disasterous database errors etc) There are other messages as well, > I'm not going to list every one. > > Bdump contains trace files that relate to the Oracle background process -- > anything generated by smon, pmon, etc > > Udump contains trace files that relate to specific user Oracle processes > > Cdump contains core dumps, associated with one or another trace files in the > bdump directory. > > Rachel > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: cdump, bdump, udump > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > >Hi all, > > > >When those logs will created ? > > > >Thank you > > > >Sinardy > > > > > >-Original Message- > >Sent: Tuesday, 24 April 2001 9:41 AM > >To: LazyDBA mailing list > > > > > >Hi DBAs and SAs, > > > >I had a task to do housekeep ...\bdump\alertSID.log > >What logs usually Oracle system need to housekeep, and what are these > >directory > > cdump, > > bdump and > > udump > >for ? > > > > > >Thank you for your time > > > >Sinardy > > > > > > > > > >Think you know someone who can answer the above question? Forward it to > >them! > >to unsubscribe, send a blank email to [EMAIL PROTECTED] > >to subscribe send a blank email to [EMAIL PROTECTED] > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > >Tell yer mates about http://www.farAwayJobs.com > > > > > >-- > >Please see the official ORACLE-L FAQ: http:/
RE: cdump, bdump, udump
Ron, You would not be able free the disk space even if alert.log is deleted. For example, if alert.log file size is 500 MB size and then you delete the alert.log, still you would not be able to get a disk free space of 500 MB. This space would be released once you bounce the database. The above scenario is similar even if you copy alert.log to a different location and then delete the rows. The above scenario applies to Solaris environment. I do not know what happens in NT environment. Rao [EMAIL PROTECTED] -Original Message- Sent: Wednesday, April 25, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't "see". The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null > alert.log. Just a house keeping note. ROR mª¿ªm >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of "RTFM" emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel >From: "Sinardy Xing" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: cdump, bdump, udump >Date: Tue, 24 Apr 2001 03:40:27 -0800 > >Hi all, > >When those logs will created ? > >Thank you > >Sinardy > > >-Original Message- >Sent: Tuesday, 24 April 2001 9:41 AM >To: LazyDBA mailing list > > >Hi DBAs and SAs, > >I had a task to do housekeep ...\bdump\alertSID.log >What logs usually Oracle system need to housekeep, and what are these >directory > cdump, > bdump and > udump >for ? > > >Thank you for your time > >Sinardy > > > > >Think you know someone who can answer the above question? Forward it to >them! >to unsubscribe, send a blank email to [EMAIL PROTECTED] >to subscribe send a blank email to [EMAIL PROTECTED] >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl >Tell yer mates about http://www.farAwayJobs.com > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sinardy Xing > 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-
Re: cdump, bdump, udump
On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and space has immediately become free. (Not true with the listener.log however). Terry "Rao, Maheswara" wrote: > Ron, > > You would not be able free the disk space even if alert.log is deleted. For > example, if alert.log file size is 500 MB size and then you delete the > alert.log, still you would not be able to get a disk free space of 500 MB. > This space would be released once you bounce the database. > > The above scenario is similar even if you copy alert.log to a different > location and then delete the rows. > > The above scenario applies to Solaris environment. I do not know what > happens in NT environment. > > Rao > > [EMAIL PROTECTED] > > -Original Message- > Sent: Wednesday, April 25, 2001 10:39 AM > To: Multiple recipients of list ORACLE-L > > Team, > Correct me if I am wrong, please.. If you delete the alert.log file with the > database up and running, the oracle still thinks the file exists and writes > to a non existant file that you can't "see". The proper method of reducing > the file size is to copy the file to a backup location, and edit the > original and delete rows from the file. OR if you do not need to keep the > original log for analysis you could copu /dev/null > alert.log. > Just a house keeping note. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > Sinardy, > > First, I suggest you find some time and sit down and READ the Oracle > documentation. Otherwise you are going to get a large number of "RTFM" > emails, and some flaming as well. > > Now.. the alert log is created (if it does not already exist) or written to > every time Oracle wants to record an event that has happened in the > database/instance. So log switches will be in there, database shutdown and > startup messages, errors dealing with the infrastructure of the database > (failure to extend a rollback segment, failure to get space in the temp > segment, disasterous database errors etc) There are other messages as well, > I'm not going to list every one. > > Bdump contains trace files that relate to the Oracle background process -- > anything generated by smon, pmon, etc > > Udump contains trace files that relate to specific user Oracle processes > > Cdump contains core dumps, associated with one or another trace files in the > bdump directory. > > Rachel > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: cdump, bdump, udump > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > >Hi all, > > > >When those logs will created ? > > > >Thank you > > > >Sinardy > > > > > >-Original Message- > >Sent: Tuesday, 24 April 2001 9:41 AM > >To: LazyDBA mailing list > > > > > >Hi DBAs and SAs, > > > >I had a task to do housekeep ...\bdump\alertSID.log > >What logs usually Oracle system need to housekeep, and what are these > >directory > > cdump, > > bdump and > > udump > >for ? > > > > > >Thank you for your time > > > >Sinardy > > > > > > > > > >Think you know someone who can answer the above question? Forward it to > >them! > >to unsubscribe, send a blank email to [EMAIL PROTECTED] > >to subscribe send a blank email to [EMAIL PROTECTED] > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > >Tell yer mates about http://www.farAwayJobs.com > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Sinardy Xing > > 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). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel
Re: cdump, bdump, udump
The space is freed when the process accessing the file ends. In the case of the alert.log, it is accessed infrequently. The listener.log is constantly being updated on an active database and may not release as quickly. There are Unix commands which will show the pid accessing each file, including those supposedly deleted, but it has been a long time since I was a sys admin. Maybe one of the listers has the command. Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] On Tue, 15 May 2001, Terry Ball wrote: > On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and > space has immediately become free. (Not true with the listener.log however). > > Terry > > "Rao, Maheswara" wrote: > > > Ron, > > > > You would not be able free the disk space even if alert.log is deleted. For > > example, if alert.log file size is 500 MB size and then you delete the > > alert.log, still you would not be able to get a disk free space of 500 MB. > > This space would be released once you bounce the database. > > > > The above scenario is similar even if you copy alert.log to a different > > location and then delete the rows. > > > > The above scenario applies to Solaris environment. I do not know what > > happens in NT environment. > > > > Rao > > > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Wednesday, April 25, 2001 10:39 AM > > To: Multiple recipients of list ORACLE-L > > > > Team, > > Correct me if I am wrong, please.. If you delete the alert.log file with the > > database up and running, the oracle still thinks the file exists and writes > > to a non existant file that you can't "see". The proper method of reducing > > the file size is to copy the file to a backup location, and edit the > > original and delete rows from the file. OR if you do not need to keep the > > original log for analysis you could copu /dev/null > alert.log. > > Just a house keeping note. > > ROR mª¿ªm > > > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > > Sinardy, > > > > First, I suggest you find some time and sit down and READ the Oracle > > documentation. Otherwise you are going to get a large number of "RTFM" > > emails, and some flaming as well. > > > > Now.. the alert log is created (if it does not already exist) or written to > > every time Oracle wants to record an event that has happened in the > > database/instance. So log switches will be in there, database shutdown and > > startup messages, errors dealing with the infrastructure of the database > > (failure to extend a rollback segment, failure to get space in the temp > > segment, disasterous database errors etc) There are other messages as well, > > I'm not going to list every one. > > > > Bdump contains trace files that relate to the Oracle background process -- > > anything generated by smon, pmon, etc > > > > Udump contains trace files that relate to specific user Oracle processes > > > > Cdump contains core dumps, associated with one or another trace files in the > > bdump directory. > > > > Rachel > > > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: RE: cdump, bdump, udump > > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > > > >Hi all, > > > > > >When those logs will created ? > > > > > >Thank you > > > > > >Sinardy > > > > > > > > >-Original Message- > > >Sent: Tuesday, 24 April 2001 9:41 AM > > >To: LazyDBA mailing list > > > > > > > > >Hi DBAs and SAs, > > > > > >I had a task to do housekeep ...\bdump\alertSID.log > > >What logs usually Oracle system need to housekeep, and what are these > > >directory > > > cdump, > > > bdump and > > > udump > > >for ? > > > > > > > > >Thank you for your time > > > > > >Sinardy > > > > > > > > > > > > > > >Think you know someone who can answer the above question? Forward it to > > >them! > > >to unsubscribe, send a blank email to [EMAIL PROTECTED] > > >to subscribe send a blank email to [EMAIL PROTECTED] > > >Visit the list arch
RE: cdump, bdump, udump
Terry, I tested this again now. I removed alert.log and then checked disk usage. It did not release the disk space. Then I bounced the db. Now, the disk space is released. Environment: Solaris 7, 64 bit. Oracle 817. Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 12:36 PM To: Multiple recipients of list ORACLE-L On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and space has immediately become free. (Not true with the listener.log however). Terry "Rao, Maheswara" wrote: > Ron, > > You would not be able free the disk space even if alert.log is deleted. For > example, if alert.log file size is 500 MB size and then you delete the > alert.log, still you would not be able to get a disk free space of 500 MB. > This space would be released once you bounce the database. > > The above scenario is similar even if you copy alert.log to a different > location and then delete the rows. > > The above scenario applies to Solaris environment. I do not know what > happens in NT environment. > > Rao > > [EMAIL PROTECTED] > > -Original Message- > Sent: Wednesday, April 25, 2001 10:39 AM > To: Multiple recipients of list ORACLE-L > > Team, > Correct me if I am wrong, please.. If you delete the alert.log file with the > database up and running, the oracle still thinks the file exists and writes > to a non existant file that you can't "see". The proper method of reducing > the file size is to copy the file to a backup location, and edit the > original and delete rows from the file. OR if you do not need to keep the > original log for analysis you could copu /dev/null > alert.log. > Just a house keeping note. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > Sinardy, > > First, I suggest you find some time and sit down and READ the Oracle > documentation. Otherwise you are going to get a large number of "RTFM" > emails, and some flaming as well. > > Now.. the alert log is created (if it does not already exist) or written to > every time Oracle wants to record an event that has happened in the > database/instance. So log switches will be in there, database shutdown and > startup messages, errors dealing with the infrastructure of the database > (failure to extend a rollback segment, failure to get space in the temp > segment, disasterous database errors etc) There are other messages as well, > I'm not going to list every one. > > Bdump contains trace files that relate to the Oracle background process -- > anything generated by smon, pmon, etc > > Udump contains trace files that relate to specific user Oracle processes > > Cdump contains core dumps, associated with one or another trace files in the > bdump directory. > > Rachel > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: cdump, bdump, udump > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > >Hi all, > > > >When those logs will created ? > > > >Thank you > > > >Sinardy > > > > > >-Original Message- > >Sent: Tuesday, 24 April 2001 9:41 AM > >To: LazyDBA mailing list > > > > > >Hi DBAs and SAs, > > > >I had a task to do housekeep ...\bdump\alertSID.log > >What logs usually Oracle system need to housekeep, and what are these > >directory > > cdump, > > bdump and > > udump > >for ? > > > > > >Thank you for your time > > > >Sinardy > > > > > > > > > >Think you know someone who can answer the above question? Forward it to > >them! > >to unsubscribe, send a blank email to [EMAIL PROTECTED] > >to subscribe send a blank email to [EMAIL PROTECTED] > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > >Tell yer mates about http://www.farAwayJobs.com > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Sinardy Xing > > 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 rem
Re: cdump, bdump, udump
On Tuesday 15 May 2001 11:36, Thater, William wrote: > On Tue, 15 May 2001,Peter Barnett scribbled on the wall in glitter crayon: > > ->There are Unix commands which will show the pid accessing each file, > ->including those supposedly deleted, but it has been a long time since I > ->was a sys admin. Maybe one of the listers has the command. > > Man fuser That sounds supiciously like some type of alien equipment issued as standard equipment to Earth bound ships. ;) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
Re: cdump, bdump, udump
On Tue, 15 May 2001,Peter Barnett scribbled on the wall in glitter crayon: ->There are Unix commands which will show the pid accessing each file, ->including those supposedly deleted, but it has been a long time since I ->was a sys admin. Maybe one of the listers has the command. Man fuser -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Random access is the optimum of the mass storages. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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).
Re: cdump, bdump, udump
Do you have frequest writes to your alert log? If you try to remove will it is being written to, it will not release the space. We tend to remove our logs during periods of low acitivity, so the file is not likely to be being written to. So we have not seen the space not released. Terry "Rao, Maheswara" wrote: > Terry, > > I tested this again now. I removed alert.log and then checked disk usage. > It did not release the disk space. Then I bounced the db. Now, the disk > space is released. > > Environment: Solaris 7, 64 bit. Oracle 817. > > Rao > > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, May 15, 2001 12:36 PM > To: Multiple recipients of list ORACLE-L > > On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log > and > space has immediately become free. (Not true with the listener.log > however). > > Terry > > "Rao, Maheswara" wrote: > > > Ron, > > > > You would not be able free the disk space even if alert.log is deleted. > For > > example, if alert.log file size is 500 MB size and then you delete the > > alert.log, still you would not be able to get a disk free space of 500 MB. > > This space would be released once you bounce the database. > > > > The above scenario is similar even if you copy alert.log to a different > > location and then delete the rows. > > > > The above scenario applies to Solaris environment. I do not know what > > happens in NT environment. > > > > Rao > > > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Wednesday, April 25, 2001 10:39 AM > > To: Multiple recipients of list ORACLE-L > > > > Team, > > Correct me if I am wrong, please.. If you delete the alert.log file with > the > > database up and running, the oracle still thinks the file exists and > writes > > to a non existant file that you can't "see". The proper method of reducing > > the file size is to copy the file to a backup location, and edit the > > original and delete rows from the file. OR if you do not need to keep the > > original log for analysis you could copu /dev/null > alert.log. > > Just a house keeping note. > > ROR mª¿ªm > > > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > > Sinardy, > > > > First, I suggest you find some time and sit down and READ the Oracle > > documentation. Otherwise you are going to get a large number of "RTFM" > > emails, and some flaming as well. > > > > Now.. the alert log is created (if it does not already exist) or written > to > > every time Oracle wants to record an event that has happened in the > > database/instance. So log switches will be in there, database shutdown and > > startup messages, errors dealing with the infrastructure of the database > > (failure to extend a rollback segment, failure to get space in the temp > > segment, disasterous database errors etc) There are other messages as > well, > > I'm not going to list every one. > > > > Bdump contains trace files that relate to the Oracle background process -- > > anything generated by smon, pmon, etc > > > > Udump contains trace files that relate to specific user Oracle processes > > > > Cdump contains core dumps, associated with one or another trace files in > the > > bdump directory. > > > > Rachel > > > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: RE: cdump, bdump, udump > > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > > > >Hi all, > > > > > >When those logs will created ? > > > > > >Thank you > > > > > >Sinardy > > > > > > > > >-Original Message- > > >Sent: Tuesday, 24 April 2001 9:41 AM > > >To: LazyDBA mailing list > > > > > > > > >Hi DBAs and SAs, > > > > > >I had a task to do housekeep ...\bdump\alertSID.log > > >What logs usually Oracle system need to housekeep, and what are these > > >directory > > > cdump, > > > bdump and > > > udump > > >for ? > > > > > > > > >Thank you for your time > > > > > >Sinardy > > > > > > > > > > > > > > >Think you know someone who can answer the above question? Forward it to > > >them! > > &g
RE: cdump, bdump, udump
1. Space occupied by alert.log is freed once you delete the file. 2. You may not see an immediate reclamation of free space. Try to do sync ( In solaris) and notice the free space. Also, try more than one method of free space checking - Using du, bdf, sam or sysadmin tools. -Original Message- From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:50 PM To: Multiple recipients of list ORACLE-L Subject:RE: cdump, bdump, udump Terry, I tested this again now. I removed alert.log and then checked disk usage. It did not release the disk space. Then I bounced the db. Now, the disk space is released. Environment: Solaris 7, 64 bit. Oracle 817. Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 12:36 PM To: Multiple recipients of list ORACLE-L On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and space has immediately become free. (Not true with the listener.log however). Terry "Rao, Maheswara" wrote: > Ron, > > You would not be able free the disk space even if alert.log is deleted. For > example, if alert.log file size is 500 MB size and then you delete the > alert.log, still you would not be able to get a disk free space of 500 MB. > This space would be released once you bounce the database. > > The above scenario is similar even if you copy alert.log to a different > location and then delete the rows. > > The above scenario applies to Solaris environment. I do not know what > happens in NT environment. > > Rao > > [EMAIL PROTECTED] > > -Original Message- > Sent: Wednesday, April 25, 2001 10:39 AM > To: Multiple recipients of list ORACLE-L > > Team, > Correct me if I am wrong, please.. If you delete the alert.log file with the > database up and running, the oracle still thinks the file exists and writes > to a non existant file that you can't "see". The proper method of reducing > the file size is to copy the file to a backup location, and edit the > original and delete rows from the file. OR if you do not need to keep the > original log for analysis you could copu /dev/null > alert.log. > Just a house keeping note. > ROR ma?am > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > Sinardy, > > First, I suggest you find some time and sit down and READ the Oracle > documentation. Otherwise you are going to get a large number of "RTFM" > emails, and some flaming as well. > > Now.. the alert log is created (if it does not already exist) or written to > every time Oracle wants to record an event that has happened in the > database/instance. So log switches will be in there, database shutdown and > startup messages, errors dealing with the infrastructure of the database > (failure to extend a rollback segment, failure to get space in the temp > segment, disasterous database errors etc) There are other messages as well, > I'm not going to list every one. > > Bdump contains trace files that relate to the Oracle background process -- > anything generated by smon, pmon, etc > > Udump contains trace files that relate to specific user Oracle processes > > Cdump contains core dumps, associated with one or another trace files in the > bdump directory. > > Rachel > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: cdump, bdump, udump > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > >Hi all, > > > >When those logs will created ? > > > >Thank you > > > >Sinardy > > > > > >-Original Message- > >Sent: Tuesday, 24 April 2001 9:41 AM > >To: LazyDBA mailing list > > > > > >Hi DBAs and SAs, > > > >I had a task to do housekeep ...\bdump\alertSID.log > >What logs usually Oracle system need to housekeep, and what are these > >directory > > cdump, > > bdump and > > udump > >for ? > > NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram 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).
RE: cdump, bdump, udump
OK. I would test this. scheduled a cron to run in the night to remove alert.log (of course after copying!!). Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Do you have frequest writes to your alert log? If you try to remove will it is being written to, it will not release the space. We tend to remove our logs during periods of low acitivity, so the file is not likely to be being written to. So we have not seen the space not released. Terry "Rao, Maheswara" wrote: > Terry, > > I tested this again now. I removed alert.log and then checked disk usage. > It did not release the disk space. Then I bounced the db. Now, the disk > space is released. > > Environment: Solaris 7, 64 bit. Oracle 817. > > Rao > > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, May 15, 2001 12:36 PM > To: Multiple recipients of list ORACLE-L > > On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log > and > space has immediately become free. (Not true with the listener.log > however). > > Terry > > "Rao, Maheswara" wrote: > > > Ron, > > > > You would not be able free the disk space even if alert.log is deleted. > For > > example, if alert.log file size is 500 MB size and then you delete the > > alert.log, still you would not be able to get a disk free space of 500 MB. > > This space would be released once you bounce the database. > > > > The above scenario is similar even if you copy alert.log to a different > > location and then delete the rows. > > > > The above scenario applies to Solaris environment. I do not know what > > happens in NT environment. > > > > Rao > > > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Wednesday, April 25, 2001 10:39 AM > > To: Multiple recipients of list ORACLE-L > > > > Team, > > Correct me if I am wrong, please.. If you delete the alert.log file with > the > > database up and running, the oracle still thinks the file exists and > writes > > to a non existant file that you can't "see". The proper method of reducing > > the file size is to copy the file to a backup location, and edit the > > original and delete rows from the file. OR if you do not need to keep the > > original log for analysis you could copu /dev/null > alert.log. > > Just a house keeping note. > > ROR mª¿ªm > > > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > > Sinardy, > > > > First, I suggest you find some time and sit down and READ the Oracle > > documentation. Otherwise you are going to get a large number of "RTFM" > > emails, and some flaming as well. > > > > Now.. the alert log is created (if it does not already exist) or written > to > > every time Oracle wants to record an event that has happened in the > > database/instance. So log switches will be in there, database shutdown and > > startup messages, errors dealing with the infrastructure of the database > > (failure to extend a rollback segment, failure to get space in the temp > > segment, disasterous database errors etc) There are other messages as > well, > > I'm not going to list every one. > > > > Bdump contains trace files that relate to the Oracle background process -- > > anything generated by smon, pmon, etc > > > > Udump contains trace files that relate to specific user Oracle processes > > > > Cdump contains core dumps, associated with one or another trace files in > the > > bdump directory. > > > > Rachel > > > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: RE: cdump, bdump, udump > > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > > > >Hi all, > > > > > >When those logs will created ? > > > > > >Thank you > > > > > >Sinardy > > > > > > > > >-Original Message- > > >Sent: Tuesday, 24 April 2001 9:41 AM > > >To: LazyDBA mailing list > > > > > > > > >Hi DBAs and SAs, > > > > > >I had a task to do housekeep ...\bdump\alertSID.log > > >What logs usually Oracle system need to housekeep, and what are these > > >directory > > > cdump, > > > bdump and > > > udump > > >for ? > > > > > > > > >Thank
RE: cdump, bdump, udump
Rao, I didnt follow this thread from the beginnig, but if you primary task is to release disk space, try echo > alert.log (or cat /dev/null > listener.log) instead of rm. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, May 15, 2001 2:50 PM To: Multiple recipients of list ORACLE-L Terry, I tested this again now. I removed alert.log and then checked disk usage. It did not release the disk space. Then I bounced the db. Now, the disk space is released. Environment: Solaris 7, 64 bit. Oracle 817. Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 12:36 PM To: Multiple recipients of list ORACLE-L On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and space has immediately become free. (Not true with the listener.log however). Terry "Rao, Maheswara" wrote: > Ron, > > You would not be able free the disk space even if alert.log is deleted. For > example, if alert.log file size is 500 MB size and then you delete the > alert.log, still you would not be able to get a disk free space of 500 MB. > This space would be released once you bounce the database. > > The above scenario is similar even if you copy alert.log to a different > location and then delete the rows. > > The above scenario applies to Solaris environment. I do not know what > happens in NT environment. > > Rao > > [EMAIL PROTECTED] > > -Original Message- > Sent: Wednesday, April 25, 2001 10:39 AM > To: Multiple recipients of list ORACLE-L > > Team, > Correct me if I am wrong, please.. If you delete the alert.log file with the > database up and running, the oracle still thinks the file exists and writes > to a non existant file that you can't "see". The proper method of reducing > the file size is to copy the file to a backup location, and edit the > original and delete rows from the file. OR if you do not need to keep the > original log for analysis you could copu /dev/null > alert.log. > Just a house keeping note. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > Sinardy, > > First, I suggest you find some time and sit down and READ the Oracle > documentation. Otherwise you are going to get a large number of "RTFM" > emails, and some flaming as well. > > Now.. the alert log is created (if it does not already exist) or written to > every time Oracle wants to record an event that has happened in the > database/instance. So log switches will be in there, database shutdown and > startup messages, errors dealing with the infrastructure of the database > (failure to extend a rollback segment, failure to get space in the temp > segment, disasterous database errors etc) There are other messages as well, > I'm not going to list every one. > > Bdump contains trace files that relate to the Oracle background process -- > anything generated by smon, pmon, etc > > Udump contains trace files that relate to specific user Oracle processes > > Cdump contains core dumps, associated with one or another trace files in the > bdump directory. > > Rachel > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: cdump, bdump, udump > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > >Hi all, > > > >When those logs will created ? > > > >Thank you > > > >Sinardy > > > > > >-Original Message- > >Sent: Tuesday, 24 April 2001 9:41 AM > >To: LazyDBA mailing list > > > > > >Hi DBAs and SAs, > > > >I had a task to do housekeep ...\bdump\alertSID.log > >What logs usually Oracle system need to housekeep, and what are these > >directory > > cdump, > > bdump and > > udump > >for ? > > > > > >Thank you for your time > > > >Sinardy > > > > > > > > > >Think you know someone who can answer the above question? Forward it to > >them! > >to unsubscribe, send a blank email to [EMAIL PROTECTED] > >to subscribe send a blank email to [EMAIL PROTECTED] > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > >Tell yer mates about http://www.farAwayJobs.com > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Sinardy Xing > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California-- Public Internet access / Mailing Lists > >---
Re: cdump, bdump, udump
On Tue, 15 May 2001,Jared Still scribbled on the wall in glitter crayon: ->On Tuesday 15 May 2001 11:36, Thater, William wrote: ->> On Tue, 15 May 2001,Peter Barnett scribbled on the wall in glitter crayon: ->> ->> ->There are Unix commands which will show the pid accessing each file, ->> ->including those supposedly deleted, but it has been a long time since I ->> ->was a sys admin. Maybe one of the listers has the command. ->> ->> Man fuser -> ->That sounds supiciously like some type of alien equipment issued as ->standard equipment to Earth bound ships. ;) -> ->Jared -> Ah, you're on to my secret. I'm really an alien or is that really alien?;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Random access is the optimum of the mass storages. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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).
RE: cdump, bdump, udump
Look like this message did not get thru.. sending again. Pl. Ignore if repeat 1. Space occupied by alert.log is freed once you delete the file. 2. You may not see an immediate reclamation of free space. Try to do sync ( In solaris) and notice the free space. Also, try more than one method of free space checking - Using du, bdf, sam or sysadmin tools. -Original Message- From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 2:50 PM To: Multiple recipients of list ORACLE-L Subject:RE: cdump, bdump, udump Terry, I tested this again now. I removed alert.log and then checked disk usage. It did not release the disk space. Then I bounced the db. Now, the disk space is released. Environment: Solaris 7, 64 bit. Oracle 817. Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 12:36 PM To: Multiple recipients of list ORACLE-L On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and space has immediately become free. (Not true with the listener.log however). Terry "Rao, Maheswara" wrote: > Ron, > > You would not be able free the disk space even if alert.log is deleted. For > example, if alert.log file size is 500 MB size and then you delete the > alert.log, still you would not be able to get a disk free space of 500 MB. > This space would be released once you bounce the database. > > The above scenario is similar even if you copy alert.log to a different > location and then delete the rows. > > The above scenario applies to Solaris environment. I do not know what > happens in NT environment. > > Rao > > [EMAIL PROTECTED] > > -Original Message- > Sent: Wednesday, April 25, 2001 10:39 AM > To: Multiple recipients of list ORACLE-L > > Team, > Correct me if I am wrong, please.. If you delete the alert.log file with the > database up and running, the oracle still thinks the file exists and writes > to a non existant file that you can't "see". The proper method of reducing > the file size is to copy the file to a backup location, and edit the > original and delete rows from the file. OR if you do not need to keep the > original log for analysis you could copu /dev/null > alert.log. > Just a house keeping note. > ROR ma?am > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > Sinardy, > > First, I suggest you find some time and sit down and READ the Oracle > documentation. Otherwise you are going to get a large number of "RTFM" > emails, and some flaming as well. > > Now.. the alert log is created (if it does not already exist) or written to > every time Oracle wants to record an event that has happened in the > database/instance. So log switches will be in there, database shutdown and > startup messages, errors dealing with the infrastructure of the database > (failure to extend a rollback segment, failure to get space in the temp > segment, disasterous database errors etc) There are other messages as well, > I'm not going to list every one. > > Bdump contains trace files that relate to the Oracle background process -- > anything generated by smon, pmon, etc > > Udump contains trace files that relate to specific user Oracle processes > > Cdump contains core dumps, associated with one or another trace files in the > bdump directory. > > Rachel > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: cdump, bdump, udump > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > >Hi all, > > > >When those logs will created ? > > > >Thank you > > > >Sinardy > > > > > >-Original Message- > >Sent: Tuesday, 24 April 2001 9:41 AM > >To: LazyDBA mailing list > > > > > >Hi DBAs and SAs, > > > >I had a task to do housekeep ...\bdump\alertSID.log > >What logs usually Oracle system need to housekeep, and what are these > >directory > > cdump, > > bdump and > > udump > >for ? > > NetZero Platinum No Banner Ads and Unlimited Access Sign Up Today - Only $9.95 per month! http://www.netzero.net -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajaram 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).
RE: cdump, bdump, udump
I tried the 'alien' weapon - fuser - against the alert.log file. There are 18 oracle processes accessing it. A simple rm will delete the file handle but apparently not actually release the space without bouncing the database. Lesson learned. And, that's my limit for today. Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] On Tue, 15 May 2001, Rajaram wrote: > Look like this message did not get thru.. sending again. Pl. Ignore if > repeat > > > 1. Space occupied by alert.log is freed once you delete the file. > > 2. You may not see an immediate reclamation of free space. Try to do sync ( > In solaris) and notice the free space. Also, try more than one method of > free space checking - Using du, bdf, sam or sysadmin tools. > > > > -Original Message- > From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, May 15, 2001 2:50 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: cdump, bdump, udump > > Terry, > > I tested this again now. I removed alert.log and then checked disk usage. > It did not release the disk space. Then I bounced the db. Now, the disk > space is released. > > Environment: Solaris 7, 64 bit. Oracle 817. > > Rao > > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, May 15, 2001 12:36 PM > To: Multiple recipients of list ORACLE-L > > On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log > and > space has immediately become free. (Not true with the listener.log > however). > > Terry > > "Rao, Maheswara" wrote: > > > Ron, > > > > You would not be able free the disk space even if alert.log is deleted. > For > > example, if alert.log file size is 500 MB size and then you delete the > > alert.log, still you would not be able to get a disk free space of 500 > MB. > > This space would be released once you bounce the database. > > > > The above scenario is similar even if you copy alert.log to a different > > location and then delete the rows. > > > > The above scenario applies to Solaris environment. I do not know what > > happens in NT environment. > > > > Rao > > > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Wednesday, April 25, 2001 10:39 AM > > To: Multiple recipients of list ORACLE-L > > > > Team, > > Correct me if I am wrong, please.. If you delete the alert.log file with > the > > database up and running, the oracle still thinks the file exists and > writes > > to a non existant file that you can't "see". The proper method of > reducing > > the file size is to copy the file to a backup location, and edit the > > original and delete rows from the file. OR if you do not need to keep the > > original log for analysis you could copu /dev/null > alert.log. > > Just a house keeping note. > > ROR ma?am > > > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > > Sinardy, > > > > First, I suggest you find some time and sit down and READ the Oracle > > documentation. Otherwise you are going to get a large number of "RTFM" > > emails, and some flaming as well. > > > > Now.. the alert log is created (if it does not already exist) or written > to > > every time Oracle wants to record an event that has happened in the > > database/instance. So log switches will be in there, database shutdown > and > > startup messages, errors dealing with the infrastructure of the database > > (failure to extend a rollback segment, failure to get space in the temp > > segment, disasterous database errors etc) There are other messages as > well, > > I'm not going to list every one. > > > > Bdump contains trace files that relate to the Oracle background process > -- > > anything generated by smon, pmon, etc > > > > Udump contains trace files that relate to specific user Oracle processes > > > > Cdump contains core dumps, associated with one or another trace files in > the > > bdump directory. > > > > Rachel > > > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > > >Reply-To: [EMAIL PROTECTED] > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > >Subject: RE: cdump, bdump, udump > > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > > > >Hi all, > > > > > >When those logs will created ? > > > > > >Thank you > > > > > >Sinardy > > > > > >
RE: cdump, bdump, udump
I also monitored the processes and found that alert.log file is constantly accessed at least by one Oracle process during a period of one hour continuous monitoring. Hence, my conclusions: 1. By removing alert.log, the space would not be reclaimed by the disk on Unix machines immediately until you bounce the db. 2. Perhaps, on rare occasions, the space is reclaimed by the disk without bouncing the db. But this, in my opinion, is a rarity. Thanks, Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 7:46 PM To: Multiple recipients of list ORACLE-L I tried the 'alien' weapon - fuser - against the alert.log file. There are 18 oracle processes accessing it. A simple rm will delete the file handle but apparently not actually release the space without bouncing the database. Lesson learned. And, that's my limit for today. Pete Barnett Oracle Database Administrator Regence BlueCross BlueShield [EMAIL PROTECTED] On Tue, 15 May 2001, Rajaram wrote: > Look like this message did not get thru.. sending again. Pl. Ignore if > repeat > > > 1. Space occupied by alert.log is freed once you delete the file. > > 2. You may not see an immediate reclamation of free space. Try to do sync ( > In solaris) and notice the free space. Also, try more than one method of > free space checking - Using du, bdf, sam or sysadmin tools. > > > > -Original Message- > From: Rao, Maheswara [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, May 15, 2001 2:50 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: cdump, bdump, udump > > Terry, > > I tested this again now. I removed alert.log and then checked disk usage. > It did not release the disk space. Then I bounced the db. Now, the disk > space is released. > > Environment: Solaris 7, 64 bit. Oracle 817. > > Rao > > [EMAIL PROTECTED] > > -Original Message- > Sent: Tuesday, May 15, 2001 12:36 PM > To: Multiple recipients of list ORACLE-L > > On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log > and > space has immediately become free. (Not true with the listener.log > however). > > Terry > > "Rao, Maheswara" wrote: > > > Ron, > > > > You would not be able free the disk space even if alert.log is deleted. > For > > example, if alert.log file size is 500 MB size and then you delete the > > alert.log, still you would not be able to get a disk free space of 500 > MB. > > This space would be released once you bounce the database. > > > > The above scenario is similar even if you copy alert.log to a different > > location and then delete the rows. > > > > The above scenario applies to Solaris environment. I do not know what > > happens in NT environment. > > > > Rao > > > > [EMAIL PROTECTED] > > > > -Original Message- > > Sent: Wednesday, April 25, 2001 10:39 AM > > To: Multiple recipients of list ORACLE-L > > > > Team, > > Correct me if I am wrong, please.. If you delete the alert.log file with > the > > database up and running, the oracle still thinks the file exists and > writes > > to a non existant file that you can't "see". The proper method of > reducing > > the file size is to copy the file to a backup location, and edit the > > original and delete rows from the file. OR if you do not need to keep the > > original log for analysis you could copu /dev/null > alert.log. > > Just a house keeping note. > > ROR ma?am > > > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > > Sinardy, > > > > First, I suggest you find some time and sit down and READ the Oracle > > documentation. Otherwise you are going to get a large number of "RTFM" > > emails, and some flaming as well. > > > > Now.. the alert log is created (if it does not already exist) or written > to > > every time Oracle wants to record an event that has happened in the > > database/instance. So log switches will be in there, database shutdown > and > > startup messages, errors dealing with the infrastructure of the database > > (failure to extend a rollback segment, failure to get space in the temp > > segment, disasterous database errors etc) There are other messages as > well, > > I'm not going to list every one. > > > > Bdump contains trace files that relate to the Oracle background process > -- > > anything generated by smon, pmon, etc > > > > Udump contains trace files that relate to specific user Oracle processes > > > > Cdump contains core dumps, associated with one or another trace files in > the
Re: cdump, bdump, udump
Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA? Check your init.ora file and check out OTN /*+ SEARCH ON OFA */ David A. Barbour Oracle DBA Sinardy Xing wrote: > > Hi DBAs and SAs, > > I had a task to do housekeep ...\bdump\alertSID.log > What logs usually Oracle system need to housekeep, and what are these > directory > cdump, > bdump and > udump > for ? > > Thank you for your time > > Sinardy > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy Xing > 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: David A. Barbour 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).
RE: cdump, bdump, udump
Thank You -Original Message- Barbour Sent: Tuesday, 24 April 2001 12:40 PM To: Multiple recipients of list ORACLE-L Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA? Check your init.ora file and check out OTN /*+ SEARCH ON OFA */ David A. Barbour Oracle DBA Sinardy Xing wrote: > > Hi DBAs and SAs, > > I had a task to do housekeep ...\bdump\alertSID.log > What logs usually Oracle system need to housekeep, and what are these > directory > cdump, > bdump and > udump > for ? > > Thank you for your time > > Sinardy > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy Xing > 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: David A. Barbour 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: Sinardy Xing 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).
RE: cdump, bdump, udump
Title: RE: cdump, bdump, udump Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer. I want to know what are the advantages we get on this and what are the steps to implement this? Any help is grateful... Rgd Venkat DBA.
RE: cdump, bdump, udump
Hi all, When those logs will created ? Thank you Sinardy -Original Message- Sent: Tuesday, 24 April 2001 9:41 AM To: LazyDBA mailing list Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your time Sinardy Think you know someone who can answer the above question? Forward it to them! to unsubscribe, send a blank email to [EMAIL PROTECTED] to subscribe send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing 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).
Re: cdump, bdump, udump
read the tuning guide and the administrators guide. nowadays this is a valid answer now that oracle docs are online, NO ONE HAS AN EXCUSE to not read the docs unlike back in the days when you had to pay thousands of dollars for paper docs. joe > Venkat_Kalepalli wrote: > > Hello folks! > > I am working in SUN solaris 5.6 with Oracle 8i. I want to implement > MTS on the Oracle server. Next we are running with Rule based > optimizer and we want to change to costbased optimizer. > > I want to know what are the advantages we get on this and what are the > steps to implement this? > > Any help is grateful... > > Rgd > Venkat > DBA. -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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).
Re: cdump, bdump, udump
read the administrators documentation, have a nice day. hahahahaha, joe Sinardy Xing wrote: > > Hi DBAs and SAs, > > I had a task to do housekeep ...\bdump\alertSID.log > What logs usually Oracle system need to housekeep, and what are these > directory > cdump, > bdump and > udump > for ? > > Thank you for your time > > Sinardy > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy Xing > 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). -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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).
RE: cdump, bdump, udump
I must be 'old' because I miss my paper docs. I still print out some of the pdf docs, must be a confort thing! Mike The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed. > -Original Message- > From: Joseph S. Testa [SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, April 24, 2001 8:50 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: cdump, bdump, udump > > read the tuning guide and the administrators guide. > > nowadays this is a valid answer now that oracle docs are online, NO ONE > HAS AN EXCUSE to not read the docs unlike back in the days when you had > to pay thousands of dollars for paper docs. > > joe > > Venkat_Kalepalli wrote: > > > > Hello folks! > > > > I am working in SUN solaris 5.6 with Oracle 8i. I want to implement > > MTS on the Oracle server. Next we are running with Rule based > > optimizer and we want to change to costbased optimizer. > > > > I want to know what are the advantages we get on this and what are the > > steps to implement this? > > > > Any help is grateful... > > > > Rgd > > Venkat > > DBA. > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask :) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > 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: Lanteigne, Mike 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).
RE: cdump, bdump, udump
Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of "RTFM" emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel >From: "Sinardy Xing" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: cdump, bdump, udump >Date: Tue, 24 Apr 2001 03:40:27 -0800 > >Hi all, > >When those logs will created ? > >Thank you > >Sinardy > > >-Original Message- >Sent: Tuesday, 24 April 2001 9:41 AM >To: LazyDBA mailing list > > >Hi DBAs and SAs, > >I had a task to do housekeep ...\bdump\alertSID.log >What logs usually Oracle system need to housekeep, and what are these >directory > cdump, > bdump and > udump >for ? > > >Thank you for your time > >Sinardy > > > > >Think you know someone who can answer the above question? Forward it to >them! >to unsubscribe, send a blank email to [EMAIL PROTECTED] >to subscribe send a blank email to [EMAIL PROTECTED] >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl >Tell yer mates about http://www.farAwayJobs.com > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sinardy Xing > 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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).
Re: cdump, bdump, udump
Sinardy, Some logs are generated by default (alert_.log) but actions triggering entries can be adjusted through either initialization parameters in the init.ora file, via commands issued by the DBA, or by users who have been granted specific privileges/roles (commands like ALTER DATABASE, ALTER SESSION and the dbms_trace package come to mind here). If you were able to get the doc on OFA, you now need to go and get the docs on Initialization Parameters and Oracle Supplied Packages as a minimum. Regards, David A. Barbour Oracle DBA Sinardy Xing wrote: > > Hi all, > > When those logs will created ? > > Thank you > > Sinardy > > -Original Message- > Sent: Tuesday, 24 April 2001 9:41 AM > To: LazyDBA mailing list > > Hi DBAs and SAs, > > I had a task to do housekeep ...\bdump\alertSID.log > What logs usually Oracle system need to housekeep, and what are these > directory > cdump, > bdump and > udump > for ? > > Thank you for your time > > Sinardy > > > Think you know someone who can answer the above question? Forward it to > them! > to unsubscribe, send a blank email to [EMAIL PROTECTED] > to subscribe send a blank email to [EMAIL PROTECTED] > Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy Xing > 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: David A. Barbour 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).
RE: cdump, bdump, udump
Wow. I feel just the opposite. When I had the paper docs, I could take one on the train, take it home, know what I read, feel like I'd accomplished something when I'd read a chunk, etc. I had a relationship with the books, my tuning guide had a corner bent, the app dev guide was missing a cover. With this electronic stuff, I can't 'sit down and study', I find its hard to get a feel of what I should read because it all looks and feels the same. I really miss the hard copy docs. My two pence. Yosi > -Original Message- > From: Joseph S. Testa [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 24, 2001 8:50 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: cdump, bdump, udump > > > read the tuning guide and the administrators guide. > > nowadays this is a valid answer now that oracle docs are > online, NO ONE > HAS AN EXCUSE to not read the docs unlike back in the days > when you had > to pay thousands of dollars for paper docs. > > joe > > Venkat_Kalepalli wrote: > > > > Hello folks! > > > > I am working in SUN solaris 5.6 with Oracle 8i. I want to implement > > MTS on the Oracle server. Next we are running with Rule based > > optimizer and we want to change to costbased optimizer. > > > > I want to know what are the advantages we get on this and > what are the > > steps to implement this? > > > > Any help is grateful... > > > > Rgd > > Venkat > > DBA. > > -- > Joe Testa http://www.oracle-dba.com > Performing Remote DBA Services, need some backup DBA support? > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > ask :) > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joseph S. Testa > 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: 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).
RE: cdump, bdump, udump
I'm taking yoga classes and being much happier and less cynical, I'm much less inclined to reply with RTFM, despite the fact that this question more then deserves such an answer. -Original Message- Sent: Tuesday, April 24, 2001 12:40 AM To: Multiple recipients of list ORACLE-L Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA? Check your init.ora file and check out OTN /*+ SEARCH ON OFA */ David A. Barbour Oracle DBA Sinardy Xing wrote: > > Hi DBAs and SAs, > > I had a task to do housekeep ...\bdump\alertSID.log > What logs usually Oracle system need to housekeep, and what are these > directory > cdump, > bdump and > udump > for ? > > Thank you for your time > > Sinardy > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy Xing > 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: David A. Barbour 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: Gogala, Mladen 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).
RE: cdump, bdump, udump
Title: RE: cdump, bdump, udump karma, prana, hatha, or ayurvedic yoga? Most people just think of hatha yoga when they talk about it. Ross p.s. let me know when you can do the "Royal Pigeon" || -Original Message- || From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, April 24, 2001 12:16 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: cdump, bdump, udump || || || I'm taking yoga classes and being much happier and less cynical, I'm || much less inclined to reply with RTFM, despite the fact that this || question more then deserves such an answer. || || -Original Message- || Sent: Tuesday, April 24, 2001 12:40 AM || To: Multiple recipients of list ORACLE-L || || || Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA? || Check your init.ora file and check out OTN /*+ SEARCH ON OFA */ || || David A. Barbour || Oracle DBA || || Sinardy Xing wrote: || > || > Hi DBAs and SAs, || > || > I had a task to do housekeep ...\bdump\alertSID.log || > What logs usually Oracle system need to housekeep, and || what are these || > directory || > cdump, || > bdump and || > udump || > for ? || > || > Thank you for your time || > || > Sinardy || > || > -- || > Please see the official ORACLE-L FAQ: http://www.orafaq.com || > -- || > Author: Sinardy Xing || > 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: David A. Barbour || 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: Gogala, Mladen || 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). ||
RE: cdump, bdump, udump
On Tue, 24 Apr 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon: ->Wow. I feel just the opposite. When I had the paper docs, I could ->take one on the train, take it home, know what I read, feel like ->I'd accomplished something when I'd read a chunk, etc. I had a ->relationship with the books, my tuning guide had a corner bent, the ->app dev guide was missing a cover. -> ->With this electronic stuff, I can't 'sit down and study', I find ->its hard to get a feel of what I should read because it all looks ->and feels the same. -> ->I really miss the hard copy docs. -> ->My two pence. -> ->Yosi maybe someone should convert them to Palm DOC format and we can load them on our Palms to carry with us *everywhere*.;-) -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Stock item: We shipped it once before, and we can do it again, probably. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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).
RE: cdump, bdump, udump
what's wrong with your printer? what's wrong with just spending a bunch of money on hardcopy documentation like you used to do On 24 Apr 2001, at 8:15, [EMAIL PROTECTED] wrote: Date sent: Tue, 24 Apr 2001 08:15:54 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> ... > With this electronic stuff, I can't 'sit down and study', I find > its hard to get a feel of what I should read because it all looks > and feels the same. > > I really miss the hard copy docs. ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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).
RE: cdump, bdump, udump
Oh, my god! I think that I should return to my beloved threadmill -Original Message- Sent: Tuesday, April 24, 2001 2:16 PM To: Multiple recipients of list ORACLE-L karma, prana, hatha, or ayurvedic yoga? Most people just think of hatha yoga when they talk about it. Ross p.s. let me know when you can do the "Royal Pigeon" || -Original Message- || From: Gogala, Mladen [ mailto:[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> ] || Sent: Tuesday, April 24, 2001 12:16 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: cdump, bdump, udump || || || I'm taking yoga classes and being much happier and less cynical, I'm || much less inclined to reply with RTFM, despite the fact that this || question more then deserves such an answer. || || -Original Message- || Sent: Tuesday, April 24, 2001 12:40 AM || To: Multiple recipients of list ORACLE-L || || || Uh oh - here's one for Mladen. Sinardy, have you ever heard of OFA? || Check your init.ora file and check out OTN /*+ SEARCH ON OFA */ || || David A. Barbour || Oracle DBA || || Sinardy Xing wrote: || > || > Hi DBAs and SAs, || > || > I had a task to do housekeep ...\bdump\alertSID.log || > What logs usually Oracle system need to housekeep, and || what are these || > directory || > cdump, || > bdump and || > udump || > for ? || > || > Thank you for your time || > || > Sinardy || > || > -- || > Please see the official ORACLE-L FAQ: http://www.orafaq.com <http://www.orafaq.com> || > -- || > Author: Sinardy Xing || > 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 <http://www.orafaq.com> || -- || Author: David A. Barbour || 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 <http://www.orafaq.com> || -- || Author: Gogala, Mladen || 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: Gogala, Mladen 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).
RE: cdump, bdump, udump
Does everybody else need to wear a really big hat? On 24 Apr 2001, at 10:15, Mohan, Ross wrote: > p.s. let me know when you can do the "Royal Pigeon" ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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).
RE: cdump, bdump, udump
Printer's not the same. I understand this is all ethereal, but it's not the same. I've got a collection of the docs in big black looseleaf binders with a label I printed on the side that says which book it is. It's not as carriable as a smaller book, (try opening one of those on a subway...) and all the books look alike - since all the looseleafs are identical. (Maybe I should get colored looseleafs...) As for buying the books - no way management wants to pay for them any more than Oracle does. And that's probably justifiable. I'll live - I just liked the hardcopy way better. > -Original Message- > From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 24, 2001 2:11 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: cdump, bdump, udump > > > what's wrong with your printer? > > what's wrong with just spending a bunch of money on hardcopy > documentation like you used to do > > > > > On 24 Apr 2001, at 8:15, [EMAIL PROTECTED] wrote: > > Date sent:Tue, 24 Apr 2001 08:15:54 -0800 > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > > ... > > With this electronic stuff, I can't 'sit down and study', I find > > its hard to get a feel of what I should read because it all looks > > and feels the same. > > > > I really miss the hard copy docs. > ... > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eric D. Pierce > 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: 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).
RE: cdump, bdump, udump
Everywhere? Not where I do my heavy reading. Palm pilots are a poor substitute for emergency T.P.8-) >>> [EMAIL PROTECTED] 04/24/01 12:31PM >>> On Tue, 24 Apr 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon: ->Wow. I feel just the opposite. When I had the paper docs, I could ->take one on the train, take it home, know what I read, feel like ->I'd accomplished something when I'd read a chunk, etc. I had a ->relationship with the books, my tuning guide had a corner bent, the ->app dev guide was missing a cover. -> ->With this electronic stuff, I can't 'sit down and study', I find ->its hard to get a feel of what I should read because it all looks ->and feels the same. -> ->I really miss the hard copy docs. -> ->My two pence. -> ->Yosi maybe someone should convert them to Palm DOC format and we can load them on our Palms to carry with us *everywhere*.;-) -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Stock item: We shipped it once before, and we can do it again, probably. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Tim Sawmiller 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).
Re: cdump, bdump, udump
On Tuesday 24 April 2001 09:15, Gogala, Mladen wrote: > I'm taking yoga classes and being much happier and less cynical, I'm > much less inclined to reply with RTFM, despite the fact that this > question more then deserves such an answer. Really? I thought you might engage in a little Greco Roman wrestling to get the aggression out. :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
RE: cdump, bdump, udump
Yeah, as soon as Palm increases the amount of Memory to something like 1GB. ;-) Ed Haskins Oracle DBA Verizon Wireless maybe someone should convert them to Palm DOC format and we can load them on our Palms to carry with us *everywhere*.;-) -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Stock item: We shipped it once before, and we can do it again, probably. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: 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).
RE: cdump, bdump, udump
On Tue, 24 Apr 2001,[EMAIL PROTECTED] scribbled on the wall in...: ->Yeah, as soon as Palm increases the amount of Memory to something like 1GB. -> ->;-) -> ->Ed Haskins ->Oracle DBA ->Verizon Wireless handspring should have a new module out soon with a minidrive, should be about 4GB.;-) -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ I would be very ashamed of my civilization if we did not try to find out if there is life in outer space. - Carl Sagan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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).
RE: cdump, bdump, udump
That is true, Tim. Rest rooms are much more convenient for emergencies then a palm pilot. -Original Message- Sent: Tuesday, April 24, 2001 3:13 PM To: Multiple recipients of list ORACLE-L Everywhere? Not where I do my heavy reading. Palm pilots are a poor substitute for emergency T.P.8-) >>> [EMAIL PROTECTED] 04/24/01 12:31PM >>> On Tue, 24 Apr 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon: ->Wow. I feel just the opposite. When I had the paper docs, I could ->take one on the train, take it home, know what I read, feel like ->I'd accomplished something when I'd read a chunk, etc. I had a ->relationship with the books, my tuning guide had a corner bent, the ->app dev guide was missing a cover. -> ->With this electronic stuff, I can't 'sit down and study', I find ->its hard to get a feel of what I should read because it all looks ->and feels the same. -> ->I really miss the hard copy docs. -> ->My two pence. -> ->Yosi maybe someone should convert them to Palm DOC format and we can load them on our Palms to carry with us *everywhere*.;-) -- Bill Thater Certifieable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ Stock item: We shipped it once before, and we can do it again, probably. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Tim Sawmiller 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: Gogala, Mladen 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).
RE: cdump, bdump, udump
Hi All, Thank you Rachel, David, Christopher and all DBAs and SAs May I know where to find documents that explain all those stuff with some information how managed them I tried ora816 document, but no much info there. It only tells the description, I also read my initSID.ora. Thank you for your time Sinardy -Original Message- Carmichael Sent: Tuesday, 24 April 2001 9:21 PM To: Multiple recipients of list ORACLE-L Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of "RTFM" emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel >From: "Sinardy Xing" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: cdump, bdump, udump >Date: Tue, 24 Apr 2001 03:40:27 -0800 > >Hi all, > >When those logs will created ? > >Thank you > >Sinardy > > >-Original Message- >Sent: Tuesday, 24 April 2001 9:41 AM >To: LazyDBA mailing list > > >Hi DBAs and SAs, > >I had a task to do housekeep ...\bdump\alertSID.log >What logs usually Oracle system need to housekeep, and what are these >directory > cdump, > bdump and > udump >for ? > > >Thank you for your time > >Sinardy > > > > >Think you know someone who can answer the above question? Forward it to >them! >to unsubscribe, send a blank email to [EMAIL PROTECTED] >to subscribe send a blank email to [EMAIL PROTECTED] >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl >Tell yer mates about http://www.farAwayJobs.com > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sinardy Xing > 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Sinardy Xing 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).
Re: cdump, bdump, udump
Sinardy, I don't know if you've got access to Metalink, so why don't you go to the following URL: http://otn.oracle.com/index.html If you click on the membership link at the top right portion of the page, follow the instructions to sign up. It's free, they've never spammed me, and I haven't received any junk mail as a result of giving them the minimal information they request. Once you've signed up, there is a whole host of information and free stuff available, including ALL the documentation we've been talking about here. Hope this helps. David A. Barbour Oracle DBA, OCP Sinardy Xing wrote: > > Hi All, > > Thank you Rachel, David, Christopher and all DBAs and SAs > > May I know where to find documents that explain all those stuff with some > information how managed them > I tried ora816 document, but no much info there. It only tells the > description, I also read my initSID.ora. > > Thank you for your time > > Sinardy > > -Original Message- > Carmichael > Sent: Tuesday, 24 April 2001 9:21 PM > To: Multiple recipients of list ORACLE-L > > Sinardy, > > First, I suggest you find some time and sit down and READ the Oracle > documentation. Otherwise you are going to get a large number of "RTFM" > emails, and some flaming as well. > > Now.. the alert log is created (if it does not already exist) or written to > every time Oracle wants to record an event that has happened in the > database/instance. So log switches will be in there, database shutdown and > startup messages, errors dealing with the infrastructure of the database > (failure to extend a rollback segment, failure to get space in the temp > segment, disasterous database errors etc) There are other messages as well, > I'm not going to list every one. > > Bdump contains trace files that relate to the Oracle background process -- > anything generated by smon, pmon, etc > > Udump contains trace files that relate to specific user Oracle processes > > Cdump contains core dumps, associated with one or another trace files in the > bdump directory. > > Rachel > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: cdump, bdump, udump > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > >Hi all, > > > >When those logs will created ? > > > >Thank you > > > >Sinardy > > > > > >-Original Message- > >Sent: Tuesday, 24 April 2001 9:41 AM > >To: LazyDBA mailing list > > > > > >Hi DBAs and SAs, > > > >I had a task to do housekeep ...\bdump\alertSID.log > >What logs usually Oracle system need to housekeep, and what are these > >directory > > cdump, > > bdump and > > udump > >for ? > > > > > >Thank you for your time > > > >Sinardy > > > > > > > > > >Think you know someone who can answer the above question? Forward it to > >them! > >to unsubscribe, send a blank email to [EMAIL PROTECTED] > >to subscribe send a blank email to [EMAIL PROTECTED] > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > >Tell yer mates about http://www.farAwayJobs.com > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Sinardy Xing > > 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). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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 > t
RE: cdump, bdump, udump
Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't "see". The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null > alert.log. Just a house keeping note. ROR mª¿ªm >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of "RTFM" emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel >From: "Sinardy Xing" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: cdump, bdump, udump >Date: Tue, 24 Apr 2001 03:40:27 -0800 > >Hi all, > >When those logs will created ? > >Thank you > >Sinardy > > >-Original Message- >Sent: Tuesday, 24 April 2001 9:41 AM >To: LazyDBA mailing list > > >Hi DBAs and SAs, > >I had a task to do housekeep ...\bdump\alertSID.log >What logs usually Oracle system need to housekeep, and what are these >directory > cdump, > bdump and > udump >for ? > > >Thank you for your time > >Sinardy > > > > >Think you know someone who can answer the above question? Forward it to >them! >to unsubscribe, send a blank email to [EMAIL PROTECTED] >to subscribe send a blank email to [EMAIL PROTECTED] >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl >Tell yer mates about http://www.farAwayJobs.com > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sinardy Xing > 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Ron Rogers 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).
RE: cdump, bdump, udump
Nope. That's the way the listener.log works, but the alert log will be recreated if deleted or moved. -Original Message- Sent: Wednesday, April 25, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't "see". The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null > alert.log. Just a house keeping note. ROR mª¿ªm >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of "RTFM" emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel >From: "Sinardy Xing" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: cdump, bdump, udump >Date: Tue, 24 Apr 2001 03:40:27 -0800 > >Hi all, > >When those logs will created ? > >Thank you > >Sinardy > > >-Original Message- >Sent: Tuesday, 24 April 2001 9:41 AM >To: LazyDBA mailing list > > >Hi DBAs and SAs, > >I had a task to do housekeep ...\bdump\alertSID.log >What logs usually Oracle system need to housekeep, and what are these >directory > cdump, > bdump and > udump >for ? > > >Thank you for your time > >Sinardy > > > > >Think you know someone who can answer the above question? Forward it to >them! >to unsubscribe, send a blank email to [EMAIL PROTECTED] >to subscribe send a blank email to [EMAIL PROTECTED] >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl >Tell yer mates about http://www.farAwayJobs.com > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sinardy Xing > 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Ron Rogers 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 HE
RE: cdump, bdump, udump
Yep, Oracle just keeps on chugging along. When it needs to write to the alert log it will create a new one if it needs to. On Wed, 25 Apr 2001, Ron Rogers wrote: > Team, > Correct me if I am wrong, please.. If you delete the alert.log file with the >database up and running, the oracle still thinks the file exists and writes to a non >existant file that you can't "see". The proper method of reducing the file size is to >copy the file to a backup location, and edit the original and delete rows from the >file. OR if you do not need to keep the original log for analysis you could copu >/dev/null > alert.log. > Just a house keeping note. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > Sinardy, > > First, I suggest you find some time and sit down and READ the Oracle > documentation. Otherwise you are going to get a large number of "RTFM" > emails, and some flaming as well. > > Now.. the alert log is created (if it does not already exist) or written to > every time Oracle wants to record an event that has happened in the > database/instance. So log switches will be in there, database shutdown and > startup messages, errors dealing with the infrastructure of the database > (failure to extend a rollback segment, failure to get space in the temp > segment, disasterous database errors etc) There are other messages as well, > I'm not going to list every one. > > Bdump contains trace files that relate to the Oracle background process -- > anything generated by smon, pmon, etc > > Udump contains trace files that relate to specific user Oracle processes > > Cdump contains core dumps, associated with one or another trace files in the > bdump directory. > > > Rachel > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: cdump, bdump, udump > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > >Hi all, > > > >When those logs will created ? > > > >Thank you > > > >Sinardy > > > > > >-Original Message- > >Sent: Tuesday, 24 April 2001 9:41 AM > >To: LazyDBA mailing list > > > > > >Hi DBAs and SAs, > > > >I had a task to do housekeep ...\bdump\alertSID.log > >What logs usually Oracle system need to housekeep, and what are these > >directory > > cdump, > > bdump and > > udump > >for ? > > > > > >Thank you for your time > > > >Sinardy > > > > > > > > > >Think you know someone who can answer the above question? Forward it to > >them! > >to unsubscribe, send a blank email to [EMAIL PROTECTED] > >to subscribe send a blank email to [EMAIL PROTECTED] > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > >Tell yer mates about http://www.farAwayJobs.com > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Sinardy Xing > > 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). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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 > -- > Aut
Re: cdump, bdump, udump
It seems to work different for me. For the last 2 years, I have been deleting the old file and a new one appears with the very next message to be written. Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, April 25, 2001 9:39 AM Team, Correct me if I am wrong, please.. If you delete the alert.log file with the database up and running, the oracle still thinks the file exists and writes to a non existant file that you can't "see". The proper method of reducing the file size is to copy the file to a backup location, and edit the original and delete rows from the file. OR if you do not need to keep the original log for analysis you could copu /dev/null > alert.log. Just a house keeping note. ROR mª¿ªm >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> Sinardy, First, I suggest you find some time and sit down and READ the Oracle documentation. Otherwise you are going to get a large number of "RTFM" emails, and some flaming as well. Now.. the alert log is created (if it does not already exist) or written to every time Oracle wants to record an event that has happened in the database/instance. So log switches will be in there, database shutdown and startup messages, errors dealing with the infrastructure of the database (failure to extend a rollback segment, failure to get space in the temp segment, disasterous database errors etc) There are other messages as well, I'm not going to list every one. Bdump contains trace files that relate to the Oracle background process -- anything generated by smon, pmon, etc Udump contains trace files that relate to specific user Oracle processes Cdump contains core dumps, associated with one or another trace files in the bdump directory. Rachel >From: "Sinardy Xing" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: cdump, bdump, udump >Date: Tue, 24 Apr 2001 03:40:27 -0800 > >Hi all, > >When those logs will created ? > >Thank you > >Sinardy > > >-Original Message- >Sent: Tuesday, 24 April 2001 9:41 AM >To: LazyDBA mailing list > > >Hi DBAs and SAs, > >I had a task to do housekeep ...\bdump\alertSID.log >What logs usually Oracle system need to housekeep, and what are these >directory > cdump, > bdump and > udump >for ? > > >Thank you for your time > >Sinardy > > > > >Think you know someone who can answer the above question? Forward it to >them! >to unsubscribe, send a blank email to [EMAIL PROTECTED] >to subscribe send a blank email to [EMAIL PROTECTED] >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl >Tell yer mates about http://www.farAwayJobs.com > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Sinardy Xing > 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Ron Rogers 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
Re: cdump, bdump, udump
I tend to agree with you. I feel MUCH more comfortable reading paper. Terry [EMAIL PROTECTED] wrote: > Wow. I feel just the opposite. When I had the paper docs, I could > take one on the train, take it home, know what I read, feel like > I'd accomplished something when I'd read a chunk, etc. I had a > relationship with the books, my tuning guide had a corner bent, the > app dev guide was missing a cover. > > With this electronic stuff, I can't 'sit down and study', I find > its hard to get a feel of what I should read because it all looks > and feels the same. > > I really miss the hard copy docs. > > My two pence. > > Yosi > > > -Original Message- > > From: Joseph S. Testa [mailto:[EMAIL PROTECTED]] > > Sent: Tuesday, April 24, 2001 8:50 AM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: cdump, bdump, udump > > > > > > read the tuning guide and the administrators guide. > > > > nowadays this is a valid answer now that oracle docs are > > online, NO ONE > > HAS AN EXCUSE to not read the docs unlike back in the days > > when you had > > to pay thousands of dollars for paper docs. > > > > joe > > > Venkat_Kalepalli wrote: > > > > > > Hello folks! > > > > > > I am working in SUN solaris 5.6 with Oracle 8i. I want to implement > > > MTS on the Oracle server. Next we are running with Rule based > > > optimizer and we want to change to costbased optimizer. > > > > > > I want to know what are the advantages we get on this and > > what are the > > > steps to implement this? > > > > > > Any help is grateful... > > > > > > Rgd > > > Venkat > > > DBA. > > > > -- > > Joe Testa http://www.oracle-dba.com > > Performing Remote DBA Services, need some backup DBA support? > > For Sale: Oracle-dba.com domain, its not going cheap but feel free to > > ask :) > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Joseph S. Testa > > 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: > 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: Terry Ball 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).
Re: cdump, bdump, udump
With the alert.log you are incorrect. Oracle only get a handle on the file when it writes to it. The rest of the time, it does not need nor keep a handle on the alert.log. You can move or delete the file and neither Oracle nor the OS care. A new alert.log will be created as soon as Oracle needs to write to one. Terry Ron Rogers wrote: > Team, > Correct me if I am wrong, please.. If you delete the alert.log file with the >database up and running, the oracle still thinks the file exists and writes to a non >existant file that you can't "see". The proper method of reducing the file size is to >copy the file to a backup location, and edit the original and delete rows from the >file. OR if you do not need to keep the original log for analysis you could copu >/dev/null > alert.log. > Just a house keeping note. > ROR mª¿ªm > > >>> [EMAIL PROTECTED] 04/24/01 09:21AM >>> > Sinardy, > > First, I suggest you find some time and sit down and READ the Oracle > documentation. Otherwise you are going to get a large number of "RTFM" > emails, and some flaming as well. > > Now.. the alert log is created (if it does not already exist) or written to > every time Oracle wants to record an event that has happened in the > database/instance. So log switches will be in there, database shutdown and > startup messages, errors dealing with the infrastructure of the database > (failure to extend a rollback segment, failure to get space in the temp > segment, disasterous database errors etc) There are other messages as well, > I'm not going to list every one. > > Bdump contains trace files that relate to the Oracle background process -- > anything generated by smon, pmon, etc > > Udump contains trace files that relate to specific user Oracle processes > > Cdump contains core dumps, associated with one or another trace files in the > bdump directory. > > Rachel > > >From: "Sinardy Xing" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: RE: cdump, bdump, udump > >Date: Tue, 24 Apr 2001 03:40:27 -0800 > > > >Hi all, > > > >When those logs will created ? > > > >Thank you > > > >Sinardy > > > > > >-Original Message- > >Sent: Tuesday, 24 April 2001 9:41 AM > >To: LazyDBA mailing list > > > > > >Hi DBAs and SAs, > > > >I had a task to do housekeep ...\bdump\alertSID.log > >What logs usually Oracle system need to housekeep, and what are these > >directory > > cdump, > > bdump and > > udump > >for ? > > > > > >Thank you for your time > > > >Sinardy > > > > > > > > > >Think you know someone who can answer the above question? Forward it to > >them! > >to unsubscribe, send a blank email to [EMAIL PROTECTED] > >to subscribe send a blank email to [EMAIL PROTECTED] > >Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl > >Tell yer mates about http://www.farAwayJobs.com > > > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Sinardy Xing > > 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). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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
OT RE: cdump, bdump, udump
Title: OT RE: cdump, bdump, udump LoL! No, but it is hellaciously hard to do. And extremely rewarding! || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, April 24, 2001 3:13 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: cdump, bdump, udump || || || Does everybody else need to wear a really big hat? || || On 24 Apr 2001, at 10:15, Mohan, Ross wrote: || || || > p.s. let me know when you can do the "Royal Pigeon" || || ... || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Eric D. Pierce || 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). ||