Re: Unix program to return connected process ids
From: Alvin Law <alaw_at_oracle.com>
Date: 4 Jan 95 01:35:15
Message-ID: <ALAW.95Jan4013515_at_ap226sun.oracle.com>
Date: 4 Jan 95 01:35:15
Message-ID: <ALAW.95Jan4013515_at_ap226sun.oracle.com>
In article <1994Dec30.030825.26166_at_mother.bates.edu> rspell_at_bates.edu (Rob Spellman) writes:
> I'm looking for a program which will print out a list of the unix
> process ids which are connected to an Oracle database. My idea is to
> use this program to disconnect process from Oracle before shutting down
> the database with an dbshut.
You can write a Pro*C/OCI program to read all the active processes connected to the database in the view v$process. You then have to kill them one by one (in the C program perhaps). It's a bit clumsy but it gets the job done.
--
___
(o o)
+-oo0-\_/-0oo---------------------------------------------------------------+
| Alvin Law .. Project Leader, Applications Division ... Oracle Corporation |
| Email: alaw_at_us.oracle.com ..... Voice: 415.506.8317 . Fax: 415.506.7299 |
+---------------------------------------------------------------------------+
ORA-03113: end-of-file on communication channel
Received on Wed Jan 04 1995 - 01:35:15 CET