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 -> Re: Difference between db_block & extent?

Re: Difference between db_block & extent?

From: <poohland_at_hotmail.com>
Date: Thu, 06 Aug 1998 19:38:48 GMT
Message-ID: <6qd0o8$f3d$1@nnrp1.dejanews.com>


db_block is the Oracle block size. Usually it is the size of the OS block or a multiple of it. Extent is a group of db_block together. Everytime Oracle expands the size of an object. It will get a group of db_block (which is a extent). And the size of the extent (no. of db_block) that it will try to get is specified when you create the object.

Winnie

In article <35c959fa.27440631_at_news.twsc.pouchen.com.tw>,   violin.hsiao_at_mail.pouchen.com.tw (Violin) wrote:
> Hello,
> Does anyone tell me what the difference is between db_block
> and extent?
> Please cc to : violin.hsiao_at_mail.pouchen.com.tw,Thank you :)
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Aug 06 1998 - 14:38:48 CDT

Original text of this message

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