Home

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)

parser (SQL)

component registry

• database feature usage statistics

ASM

• disks, diskgroups, operations and statistics