gd6502_at_eudoramail.com wrote:
> gazzag wrote:
>
>> select username, osuser, lpad(sid,4)||', '||lpad(serial#, 6) Proc,
>> program, to_char(logon_time, 'DD-Mon-yy HH24:MI:SS') Logon
>> from v$session
>> where username is not null
>> order by username, osuser, Logon;
>>
>
> It say to me "table or view not exists".
> I already tried something about this, but I can't find the object in
> any schema (I think it should be in SYS). Where can I find it?
> After the object will be found, can I execute the query as a
> non-administrator user?
> Thanks
>
> Peppe
v$ "magic" views are owned by SYS. You need to have a DBA run the
query for you.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Dec 12 2006 - 11:18:33 CST
