Re: sp_who equivelant in Oracle 8i
From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 24 Jan 2003 12:00:42 -0800
Message-ID: <1b061893.0301241200.4698b1b0_at_posting.google.com>
Date: 24 Jan 2003 12:00:42 -0800
Message-ID: <1b061893.0301241200.4698b1b0_at_posting.google.com>
v$sql should be what you're looking for. You need a direct grant or be able to read the data dictionary to see it.
Daniel
> 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 - 21:00:42 CET