Monitoring

Front 1

session logical reads

Back 1

The total number of requests to access a block, whether in memory or on disk

Front 2

physical reads

Back 2

The total number of requests to access a data block that resulted in access to datafiles on disk. The block could have been read into the cache or read into local memory by a direct read.

Front 3

physical reads direct

Back 3

The number of blocks read, bypassing the buffer cache, excluding direct reads for large objects (LOBs).

Front 4

physical reads direct (lob)

Back 4

The number of blocks read while reading LOBs, bypassing the buffer cache.

Front 5

V$BH

Back 5

shows the data object ID of all blocks that currently reside in the SGA

Front 6

soft parse, or a library cache hit

Back 6

the parsed representation of the statement does exist in the library cache and it can be shared, then Oracle reuses the existing code

Front 7

The statistic that shows the amount of reloading (that is, reparsing) of a previously cached SQL statement that was aged out of the cache

Back 7

the RELOADS column in the V$LIBRARYCACHE view

Front 8

The INVALIDATIONS column in V$LIBRARYCACHE view

Back 8

shows the number of times library cache data was invalidated and had to be reparsed

Front 9

V$PGASTAT

Back 9

This view gives instance-level statistics on the PGA memory usage and the automatic PGA memory manager

Front 10

V$PROCESS

Back 10

This view has one row for each Oracle process connected to the instance.