Re: Sqlplus behavior change or am i missing something?

Looks like they are overwriting argv[] with 0s for safety reasons ... You may be more lucky with some of the -o options of ps. Some values are sometimes saved before the program has any chance to modify its environment, for accounting. If not, you have probably no other resource than v$session.

SF

rjamya wrote:

> In versions prior to 10.1.0.4 <http://10.1.0.4>, if I run following
> command
>
> echo password | sqlplus userid_at_db @my_script.sql
>
> the ps -ef command would show sqlplus userid_at_db @my_script.sql but not
> in 10.1.0.4 <http://10.1.0.4>. It only shows sqlplus.
>
> I have spent some time RTFM/STFM but no clues. Any ideas how to get
> the script name on the command like to show?
>
> Obviously this is Unix, AIX to be specific. No OS changes, only DB
> upgraded from 10.1.0.3 <http://10.1.0.3> to 10.1.0.4 <http://10.1.0.4>
>
> TIA
> Raj
> ------------------------------
> select standard_disclaimer from company_requirements where category =
> 'MANDATORY';

--
http://www.freelists.org/webpage/oracle-l