DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Pga

Hybrid View

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    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


  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    2 will be stored in PGA if it´s a bind variable

  4. #4
    Join Date
    Feb 2002
    Posts
    267
    hi pando/julian,


    thanx

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


    regards

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  


Click Here to Expand Forum to Full Width