RE: data block waits

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Wed, 6 Sep 2000 17:12:36 +1000
Message-Id: <10610.116271@fatcity.com>

Hi Vivek,

You are right. This is a very basic question. You could have answered it yourself by reading the documentation on TechNet, by searching on MetaLink, or even by checking the Ixora web site. Nevertheless, lest you think I'm in a bad mood, I'll answer your question.

Of course FREELISTS = 1 does not prevent concurrent inserts. It merely fails to reduce the risk of buffer busy waits on the data block on the head of the freelist should multiple concurrent inserts be attempted.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

@ Going to OpenWorld?
@ Catch the Ixora performance tuning seminar too!
@ See http://www.ixora.com.au/seminars/ for details.

-----Original Message-----
From: VIVEK_SHARMA [mailto:VIVEK_SHARMA_at_infy.com] Sent: Wednesday, 6 September 2000 15:53
To: 'gajav_at_yahoo.com'; 'steve.adams_at_ixora.com.au' Cc: 'ORACLE-L_at_fatcity.com'; 'oracledba_at_quickdoc.co.uk' Subject: RE: data block waits

A very basic Qs.

Qs. What are Disadvantages with Default Value of FREELISTS = 1 ? STORAGE(INITIAL 20480 NEXT 16384
REM MINEXTENTS 1 MAXEXTENTS 121 PCTINCREASE 50 FREELISTS 1 FREELIST REM GROUPS 1) Qs. Does it Prevent Concurrent inserts/... ? Received on Wed Sep 06 2000 - 02:12:36 CDT