CODEWITHSUNDEEP
oracle-databasesql-execution-plan
Hank
Hank

Reputation: 21

Explain parameters in Oracle actual execution plan

I am reading Oracle actual execution plan but I don't know about some parameters shown in exported plan: Actual execution plan

Can someone explain to me about Starts, Buffers, OMem, 1Mem and Used-Mem? Thanks for any explanation!

Upvotes: 1

Views: 377

Answers (1)

artemis
artemis

Reputation: 7241

  • Starts is the number of times that operation actually happened
  • Buffers refers to the amount of buffer read/write (IO) performed
  • OMem is the memory estimate needed to perform the operation in memory only. You can consider it as the optimal execution.
  • 1Mem is the memory estimate needed to perform the operation in a single pass (R/W from disk or temp disk). Called one-pass execution (i.e. 1Mem)
  • Used-Mem is the ACTUAL amount of memory used for the operation.

Sources:

Upvotes: 1

Related Questions