SRM Oracle Reports

Topics | How To | Related Topics

SRM reports provide a sleek, versatile, and easy-to-use reporting framework that enables you to easily and effectively choose, view, and analyze vital data. Customized reporting is available through the selection of filter criteria (e.g., individual columns, specific clients, specific client computer groups, etc.) and filters as described in SRM Reports.

From the CommCell Console, the SRM Report Manager provides these types of reports:

• Computer Inventory
• Cost Analysis
• Applications

Initial templates are provided for each type (e.g., Cost History by Application, Capacity by File System, etc.) where columns have been preselected. The only requirement before generating and displaying the report is to specify one or more client computers. For most reports, a data collection job must also have been run prior to generating the report.

Reports can be customized by adding or removing columns in the initial templates or specifying additional Filter Criteria.

This following table lists:

• The category/columns that can be selected.
• A description of the category.
• For each type of data collection job, if data is collected for the column, it is marked with a . Running an Discovery and Analysis Job may be required to produce complete and accurate data. An Analysis Job also includes the data collected by a Discovery Job.

For step-by-step instructions on generating reports, see Display, Run, or Schedule a Report Manager Report for step-by-step instructions.

Category/Column	Description	SRM Oracle Agent
		Discovery Job	Discovery and Analysis Job
ASM Disk Details	(Automatic Storage Management) In an ASM instance, it displays details for every disk discovered by the instance, including disks which are not part of any disk group. In a database instance, it displays details for disks in disk groups that are in use by the database instance. Use this report column to identify disks that are not part of a disk group, and to monitor read/write performance.
Bytes Read
Bytes Written
Created
Free Space
Header Status
Mode Status
Mount Status
Mounted
Name
Number
Read Errors
Redundancy Type
State
Total Space
Write Errors
ASM Disk Group Details	(Automatic Storage Management) In an ASM instance, it displays information about every disk group discovered by the instance. In a database instance, it displays information about every ASM disk group mounted by the local ASM instance. Use it to obtain general properties of ASM disk groups.
Allocation Unit Size
Block Size
Free Space
Name
Number
Redundancy Type
Sector Size
State
Total Space
ASM Template Details	(Automatic Storage Management) Displays properties of every template that is present in every disk group mounted by the ASM instance. Use it to obtain general properties of ASM templates.
Name
Number
Redundancy Type
Stripe
System
Client	Displays aspects of each client and their respective subclients on which the SRM Oracle Agent is installed.
Computer
Host Group
Sub Client
Client Properties	Displays aspects of the client computer on which the SRM Oracle Agent is installed.
Hostname
Memory
Operating System
OS Vendor
OS Version
Processors
Service Pack
SP Version
Time Zone
Database Details	Summarizes aspects of the content database in order to obtain database details, and to monitor space utilization.
Control File Creation Date
Control File Time
Control File Type
Creation Date
DBid
Flashback On
Force Logging
Guard Status
Host Name
Log Mode
Open Mode
Platform Name
Protection Mode
Remote Archive
Reserved Space
Reserved Space Rank
Role
Switchover Status
Unique Name
Used Space
Utilization
Version
Database Usage History	Displays overall database statistics. Useful for trending purposes.
As Of
Reserved Space
Used Space
Utilization
Datafile Details	Summarizes aspects of each datafile in order to obtain database details and monitor space utilization.
Autoextensible
Available
Blocks
Bytes
Data File
File Id
Increment By
Max Bytes
Relative Fno
User Bytes
Index Details	Displays aspects of the B-tree indexes used by Oracle to allow faster retrieval of records.
Average Data Blocks per Key
Average Leaf Blocks per Key
BLevel
Cluster Factor
Compression
Distinct Keys
Free Space
Generated
Index
Ind Level
Leaf Blocks
Number of Rows
Owner
Partitioned
Reserved Space
Reserved Space Rank
Secondary
Temporary
Type
Uniqueness
Used Space
User Stats
Valid
Index Usage History	Provides a historical view of the B-tree indexes used by Oracle. Useful for trending purposes.
As Of
Reserved Space
Used Space
Utilization
Instance Details	Displays information on the Calypso instance created in the CommCell Browser tree that represents the database that needs to be backed up.
Active State
Actual Redo Blocks
Archiver
Database Status
Estimated Cluster Available Time
Estimated Mttr
Host Name
Log Switch Wait
Logfile Size Redo Blocks
Logs Bytes
Optimal Logfile Size
Parallel
Recovery Estimated IOs
Startup Time
Status
Target Mttr
Target Redo Blocks
Version
Instance Usage History	Displays a log of the instance usage. Useful for trending purposes.
As Of
Log Archive Space
Oracle Entities	Displays overall aspects per each computer selected (e.g., database, instance, etc.)
Database
Instance
Tablespace
RMAN Archived REDO Log Details	Displays aspects of redo logs that Oracle has filled with redo entries, rendered inactive, and copied to one or more log archive destinations.
Block Size
Blocks
First Time
Next Time
REC ID
Sequence
Stamp
Stamp Thread
RMAN Backup Details	Provides a detailed history of all backups, such as parallelization of backup data streams, and backup files retention policy.
Backup Type
File
File Size
File Type
Keep
Keep Options
Keep Until
Status
RMAN Corruption Details	Displays information of each recorded block corruption symptoms at the file level.
Block Number
Blocks
File Number
Type
RMAN Database Corruption Details Details	Displays information of each recorded block corruption symptoms at the database level.
Block Number
Blocks
File Number
Marked Corrupt
REC ID
Stamp
Type
RMAN Datafile Details	Displays aspects of redo logs that Oracle has filled with redo entries, rendered inactive, and copied to one or more log archive destinations.
Blocks
Checkpoint Time
Completion Time
Control File Type
Creation Time
File Number
Increment Level
Marked Corrupt
REC ID
Reset Log Time
RMAN Job Details	Displays aspects of every task performed by the Recovery Manager (RMAN), such as the time it started and the operation involved.
Bytes Processed
End Time
Operation
REC ID
Row Type
Sid
Stamp
Start Time
Status
RMAN REDO Log Details	Displays aspects of redo logs, which Oracle uses to record all changes made to the database.
Archived
Block Size
Blocks
First Time
Flash Recovery
Name
Next Time
REC ID
Stamp
Standby
Status
Thread
Table Details	Displays information of tables in the Oracle database in order to to identify tables and monitor space utilization.
Average Space
Backed Up
Blocks
Chain Count
Clustered
Empty Blocks
Free Space
Index Used Space
Number of Rows
Owner
Partitioned
Reserved Space
Reserved Space Rank
Skip Corrupt
Table
Temporary
Used Space
Table Usage History	Displays overall table usage statistics. Useful for trending purposes.
As Of
Index Used
Total Used
Used Space
Utilization
Tablespace Details	Displays details of the tablespace in order to obtain properties of individual tablespaces and monitor increase in tablespace.
% Increase
Allocation Type
ASSM
Big File
Block Size
Contents
Extents Local
Free Space
Initial Extent
Max Extents
Min Extents
Minimum Extent Length
Next Extent
Reserved Space Rank
Reserved Space
Status
Table Compression
Used Space
Utilization
Tablespace Usage History	Displays overall tablespace usage statistics. Useful for trending purposes.
As Of
Reserved Space
Used Space
Utilization
User Details	Displays details of all users in the Oracle database such as user accounts per user name.
Account Status
Created
Expiry Date
Lock Date
Name
Profile
Reserved Space
Temporary Tablespace
Used Space
Utilization

Back to Top