| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 <RAYMOND_at_infopro.com.my>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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:bruce.reardon_at_comalco.riotinto.com.au
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Reardon, Bruce (CALBBAY)
> > INET: Bruce.Reardon_at_comalco.riotinto.com.au
> >
> > 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: ListGuru_at_fatcity.com (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: RAYMOND_at_infopro.com.my
>
>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: ListGuru_at_fatcity.com (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: Seema Singh INET: oracledbam_at_hotmail.com 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: ListGuru_at_fatcity.com (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).Received on Wed May 30 2001 - 11:12:03 CDT
 |
 |