Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Is it just me

Re: Is it just me

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Wed, 11 Aug 2004 14:30:43 +0100 (BST)
Message-ID: <20040811133043.59097.qmail@web86908.mail.ukl.yahoo.com>


Its like the "audit" facility on a system I've recently seen. ins/upd/del on every single table - every single row change logged to a single audit table which (in order to handle all tables) has columns (renamed to preserve anonymity)

id    number         (surrogate key)
dt    date           (timestamp)
typ   varchar        (ins/upd/del)
ta    varchar2       (tablename)
c1    varchar2(2000)  first column of table 
c2 varchar2(2000) next column of table c3 varchar2(2000) next column of table ...
...
c200 varchar2(2000) next column of table

So now there's several hundred million records in there...Also a bit of bummer that pretty much any kind of analysis query simply never comes back within reasonable time frames (if it all...).

Thus its data stored that will never be read :-)


Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"


                                  
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun!  http://uk.messenger.yahoo.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Wed Aug 11 2004 - 08:27:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US