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
Received on Tue Jul 25 2000 - 20:18:02 CDT