Home » RDBMS Server » Server Administration » v$session-v$process
v$session-v$process [message #273986] Fri, 12 October 2007 10:22 Go to next message
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 Go to previous messageGo to next message
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
Re: v$session-v$process [message #274721 is a reply to message #273986] Tue, 16 October 2007 23:33 Go to previous message
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.
Previous Topic: Error 997
Next Topic: What privileges for GATHER_TABLE_STATS on table in other schema
Goto Forum:
  


Current Time: Thu Dec 08 00:24:52 CST 2016

Total time taken to generate the page: 0.13316 seconds