v$waitstat

From: Mitchell <mitchell_at_comnet.ca>
Date: Tue, 06 Feb 2001 13:23:33 -0800
Message-ID: <F001.002ACA89.20010206131151@fatcity.com>

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 - 15:23:33 CST