Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How do blocks,segments,extents nad rbs and redo logs all tie together??

How do blocks,segments,extents nad rbs and redo logs all tie together??

From: Dan Roberts <roberts_d_at_bms.com>
Date: Fri, 06 Nov 1998 21:14:13 -0500
Message-ID: <3643ACF4.9D54E67F@bms.com>


Hello All..I know this is quite an order to expalin this...But I am looking for a simple explaination..because as a newbie DBA I am running into problems with understanding these ideas..

I am running Oracle 7.3.3.0.0 on UNIX IRIX 6.4 My question is..how and what are blocks, segments and extents and how are they used by tablespaces and etc??

Also how does a redo log, rollback segement work together?/For example..If I would like to change my SSN in my employee table how does the rollback and redo logs all come into play?? The redo holds the old information from the table while the redo log contains the new info before it gets written to the dbf file??.>Thnaks for any and all help!!!>>Dan Received on Fri Nov 06 1998 - 20:14:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US