Hi,

My program connects to oracle and executes some querirs... When i Grep for sql in my linux box, I am not getting the exact query which is getting executed rather i am getting "SQL" alone like below...

anil 29605 29368 0 13:28 pts/1 00:00:00 sql

When i execute the same program in my pre-prod environments, the ps command gives the o/p of exactly which sql query is being executed...

I am not sure what to do..

Is there anything i need to do with my env variables or profile file...
Is there anything i need to do with oracle configuration... Please advice..

You can simply use the -f option of ps, to force it to display the command line arguments.

i am using ps -ef| grep -i sql only, The same works fine in a different box...