DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Data flow

  1. #1
    Join Date
    Apr 2003
    Posts
    353

    Data flow

    Hi

    I am a bit confused about the data flow of Inserts.

    When updations are taking place,
    oracle places the blocks from datafiles to the SGA..

    But when insert is taking place
    how it is dealt..? It is written to the
    redo log buffer then to log files..
    then How it is coming to the data files..?

    Thanks
    giri

  2. #2
    Join Date
    Jan 2003
    Location
    india
    Posts
    175
    check point triggers dbwriter.

    dbwriter updates datafiles.

    even a log switch can cause a check point.

  3. #3
    Join Date
    Apr 2003
    Posts
    353
    Sorry Still I am not clear..

    Any links,, which details this flow of insertion data into
    data files.

    Thanks very much
    Giri

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Read the Concepts Guide -- it's all in there.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width