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@db @my_script.sql
the ps -ef command would show sqlplus userid@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';
-- //www.freelists.org/webpage/oracle-l