Message-Id: <10549.111200@fatcity.com> From: Oracle DBA Shluchot Date: 5 Jul 00 05:57:31 EDT Subject: Data Dictionary Poster Hi list - CA (Computer Associates) has a HUGE (approximately 115x90 cm - I haven't = found a place to hang it yet - and I have a real office, not a cubicle) 8i Data= Dictionary poster. They gave it out at the ilOUG (Israel Oracle Users' Gr= oup) annual meeting, which was held yesterday in Tel Aviv. (It was a great mee= ting, lots of tech talk, and no mention of departing executives, industrial espionage, or dropping stock prices. Though in a demo, the lecturer used = IBM's share price as an example and not Oracle's). I don't know if CA will send the poster for the asking, but I'm enjoying = mine :-) . I suppose it can't hurt to request it. Their website is www.cai.com= =2E Daniel ____________________________________________________________________ Get free email and a permanent address at http://www.amexmail.com/?A=3D1 ------------------------------ From: Rahul Date: Wed, 5 Jul 2000 10:57:28 +0700 Subject: RE: When the db was last accessed.. why not switch on the SESSION audit option for all the users ?? > ---------- > From: mohan krishnaraj[SMTP:mohan.krishnaraj@tatainfotech.com] > Sent: Wednesday, July 05, 2000 10:56 AM > To: Surya Rao; patrick.bellard@francetelecom.fr; baiju@mahindrabt.com; oracledba@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 > To: ; ; > > 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 > > =C0 : Oracle dba lazy > > 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.