RE: Database slowdown after 100 days uptime
Its not a general Oracle or Unix thing because we had out AIX boxes up and running Oracle 7.3.4 and 8.1.6 for many months at a time with no reboots. -Original Message- Sent: Wednesday, May 30, 2001 9:50 AM To: Multiple recipients of list ORACLE-L Hi Bruce As I understand ur server uptime is 242 days.Right!If this is the case then Please reboot the server would solve this problem.The similar kind of problem I faced in past. Hope this will help u.If you would like to more information then please visit metalink. Thanks -Seema >From: Raymond Lee Meng Hong <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Database slowdown after 100 days uptime >Date: Tue, 29 May 2001 18:15:47 -0800 > >As far as my experience ,my site also got this problem , that is why every >weekend we run a shutdown and restart the Unix box also in order to clean >up >some of the unwanted redo log and refresh the memory as well. > >it seen like our system become 6*24 instead of 7*24 , but in the business >view is we open only until Saturday. > >but now we have branch open in shopping mall ,and they work in Sunday ? > >-Original Message- >Sent: Tuesday, May 29, 2001 10:31 PM >To: Multiple recipients of list ORACLE-L > > >Keep an eye on free memory -- one of our similar systems has to be >restarted >every 60 days to prevent the behaviour you're encountering. We haven't >determined the source of the memory leak, but if we permit it to continue >eventually the DB stops responding and cannot be shut down. This system >does >some analytical work for us so it has different connection and activity >profiles than the others, so I've a limited basis for comparison, but the >other >8.1.5 databse (this one's data source) shows similar problems over a longer >period. >My plan is to take it up to 8.1.7 as those systems are not showing that >sort >of >problem. >"Reardon, Bruce (CALBBAY)" wrote: > > > Hi, > > > > We're running Oracle 8.1.5.1.1 on NT 4. > > > > On Saturday our database started getting much slower > > - to me, there didn't seem to be any major events showing up in > > v$session_wait, v$session_event > > > > Restarting the database instance and service solved the performance > > problems. > > > > Today, when reviewing logs of the queries I noticed that the database >had > > been up for 100 days when it started slowing. > > > > The 100 days uptime may be unrelated, but has anyone seen this behaviour >on > > any platform? > > > > For information, the server itself has been up for 242 days (240 days >when > > the problem started occurring). > > > > Thanks, > > Bruce Reardon > > mailto:[EMAIL PROTECTED] > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Reardon, Bruce (CALBBAY) > > 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: Raymond Lee Meng Hong > 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: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Database slowdown after 100 days uptime
Hi Bruce As I understand ur server uptime is 242 days.Right!If this is the case then Please reboot the server would solve this problem.The similar kind of problem I faced in past. Hope this will help u.If you would like to more information then please visit metalink. Thanks -Seema >From: Raymond Lee Meng Hong <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Database slowdown after 100 days uptime >Date: Tue, 29 May 2001 18:15:47 -0800 > >As far as my experience ,my site also got this problem , that is why every >weekend we run a shutdown and restart the Unix box also in order to clean >up >some of the unwanted redo log and refresh the memory as well. > >it seen like our system become 6*24 instead of 7*24 , but in the business >view is we open only until Saturday. > >but now we have branch open in shopping mall ,and they work in Sunday ? > >-Original Message- >Sent: Tuesday, May 29, 2001 10:31 PM >To: Multiple recipients of list ORACLE-L > > >Keep an eye on free memory -- one of our similar systems has to be >restarted >every 60 days to prevent the behaviour you're encountering. We haven't >determined the source of the memory leak, but if we permit it to continue >eventually the DB stops responding and cannot be shut down. This system >does >some analytical work for us so it has different connection and activity >profiles than the others, so I've a limited basis for comparison, but the >other >8.1.5 databse (this one's data source) shows similar problems over a longer >period. >My plan is to take it up to 8.1.7 as those systems are not showing that >sort >of >problem. >"Reardon, Bruce (CALBBAY)" wrote: > > > Hi, > > > > We're running Oracle 8.1.5.1.1 on NT 4. > > > > On Saturday our database started getting much slower > > - to me, there didn't seem to be any major events showing up in > > v$session_wait, v$session_event > > > > Restarting the database instance and service solved the performance > > problems. > > > > Today, when reviewing logs of the queries I noticed that the database >had > > been up for 100 days when it started slowing. > > > > The 100 days uptime may be unrelated, but has anyone seen this behaviour >on > > any platform? > > > > For information, the server itself has been up for 242 days (240 days >when > > the problem started occurring). > > > > Thanks, > > Bruce Reardon > > mailto:[EMAIL PROTECTED] > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Reardon, Bruce (CALBBAY) > > 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: Raymond Lee Meng Hong > 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: Seema Singh 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: Database slowdown after 100 days uptime
As far as my experience ,my site also got this problem , that is why every weekend we run a shutdown and restart the Unix box also in order to clean up some of the unwanted redo log and refresh the memory as well. it seen like our system become 6*24 instead of 7*24 , but in the business view is we open only until Saturday. but now we have branch open in shopping mall ,and they work in Sunday ? -Original Message- Sent: Tuesday, May 29, 2001 10:31 PM To: Multiple recipients of list ORACLE-L Keep an eye on free memory -- one of our similar systems has to be restarted every 60 days to prevent the behaviour you're encountering. We haven't determined the source of the memory leak, but if we permit it to continue eventually the DB stops responding and cannot be shut down. This system does some analytical work for us so it has different connection and activity profiles than the others, so I've a limited basis for comparison, but the other 8.1.5 databse (this one's data source) shows similar problems over a longer period. My plan is to take it up to 8.1.7 as those systems are not showing that sort of problem. "Reardon, Bruce (CALBBAY)" wrote: > Hi, > > We're running Oracle 8.1.5.1.1 on NT 4. > > On Saturday our database started getting much slower > - to me, there didn't seem to be any major events showing up in > v$session_wait, v$session_event > > Restarting the database instance and service solved the performance > problems. > > Today, when reviewing logs of the queries I noticed that the database had > been up for 100 days when it started slowing. > > The 100 days uptime may be unrelated, but has anyone seen this behaviour on > any platform? > > For information, the server itself has been up for 242 days (240 days when > the problem started occurring). > > Thanks, > Bruce Reardon > mailto:[EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Reardon, Bruce (CALBBAY) > 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: Raymond Lee Meng Hong 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: Database slowdown after 100 days uptime
Keep an eye on free memory -- one of our similar systems has to be restarted every 60 days to prevent the behaviour you're encountering. We haven't determined the source of the memory leak, but if we permit it to continue eventually the DB stops responding and cannot be shut down. This system does some analytical work for us so it has different connection and activity profiles than the others, so I've a limited basis for comparison, but the other 8.1.5 databse (this one's data source) shows similar problems over a longer period. My plan is to take it up to 8.1.7 as those systems are not showing that sort of problem. "Reardon, Bruce (CALBBAY)" wrote: > Hi, > > We're running Oracle 8.1.5.1.1 on NT 4. > > On Saturday our database started getting much slower > - to me, there didn't seem to be any major events showing up in > v$session_wait, v$session_event > > Restarting the database instance and service solved the performance > problems. > > Today, when reviewing logs of the queries I noticed that the database had > been up for 100 days when it started slowing. > > The 100 days uptime may be unrelated, but has anyone seen this behaviour on > any platform? > > For information, the server itself has been up for 242 days (240 days when > the problem started occurring). > > Thanks, > Bruce Reardon > mailto:[EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Reardon, Bruce (CALBBAY) > 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). begin:vcard n:Jerman;Don tel;work:919.508.1886 x-mozilla-html:TRUE org:Database Management Service,Information Technology version:2.1 email;internet:[EMAIL PROTECTED] title:Database Administrator adr;quoted-printable:;;Database Management Service,Information Technology=0D=0A104 Fayetteville Street Mall;Raleigh;NC;27699-1521;USA x-mozilla-cpt:;-9536 fn:Don Jerman end:vcard
RE: Database slowdown after 100 days uptime
Hi Bruce Yep there is something on Metalink about this when server uptime is > 248 days (I know it sounds unbelievable). Happened to me, databases slowing/hanging and I could only shutdown abort databases. Rebooted and everything worked fine. HTH Mark. ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Marsden 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: Database slowdown after 100 days uptime
Hi, There is an alert (Note:118228.1) ALERT: Hang During Startup/Shutdown on Unix When System Uptime > 248 Days. But, you are using NT. do you have other errors in alert.log before crash or is there core.log ? "Reardon, Bruce (CALBBAY)" wrote: > Hi, > > We're running Oracle 8.1.5.1.1 on NT 4. > > On Saturday our database started getting much slower > - to me, there didn't seem to be any major events showing up in > v$session_wait, v$session_event > > Restarting the database instance and service solved the performance > problems. > > Today, when reviewing logs of the queries I noticed that the database had > been up for 100 days when it started slowing. > > The 100 days uptime may be unrelated, but has anyone seen this behaviour on > any platform? > > For information, the server itself has been up for 242 days (240 days when > the problem started occurring). > > Thanks, > Bruce Reardon > mailto:[EMAIL PROTECTED] > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Reardon, Bruce (CALBBAY) > 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: Danisment Gazi Unal (Unal Bilisim) 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).
Database slowdown after 100 days uptime
Hi, We're running Oracle 8.1.5.1.1 on NT 4. On Saturday our database started getting much slower - to me, there didn't seem to be any major events showing up in v$session_wait, v$session_event Restarting the database instance and service solved the performance problems. Today, when reviewing logs of the queries I noticed that the database had been up for 100 days when it started slowing. The 100 days uptime may be unrelated, but has anyone seen this behaviour on any platform? For information, the server itself has been up for 242 days (240 days when the problem started occurring). Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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).