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.