RE: v$waitstat

From: Koivu, Lisa <lkoivu_at_qode.com>
Date: Tue, 06 Feb 2001 14:06:56 -0800
Message-ID: <F001.002ACBE0.20010206132804@fatcity.com>

Mitchell, in order to clear your waits you must bounce your database.

Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL  33319

V: 954.484.3191, x174
F: 954.484.2933 
C: 954.658.5849

http://www.qode.com

"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."

-----Original Message-----
From: Mitchell [mailto:mitchell_at_comnet.ca] Sent: Tuesday, February 06, 2001 4:12 PM To: Multiple recipients of list ORACLE-L Subject: v$waitstat

Hi DBAs

I have follwoing v$waitstat output show contention on undo header. When I add some rollback segments. the count and time is up. How can reset the count? or I do something wrong.

Mitchell

Tue Feb 06
page    1

                                                                Disk

Balancing Report

CLASS                   COUNT       TIME
------------------ ---------- ----------
data block            7246880    6502280
sort block                  0          0
save undo block             0          0
segment header            736       4273
save undo header            0          0
free list                   0          0
extent map                  9          7
bitmap block                0          0
bitmap index block          0          0
unused                      0          0
system undo header          0          0
system undo block           0          0

undo header            109487    2237121 undo block              73679     503486

14 rows selected.

After add another 3 rollback segment.

Tue Feb 06
page    1

CLASS                   COUNT       TIME
------------------ ---------- ----------
data block            7253012    6505054
sort block                  0          0
save undo block             0          0
segment header            736       4273
save undo header            0          0
free list                   0          0
extent map                  9          7
bitmap block                0          0
bitmap index block          0          0
unused                      0          0
system undo header          0          0
system undo block           0          0

undo header            109494    2237123 undo block              73691     503498

14 rows selected.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mitchell
  INET: mitchell_at_comnet.ca

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 Tue Feb 06 2001 - 16:06:56 CST