C.2.13 DBA_HIST_CELL_IOREASON
The DBA_HIST_CELL_IOREASON view displays historic information about the reasons for performing I/Os on the cells. This is a snapshot of V$CELL_IOREASON.
                  
| Column | Datatype | NULL | Description | 
|---|---|---|---|
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               NOT NULL  | 
                           
                               Unique snapshot identifier.  | 
                        
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               NOT NULL  | 
                           
                               Database identifier for the snapshot.  | 
                        
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               NOT NULL  | 
                           
                               Hash number that uniquely identifies the cell.  | 
                        
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               NOT NULL  | 
                           
                               Incarnation number of the cell.  | 
                        
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               NOT NULL  | 
                           
                               Unique identifier for the I/O reason.  | 
                        
| 
                               
  | 
                           
                               VARCHAR2(257)  | 
                           
                               User readable I/O reason.  | 
                        |
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               Number of I/O requests performed for the reason.  | 
                        |
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               Number of IO Bytes performed for the reason.  | 
                        |
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               The database identifier.  | 
                        |
| 
                               
  | 
                           
                               NUMBER  | 
                           
                               The identifier of the container identified by CON_DBID. Possible values are as follows: 
  | 
                        |
| 
                              
                               
  | 
                           
                              
                               NUMBER  | 
                           
                              
                               Number of read requests for the reason. This value includes the flash reads counted in the
                                      | 
                        |
| 
                              
                               
  | 
                           
                              
                               NUMBER  | 
                           
                              
                               Number of write requests for the reason. This value includes the flash writes counted in the
                                      | 
                        |
| 
                              
                               
  | 
                           
                              
                               NUMBER  | 
                           
                              
                               Number of flash read requests for the reason. This value is a subset of  the value in the
                                      | 
                        |
| 
                              
                               
  | 
                           
                              
                               NUMBER  | 
                           
                              
                               Number of flash write requests for the reason. This value is a subset of  the value in the
                                      | 
                        
Parent topic: Automatic Workload Repository Views