4. Monitoring template

Organization of this chapter

• Overview of the monitoring template

• Format of alarm explanations

• List of alarms

• Buffer Cache Usage

• Buffer Cache Waits

• Dict. Cache Usage

• Disk Sorts

• Free List Waits

• Full Table Scans

• Library Cache Usage

• Redo Log Contention

• Server Status

• Tablespace Usage

• Format of report explanations

• Organization of report folders

• List of reports

• Blocking Locks(7.0)

• Cache Usage

• Cache Usage Status(Multi-Agent)

• Cache Usage Trend(Multi-Agent)

• Database Activity Status(5.0)

• Database Activity Status Detail(5.0)

• Database Activity Status(Multi-Agent)

• Database Activity Trend(Multi-Agent)

• Database Space Overview(5.0)

• Database Space Summary(Multi-Agent)(5.0)

• Database Space Trend(Multi-Agent)(5.0)

• Datafile I/O Activity Detail(5.0)

• Datafile I/O Status Detail(Reads)(5.0)

• Datafile I/O Status Detail(Writes)(5.0)

• Datafile I/O Status Summary(5.0)

• Datafile I/O Trend Detail(Reads)(5.0)

• Datafile I/O Trend Detail(Writes)(5.0)

• Datafile I/O Trend Summary(5.0)

• Disk Sorts - Top 10 Sessions(7.0)

• Fast Recovery Area Status(8.0)

• Full Table Scans

• I/O Activity - Top 10 Datafiles(7.0)

• Lock Usage - Top 10 Sessions(7.0)

• Locked Objects(7.0)

• Longest Transactions - Top 10 Sessions(7.0)

• Memory Usage - Top 10 Sessions(7.0)

• Open Cursors

• Physical I/O - Top 10 Sessions(7.0)

• Redo Log Buffer Contention

• Server Configuration Status

• Session Detail(7.0)

• Session Statistics Detail

• SGA Status(7.0)

• SGA Status Summary(7.0)

• SQL Text

• System Overview(7.0)(real-time report on the overall status of instance)

• System Overview(7.0) (real-time report on the general status of instance)

• Tablespace Status

• Tablespace Status Detail

To Page Top