Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/10

Click to flip

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.