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)

redo

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

optimizer statistics

column group statistics (extended statistics)

• USER_STAT_EXTENSIONS view

column statistics

• histograms

database dictionary

• source code
• object dependency
• java objects
• unicode support

cursor (SQL)

• SQL ID and text from v$sqlarea or v$sql

component registry

• database feature usage statistics

ASM

• disks, diskgroups, operations and statistics