Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Where does a PL/SQL block run? PGA or SGA?

MorvenJun 14 2011 — edited Jun 14 2011
Hi all,

11g

I'm not familiar with the oracle memory structure, if I have a simple pl/sql block as below
DECLARE
  v1 number;
BEGIN
  v1:=100;
  DBMS_OUTPUT.PUT_LINE(v1);
END;
in my mind, even though it's a small block, when i execute it, it would also consume some memory, where does this memory come from, pga or sga?

in other words, when 'pl/sql engine' needs some memory, for example, for the local variables, where does this memory come from?

many thanks.
This post has been answered by Pierre Forstmann on Jun 14 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2011
Added on Jun 14 2011
13 comments
767 views