Previous Table of Contents Next


Table 11.6 Excerpts from MY_SID average write queue and redo wait report for the last 21 days (07/08/96 10:06).
B/Estat Execution Summed Dirty Que Length Write Requests Avg Write Que Length Redo Special Requests
96/06/26 WED 16:19-16:20 0   128   .00   0  
96/06/27 THU 08:05-12:05 5,572   16,856   .33   28  
96/06/28 FRI 09:28-16:00 18   378   .05   0  
96/07/01 MON 08:00-09:30 35,784   122,334   .29   138  
96/07/01 MON 08:00-12:00 41,909   38,976   1.08   126  
96/07/02 TUE 08:00-12:00 2,016   22,950   .09   126  
96/07/02 TUE 08:00-16:00 116,455   28,080   4.15   40  
96/07/03 WED 08:00-12:00 437   2,207   .20   3  
96/07/03 WED 08:00-16:00 87,396   74,064   1.18   80  
96/07/04 THU 08:00-09:30 0   32   .00   0  
96/07/05 FRI 08:00-16:00 0   184   .00   0  
—————   —————   ———   ———  
Average 30,612   18,540   .96   32  
Minimum 0   32   .00   0  
Maximum 116,455   122,334   4.15   138  

Table 11.7 Excerpts from MY_SID instance B/E file stats totals by data file for last 31 days (07/08/96 10:06).
Data File Total Reads Total Read Time Total Writes Total Write Time
/Datadisks/d01/ORACLE/my_sid/mptv.dbf 6,870,264 0 100,596 0
/Datadisks/d02/ORACLE/my_sid/index.dbf 282,408 0 66,876 0
————— —— ——— ——
Average 806,251 0 54,535 0
Minimum 0 0 0 0
Maximum 6,870,264 0 255,474 0
sum 7,256,258 0 490,816 0

Table 11.8 Excerpts from OIDB instance B/E file totals by file system for last 7 days stats (07/09/96 09:22).
File System Total Reads Total Writes
/Datadisks/d01/ORACLE 373,144 45,823
/Datadisks/d02/ORACLE 22,120 67,729
/Datadisks/d03/ORACLE 449,608 9,107
/Datadisks/d04/ORACLE 1,119,456 11,920
/Datadisks/d05/ORACLE 272,716 9,703
/Datadisks/d06/ORACLE 1,051,170 37,835
/Datadisks/d09/ORACLE 746 1,186
————— —————
Average 644,920 158,627
Minimum 0 0
Maximum 2,876,425 1,444,968
sum 9,673,799 2,379,401

Table 11.9 Excerpts from MY_SID instance B-E rollback stats last 21 days (07/08/96). Transaction table wait ratio > .05 Add rollbacks.
B/Estat Execution Gets Waits Ratio Undo Bytes
96/06/28 FRI 09:23-09:24 28 0 .00 9,576
96/06/28 FRI 09:28-16:00 2,975 0 .00 99,988
96/07/01 MON 08:00-07:36 94,101 0 .00 124,102,104
96/07/02 TUE 09:18-09:30 266 0 .00 501,942
96/07/03 WED 08:00-09:30 658 0 .00 9,632
96/07/04 THU 08:00-09:30 470 0 .00 6,880
96/07/05 FRI 08:00-09:30 470 0 .00 6,880


Previous Table of Contents Next