Re: sp_who equivelant in Oracle 8i
From: Brian E Dick <bdick_at_cox.net>
Date: Fri, 24 Jan 2003 18:31:34 GMT
Message-ID: <aEfY9.8910$GX4.438141_at_news2.east.cox.net>
Date: Fri, 24 Jan 2003 18:31:34 GMT
Message-ID: <aEfY9.8910$GX4.438141_at_news2.east.cox.net>
Start with
select *
from v$session
Then look at the other v$ views.
"DiggidyMack69" <DiggidyMack69_at_hotmail.com> wrote in message
news:c86ce4f.0301240722.7b9866b5_at_posting.google.com...
> Hello folks,
> Is there a command that normal users and use to determine
> running/locked etc queries in Oracle? In the SQLServer world you can
> use sp_who which will give you a good overview of what's going on. Is
> there an oracle equivelant and if so should users be able to run it?
>
> Thanks,
> DM
Received on Fri Jan 24 2003 - 19:31:34 CET