Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Urgent: NT 8.0.5 restarted after 76 days, now slow

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

From: Michael Kline <maklinesr_at_home.com>
Date: Wed, 26 Jul 2000 07:39:28 -0400
Message-Id: <10570.112990@fatcity.com>


This is a multi-part message in MIME format.

------=_NextPart_000_000F_01BFF6D4.A0EDC560 Content-Type: text/plain;

        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

RE: Urgent: NT 8.0.5 restarted after 76 days, now slowThe various queries statements:

select length from fet$ where file#=:1 and block#=:2 and ts#=:3 select file#,block#length from uet$ where ts#=:1 and segfile#=:2 and segblock#=:3 and ext#=:4

delete from fet$ where file#=:1 and block#=:2 and ts#=:3
insert into fet$ (file#,block#,ts#,length) values (:1,:2,:3,:4)
delete from uet$ where ts#=:1 and segfile#=:2 and segblock#=:3 and ext#=:4



 -----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Siva_Chintalapati
Sent: Tuesday, July 25, 2000 11:14 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Urgent: NT 8.0.5 restarted after 76 days, now slow

  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_000_000F_01BFF6D4.A0EDC560 Content-Type: text/html;

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD><TITLE>RE: Urgent: NT 8.0.5 restarted after 76 days, now = slow</TITLE>
<META http-equiv=3DContent-Type content=3D"text/html; = charset=3Dwindows-1252">

<META content=3D"MSHTML 5.50.4134.600" name=3DGENERATOR></HEAD>
<BODY>
<DIV><SPAN class=3D160413411-26072000><FONT face=3DArial color=3D#0000ff =
size=3D2>The=20
various queries statements:</FONT></SPAN></DIV> <DIV><SPAN class=3D160413411-26072000><FONT face=3DArial color=3D#0000ff =

size=3D2></FONT></SPAN>&nbsp;</DIV>
<DIV><SPAN class=3D160413411-26072000><FONT face=3DArial color=3D#0000ff = size=3D2>select=20
length from fet$ where file#=3D:1 and block#=3D:2 and = ts#=3D:3</FONT></SPAN></DIV>
<DIV><SPAN class=3D160413411-26072000><FONT face=3DArial color=3D#0000ff = size=3D2>select=20
file#,block#length from uet$ where ts#=3D:1 and segfile#=3D:2 and = segblock#=3D:3 and=20
ext#=3D:4</FONT></SPAN></DIV>
<DIV><SPAN class=3D160413411-26072000><FONT face=3DArial color=3D#0000ff = size=3D2>delete=20
from fet$ where file#=3D:1 and block#=3D:2 and = ts#=3D:3</FONT></SPAN></DIV>
<DIV><SPAN class=3D160413411-26072000><FONT face=3DArial color=3D#0000ff = size=3D2>insert=20
into fet$ (file#,block#,ts#,length) values = (:1,:2,:3,:4)</FONT></SPAN></DIV>
<DIV><SPAN class=3D160413411-26072000><FONT face=3DArial color=3D#0000ff = size=3D2>delete=20
from uet$ where ts#=3D:1 and segfile#=3D:2 and segblock#=3D:3 and=20 ext#=3D:4</FONT></SPAN></DIV>
<DIV><SPAN class=3D160413411-26072000><A = href=3D"mailto:ext@=3D:4"></A></SPAN><FONT=20 face=3D"Times New Roman"><FONT size=3D2><SPAN = class=3D160413411-26072000><FONT=20
face=3DArial color=3D#0000ff>&nbsp;</FONT></SPAN></FONT></FONT></DIV> <DIV><FONT face=3D"Times New Roman"><FONT size=3D2><SPAN=20 class=3D160413411-26072000></SPAN></FONT></FONT>&nbsp;</DIV> <DIV><FONT face=3D"Times New Roman"><FONT size=3D2><SPAN=20 class=3D160413411-26072000></SPAN></FONT></FONT>&nbsp;</DIV> <DIV><FONT face=3D"Times New Roman"><FONT size=3D2><SPAN=20 class=3D160413411-26072000>&nbsp;</SPAN>-----Original = Message-----<BR><B>From:</B>=20
root_at_fatcity.com [mailto:root_at_fatcity.com]<B>On Behalf Of</B>=20 Siva_Chintalapati<BR><B>Sent:</B> Tuesday, July 25, 2000 11:14 = PM<BR><B>To:</B>=20
Multiple recipients of list ORACLE-L<BR><B>Subject:</B> RE: Urgent: NT = 8.0.5=20
restarted after 76 days, now slow<BR><BR></DIV></FONT></FONT> <BLOCKQUOTE=20
style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px = solid">
  <P><FONT face=3DArial color=3D#0000ff size=3D2>Hi,</FONT> <BR><FONT = face=3DArial=20
  color=3D#0000ff size=3D2>Can U please say what are the queries to b = given for=20
  deallocating.</FONT> </P>
  <P><FONT face=3DArial color=3D#0000ff size=3D2>Regards</FONT> = <BR><FONT face=3DArial=20
  color=3D#0000ff size=3D2>Siva</FONT> </P>   <UL>
    <P><FONT face=3D"MS Sans Serif" size=3D1>----------</FONT> = <BR><B><FONT=20

    face=3D"MS Sans Serif" size=3D1>From:</FONT></B> &nbsp; <FONT=20     face=3D"MS Sans Serif" size=3D1>Michael = Kline[SMTP:maklinesr_at_home.com]</FONT>=20

    <BR><B><FONT face=3D"MS Sans Serif" size=3D1>Reply To:</FONT></B>=20     &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT face=3D"MS Sans Serif"=20     size=3D1>ORACLE-L_at_fatcity.com</FONT> <BR><B><FONT face=3D"MS Sans = Serif"=20

    size=3D1>Sent:</FONT></B> &nbsp; <FONT face=3D"MS Sans Serif" = size=3D1>Wednesday,=20

    July 26, 2000 7:54 AM</FONT> <BR><B><FONT face=3D"MS Sans Serif"=20     size=3D1>To:</FONT></B> &nbsp;&nbsp;&nbsp; <FONT face=3D"MS Sans = Serif"=20

    size=3D1>Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT=20     face=3D"MS Sans Serif" size=3D1>Subject:</FONT></B>=20     &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT face=3D"MS Sans Serif" = size=3D1>RE:=20

    Urgent: NT 8.0.5 restarted after 76 days, now slow</FONT> </P>     <P><FONT face=3DArial size=3D2>This appeared to be the clean up of = 800 meg of=20

    temporary tablespace with 10K</FONT> <BR><FONT face=3DArial = size=3D2>extents....=20

    While there was a pctincrease, it was thousands of segments = that</FONT>=20

    <BR><FONT face=3DArial size=3D2>had to all be cleaned up again for a = new start.=20

    It took 8-10 hours, and then</FONT> <BR><FONT face=3DArial = size=3D2>suddenly the=20

    utilization dropped from 85% to 5%. The problem went away as</FONT>=20     <BR><FONT face=3DArial size=3D2>quickly as it started. Everything is = fine once=20

    again.</FONT> </P>
    <P><FONT face=3DArial size=3D2>I found queries to fet$ and uet$(I = think it was)=20

    that had the looks of</FONT> <BR><FONT face=3DArial = size=3D2>deallocating and=20

    then reassigning the segments. These had all be executed</FONT> = <BR><FONT=20

    face=3DArial size=3D2>between 72,000 and 164,000 times = each...</FONT> </P>

    <P><FONT face=3DArial size=3D2>&gt; -----Original = Message-----</FONT> <BR><FONT=20

    face=3DArial size=3D2>&gt; From: root_at_fatcity.com [</FONT><U><FONT = face=3DArial=20

    color=3D#0000ff size=3D2><A=20
    =
href=3D"mailto:root_at_fatcity.com">mailto:root_at_fatcity.com</A></FONT></U><F= ONT=20
    face=3DArial size=3D2>]On Behalf Of Ron Rogers</FONT> <BR><FONT = face=3DArial=20

    size=3D2>&gt; Sent: Tuesday, July 25, 2000 5:19 PM</FONT> <BR><FONT = face=3DArial=20

    size=3D2>&gt; To: Multiple recipients of list ORACLE-L</FONT> = <BR><FONT=20

    face=3DArial size=3D2>&gt; Subject: Re: Urgent: NT 8.0.5 restarted = after 76=20

    days, now slow</FONT> <BR><FONT face=3DArial size=3D2>&gt;</FONT> = <BR><FONT=20

    face=3DArial size=3D2>&gt;</FONT> <BR><FONT face=3DArial = size=3D2>&gt; Sounds like=20

    there was long running process that was active during</FONT> = <BR><FONT=20

    face=3DArial size=3D2>&gt; the "shutdown abort" command and it is in = the process=20

    of rolling</FONT> <BR><FONT face=3DArial size=3D2>&gt; back what was = aborted. It=20

    could take many hours..about the same</FONT> <BR><FONT face=3DArial=20     size=3D2>&gt; time it took to create the rollback data. Check your=20     V$ROLLSTAT</FONT> <BR><FONT face=3DArial size=3D2>&gt; for rollback = segment=20

    comsumption.</FONT> <BR><FONT face=3DArial size=3D2>&gt; Ron = Rogers</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt; DBA</FONT> <BR><FONT = face=3DArial size=3D2>&gt;=20

    Atl.GA</FONT> <BR><FONT face=3DArial size=3D2>&gt;</FONT> <BR><FONT = face=3DArial=20

    size=3D2>&gt; &gt;&gt;&gt; maklinesr_at_home.com 07/25/00 11:07AM=20     &gt;&gt;&gt;</FONT> <BR><FONT face=3DArial size=3D2>&gt; One of my = Houston=20

    customers bounced the database server this morning, and</FONT> = <BR><FONT=20

    face=3DArial size=3D2>&gt; Oracle80.exe is eating up almost 90% of = the server,=20

    constantly</FONT> <BR><FONT face=3DArial size=3D2>&gt; for a = couple</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt; of hours now.</FONT> <BR><FONT = face=3DArial=20

    size=3D2>&gt;</FONT> <BR><FONT face=3DArial size=3D2>&gt; The = database did not=20

    want to shut down normally. He finally had</FONT> <BR><FONT = face=3DArial=20

    size=3D2>&gt; to kill it.</FONT> <BR><FONT face=3DArial = size=3D2>&gt;</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt; When he brought it back up, it = just sucks=20

    up all sorts of CPU and queries</FONT> <BR><FONT face=3DArial = size=3D2>&gt; are=20

    taking "forever" to run.</FONT> <BR><FONT face=3DArial = size=3D2>&gt;</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt; buffer cache and library cache = are almost=20

    100%, but dictionary</FONT> <BR><FONT face=3DArial size=3D2>&gt; = cache is=20

    only</FONT> <BR><FONT face=3DArial size=3D2>&gt; 39%.... Running the = "less than=20

    5%" query, it's reported to be</FONT> <BR><FONT face=3DArial = size=3D2>&gt;=20

    51.98%.&nbsp; (It's</FONT> <BR><FONT face=3DArial size=3D2>&gt; been = up for 2-3=20

    hours now)</FONT> <BR><FONT face=3DArial size=3D2>&gt;</FONT> = <BR><FONT=20

    face=3DArial size=3D2>&gt; It's 8.0.5.0.0 on NT SP3, with 256MB = memory and twin=20

    360mhz processors.</FONT> <BR><FONT face=3DArial = size=3D2>&gt;</FONT> <BR><FONT=20

    face=3DArial size=3D2>&gt; Previously to this, the system was = running just=20

    fine.&nbsp; Normal running is</FONT> <BR><FONT face=3DArial = size=3D2>&gt;=20

    Dictionary 99, Library 99, and Buffer 89.</FONT> <BR><FONT = face=3DArial=20

    size=3D2>&gt;</FONT> <BR><FONT face=3DArial size=3D2>&gt; In 16 = years I've not=20

    seen anything quite like this. Nothing has been added</FONT> = <BR><FONT=20

    face=3DArial size=3D2>&gt; or changed. As I said, the database = server had been=20

    up steady for over 76</FONT> <BR><FONT face=3DArial size=3D2>&gt; = days. Being=20

    NT, there is little they could add without bouncing</FONT> <BR><FONT =

    face=3DArial size=3D2>&gt; the server.</FONT> <BR><FONT face=3DArial =

    size=3D2>&gt;</FONT> <BR><FONT face=3DArial size=3D2>&gt; Metalink = shows nothing=20

    so far...</FONT> <BR><FONT face=3DArial size=3D2>&gt;</FONT> = <BR><FONT=20

    face=3DArial size=3D2>&gt; Anyone seen anything like this?</FONT> = <BR><FONT=20

    face=3DArial size=3D2>&gt;</FONT> <BR><FONT face=3DArial = size=3D2>&gt;</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt; Michael Kline</FONT> <BR><FONT = face=3DArial=20

    size=3D2>&gt; ThinkSpark</FONT> <BR><FONT face=3DArial size=3D2>&gt; = Richmond,=20

    VA</FONT> <BR><FONT face=3DArial size=3D2>&gt; 804-744-1545</FONT> = <BR><FONT=20

    face=3DArial size=3D2>&gt;</FONT> <BR><FONT face=3DArial = size=3D2>&gt;</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt;</FONT> <BR><FONT face=3DArial = size=3D2>&gt;=20

    --</FONT> <BR><FONT face=3DArial size=3D2>&gt; Author: Michael = Kline</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt;&nbsp;&nbsp; INET: = maklinesr_at_home.com</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt;</FONT> <BR><FONT face=3DArial = size=3D2>&gt; Fat=20

    City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: = (858)=20

    538-5051</FONT> <BR><FONT face=3DArial size=3D2>&gt; San Diego,=20     California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public = Internet=20

    access / Mailing Lists</FONT> <BR><FONT face=3DArial size=3D2>&gt;=20     =

--------------------------------------------------------------------</FON=
T>=20

    <BR><FONT face=3DArial size=3D2>&gt; To REMOVE yourself from this = mailing list,=20

    send an E-Mail message</FONT> <BR><FONT face=3DArial size=3D2>&gt; = to:=20

    ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and = in</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt; the message BODY, include a = line=20

    containing: UNSUB ORACLE-L</FONT> <BR><FONT face=3DArial = size=3D2>&gt; (or the=20

    name of mailing list you want to be removed from).&nbsp; You = may</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt; also send the HELP command for = other=20

    information (like subscribing).</FONT> <BR><FONT face=3DArial=20     size=3D2>&gt;</FONT> <BR><FONT face=3DArial size=3D2>&gt; --</FONT> = <BR><FONT=20

    face=3DArial size=3D2>&gt; Author: Ron Rogers</FONT> <BR><FONT = face=3DArial=20

    size=3D2>&gt;&nbsp;&nbsp; INET: RROGERS_at_galottery.org</FONT> = <BR><FONT=20

    face=3DArial size=3D2>&gt;</FONT> <BR><FONT face=3DArial = size=3D2>&gt; Fat City=20

    Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: = (858)=20

    538-5051</FONT> <BR><FONT face=3DArial size=3D2>&gt; San Diego,=20     California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public = Internet=20

    access / Mailing Lists</FONT> <BR><FONT face=3DArial size=3D2>&gt;=20     =

--------------------------------------------------------------------</FON=
T>=20

    <BR><FONT face=3DArial size=3D2>&gt; To REMOVE yourself from this = mailing list,=20

    send an E-Mail message</FONT> <BR><FONT face=3DArial size=3D2>&gt; = to:=20

    ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and = in</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt; the message BODY, include a = line=20

    containing: UNSUB ORACLE-L</FONT> <BR><FONT face=3DArial = size=3D2>&gt; (or the=20

    name of mailing list you want to be removed from).&nbsp; You = may</FONT>=20

    <BR><FONT face=3DArial size=3D2>&gt; also send the HELP command for = other=20

    information (like subscribing).</FONT> <BR><FONT face=3DArial=20     size=3D2>&gt;</FONT> </P>
    <P><FONT face=3DArial size=3D2>-- </FONT><BR><FONT face=3DArial = size=3D2>Author:=20

    Michael Kline</FONT> <BR><FONT face=3DArial size=3D2>&nbsp; INET:=20     maklinesr_at_home.com</FONT> </P>
    <P><FONT face=3DArial size=3D2>Fat City Network = Services&nbsp;&nbsp;&nbsp; --=20

    (858) 538-5051&nbsp; FAX: (858) 538-5051</FONT> <BR><FONT = face=3DArial=20

    size=3D2>San Diego, =
California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; --=20

    Public Internet access / Mailing Lists</FONT> <BR><FONT face=3DArial =

    =

size=3D2>----------------------------------------------------------------=
----</FONT>=20

    <BR><FONT face=3DArial size=3D2>To REMOVE yourself from this mailing = list, send=20

    an E-Mail message</FONT> <BR><FONT face=3DArial size=3D2>to:=20     ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and = Received on Wed Jul 26 2000 - 06:39:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US