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

undo

• transaction (recovery)
• statistics by 10 minutes for 4 days

redo

• v$archived_log on primary database
• v$archive_gap, v$dataguard_stats and v$managed_standby on physical standby

real application cluster (RAC)

• gc blocks lost

parallel execution (PX)

• px_ and PX%

optimizer statistics

flashback

data objects

• Large Objects (LOBs)
• index(es) and constraint(s)

database objects

database dictionary

• source code
• object dependency
• unicode support

cursor (SQL)

• SQL ID and text (parent cursor)
• (child cursors)

component registry

• database feature usage statistics

ASM

• disks, diskgroups, operations and statistics