Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle 10g: SQL Statements KEPT in the Shared Pool

Re: Oracle 10g: SQL Statements KEPT in the Shared Pool

From: Juan Carlos Reyes Pacheco <juancarlosreyesp_at_gmail.com>
Date: Wed, 22 Nov 2006 09:03:27 -0400
Message-ID: <cd4305c10611220503rba17012k15d3ae5aca12d60b@mail.gmail.com>


About the value of the parameter for me is true, why is false in your instance, I didn't change it?
Oracle 10.2.0.2.0

select

        nam.indx+1                            numb,
        nam.ksppinm                           name,
        val.ksppstvl                          value,
        nam.ksppity                           type,
        val.ksppstdf                          is_default,
        decode(bitand(nam.ksppiflg/256,1),
               1,'True',

'False'
) is_session_modifiable, decode(bitand(nam.ksppiflg/65536,3), 1,'Immediate', 2,'Deferred' , 3,'Immediate',
'False'
) is_system_modifiable, decode(bitand(val.ksppstvf,7), 1,'Modified', 4,'System Modified',
'False'
) is_modified, decode(bitand(val.ksppstvf,2), 2,'True',
'False'
) is_adjusted, nam.ksppdesc description from x$ksppi nam, x$ksppsv val where nam.indx = val.indx and nam.ksppinm = '_kks_use_mutex_pin'
;
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 22 2006 - 07:03:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US