CODEWITHSUNDEEP
oracle-databasestored-procedures
Rafael Adonis
Rafael Adonis

Reputation: 3

Oracle behavior multiple calls for the same procedure

First sorry for my bad english but go to the problem, I have multiple calls for the same procedure and I would like to know when working with multiple calls to the same procedure Oracle uses one instance for each call or static mode to work, running a call at a time.

Upvotes: 0

Views: 640

Answers (1)

toddlermenot
toddlermenot

Reputation: 1618

If you are talking about variables in a SP, when making multiple calls, they are not shared. Oracle will allocate space for the instance variables separately in PGA each time the SP is invoked.

Upvotes: 1

Related Questions