Re: Asynchronous Commit in Oracle Database 10g R2


HansF wrote:
> On Sat, 27 Aug 2005 14:30:26 -0700, fitzjarrell interested us by writing:
>
> > Committing a transaction in a manner which
> > may or may not get it to the redo logs is questionable and deserves
> > CAREFUL thought and consideration before implementation.
>
> AND yet .... when loading a warehouse, or any place in which all
> transactions are repeatable, this might be perfectly acceptable. If the
> system crashed during a bulk load, wipe and restart might be better than
> recovery.
>
> As you state eelsewhere in your reply, it requires careful consideration
> and an awareness of what is right for the application.
>
> --
> Hans Forbrich
> Canada-wide Oracle training and consulting
> mailto: Fuzzy.GreyBeard_at_gmail.com
> *** I no longer assist with top-posted newsgroup queries ***

I should have said 'production OLTP applications', as that was at the
forefront of my mind as I was typing my response. Certainly a
datawarehouse is a suitable choice for asynchronous commits; such could
decrease the load time and bring the warehouse to availability much
more rapidly than standard commits.

I still stand by my statements with regard to OLTP applications. I
apologise for not making that sentiment clear in my previous response.


David Fitzjarrell

.

Relevant Pages

  • Re: Can this be done??
    ... >> As far as I know, this is impossible to be achieved in transaction. ... >> the SQL server database engine commits and rolls back transactions by ... the transaction log cannot be ... >> use DataSet.GetChanges to get the newly inserted rows. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: [PATCH] Fix bad data from non-direct-io read after direct-io write
    ... commits the transaction. ... ->releasepage if jbd is committing the transaction. ... page cache while dio holds a page reference. ...
    (Linux-Kernel)
  • Re: What are dirty pages?
    ... > buffer pool, so it does not match what is on disk. ... > When a transaction commits, the LOG records for that transaction are ...
    (microsoft.public.sqlserver.server)
  • Re: Duplicate serial in Informix 7.2.3
    ... I've developed an webservice application which accesses an informix ... opens a transaction inserts values in 3 tables (let's call them ... A, B and C), and commits it. ... I would contact IBM Tech Support and see. ...
    (comp.databases.informix)
  • Re: TEXT datatype, transactions, and al.
    ... If you absolutely must guarantee uniqueness, ... you call your function and insert all within a single transaction, ... your update to counter commits, and then your insert fails for any ... need to create a specific set of values or maybe add a check digit to a ...
    (comp.databases.sybase)