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 |
Availability reports
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.
- Choose Reports > Availability >Object Space Analysis from the INSTANCE menu, or Reports > Object Space Analysis from the AVAILABILITY menu for that instance.
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.
- Choose Reports > Availability >Space Usage by Object from the INSTANCE menu, or Reports > Space Usage by Object from the AVAILABILITY menu for that instance.
- Select the type of object for which you want the space analysis and the schema for that object. Click Accept.
- 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.
- Choose Reports > Free Space Deficit from the AVAILABILITY menu, or Reports > Availability > Free Space Deficit from the INSTANCE menu.
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.
- Choose Reports > Availability > Maximum Extents from the INSTANCE menu, or Reports > Maximum Extents from the AVAILABILITY menu for that instance.
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.
- Choose Reports > Availability > Temporary Extents from the INSTANCE menu or*Reports > Temporary Extents* from the AVAILABILITY menu.
- 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