Re: Check Active Users on 8.1.5 Database

Hi Jose,

Do you have any idea :-

1. what will you do if you encounter some hanging processes ?

( I check by using < ps -ef | grep f60 > and find those cpu used time is very high eg: 200 hrs ! We actually kill some processes that inactive over the night by <kill -9 process-id>

2) how to trace those hanging or rather inactive procesess ?

thanks,
CS

On Wed, 11 Oct 2000 10:48:19 GMT, joseharvey_at_my-deja.com wrote:

>In article <39E43E55.E0E7169F_at_forward-hk.com>,
> Rayfil Cheung <rayfil_at_forward-hk.com> wrote:
>> Hi,
>>
>> How can I check the active users connecting to the 8.15 database.
>Hi,
>try the following connect (with dba permissions):
>select sid, serial#, osuser, username, machine from v$session where type
>= 'USER';
>
>The first two values allow you to kill the specified session:
>alter system kill session '<SID>,<SERIAL#>';
>
>Cheers,
>
>Jose
>--
>-=[ Sancho ]=-
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.

IBM RISC/6000 AIX 4.3.3
S80 Database Server
H70 Application Server
Oracle Application 11i
Oracle Database 8i Received on Mon Oct 23 2000 - 15:24:53 CEST