Availability reports


Warning

This feature is no longer supported by any of the KM's supported versions. From version 9.7.11.01, the feature is no longer available. For more information see, 9.7.11.01: Fix pack 1 for PATROL for Oracle Database.

PATROL provides the following reports to determine space, lock and extent availability on the instance:

  • Space and lock information
    • Free Space
    • Lock Conflicts
    • Object Space Analysis
    • Space Usage by Object
  • Extent information
    • Auto Extend DBFiles
    • Free Space Deficit
    • Maximum Extents
    • Temporary Extents

Getting space and lock information

Use the reports in this section to determine space availability and lock information.

Determining free space in tablespaces

The Free Space report provides free space information for all tablespaces on the instance.

Choose Reports > Availability > Free Space from the INSTANCE menu, or Reports > Free Space from the AVAILABILITY menu.

The report appears in a text window. The following table shows the information that the report provides.



Free Space report

Item

Description

Tablespace Name

name of the tablespace

Total Space

total space allocated to the tablespace

Space Used

space used in the tablespace

Space Left

free space in the tablespace

Percent Free

percentage of free space available in the tablespace


Determining how much space an object is using

The Object Space Analysis report provides information about the size of the object and the number and size of its extents.

  1. Choose Reports > Availability >Object Space Analysis from the INSTANCE menu, or Reports > Object Space Analysis from the AVAILABILITY menu for that instance.
  2. Select the type of object for which you want the space analysis and the schema for that object. Click Accept.
    The following table shows the information that the report provides.



    Object Space Analysis report description

    Item

    Description

    Object Name

    name of the object

    Size (bytes)

    size of the object in bytes

    Size (blk)

    size of the object in blocks

    Extents

    number of extents in the rollback segment

    Next Extent

    size of the next extent to be allocated to the segment

    Min Extents

    minimum number of extents that are allowed in the segment

    Max Extents

    maximum number of extents that are allowed in the segment

    % Inc

    percentage to use to increase the size of the next allocated extent

Determining if objects are using too much space

The Space Usage by Object report provides information about the size and space of the object.

  1. Choose Reports > Availability >Space Usage by Object from the INSTANCE menu, or Reports > Space Usage by Object from the AVAILABILITY menu for that instance.
  2. Select the type of object for which you want the space analysis and the schema for that object. Click Accept.
  3. Select the object for which you want information and click Accept.

The following table shows the information that the report provides.

Space Usage By Object report

Item Description
Report for table
Tablespace Name name of the tablespace
% Free minimum percentage of free space in a block
% Used minimum percentage of used space in a block
Init Trans initial transactions
Init Extent size of the initial extent in the table
Next Extent size of the next extent to be allocated to the segment
Min Extents minimum number of extents allowed in the segment
Max Extents maximum number of extents allowed in the segment
% Inc percentage to use to increase the size of the next allocated extent
Blocks size in blocks of the table
Report for index
Tablespace Name name of the tablespace that the index is in
Table Name name of the table that the index exists on
Table Type type of the table
Status status of the index, either DIRECT LOAD or INVALID
Uniqueness uniqueness status of the index, either UNIQUE or NONUNIQUE
Init Extent size of the initial extent in the table
Next Extent size of the next extent to be allocated to the segment
Min Extents minimum number of extents allowed in the segment
Max Extents maximum number of extents allowed in the segment
% Inc percentage to use to increase the size of the next allocated extent
Report for cluster
Tablespace Name name of the tablespace that the cluster exists in
Cluster Type type of the cluster
% Free minimum percentage of free space in a block
% Used minimum percentage of used space in a block
Init Trans initial transactions
Init Extent size of the initial extent in the table
Next Extent size of the next extent to be allocated to the segment
Min Extents minimum number of extents allowed in the segment
Max Extents maximum number of extents allowed in the segment
% Inc percentage to use to increase the size of the next allocated extent

Determining lock conflicts

The Lock Conflicts report provides information about current conflicting locks.

Choose Reports > Availability > Lock Conflicts from the INSTANCE menu, or Reports > Lock Conflicts from the AVAILABILITY menu. If no conflicting locks exist, you are informed by using a response box.

All sessions, with their SID and serial number, are listed in the report. The following table shows the information that the report provides.



Lock conflicts report

Item

Description

Wait User Name

name of the user that is waiting for a lock

Wait UID

ID of the user that is waiting for a lock

Lock Type

type of lock the object is waiting for

Lock Object

object that is locked

Wait Lock Mode

mode of waiting that the object is using

Hold User Name

name of the user that is holding the lock

Hold UID

ID of the user that is holding the lock

Hold Lock Mode

mode of the holding lock


Getting extent information

The following parameters monitor extent problems with tablespaces and tablespace objects:

  • CannotExtend
  • ExtentsLeft
  • ExtentsLeftPct
  • FreeSpaceDeficit
  • RSExtentsLeft
  • RSExtentsLeftPct

You can also run the following reports:

  • Auto Extend DBFiles Report
  • Free Space Deficit Report
  • Maximum Extents Report
  • Temporary Extents Report

Running the AutoExtend DBFiles report

The AutoExtend DBFiles report lists the database files that have the autoextend feature enabled.

Choose Reports > Availability > Auto Extend DBFiles Report from the INSTANCE menu, or Reports > Auto Extend DBFiles Report from the AVAILABILITY menu.

The report appears in a text window. Upgrading and preserving customizations shows the information that the report provides.



AutoExtend DB Files report description

Item

Description

Tablespace Name

tablespace name

DB File Name

database file name

Next Extent

size of the next extent

Max Extent

maximum number of extents

Header File

header file for the database file


Running the Free Space Deficit report

The Free Space Deficit report lists all database objects which have insufficient space to allocate their next extent.

  1. Choose Reports > Free Space Deficit from the AVAILABILITY menu, or Reports > Availability > Free Space Deficit from the INSTANCE menu.
  2. Select the type of object or select all objects, and click Accept.
    The report displays in a text window. The following table shows the information that the report provides.



    Free Space Deficit report

    Item

    Description

    Next Extent

    size of the next extent

    Max Available

    size of the largest extent that is available

    Deficit

    difference between the size of the next extent and the size of the largest extent that is available

    Type

    type of segment that does not have enough extent space

    Segment Name

    segment name that does not have enough extent space

    Tablespace

    tablespace that the segment is in

    Owner

    owner of the tablespace that the segment is in

Finding the maximum extents for all tablespaces

The Maximum Extents report lists the extent information for tablespaces in the instance.

  1. Choose Reports > Availability > Maximum Extents from the INSTANCE menu, or Reports > Maximum Extents from the AVAILABILITY menu for that instance.
  2. Enter the Maximum Extents Threshold setting, select a tablespace, and click Accept.
    This setting is the threshold for extents. When an object reaches this threshold, the object appears on the report. If you select ALL TABLESPACES, extent information for all tablespaces on the instance is displayed.

    The following table shows the information that the report provides.



    Maximum Extents report

    Item

    Description

    Segment

    name of the segment that has reached the threshold

    Type

    type of segments

    Tablespace

    tablespace that the segment is in

    Current Extents

    current number of extents that the segment has

    Max Extents

    maximum number of extents that the segment can have

    Extents Left

    number of extents that the segment has left

    Pct Max

    percentage of the maximum number of extents that the segment has reached

Getting tablespace temporary extent information

The Temporary Extents report lists all temporary segments which have reached 50 percent or more of their maximum extents limit.

  1. Choose Reports > Availability > Temporary Extents from the INSTANCE menu or*Reports > Temporary Extents* from the AVAILABILITY menu.
  2. Select the tablespace or tablespaces you want information about, or select ALL TABLESPACES. Click Accept.
    The following information is displayed for each segment:
    • name of temporary segment
    • associated tablespace name
    • current number of extents
    • maximum number of extents specified for this segment
    • system limit of maximum extents for a segment
    • percent of maximum extents currently allocated
Was this page helpful? Yes No Submitting... Thank you

Comments