Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
10 Cards in this Set
- Front
- Back
session logical reads
|
The total number of requests to access a block, whether in memory or on disk
|
|
physical reads
|
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.
|
|
physical reads direct
|
The number of blocks read, bypassing the buffer cache, excluding direct reads for large objects (LOBs).
|
|
physical reads direct (lob)
|
The number of blocks read while reading LOBs, bypassing the buffer cache.
|
|
V$BH
|
shows the data object ID of all blocks that currently reside in the SGA
|
|
soft parse, or a library cache hit
|
the parsed representation of the statement does exist in the library cache and it can be shared, then Oracle reuses the existing code
|
|
The statistic that shows the amount of reloading (that is, reparsing) of a previously cached SQL statement that was aged out of the cache
|
the RELOADS column in the V$LIBRARYCACHE view
|
|
The INVALIDATIONS column in V$LIBRARYCACHE view
|
shows the number of times library cache data was invalidated and had to be reparsed
|
|
V$PGASTAT
|
This view gives instance-level statistics on the PGA memory usage and the automatic PGA memory manager
|
|
V$PROCESS
|
This view has one row for each Oracle process connected to the instance.
|