PROCESS TABLE SCAN NOTES:
  • Username - Name of the user
  • SID - Session ID of user
  • Long Scans - Full scan of a table that has > 5 database blocks.
  • Short Scans - Full scan of a table that has <= 5 database blocks.
  • Row Retrieved - Cumulative number of rows read for full table scans.