Re: Oracle Connections

From: Dave <david.sharples3_at_ntlXworld.com>
Date: Mon, 31 May 2004 20:52:06 +0100
Message-ID: <9VMuc.485$PQ.28@newsfe3-win.server.ntli.net>

"Jim" <JimHeavey_at_nospam.com> wrote in message news:Xns94FA8FC4CAAB3JimHeaveyhotmailcom_at_216.168.3.44...
> I am trying to figure out how to write a query which will tell me then
> number of connections I have opened with and ASP.Net application. I found
> the following "SELECT SID, SERIAL#, STATUS FROM v$session WHERE OSUSER =
> 'ASPNET'", but when I run it in TOAD it highlights "v$session".
>
> Does this mean I lack sufficient authority or should I be using a
different
> object for Oracle *.1.7?

Should work if you have the right priveleges, try it from sql*plus to make sure either way. If you need access to that view you will need to be granted select on it Received on Mon May 31 2004 - 14:52:06 CDT