Re: sp_who equivelant in Oracle 8i

The closest thing to sp_who is probably a select from v$session and v$process.

• Jusung Yang

DiggidyMack69_at_hotmail.com (DiggidyMack69) 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 - 20:58:37 CET