BY PASSING the BUFFER CACHE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: BY PASSING the BUFFER CACHE

  1. #1
    Join Date
    Feb 2001
    Posts
    82
    is it true in driect path loading - oracle by passes the buffer cache (in a HINT or in sql loader), and it directly writes to the datafiles. what if the insert or load consumes 3 extents let's say the extent size 3MB, what happens to that 3MB that has been allocated to the datafiles, does oracle reclaims that space or oracle will just leave that space. what happens to the records stored in the datafiles.


    tnx for the support.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont understand what do you mean, in direct load Oracle srtarts to write after segment“s HWM so it is not reclaims those space before HWM

  3. #3
    Join Date
    Feb 2001
    Posts
    82
    ah, so oracle writes the after the high water mark! does oracle creates only one extent it does not create in next extents defined in a table or tablespace.
    what happens when the statement fails???

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Well with Insert if it fails the transaction is rollback, I am not sure about SQL Loader because I rarely use it

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