Pga

[Sonia]

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

[julian]

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 run

select sql_text from v$sqlarea where sql_text like ... ;

to find out what you have stored there.

[pando]

2 will be stored in PGA if it´s a bind variable

[Sonia]

hi pando/julian,


thanx

could u tell me what is stored in stack space(pga)


regards

[jmodic]

Originally posted by pando
2 will be stored in PGA if it´s a bind variable

... and if session is connected with dedicated server connection....

[pando]

yes, I should have said stored in UGA which is in PGA in dedicated server process, in shared pool when MTS is used