RE: Urgent: NT 8.0.5 restarted after 76 days, now slow

From: Siva_Chintalapati <Siva_Chintalapati_at_satyam.com>
Date: Wed, 26 Jul 2000 07:34:44 +0530
Message-Id: <10569.112959@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFF6A5.DEC2DD70
Content-Type: text/plain;

charset="iso-8859-1"

Hi,
Can U please say what are the queries to b given for deallocating.

Regards
Siva

> ----------
> From: Michael Kline[SMTP:maklinesr_at_home.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Wednesday, July 26, 2000 7:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Urgent: NT 8.0.5 restarted after 76 days, now slow
>
> This appeared to be the clean up of 800 meg of temporary tablespace with
> 10K
> extents.... While there was a pctincrease, it was thousands of segments
> that
> had to all be cleaned up again for a new start. It took 8-10 hours, and
> then
> suddenly the utilization dropped from 85% to 5%. The problem went away as
> quickly as it started. Everything is fine once again.
>
> I found queries to fet$ and uet$(I think it was) that had the looks of
> deallocating and then reassigning the segments. These had all be executed
> between 72,000 and 164,000 times each...
>
> > -----Original Message-----
> > From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Ron Rogers
> > Sent: Tuesday, July 25, 2000 5:19 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Urgent: NT 8.0.5 restarted after 76 days, now slow
> >
> >
> > Sounds like there was long running process that was active during
> > the "shutdown abort" command and it is in the process of rolling
> > back what was aborted. It could take many hours..about the same
> > time it took to create the rollback data. Check your V$ROLLSTAT
> > for rollback segment comsumption.
> > Ron Rogers
> > DBA
> > Atl.GA
> >
> > >>> maklinesr_at_home.com 07/25/00 11:07AM >>>
> > One of my Houston customers bounced the database server this morning,
> and
> > Oracle80.exe is eating up almost 90% of the server, constantly
> > for a couple
> > of hours now.
> >
> > The database did not want to shut down normally. He finally had
> > to kill it.
> >
> > When he brought it back up, it just sucks up all sorts of CPU and
> queries
> > are taking "forever" to run.
> >
> > buffer cache and library cache are almost 100%, but dictionary
> > cache is only
> > 39%.... Running the "less than 5%" query, it's reported to be
> > 51.98%. (It's
> > been up for 2-3 hours now)
> >
> > It's 8.0.5.0.0 on NT SP3, with 256MB memory and twin 360mhz processors.
> >
> > Previously to this, the system was running just fine. Normal running is
> > Dictionary 99, Library 99, and Buffer 89.
> >
> > In 16 years I've not seen anything quite like this. Nothing has been
> added
> > or changed. As I said, the database server had been up steady for over
> 76
> > days. Being NT, there is little they could add without bouncing
> > the server.
> >
> > Metalink shows nothing so far...
> >
> > Anyone seen anything like this?
> >
> >
> > Michael Kline
> > ThinkSpark
> > Richmond, VA
> > 804-744-1545
> >
> >
> >
> > --
> > Author: Michael Kline
> > INET: maklinesr_at_home.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).
> >
> > --
> > Author: Ron Rogers
> > INET: RROGERS_at_galottery.org
> >
> > 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).
> >
>
> --
> Author: Michael Kline
> INET: maklinesr_at_home.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).
>

------_=_NextPart_001_01BFF6A5.DEC2DD70
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12">

<TITLE>RE: Urgent: NT 8.0.5 restarted after 76 days, now slow</TITLE>
</HEAD>
<BODY>

Hi, Can U please say = what are the queries to b given for deallocating.

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Regards</FONT>
<BR><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">Siva</FONT>
</P>
<UL>
<P><FONT SIZE=3D1 FACE=3D"MS Sans Serif">----------</FONT>
<BR><B><FONT SIZE=3D1 FACE=3D"MS Sans Serif">From:</FONT></B> &nbsp; =
<FONT SIZE=3D1 FACE=3D"MS Sans Serif">Michael =

Kline[SMTP:maklinesr_at_home.com]
 Reply To: =       ORACLE-L_at_fatcity.com
 Sent:   = Wednesday, July 26, 2000 7:54 = AM
 To: =     Multiple = recipients of list ORACLE-L
 Subject: =        RE: Urgent: NT 8.0.5 restarted after 76 days, now slow

This appeared to be the clean up of = 800 meg of temporary tablespace with 10K extents.... While there was a = pctincrease, it was thousands of segments that had to all be cleaned up again for a = new start. It took 8-10 hours, and then suddenly the utilization dropped from = 85% to 5%. The problem went away as quickly as it started. Everything is = fine once again.

I found queries to fet$ and uet$(I = think it was) that had the looks of deallocating and then reassigning the = segments. These had all be executed between 72,000 and 164,000 times = each...

> -----Original Message----- > From: root_at_fatcity.com = [<A = HREF=3D"mailto:root_at_fatcity.com">mailto:root_at_fatcity.com</A><= FONT SIZE=3D2 FACE=3D"Arial">]On Behalf Of Ron Rogers > Sent: Tuesday, July 25, 2000 = 5:19 PM
 > To: Multiple recipients of list = ORACLE-L
 > Subject: Re: Urgent: NT 8.0.5 = restarted after 76 days, now slow

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Sounds like there was long =

running process that was active during > the "shutdown abort" = command and it is in the process of rolling > back what was aborted. It could = take many hours..about the same
 > time it took to create the = rollback data. Check your V$ROLLSTAT > for rollback segment = comsumption.

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Ron Rogers</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; DBA</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Atl.GA</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &gt;&gt;&gt; maklinesr_at_home.com =

07/25/00 11:07AM >>>
 > One of my Houston customers = bounced the database server this morning, and > Oracle80.exe is eating up almost = 90% of the server, constantly

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; for a couple</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; of hours now.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; The database did not want to =

shut down normally. He finally had

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; to kill it.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; When he brought it back up, it =

just sucks up all sorts of CPU and queries > are taking "forever" = to run.
 > > buffer cache and library cache = are almost 100%, but dictionary
 > cache is only > 39%.... Running the "less = than 5%" query, it's reported to be

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; 51.98%.&nbsp; (It's</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; been up for 2-3 hours =
now)</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; It's 8.0.5.0.0 on NT SP3, with =

256MB memory and twin 360mhz processors. > > Previously to this, the system = was running just fine.  Normal running is > Dictionary 99, Library 99, and = Buffer 89.
 > > In 16 years I've not seen = anything quite like this. Nothing has been added > or changed. As I said, the = database server had been up steady for over 76 > days. Being NT, there is little = they could add without bouncing

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; the server.</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Metalink shows nothing so =

far...
 > > Anyone seen anything like = this?

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Michael Kline</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; ThinkSpark</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Richmond, VA</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; 804-744-1545</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; --</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Author: Michael Kline</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;&nbsp;&nbsp; INET: =

maklinesr_at_home.com
 > > Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 > San Diego, = California        -- Public Internet = access / Mailing Lists
 > =

--------------------------------------------------------------------</FO=

NT>
 > 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).

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; --</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Author: Ron Rogers</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;&nbsp;&nbsp; INET: =

RROGERS_at_galottery.org
 > > Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 > San Diego, = California        -- Public Internet = access / Mailing Lists
 > =

--------------------------------------------------------------------</FO=

<P><FONT SIZE=3D2 FACE=3D"Arial">-- </FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Author: Michael Kline</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; INET: =

maklinesr_at_home.com

Fat City Network = Services    -- (858) 538-5051  FAX: (858) = 538-5051
 San Diego, = California        -- Public Internet = access / Mailing Lists
 <FONT SIZE=3D2 =

FACE=3D"Arial">---------------------------------------------------------=

-----------
 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 = Received on Tue Jul 25 2000 - 21:04:44 CDT