I think that in order to get correct statistics, you should take time difference
before and after you made modification. The same logic as you collect UTLBSTAT
and UTLESTAT report for database performance analysis. Let me know if I am
wrong.
Eveleen
Please respond to [EMAIL PROTECTED]
"Mitchell" <[EMAIL PROTECTED]> on 02/06/2001 03:11:50 PM
Message - From: "Mitchell" <[EMAIL PROTECTED]> on 02/06/2001 09:11 PM GMT
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc: (bcc: Eveleen Xu/NNIB/NNNG)
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
