Originally posted by: tux2015

Hello,

we have a SAP System on AIX 6.1 (6100-07-09-1341), with Oracle 11.2.xx.

Need to set: LDR_CNTRL=SHARED_SYMTAB=N.

I did this in .dbenv_<HOSTNAME>.csh and .dbenv_<HOSTNAME>.sh for ora<SID> User.

But wanna have set this without shutdown/start from Oracle / Downtime on workdays.

Wanna use the Automated Offline Force Backup for this.

( is then the Variable set and the Oracle not use the  Shared Symbol Table )

How to check if a binary use shared symbol table ?

Thanks

Originally posted by: j.gann

Hi,

you can check the individual environment of a process with:

ps eww <pid>

processes typically inherit their environment from their parent process (like the shell or a start-script), and do not change it during runtime (although they can do this with putenv()).

the Environment variable you mention is most likely being interpreted by the loader when the program is initially loaded, so you can be reasonably sure the program has been loaded with the semantics mentioned if you see it in the above output for the PID in question.

hope this helps

Joachim

Originally posted by: tux2015

thanks a lot Joachim!