Checking for connected users can be done using SELECT * FROM V$SESSION or
using Instance Manager. I'm not sure that'll help your problem though - it
seems more like Oracle needs to be shut down to perform some file system
maintenace (or are you doing something with raw partitions?).
sanchang_at_my-dejanews.com wrote in message
<6snlhr$51r$1_at_nnrp1.dejanews.com>...
>Hi,
>
>How do I check if there are any users login to Oracle db? What I need is to
>increase the LP of the logical volume and was reported failed because I
need
>to umount the file system. And I could not umount the file system as it
>reported that it was busy. Please advise. Thanks in advance.
>
>best regards
>
>Sandie
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Mon Sep 07 1998 - 03:19:57 CDT
