Re: oracle processes under windows98

As in all Windows platforms, there is only one actual process, and it has threads representing each of the traditional processes in the multiprocess instance. So when Oracle is running, you should see one process (oracle80 or similar) if you type a Ctrl-Alt-Delete to see the running processes on your computer. To see the actual Oracle process threads, log into sqlplus as the user 'sys' and query V$PROCESS:

SELECT * FROM v$process;

this will show you each thread and it's function, followed by the user processes connected to the database (including the sqlplus connection you're using to perform the query).

On Sat, 21 Jul 2001 21:11:25 GMT, "sam" <dragonmanyana_at_hotmail.com> wrote:

>Hi all,
>I am new to oracle server. I have installed oracle8i under windows98. and
>now I am looking how to display all the oracle processes executed by oracle.
>please can any one help me with this issue ??
>
Received on Mon Aug 20 2001 - 20:44:25 CEST