[askdba] Re: Need help with Interview Questions

  • From: Nisar Tareen <ntareen@xxxxxxxxx>
  • To: askdba@xxxxxxxxxxxxx
  • Date: Tue, 9 Nov 2004 05:36:12 -0800 (PST)

Thanks for the note, It do support my view, Please read my note again, I am 
saying the same, I never talk about 1 extent, I emphasis few is better than 


So taking the following note, if you have multiple extent in thousands Oracle 9 
will also show the strain on resources. Weather there is a technical issue on 
Oracle 8 or Oracle 7 I don't know, but as I had mentioned by reducing extent I 
do get better response. I am not an advocate of cynical 1 extent lobby.  But 
for sure few extents are better than 100 and 1000's depending on the data and 
size of each tables.


Nisar Tareen 

Ganesh Raja <ganesh.raja@xxxxxxxxx> wrote:
Okay Read this Intresting Post .. 


Guys . Pls Dont Start to Compress to One Extent after u have read this
Post .. It does not make sense .. Think abt other stuff first ... as
Jonathan Lewis Says there ... :)


On Mon, 8 Nov 2004 14:53:34 +0000, Ganesh Raja wrote:
> Nisar,
> Did not Understand too much from your Post .. But How does all the
> things that you have talked about affect the way parallelism works ..
> Parallelism is CPU Bound and not disk bound ... U dictate if you want
> to Use Parallelism and then The ur Query/DML is Split across multiple
> processess that works out how to fetch data from the database and
> processes it.
> I am disagreeing here with irfhan also when he says that Multiple
> extents will give u chances of better parallelism. U can write a small
> testcase with a One Extent Table and See what happens .. U will still
> get Parallel Reads.
> The Only thing that has some effect on performance with Multiple
> Extent is the MBRC value since an Multi Block read cannot be done over
> multiple extents. [ U will never encounter this has a Problem]
> Apart from that i will never say that if you have 1000 Extents ur
> Query is Going to Perform badly and if you have 1 Extent it will
> perform any better. I need a test case from u to prove that the
> otherway.
> Extent has always been a Logical Grouping of Blocks and not a
> Physicall Grouping.
> My $0.02 and not my logic ... :)
> Rgds
> Ganesh

Do you Yahoo!?
 Check out the new Yahoo! Front Page. www.yahoo.com

Other related posts: