Chat now with support
Chat with Support

Spotlight on Oracle 10.4 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Resource Usage

Note: Applicable to Oracle 12c.

View resource usage of pluggable databases.

To open the Pluggable Databases | Resource Usage Page

  1. Select the Spotlight on Oracle connection in the Spotlight Browser.

  2. Click Pluggable Databases | Resource Usage.

Charts on the Pluggable Databases | Resource Usage Page

Chart Description


The rate (in milliseconds per second) at which CPU time has been consumed by each

pluggable database.

DB time

The rate of time (in milliseconds per second) each pluggable database has spent performing user calls.

Logical Reads

The rate at which data blocks are requested by each pluggable database.

A logical read occurs when Oracle finds data in the local buffer cache without needing to read the data from the physical disk.

Physical Reads

The rate at which data blocks are read from datafiles on disk (by each pluggable database).

A physical read occurs when data is retrieved from datafiles on the shared disk subsystem.

Note: These charts show no data for the first five minutes that Spotlight is monitoring the database.


Related Topics

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating