PLEASE --- these queries are run by Oracle itself in the process of cleaning
up.. do NOT attempt to run them on your own, you can really mess up your
database
>From: "Michael Kline" <maklinesr_at_home.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Urgent: NT 8.0.5 restarted after 76 days, now slow
>Date: Wed, 26 Jul 2000 04:44:09 -0800
>
>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-----
>Siva_Chintalapati
>Sent: Tuesday, July 25, 2000 11:14 PM
>To: Multiple recipients of list ORACLE-L
>
>
> 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).
Received on Wed Jul 26 2000 - 08:37:12 CDT
