why not switch on the SESSION audit option for all the users ??
> ----------
> From: mohan krishnaraj[SMTP:mohan.krishnaraj_at_tatainfotech.com]
> Sent: Wednesday, July 05, 2000 10:56 AM
> To: Surya Rao; patrick.bellard_at_francetelecom.fr; baiju_at_mahindrabt.com; oracledba_at_lazydba.com
> Subject: Re: When the db was last accessed..
>
> Hi,
>
> From the alert and listener log, I hope we can view when the database was
> last accessed,
>
> Mohan.
> ----- Original Message -----
> From: Surya Rao <surya.rao_at_reuters.com>
> To: <patrick.bellard_at_francetelecom.fr>; <baiju_at_mahindrabt.com>;
> <oracledba_at_lazydba.com>
> Sent: Tuesday, July 04, 2000 11:04 PM
> Subject: Re: When the db was last accessed..
>
>
> > If the DB was accessed via sql*net or net8, it
> > would work, but not for local connections, I
> > guess.
> >
> > surya
> > ------
> >
> > MIME-Version: 1.0
> > Content-type: text/plain; charset=x-user-defined
> > Content-transfer-encoding: QUOTED-PRINTABLE
> >
> > See the file $ORACLE_HOME/network/log/listener.log
> >
> > Patrick Bellard
> > Little DBA
> > P.S.: Je vous pris de bien vouloir excuser mon niveau d'anglais.
> >
> > ----- Message d'origine -----
> > De : Baiju Anthony <baiju_at_mahindrabt.com>
> > =C0 : Oracle dba lazy <oracledba_at_lazydba.com>
> > Envoy=E9 : mardi 4 juillet 2000 08:04
> > Objet : When the db was last accessed..
> >
> >
> > > Hi all,
> > >
> > > Is there a way to find out when a database was last accessed by
> > > anyone from user community. We have a development environment
> > > where a SUN SPARC is running SUN OS 5.6 and Oracle 8.0.3/8.0.6
> > > The RAM is 256 M !. Six development databases are running. A
> > > seventh
> > > one wants to go up and fails to get shared segment.
> > >
> > > I wish to know, which of the current running databases was not
> > > accessed in
> > > say last 3 day's, so that I can get in touch with respective people
> > > to ask them
> > > if there database can go down, for somebody else ?
> > >
> > > Thanks in Advance.
> > > Baiju
> > >
> > >
> > >
> > > --------
> > > If you're bored, then visit the list's website: http://www.lazydba.com
> (u=
> > pdated daily)
> > > to unsubscribe, send a blank email to
> oracledba-unsubscribe_at_quickdoc.co.u=
> > k
> > > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> > >
> >
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated
> > daily)
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
> > -----------------------------------------------------------------
> > Visit our Internet site at http://www.reuters.com
> >
> > Any views expressed in this message are those of the individual
> > sender, except where the sender specifically states them to be
> > the views of Reuters Ltd.
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
> (updated daily)
> > to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
>
> --------
> If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
Received on Tue Jul 04 2000 - 22:57:28 CDT
