Thread: Pga
-
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 run
Code:
select sql_text from v$sqlarea where sql_text like ... ;
to find out what you have stored there.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
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
-
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....
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
yes, I should have said stored in UGA which is in PGA in dedicated server process, in shared pool when MTS is used
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|