RE: Little competition

From: Naveen, Nahata (IE10) <Naveen.Nahata_at_honeywell.com>
Date: Thu, 11 Dec 2003 04:04:34 -0800
Message-ID: <F001.005D98BA.20031211040434@fatcity.com>

Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C3BFDF.E5440BC0" ------_=_NextPart_001_01C3BFDF.E5440BC0
Content-Type: text/plain;
charset="iso-8859-1"

Well, Googling this statement, one can easily find the source of this statement :-)

Naveen

-----Original Message-----
Sent: Thursday, December 11, 2003 5:09 PM To: Multiple recipients of list ORACLE-L

Little competition for you all :)

It's a two part question:

What's wrong with the following piece of expert analysis ?
Which well know "Oracle Guru" published this (and continues to display it on his web-page) ?

"Sadly, Oracle9i doesn't allow you to specify the value for PCTFREE if you're using automatic space management. This is a serious limitation because Oracle9i can't know in advance about the amount of VARCHAR expansion in a table row, leading to excessive row chaining and poor access performance."

SQL> create table
  2 test_table
  3 (c1 number)
  4 tablespace
  5 asm_test
  6 storage
  7 ( pctfree 20 pctused 30 )
  8 ;

( pctfree 20 pctused 30 )
*
ERROR at line 7:
ORA-02143: invalid STORAGE option

However, here's an important point. While Oracle9i rejects the PCTFREE and PCTUSED parameters with locally managed tablespaces with automatic space management, it does allow you to enter invalid settings for NEXT and FREELISTS settings"

You've gotta love it !!

Sorry no clues ....

Cheers ;)

Richard

------_=_NextPart_001_01C3BFDF.E5440BC0
Content-Type: text/html;
charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 6.00.2462.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><SPAN class=546490312-11122003><FONT face="Courier New" color=#0000ff
size=2>Well, Googling this statement, one can easily find the source of this statement :-)</FONT></SPAN></DIV>
<DIV><SPAN class=546490312-11122003><FONT face="Courier New" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=546490312-11122003><FONT face="Courier New" color=#0000ff
size=2>Naveen</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr

style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> <DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Richard Foote [mailto:richard.foote_at_bigpond.com]<BR><B>Sent:</B> Thursday, December 11, 2003 5:09 PM<BR><B>To:</B> Multiple recipients of list ORACLE-L<BR><B>Subject:</B> Little competition<BR><BR></FONT></DIV>

  <DIV><FONT face=Arial size=2>Little competition for you all :)</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>It's a two part question:</FONT></DIV>
  <UL>

<LI><FONT face=Arial size=2>    What's wrong with the following piece of expert analysis ?</FONT> <LI><FONT face=Arial size=2>    Which well know "Oracle Guru" published this (and continues to display it on his web-page) ?</FONT></LI></UL>

  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>"Sadly, Oracle9i doesn't allow you to specify the

value for PCTFREE if you're using automatic space management. This is a serious limitation because Oracle9i can't know in advance about the amount of VARCHAR expansion in a table row, leading to excessive row chaining and poor access performance."</FONT></DIV>

  <DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial><FONT size=2><SPAN class=code>SQL&gt; create

table</SPAN><BR><SPAN class=code>  2   test_table</SPAN><BR><SPAN class=code>  3   (c1 number)</SPAN><BR><SPAN class=code>  4  tablespace</SPAN><BR><SPAN class=code>  5   asm_test</SPAN><BR><SPAN class=code>  6  storage</SPAN><BR><SPAN class=code>  7   ( pctfree 20 pctused 30 )</SPAN><BR><SPAN class=code>  8  ;</SPAN><BR><SPAN

  class=code>&nbsp;</SPAN><BR><SPAN class=code>&nbsp;&nbsp; ( pctfree 20 pctused 
  30 )</SPAN><BR><SPAN class=code>&nbsp;&nbsp;&nbsp;&nbsp; *</SPAN><BR><SPAN 
  class=code>ERROR at line 7:</SPAN><BR><SPAN class=code>ORA-02143: invalid

STORAGE option</SPAN><BR><BR>However, here's an important point. While Oracle9i rejects the PCTFREE and PCTUSED parameters with locally managed tablespaces with automatic space management, it does allow you to enter invalid settings for NEXT and FREELISTS settings"</FONT></FONT></DIV>

  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>You've gotta love it !!</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>Sorry no clues ....</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial size=2>Cheers ;)</FONT></DIV>
  <DIV><FONT face=Arial size=2></FONT>&nbsp;</DIV>
  <DIV><FONT face=Arial

size=2>Richard</FONT></DIV></DIV></BLOCKQUOTE></BODY></HTML>

------_=_NextPart_001_01C3BFDF.E5440BC0--

------=_NextPartTM-000-32d5f4bd-74a2-4aa7-ae44-e7771319cb43--

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Naveen, Nahata (IE10)
  INET: Naveen.Nahata_at_honeywell.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Dec 11 2003 - 06:04:34 CST