Hi


This is not working
regards/sudheer

SQL> SELECT * FROM v$SESSION WHERE AUDSID = (select
sys_context('USERENV','SESSI
ONID') from dual);
SELECT * FROM v$SESSION WHERE AUDSID = (select
sys_context('USERENV','SESSIONID'
) from dual)
*
ERROR at line 1:
ORA-00942: table or view does not exist
-----Original Message-----
From: Ganesh Raja [mailto:[Email Address Removed] Thursday, January 31, 2002 12:54 PM
To: LazyDBA.com Discussion
Subject: RE: Help reqd


SELECT * FROM v$SESSION WHERE AUDSID = (select
sys_context('USERENV','SESSIONID') from dual);

Remeber the AudSid for SysDBA is 0.

Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019



Oracle LazyDBA home page