Hp PolyServe Software Manual do Utilizador

PolyServe MxS Oracle DatabaseSolution Pack Advanced I/OMonitoring User’s GuideFebruary 2004

Advanced I/O Monitoring 7Figure 1Example 2Question: How can I display the Core Reporting Elements broken out by database with 3-second granularity?Ans

Advanced I/O Monitoring 8Example 3Question: I have a very complex Oracle9i RAC environment. How can I get a “birds-eye” view of cluster-wide Database

Advanced I/O Monitoring 9• Large Data. I/O transfers of sizes greater than 16K are reported under this column. Generally, these will be full table sca

Advanced I/O Monitoring 10Figure 5 Example 6Question: I have started a script on node 5 of the cluster which adds a large amount of space to the BENCH

Advanced I/O Monitoring 11Figure 6

Copyright © 2004 PolyServe, Inc.Use, reproduction and distribution of this document and the software it describes are subject to the terms of the soft

iiiContentsAdvanced I/O MonitoringIntroduction . . . . . . . . . . .

1Advanced I/O MonitoringIntroductionOracle Database Administrators ro

Advanced I/O Monitoring 2The PolyServe MxS Oracle Database Solution Pack (MxODM) with the mxodmstat(8) command is the perfect compliment to the perfor

Advanced I/O Monitoring 3Reporting LevelsThe Core Reporting Elements can be provided at the following levels:• Cluster-Wide LevelProvides aggregate in

Advanced I/O Monitoring 4allows DBAs to get a top-level view of the impact PQO is having on the cluster, either as a whole or at the node level.• Log

Advanced I/O Monitoring 5Environment variables are passed through the lsnrctl process to the listener daemons. Hence, before starting a listener for t

Advanced I/O Monitoring 6MxODM I/O Monitoring: Practical ExamplesThis section offers several practical examples of the powerful I/O monitoring capabil