HP Storage Essentials Oracle Viewer -
Overview & Features

Overview

HP Oracle Viewer extends the HP Storage Essentials Suite with application-to-spindle management of Oracle Databases. With its powerful capacity, performance, and dependency management capabilities, this integrated Application plug-in helps ensure the availability and performance of Oracle databases and applications in Storage Area Network (SAN) environments.

HP Oracle Viewer automatically discovers Oracle databases, tablespaces, and files and graphically depicts their dependencies on the SAN. The path that each Oracle element takes through host mount points, servers, volume management software, HBAs, fabric switches, and storage systems is represented in a single, integrated view. These powerful path management capabilities, combined with real-time performance monitoring features, enable you to predict the impact of planned and unplanned SAN downtime on Oracle applications and determine the root cause of Oracle performance problems. HP Oracle Viewer also extends the full range of capacity management, role-based security, event management, reporting, and policy-based automation capabilities of HP Storage Essentials Suite to Oracle environments.

Features

Discovery and SAN dependency management

• Discovers Oracle databases, tablespaces, and files
• Correlates dependencies on host mount points, volume managers, servers, HBAs, fabric switches, and storage systems

Application Explorer with topology visualization

• Renders the storage topology from the perspective of Oracle Database, and shows all of the SAN resources in the Oracle "supply chain" (e.g. Oracle tablespaces, Oracle database files, host mount points, volume management software, host, HBA port, switch port from host, ISLs, switch port to storage system, and storage system volumes and disks).
• Identifies failover and load balancing relationships and redundant paths

Capacity management

• View Total Capacity, Total Used, Percent Used, and Available for all Oracle instances, devices, and database files
• "In context" capacity views for all dependent SAN resources (host servers, fabric switches, storage systems)
• Historical trend charts with customizable start and end dates and hourly, daily, weekly, and monthly snapshots
• Trend extrapolation for capacity planning

Performance monitoring with SmartGuideTM technology

• Real-time monitoring of key Oracle counters, including Buffer Hit Ratio; Parse CPU to Total CPU Ratio; Dictionary Hit Ratio; In Memory Sort Ratio; File Write, Read, and Total I/O Percent; Library Cache Hit Ratio; Redo Buffer Allocation Retries Ratio; Redo Logspace Request Ratio; System Event Time Waited; Tablespace Write, Read, and Total I/O Percent
• Real-time monitoring of dependent SAN resources; SmartGuide technology filters out hosts, HBA ports, switch ports, and storage system ports that are not relevant to the selected Oracle path
• Performance measurement views enable administrators to simultaneously display traffic and utilization charts that monitor individual statistics for every element in the Oracle path
• Historical trending and trend extrapolation of all Oracle and SAN resource counters

Reports

• Out-of-the-box and customizable reports on Oracle and SAN elements
• Export to PDF, XML, Excel, HTML
• Built-in auto-email and e-mail scheduling functions

Event and policy management

• Free Space and Percentage Storage Used triggers for all Oracle instances to proactively avoid out-of-space problems
• Actions for sending email, generating events, or running custom scripts or programs

Role-based Security and Organizational Groupings

• Grant read-only, asset record, and provisioning permissions to different administrators
• Block specific Oracle instances, hosts, switches and arrays from different administrators’ views