| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: v$waitstat
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 ORACLE-L_at_fatcity.com
"Mitchell" <mitchell_at_comnet.ca> on 02/06/2001 03:11:50 PM
Message - From: "Mitchell" <mitchell_at_comnet.ca> on 02/06/2001 09:11 PM GMT
To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
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: 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-LReceived on Tue Feb 06 2001 - 18:43:44 CST
(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: exu_at_nnng.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).
 |
 |