Re: schema auditing

From: Kimberly Smith <KSMITH1_at_gmd.fujitsu.com>
Date: 03 May 2000 11:12:41 -0700
Message-Id: <10486.104839@fatcity.com>

--=_ORCL_5969098_0r0
Content-Type:text/plain; charset="iso-8859-1" Content-Transfer-Encoding:quoted-printable

One day when I was a developer some DBA did that to me and did it ever slow down my conversion since it was nothing but insert/update/delete and doing so none stop.
Whatever you do take the audit table out of the system tablespace. I think the table is aud$ or something like that. I believe one of the Oracle manuals go though the steps to do this.

I would question why the auditor wants this on every table. Maybe you could talk
them into just a couple of tables.

Kimberly Smith
EDS/Fujitsu
Gresham, Oregon
Work: 503-669-6050
Email: kimberly.smith_at_gmd.fujitsu.com

kimberly.smith_at_eds.com

--=_ORCL_5969098_0r0
content-type:message/rfc822

Date: 03 May 2000 11:59:09
From:"Jeffrey Beckstrom" <JBECKSTROM_at_gcrta.org> To:Multiple recipients of list ORACLE-L <ORACLE-L> Subject:schema auditing
Reply-to:UNIX.IOGMD:ORACLE-L_at_fatcity.com Return-Path:root_at_fatcity.cts.com

Message-ID:<F001.0015758E.20000503105909_at_fatcity.com> X-Comment:Oracle RDBMS Community Forum
X-Sender:"Jeffrey Beckstrom" <JBECKSTROM_at_gcrta.org> Sender:root_at_fatcity.com
Errors-To:ML-ERRORS_at_fatcity.com
Organization:Fat City Network Services, San Diego, California X-ListServer:v1.0f, build 68; ListGuru (c) 1996-2000 Bruce A. Bergman Precedence: bulk
MIME-Version: 1.0
Content-Type:text/plain; charset=US-ASCII Content-Transfer-Encoding:quoted-printable

Our auditors have requested that I turn on database auditing to capture all updates, deletes and inserts that are done in the database. Does anyone do this on a regular basis.

Jeffrey Beckstrom
Database Administrator
Greater Cleveland Regional Transit Authority 1240 W. 6th Street
Cleveland, Ohio 44113
(216) 781-4204

-- 
Author: Jeffrey Beckstrom
  INET: JBECKSTROM_at_gcrta.org

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
=00
--=_ORCL_5969098_0r0--

------------------------------

 From: Bruce Bergman <bbergman_at_BridgeMedical.com>
 Date: Wed, 3 May 2000 11:15:57 -0700 
 Subject: ADMIN: LastMail command (was: Q: Is the new list online)

In a message, Schoen Volker <v.schoen_at_inplan.de> wrote:

> 

> Today there are no mails from the list. Is the list online?

> 

> Mit freundlichen Gr=FC=DFen

Just wanted to point out to everyone that there is an easier way to find out
if everything is fine with the list, and/or if you've missed messages.  Send
a message to:

	ListGuru_at_fatcity.com

And in the message BODY, put:

	LASTMAIL ORACLE-L
or
	ALLMAIL ORACLE-L

ListGuru will then send you back a message with either the headers of the
last message posted, or the headers of ALL the messages posted since
midnight (depending on which command you use).  This way you can check up
with what has been posted, find out if the list is working, etc.  The best
part is that you don't have to send "is the list alive" type messages to the
list, which seem to just make everyone unhappy. :-)

thanks,
bruce

------------------------------

 From: "Madhavan Amruthur" <mad012000_at_hotmail.com>
 Date: Wed, 03 May 2000 11:34:51 PDT
 Subject: Re: Tune for 'db file sequential read'

Hi Deepak,
The db file sequential read usually ndicates wait for sequential block reads 
(indexes mostly). Check to see if you have any buffer busy waits and if 
there are buffers that is being contended upon. You can query the x$bh

Received on Wed May 03 2000 - 13:12:41 CDT