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