Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.


Share this Page URL
Help

Chapter 13: Using TotalStorage Productiv... > Data Manager reporting capabilities - Pg. 592

Count of chained rows Chained rows can have an impact on database access performance. This issue can be monitored using the Chained Row Count Greater than table Alert trigger. Count of Used table extents You can monitor the need for table reorganization using the table Alert trigger Segment has more than n extents . Freelist count You cannot monitor the count of freelists in an Oracle table using Data Manager for Databases. 13.10 Data Manager reporting capabilities The reporting capabilities of Data Manager are very rich, with over 300 predefined views. You can see the data from a very high-level; for example, the total amount of free space available over the enterprise; or from a low-level, for example, the amount of free space available on a particular volume or a table in a database. The data can be displayed in tabular or graphical format, or can be exported as HTML, Comma Separated Variable (CSV), or formatted report files. The reporting function uses the data stored in the Data Manager repository. Therefore, in order for reporting to be accurate in terms of using current data, regular discovery, Ping, Probe, and Scan jobs must be scheduled. These jobs are discussed in 13.3, "OS Monitoring" on page 533.