| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Commit boundary <-> Stripe Unit Size Co-relation
Vivek - Just to add to Connor's statements (wow am I being rash here),
Oracle's strength is that it's architecture disconnects transactions from
disk writes. On one hand, block may be modified several times before being
written to disk (hot block, for instance). On the other hand, Oracle may
need buffer space and write a block to disk before a transaction commits.
But Oracle keeps track of all this and can straighten everything out if the
transaction is rolled back or the system crashes.
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com
-----Original Message-----
Sent: Wednesday, February 12, 2003 12:04 AM
To: Multiple recipients of list ORACLE-L
CASE - If Size of 1 INSERT/UPDATE Statement = 1K & Stripe Unit Size is 128 K ?
How will 1 COMMIT issued after 300 "1K" INSERT/UPDATE Statements DIFFER from 1 COMMIT issued after EACH "1K" INSERT/UPDATE Statement with respect to Writing to the datafiles on the Underlying Striped Volume ?
If 1 INSERT Statement Data is Written to the 1st Disk (say) of the Striped Volume , will a Repeat of the SAME INSERT Statement Write to a Different Underlying Disk of the same Striped Volume within the SAME Segment Extent ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Feb 12 2003 - 09:24:04 CST
 |
 |