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

Home -> Community -> Usenet -> c.d.o.tools -> database buffer cache / SGA

database buffer cache / SGA

From: stevek <stefano1_at_att.net>
Date: Fri, 20 Jul 2001 01:24:27 GMT
Message-ID: <3B577825.1BB18144@att.net> 






Oracle server receives a request from a client, run sql through sqlarea
in cache, if there runs,if not runs through plan process then executes,
if data in buffer cache uses that data otherwise get block(s) from
tablespace.



Question: oracle deals with data in blocks only, block 8K, record 1K.
Does oracle take 7 additional records on the block read? Does it use the
same block size/number of records when it puts changed data in redo logs
and rbs?
Received on Thu Jul 19 2001 - 20:24:27 CDT












Original text of this message













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