1.
Data Map Hits %
Data Map Hits calculates the percentage of Data Maps in the cache that can be resolved without retrieving a page from the disk. ...
2.
DB Block Buffers Size
This data item represents the size in megabytes of the database block buffers. When a user performs a SQL query, Oracle tries to retrieve the data from the ...
3.
Using Oracle for Undergraduate Students
SQL> -- List all user tables. SQL> SELECT table_name FROM user_tables; ... load data from a file into an oracle table. To run SQL*Loader, enter the command: ...
4.
Using Oracle for Undergraduate Students
The Oracle Pro*C precompiler allows you to embed SQL statements within your C source ... Local SQL Tutorial - How to use Oracle · Stanford notes on Oracle ...
5.
Bytes Total/sec
Bytes Total/sec. Description. Bytes Total per Second measures the rate at which bytes are sent and received on the interface. ...
6.
DBWR Buffers Scanned
This data item represents the number of buffers the DBWR process scanned while looking for dirty buffers to write out. This number includes free and dirty ...
7.
DPCs Queued/sec
DPCs (Deferred Procedure Calls) Queued per Second measures the rate at which DPC objects are added to the processor's DPC queue. ...
8.
Total DPCs Queued/sec
Total DPCs (Deferred Procedure Calls) Queued per Second measures the rate at which objects are added to the processor's DPC queue. ...
9.
physical reads direct
This data item represents the number of physical reads direct that have ... value from v$segment_statistics where statistic_name = 'physical reads direct' ...
10.
Pages Input/sec
Pages Input per Second measures the number of pages read from the disk to resolve faulty memory references. This is an important metric to monitor if memory ...
