Home - cheeyoung/sqlplus-public GitHub Wiki
Welcome to the sqlplus-public wiki!
workload capture
- SQL text, (execution) plan, (optimizer) statistics, and bind variable(s) (Bind capture)
- memory components: SGA and PGA
workarea
undo
- transaction (recovery)
- statistics by 10 minutes for 4 days
redo and physical standby
real application cluster (RAC)
- gc blocks lost
parallel execution (PX)
optimizer statistics
flashback
data warehouse (DW)
data objects
database objects (by types)
database instance
- statistics
- parameters
database dictionary
cursor (SQL)
- SQL ID and text (parent cursor)
- execution plan (child cursor)
- object dependency (shared pool)