An active request represents a client- or application-centric view of I / O requests processed by the cell node. You can view active requests on a cell node as follows.
It is possible to view active requests with cellcli via the corresponding cellnode. With the following command we can display all active requests.
1 | CellCLI> LIST ACTIVEREQUEST |
The following command can be used to display active requests in detail.
1 | CellCLI> LIST ACTIVEREQUEST DETAIL |
The following command can be used for detailed information about a specific request.
1 | CellCLI> LIST ACTIVEREQUEST istek_adi DETAIL |
The output of the commands will be as follows.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 | CellCLI> LIST ACTIVEREQUEST 2082 ORCL Datafile "BufferCache Read" CacheGet "Queued for Disk Read" 2092 ORCL Datafile "BufferCache Read" CacheGet "Network Receive" 2086 ORCL Datafile "BufferCache Read" CacheGet "Queued for Disk Read" 2088 ORCL Datafile "Selftune Checkpoint Write" CachePut "Queued for Disk Write" 0 ORCL "Smart scan" "Predicate Pushing" "Queued for Predicate Disk" 0 ORCL "Smart scan" "Predicate Pushing" "Queued for Predicate Disk" 0 TESTDB "Smart scan" "Predicate Pushing" "Queued for Predicate Disk" 0 TESTDB "Smart scan" "Predicate Pushing" "Queued for Predicate Disk" 0 TESTDB "Smart scan" "Predicate Pushing" "Queued for Predicate Disk" 0 ORCL "Smart scan" "Predicate Pushing" "Queued for Predicate Disk" 0 ORCL "Smart scan" "Predicate Pushing" "Queued for Predicate Disk" 0 ORCL "Smart scan" "Predicate Pushing" "Queued for Predicate Disk" CellCLI> LIST ACTIVEREQUEST 2082 DETAIL name: 2082 asmDiskGroupNumber: 1 asmFileIncarnation: 943569601 asmFileNumber: 366 consumerGroupID: 12553 consumerGroupName: dbID: 2857344077 dbName: ORCL dbRequestID: 2082 fileType: Datafile id: 2082 instanceNumber: 2 ioBytes: 8192 ioBytesSofar: 0 ioGridDisk: DATA_EXA1_CD_06_exa1celadm10 ioOffset: 3267212432 ioReason: "BufferCache Read" ioType: CacheGet objectNumber: 203488 parentID: 2082 pdbID: 0 requestState: "Queued for Disk Read" sessionID: 1391 sessionSerNumber: 7060 sqlID: 4hjn0cn32ar44 tableSpaceNumber: 8 |