Kevin Toepke scribbled on the wall in glitter crayon:
Can anyone out there in oracle-l land help me give a reasonable
estimate?
billions and billions.;-)
--
Bill Shrek ThaterOracle DBA BAARF Party member #25
[EMAIL PROTECTED]
String? Length of??
It realy does depend on how much you want to audit, and how frequently, and
how big your system is, and how much traffic it carries etc etc.
For example, if no one used your db for a month, your audit tables would be
pretty small (grin!)
peter
-Original Message-
Kevin,
It widely depends on what you are auditing, and how (eg per access / per session).
If it's per access (certainly an overkill) a sum(executions) from v$sql group by
command_type can put you on the right tracks for the number of records you may expect
(check also the oldest loading
From our production ERP DB:
SELECT MIN(timestamp), MAX(timestamp), AVG(rowsperday), SUM(rowsperday)
FROM
(
SELECT TRUNC(timestamp) TIMESTAMP, COUNT(*) ROWSPERDAY
FROM dba_audit_trail
GROUP BY TRUNC(timestamp)
) UNION
SELECT SYSDATE, SYSDATE, 0, SUM(bytes)
FROM dba_extents de
WHERE
What do you want to audit. If all table access then I would think you
would impact performance. Are you just trying to audit signon's? If
so, the apps does that automatically.
Jeffrey BeckstromDatabase AdministratorGreater Cleveland Regional
Transit Authority1240 W. 6th StreetCleveland,
, Rich
Sent: Wednesday, June 18, 2003 10:19 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Oracle Auditing
From our production ERP DB:
SELECT MIN(timestamp), MAX(timestamp), AVG(rowsperday),
SUM(rowsperday)
FROM
(
SELECT TRUNC(timestamp) TIMESTAMP, COUNT(*) ROWSPERDAY
FROM dba_audit_trail
Lee,
what version of the database? I'm thinking a logon trigger here, to capture
and write the session info to a table
Rachel
From: Robertson Lee - lerobe [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Oracle Auditing
Date:
For the list, because we have already discussed it... nope, it's an 8i
feature
From: Robertson Lee - lerobe [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Oracle Auditing
Date: Wed, 11 Jul 2001 07:11:43 -0800
Rachel
erm... looks like 8i only for logon triggers.
Thanks anyway
Lee
-Original Message-
Sent: 11 July 2001 16:12
To: Multiple recipients of list ORACLE-L
Rachel,
Version is 8.0.5.0.0 - any good ??
TIA
Lee
-Original Message-
Sent: 11 July 2001 14:36
To: Multiple recipients