Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Unix - Top identifying processes in Oracle

Unix - Top identifying processes in Oracle

From: Jerra <jerra_at_aland.net>
Date: Fri, 1 Sep 2000 14:54:17 +0300
Message-ID: <8oo5d9$218$1@gandalf.alcom.aland.fi> 






I can see Oracle processes that take more resources than others in Top.
With the Top's PID the process can be viewed in v$process.



Is it possible to get some relation to v$session from v$process?



The problem is that all apps connect as the same user to the database so
it's not possible to identiy them by username.




Anyone got any ideas?




/Jerra
Received on Fri Sep 01 2000 - 06:54:17 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US