1. User's Guide
  2. Using the CellCLI Utility
  3. CellCLI Command Reference
  4. DESCRIBE
  5. DESCRIBE QUARANTINE

7.7.5.24 DESCRIBE QUARANTINE

Purpose

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

Syntax

DESCRIBE QUARANTINE

Usage Notes

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

  • asmClusterId: Identifier of the ASM cluster. This attribute is available in Exadata software 12.2.1.1.0 and later.

  • catDBPlan: The name of the category plan

  • cellsrvChecksum: Checksum of the CELLSRV binary

  • clientPID: The process identifier for the client process which crashed the cell

  • comment: Comment for the quarantine

  • conDbUniqueID: The container database unique ID for the quarantine

  • conDbUniqueName: The container database unique name for the quarantine

  • crashReason: Reason for the crash

  • creationTime: Quarantine creation time

  • dbUniqueID: The database unique ID for the quarantine

  • dbUniqueName: The database unique name for the quarantine

  • fineGrainControl:

  • fineGrainValue:

  • incidentID: The incident identifier of the crash that caused the quarantine creation

  • interDBPlan: The name of the interdatabase resource plan

  • intraDBPlan: The name of the intradatabase resource plan

  • ioBytes: The bytes of quarantined disk region. This is applicable to disk region quarantine only.

  • ioGridDisk: The grid disk name for quarantined disk region. This is applicable to disk region quarantine only.

  • ioOffset: The I/O offset for quarantined disk region. This is applicable to disk region quarantine only.

  • name: Identifier of the quarantine

  • objectID:

  • planLineID: The SQL Plan Line identifier. This is applicable to SQL Plan quarantine only.

  • quarantineMode:

  • quarantinePlan: This is usually SYSTEM

  • quarantineReason: The reason for creation of the quarantine

  • quarantineType: The type of quarantine created

  • remoteHostName: The host name of the remote host that ran the client process that crashed the cell

  • rpmVersion: The RPM version of the cell being used when the cell crashed

  • sqlID: The SQLID of the SQL statement that crashed a cell

  • sqlPlanHashValue: The SQL Plan hash value. This is applicable to SQL Plan quarantine only.

Example 7-117 Describing the QUARANTINE Object

CellCLI> DESCRIBE QUARANTINE
        name
        asmClusterId
        catDBPlan
        cellsrvChecksum
        clientPID
        comment                modifiable
        conDbUniqueID
        conDbUniqueName
        crashReason
        creationTime
        dbUniqueID
        dbUniqueName
        fineGrainControl
        fineGrainValue
        incidentID
        interDBPlan
        intraDBPlan
        ioBytes
        ioGridDisk
        ioOffset
        objectID
        planLineID
        quarantineMode
        quarantinePlan
        quarantineReason
        quarantineType
        remoteHostName
        rpmVersion
        sqlID
        sqlPlanHashValue

Parent topic: DESCRIBE