Writer instructions

Page title

For most spaces, this page must be titled Space announcements.

For spaces with localized content, this page must be titled Space announcements l10n.

Purpose

Provide an announcement banner on every page of your space.

Location

Move this page outside of your home branch.

Guidelines

Announcement Support for this product will end on December 22, 2025. To monitor Oracle databases, we recommend that you use PATROL for Oracle Enterprise Database.

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


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.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

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


 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


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.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

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.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline.

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

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*