Hi Jonathan,
SQL create tablespace bowie_test
2 datafile 'c:/bowie/bowie_test01.dbf' size 100m
3 extent management local uniform size 1m
4 segment space management auto;
Tablespace created.
SQL create table bowie_assm (ziggy number)
2 tablespace bowie_test
3 storage (initial 1m
Hey Richard,
One of my desktop treasures is an autographed copy of
Jonathan Lewis' book, Practical Oracle8i. The humorous,
self-deprecating caption in the author's own hand:
'Never believe all you read.'
Scott
[EMAIL PROTECTED] 12/12/03 7:24:24 AM
Hi Jonathan,SQL create tablespace
Well, Googling this statement, one can easily find the source of this
statement :-)
Naveen
-Original Message-From: Richard Foote
[mailto:[EMAIL PROTECTED]Sent: Thursday, December 11, 2003
5:09 PMTo: Multiple recipients of list ORACLE-LSubject:
Little competition
Little
Title: Message
Don
King
SQL create table 2
test_table 3 (c1
number) 4 tablespace 5 asm_test
6 pctfree 20 pctused
30;
-Original Message-From: Richard Foote
[mailto:[EMAIL PROTECTED] Sent: Thursday, December 11,
2003 1:39 PMTo: Multiple recipients of list
Well, I guess it's all about self-tuning, all
this parameter stuff is out of date...
:)
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
Little competition for you all :)
It's a two part question:
a.. What's wrong with the following piece of expert analysis ?
b..
Life would be worse w/o PCT_FREE.
create table
test_table
(c1 varchar2(1000))
pctfree 20
;
select pct_free from user_tables where table_name='TEST_TABLE'
PCT_FREE
--
20
rw
Little competition for you all :)
It's a two part question:
What's wrong
i meant automatic segment management has fragmentation issues.
From: Richard Foote [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 06:39:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Little competition
Little competition for you all :)
It's a two part question:
who wrote that?
automatic undo management has fragmentation issues. Niall Litchfield posted a test
case a couple of months ago.
From: Richard Foote [EMAIL PROTECTED]
Date: 2003/12/11 Thu AM 06:39:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Little
hopefully i wont sound like a complete idiot, but what is wrong with wanting to be
able to handle your own pctfree and pctused. Ok oracle handles the next and initial
extent sizes...(which causes fragmentation).
I use transportable tablespaces and in order to increase the time it takes to copy
Richard,
Don't know about the "guru", but sorry to hear that David Bowie is sick
with Influenza.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD:
Title: Re: Little competition
I can cut 45 minutes off my load times by shrinking the data file?
And how much overhead gets added to DML statements as blocks madly shift on and off the freelists with each operation? Priorities, priorities, priorities...
If youre using 9i or above, the table
Hi Raj,
David Bowie? Didn't he publish something regarding
'space' management a long time ago? ;-)
I may (as usual) be totally wrong here.
Greetings,
Guido
[EMAIL PROTECTED] 11.12.2003 13.49 Uhr
Richard,
Don't know about the guru, but sorry to hear that David Bowie is sick with Influenza.
No, you are not but I think Richard from down under is a big David Bowie fan !!
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts,
Thursday, December 11, 2003, 6:39:26 AM, Richard Foote ([EMAIL PROTECTED]) wrote:
RF a.. What's wrong with the following piece of expert analysis ?
I don't know what's wrong with this analysis. There's not
much really there. The claim is that it's bad not to be able
to specify PCTFREE, but
Title: Re: Little competition
Neither the PCTFREE and PCTUSED clauses go inside the STORAGE clause. They are independent of it. That is why the error was thrown, not because PCTFREE is invalid with ASSM...
Essentially, an erroneous interpretation of the error message.
If it was really going
Jonathan,
I've been coming to the same conclusion as you have. In all of my databases
that I have ever worked on, there are only a select set of Oracle params
that are really required. And with space management the way it is, a lot of
the 'create table' params are really not needed for the
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Little competition
Thursday, December 11, 2003, 6:39:26 AM, Richard Foote ([EMAIL PROTECTED]) wrote:
RF a.. What's wrong with the following piece of expert analysis ?
I don't know what's wrong with this analysis. There's not
much
: Re: Little competition
Neither the PCTFREE and PCTUSED clauses go inside the STORAGE clause. They
are independent of it. That is why the error was thrown, not because
PCTFREE is invalid with ASSM...
Essentially, an erroneous interpretation of the error message.
If it was really going
1) Pctfree and pctused are not storage parameters.
2) Oracle allows using both of those parameters as shown by
the next example:
SQL select tablespace_name from dba_tablespaces
2 where segment_space_management='AUTO';
TABLESPACE_NAME
--
CWMLITE
DRSYS
EXAMPLE
: 2003/12/11 Thu AM 07:59:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Little competition
I can cut 45 minutes off my load times by shrinking the data file?
And how much overhead gets added to DML statements as blocks madly shift on
and off the freelists
Yes, I know. That David Bowie stuff comes up every few
weeks / months in several c.d.o. groups.
But what are 'fans'? In my opintion they make wind ;-)
Anyway, I like this competition thread - mostly because
there's nothing but bulls**t coming from me.
Greetings to the list,
Guido
[EMAIL
I managed to emulate Don Burleson's problem:
SQL create table test_table
2 (c1 number)
3 storage (pctfree 20 pctused 30);
storage (pctfree 20 pctused 30)
*
ERROR at line 3:
ORA-02143: invalid STORAGE option
But when I read the error message, and
corrected the error that was
Good points Jonathan,
The 'box' as far as I'm concerned was accomodated by v7.3.4. That had 95% of
the features anyone could want for most environments. After that we've had a
succession of 'nice to have' features.
Don't get me wrong, some environments absolutely demand these new features
and
What's wrong with the analysis?
Wrong
syntax in the 'CREATE TABLE'
PCTFREE and PCTUSEDare not part of the storage
clause.
SQL create table t1 (c1 number)
tablespace lmt1 pctfree 20 pctused 30;
Table created.
Lot's
of potential to go down the wrong path on this one.
Assumptions!
create table
test_table
(c1 number)
tablespace users
pctfree 20 pctused 30
/
Works for me. ;)
( USERS is ASSM)
Richard Foote [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
12/11/2003 03:39 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL
PROTECTED]
Date: 2003/12/11 Thu AM 08:44:32 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Little competition
Good points Jonathan,
The 'box' as far as I'm concerned was accomodated by v7.3.4. That had 95% of
the features anyone could want for most
On Thu, 11 Dec 2003 [EMAIL PROTECTED] wrote:
oracle literature is really lacking in entry level docs anyway. The concepts
document is way too large to be digestable by someone new to the topic.
What we really need is:
simple SQL book for newbies
- O'Reilly's Mastering Oracle SQL?
PCTFREE and PCTUSED are not part of the storage
clause.
SQL create table t1 (c1 number)
tablespace lmt1 pctfree 20 pctused 30;
Table created.
Lot's
of potential to go down the wrong path on this one.
Assumptions!
Maybe it has been already mentioned here, but with ASSM, pctused
28 matches
Mail list logo
