Message-Id: <10570.112990@fatcity.com> From: "Michael Kline" Date: Wed, 26 Jul 2000 07:39:28 -0400 Subject: RE: Urgent: NT 8.0.5 restarted after 76 days, now slow 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@fatcity.com [mailto:root@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@home.com] Reply To: ORACLE-L@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@fatcity.com [mailto:root@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@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@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@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@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@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@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@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 RE: Urgent: NT 8.0.5 restarted after 76 days, now = slow
The=20 various queries statements:
 
select=20 length from fet$ where file#=3D:1 and block#=3D:2 and = ts#=3D:3
select=20 file#,block#length from uet$ where ts#=3D:1 and segfile#=3D:2 and = segblock#=3D:3 and=20 ext#=3D:4
delete=20 from fet$ where file#=3D:1 and block#=3D:2 and = ts#=3D:3
insert=20 into fet$ (file#,block#,ts#,length) values = (:1,:2,:3,:4)
delete=20 from uet$ where ts#=3D:1 and segfile#=3D:2 and segblock#=3D:3 and=20 ext#=3D:4
 
 
 
 -----Original = Message-----
From:=20 root@fatcity.com [mailto:root@fatcity.com]On Behalf Of=20 Siva_Chintalapati
Sent: Tuesday, July 25, 2000 11:14 = PM
To:=20 Multiple recipients of list ORACLE-L
Subject: RE: Urgent: NT = 8.0.5=20 restarted after 76 days, now slow

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

Regards =
Siva