OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » v$session-v$process

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

v$session-v$process [message #273986]

Fri, 12 October 2007 10:22

thorin666
Messages: 144
Registered: March 2007

Senior Member

Hello i have a question
i want to know what is a user doing
netstat -np
and i get something like this

oracle@sdp:/u01/scripts$ netstat -np |grep oracleeducar
(Not all processes could be identified, non-owned process info
 will not be shown, you would have to be root to see it all.)
tcp        0      0 10.1.0.50:1521          10.1.0.41:53278         ESTABLISHED2654/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:57107         ESTABLISHED2480/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:55818         ESTABLISHED2482/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:37897         ESTABLISHED2488/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:44601         ESTABLISHED2660/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:34397         ESTABLISHED2641/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:47436         ESTABLISHED2647/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:51014         ESTABLISHED2666/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:57727         ESTABLISHED2668/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:39548         ESTABLISHED2674/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:39539         ESTABLISHED2658/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:44400         ESTABLISHED2664/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:37489         ESTABLISHED5948/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:57746         ESTABLISHED2649/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:35467         ESTABLISHED2643/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:33417         ESTABLISHED2662/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:43948         ESTABLISHED2637/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:46765         ESTABLISHED2484/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:43999         ESTABLISHED2639/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:50645         ESTABLISHED2651/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:43719         ESTABLISHED2676/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:59843         ESTABLISHED2670/oracleeducar
tcp        0     14 10.1.0.50:1521          10.1.0.41:42237         ESTABLISHED2672/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:43503         ESTABLISHED2656/oracleeducar
tcp        0      0 10.1.0.50:1521          10.1.0.41:50408         ESTABLISHED2635/oracleeducar

and i do

select p.spid, ses.username, sql.sql_text
  from 
   v$process p, 
   v$session ses, 
   v$sql sql
  where 
   p.addr=ses.paddr and 
   ses.sql_id=sql.sql_id and 
   p.spid=2654

but i get noone row
can someone any idea of what i am doing wrong?
in advance

[mod-edit] removed IM speak

[Updated on: Fri, 12 October 2007 12:18] by Moderator

Report message to a moderator

Re: v$session-v$process [message #274720 is a reply to message #273986]

Tue, 16 October 2007 23:30

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

p.spid=2654

select sid , username from v$session;

After that,

select p.spid, ses.username, sql.sql_text
  from
   v$process p,
   v$session ses,
   v$sql sql
  where
   p.addr=ses.paddr and
   ses.sql_id=sql.sql_id and   ses.sid=260;

SPID         USERNAME
------------ -------------
SQL_TEXT
----------------------------------
5047         LOADTEST
SELECT MIN(SID) FROM V$MYSTAT

Report message to a moderator

Re: v$session-v$process [message #274721 is a reply to message #273986]

Tue, 16 October 2007 23:33

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Quote:

what i am doing wrong?

Though I see you have done nothing wrong.

Report message to a moderator

Previous Topic:	Error 997
Next Topic:	What privileges for GATHER_TABLE_STATS on table in other schema

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:59:34 CST 2024