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
|
|