Home

Jump to bottom

Cheeyoung O edited this page Nov 17, 2022 · 58 revisions

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