Re: Is it just me
- From: Connor McDonald <hamcdc@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 11 Aug 2004 14:30:43 +0100 (BST)
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 :-)
--- Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
> On Wed, 11 Aug 2004 06:52:21 -0500, Cary Millsap
> <cary.millsap@xxxxxxxxxx> wrote:
> > If you ever saw a system that was write-mostly over the long term, then
> > there's data going in that's never coming out. You'd have to wonder why
> > someone would pay money to store things that are never retrieved.
>
=====
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@xxxxxxxxx
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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
