Re: SQL statements

news.working.it wrote:

> Hi,
>
> I have an instance of Oracle8i 8.1.7.3.0 on Windows 2000 and
> I'd like to know if I can get from the SGA (or somewhere else)
> all the recent SQL statements issued by a specific db user.
> I'd like to do that just with my SQLPlus (not with Toad !)
>
> Thanks,
> Iron

There have been numerous posts on this subject in the group over the last few months. I'd suggest looking at the google archives. Search for things referring to:

v_$open_cursor

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)