7.7.5.1 DESCRIBE ACTIVEREQUEST

Purpose

The DESCRIBE ACTIVEREQUEST command displays a list of attributes for the ACTIVEREQUEST object type.

Syntax

DESCRIBE ACTIVEREQUEST

Usage Notes

The attributes for the DESCRIBE ACTIVEREQUEST command can include the following:

  • asmDiskGroupNumber: Number of the Oracle ASM disk group

  • asmFileIncarnation: Incarnation number of the Oracle ASM file

  • asmFileNumber: Number of the Oracle ASM file

  • consumerGroupID: Identifier of the consumer group

  • consumerGroupName: Name of the consumer group

  • dbID: Database unique name

  • dbName: Database name

  • dbRequestID: Identifier of the database request

  • fileType: File type associated with the request

  • id: Unique identifier of the active request

  • instanceNumber: Instance number associated with the request

  • ioBytes: Number of bytes of I/O against the grid disk in the current session

  • ioBytesSoFar: Number of total bytes of I/O

  • ioGridDisk: Grid disk used by a request

  • ioOffset: Measure of the offset on the grid disk

  • ioReason: Reason for I/O activity, such as a control-file read

  • ioType: Type of active request, such as file initialization, read, write, predicate pushing, filtered backup read, or predicate push read

  • name: Unique name of the active request

  • objectNumber: Object number associated with the request

  • parentID: Identifier of the parent request

  • pdbID: Identifier of the pluggable database

  • requestState: State of the active request, such as

    • Accessing Disk

    • Computing Result

    • Network Receive

    • Network Send

    • Queued Extent

    • Queued for Disk

    • Queued for File Initialization

    • Queued for Filtered Backup Read

    • Queued for Network Send

    • Queued for Predicate Pushing

    • Queued for Read

    • Queued for Write

    • Queued in Resource Manager

  • sessionID: Identifier of the session

  • sessionSerNumber: Serial number of the database session

  • sqlID: Identifier of the SQL command associated with the request

  • tableSpaceNumber: Tablespace number associated with the request

Example 7-93 Describing the ACTIVEREQUEST Object

This example shows the DESCRIBE command with the ACTIVEREQUEST object. 

CellCLI> DESCRIBE ACTIVEREQUEST

         name
         asmDiskGroupNumber
         asmFileIncarnation
         asmFileNumber
         consumerGroupID
         consumerGroupName
         dbID
         dbName
         dbRequestID
         fileType
         id
         instanceNumber
         ioBytes
         ioBytesSofar
         ioGridDisk
         ioOffset
         ioReason
         ioType
         objectNumber
         parentID
         pdbID
         requestState
         sessionID
         sessionSerNumber
         sqlID
         tableSpaceNumber

Parent topic: DESCRIBE