hi folks
suppose a user issues a query
select * from emp where enum=2;
Where does oracle stores the value 2.
is that in the PGA?
If so, in which portion of pga..?
regards
sonia
Printable View
hi folks
suppose a user issues a query
select * from emp where enum=2;
Where does oracle stores the value 2.
is that in the PGA?
If so, in which portion of pga..?
regards
sonia
Not in the PGA. The PGA contains information about the OS resources used by the process and the state of that process. The statement you issue will be stored in the shared pool. You can runto find out what you have stored there.Code:select sql_text from v$sqlarea where sql_text like ... ;
2 will be stored in PGA if it´s a bind variable
hi pando/julian,
thanx
could u tell me what is stored in stack space(pga)
regards
... and if session is connected with dedicated server connection....Quote:
Originally posted by pando
2 will be stored in PGA if it´s a bind variable
yes, I should have said stored in UGA which is in PGA in dedicated server process, in shared pool when MTS is used