LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 04-20-2009, 02:56 AM   #1
vjayraghavan
LQ Newbie
 
Registered: Feb 2009
Posts: 15
Blog Entries: 1

Rep: Reputation: 0
problems with process name when executing sql querirs


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..
 
Old 04-20-2009, 03:28 AM   #2
colucix
LQ Guru
 
Registered: Sep 2003
Location: Bologna
Distribution: CentOS 6.5 OpenSuSE 12.3
Posts: 10,509

Rep: Reputation: 1978Reputation: 1978Reputation: 1978Reputation: 1978Reputation: 1978Reputation: 1978Reputation: 1978Reputation: 1978Reputation: 1978Reputation: 1978Reputation: 1978
You can simply use the -f option of ps, to force it to display the command line arguments.
 
Old 04-20-2009, 03:34 AM   #3
vjayraghavan
LQ Newbie
 
Registered: Feb 2009
Posts: 15
Blog Entries: 1

Original Poster
Rep: Reputation: 0
i am using ps -ef| grep -i sql only, The same works fine in a different box...
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
oppinion wanted on executing an sql script frieza Programming 2 03-05-2009 03:51 PM
Executing a process at login G4tsu Linux - General 8 11-04-2008 09:21 PM
How to find the process ID of process executing in the background akeneche Linux - Newbie 1 01-03-2008 10:08 AM
java code executing SQL statements problem randomx Programming 1 11-09-2004 10:59 AM
PostgreSQL: executing a .SQL file from command line? J_Szucs Linux - Software 0 09-24-2003 11:49 PM


All times are GMT -5. The time now is 02:41 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration