Re: NOLOGGING Option on Create Table

On Mon, 08 Apr 2002 16:04:32 GMT, Daniel Morgan <damorgan_at_exesolutions.com> wrote:

>I'll throw my hat into the ring on this one. About six or seven years ago I was at
>Boeing and lobbied Oracle heavily to do something for data warehouse applications. I
>was running Oracle 7.3.x on Amdahl mainframes and had to truncate every table on
>Friday night and have hundreds of gigabytes of data loaded on an all-or-nothing basis
>by Monday morning. That anything might slow it down or cause a failure ... be it
>rollback or logging, or whatever was a constant source of pain.
>
>I'd have gladly suffered the slings and arrows of unhappy management once or twice a
>year when hardware failed rather than the weekly grind of being stoned because the
>data load wasn't completed on time.
>
>What would be nice ... would be a feature in PL/SQL that duplicates the functionality
>of DIRECT LOAD in SQL*Loader. Something like a BULK COLLECT followed by writing
>blocks directly bypassing the SQL engine.
>
>How about it Tom?
>
>Daniel Morgan
>

I'm not Tom, but I think your proposal will increase Oracle financial results, because they now will have OTS people with DUL flying all around the globe.
Just count in the newsgroup archives how often people want logging turned off completely. My gut feeling says that those are all people who don't realize the ramifications of turning logging off. From experience I can say that anyone who ever experienced without a proper backup NEVER wants to experience that again. If you are up to a CLM (Career Limiting Move) you are of course free to turn archive logging off.
IMO, that management you are referring to is just penny wise and pound foolish as they don't supply you with appropiate resources to complete the data load on time. You should proof you can't do that in the time available and confront them weekly with that fact, because if your system crashes and you can't recover, you will be stoned also. Just choose what you prefer.
It's not an issue of archive logging or no archive logging, it is an issue of improperly thought out applications and/or management not willing to pay for the functionality they requested.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Apr 08 2002 - 11:38:26 CDT