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.

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.

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.

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

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.

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.

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.

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.

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.

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