Re: Looking for a scripts, e.g. showing me User-Login in Oracle

mtnman2k_at_hotmail.com (mtnman2k) wrote in message news:<63f1fe3.0411151512.121d8a41_at_posting.google.com>...
> Patricia.Klimek_at_gmail.com (Patricia Klimek) wrote in message news:<92a8efc9.0411150254.1f79404d_at_posting.google.com>...
> > Hello,
> >
> > I'm looking for a Script I can use with Oracle that showes me
> > User-logins within a day and current logins; current performed Actions
> > on Oracle-DB with SQL; Showing me the current size of the logfile.
> > Useful scripts for Database Administrators working with Oracle 9i.
> > That is basically what I'm looking for.
> > Or a site that shows me how to write easy a script for my needs.
> > Thank you
> >
> > Patricia
>
> SELECT B.USERNAME, B.SID, B.SERIAL#, A.EVENT, A.TOTAL_WAITS,
> A.TOTAL_TIMEOUTS, A.TIME_WAITED, A.AVERAGE_WAIT
> FROM V$SESSION_EVENT A, V$SESSION B
> WHERE A.SID = B.SID
> ORDER BY 1
> /
>
> column machine format a20
> column osuser format a20
> column module format a20
>
> select machine, process, osuser, username,
> schemaname, status, lockwait, sid,
> serial#, module, action
> from v$session
> where username is not null
> and osuser is not null
> order by machine, osuser, username,
> schemaname, status, module;

Thank you for your help, I tried both and it works great. Thanks again.

Patricia Received on Tue Nov 16 2004 - 13:02:04 CET