Re: V$ Views
From: <art_at_unsu.com>
Date: Wed, 27 May 2009 07:04:28 -0700 (PDT)
Message-ID: <a906da6e-d666-4c89-b221-434801668c82_at_21g2000vbk.googlegroups.com>
On May 26, 3:42 pm, joel garry <joel-ga..._at_home.com> wrote:
> On May 26, 12:58 pm, a..._at_unsu.com wrote:
>
> > Hi,
>
> > I'm looking at some Oracle documentation and they are not really clear
> > on that the following items are in V$SESSION & V$PROCESS:
>
> > V$SESSION - process
> > V$PROCESS - pid & spid
>
> > They cannot all be server process ID's.......
>
> It becomes a little more clear when you actually check these things on
> a real system. Remember, Oracle has its process id, while the OS has
> its own process id, which on some systems may not be a process at all.
>
> Note the PADDR in V$SESSION is an address, which can be used to find
> the process in V$PROCESS. In there, there is the Oracle process, PID,
> and the OS process, SPID. The PROCESS column in V$SESSION is the
> client process, so you may see the "process" for a completely
> different OS.
>
> 1 select sid, process from v$session
> 2* where rownum < 4
> SYS_at_XXXX > /
>
> SID PROCESS
> ---------- ------------
> 231 10616
> 234 10616
> 235 5684:4476
>
> So here we see there are two Oracle session identifiers with the same
> unix process, so obviously at least one of them is expired. The one
> with a colon in it is a client on Windows.
>
> SYS_at_TPRD> select a.sid, a.process, b.pid, b.spid from v$session a, v
> $process b where a.paddr=b.addr and a.sid in (231,234,235);
>
> SID PROCESS PID SPID
> ---------- ------------ ---------- ------------
> 235 5684:4476 206 10436
> 234 10616 208 10618
> 231 10616 209 10620
>
> If you were to do a ps -ef (or whatever your local equivalent is)
> grepping for those processes, you might see children owned by the init
> process, while others might show that they are local or remote
> connections.
>
> jg
> --
> _at_home.com is bogus.http://www3.signonsandiego.com/stories/2009/may/26/1n26texting235813-...
Date: Wed, 27 May 2009 07:04:28 -0700 (PDT)
Message-ID: <a906da6e-d666-4c89-b221-434801668c82_at_21g2000vbk.googlegroups.com>
On May 26, 3:42 pm, joel garry <joel-ga..._at_home.com> wrote:
> On May 26, 12:58 pm, a..._at_unsu.com wrote:
>
> > Hi,
>
> > I'm looking at some Oracle documentation and they are not really clear
> > on that the following items are in V$SESSION & V$PROCESS:
>
> > V$SESSION - process
> > V$PROCESS - pid & spid
>
> > They cannot all be server process ID's.......
>
> It becomes a little more clear when you actually check these things on
> a real system. Remember, Oracle has its process id, while the OS has
> its own process id, which on some systems may not be a process at all.
>
> Note the PADDR in V$SESSION is an address, which can be used to find
> the process in V$PROCESS. In there, there is the Oracle process, PID,
> and the OS process, SPID. The PROCESS column in V$SESSION is the
> client process, so you may see the "process" for a completely
> different OS.
>
> 1 select sid, process from v$session
> 2* where rownum < 4
> SYS_at_XXXX > /
>
> SID PROCESS
> ---------- ------------
> 231 10616
> 234 10616
> 235 5684:4476
>
> So here we see there are two Oracle session identifiers with the same
> unix process, so obviously at least one of them is expired. The one
> with a colon in it is a client on Windows.
>
> SYS_at_TPRD> select a.sid, a.process, b.pid, b.spid from v$session a, v
> $process b where a.paddr=b.addr and a.sid in (231,234,235);
>
> SID PROCESS PID SPID
> ---------- ------------ ---------- ------------
> 235 5684:4476 206 10436
> 234 10616 208 10618
> 231 10616 209 10620
>
> If you were to do a ps -ef (or whatever your local equivalent is)
> grepping for those processes, you might see children owned by the init
> process, while others might show that they are local or remote
> connections.
>
> jg
> --
> _at_home.com is bogus.http://www3.signonsandiego.com/stories/2009/may/26/1n26texting235813-...
Actually Joel, I'd like to tap your brain one more time.......
Oracle refers to a CPU TIME & ELAPSED TIME. What are those? Is CPU time the actual time the process has been running?
Also, from within Oracle, is there a good way to get CPU Usage in a number that makes sense? Like a percentage? And, lastly, can I find out how long a query has been 'running'? not how long it will take, but how long it has been executing? not using 'timing on', as this will run within a block.....
Thanks for your time...... Received on Wed May 27 2009 - 09:04:28 CDT