ORACLE PARAMETER "_OPTIM_PEEK_USER_BINDS"

[Former Member]

Hello,

How can I check if my SAP instalations should

have this "_OPTIM_PEEK_USER_BINDS" parameter set

to FALSE?

I'm running Oracle 9i.

The SAP is 4.6D.

[fidel_vales · Accepted solution]

>

> Hello,

>

> How can I check if my SAP instalations should

> have this "_OPTIM_PEEK_USER_BINDS" parameter set

> to FALSE?

Hi,

You "should" not check if your installations "should" have that parameter.

Your installations MUST have that parameter.

It is a setting required for quite a long time, indicated on the note 124361 for oracle < 10g and note 830576 for oracle 10g

[stefan_koehler]

Hell Rui,

the easiest way to check is the following:

> shell> sqlplus "/ as sysdba"

> SQL> show parameter optimpeek_user_binds

or you can take a look at your init.ora / spfile (if you have set the value and not using the default):

> cd /oracle/<SID>/920_XX/dbs/

> cat init<SID>.ora | grep -i peek

> cat spfile<SID>.ora | grep -i peek

For parameter recommendation have a look at sapnote #124361

Regards

Stefan