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
Little competition for you all :)
It's a two part question:
What's wrong with the
followingpiece of expert analysis?
Which well know "Oracle Guru"
published this (and continues to display it on his web-page) ?
"Sadly, Oracle9i doesnt allow you to specify the
va
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
-LSubject: Little competition
Little competition for you all :)
It's a two part question:
What's wrong with the
followingpiece of expert analysis?
Which well know "Oracle Guru"
published this (and continues to display it on his web-page)
?
"
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
competition
Little competition for you all :)
It's a two part question:
a.. What's wrong with the following piece of expert analysis ?
b.. Which well know Oracle Guru published this (and continues to display it
on his web-page) ?
Sadly, Oracle9i doesn't allow you to specify
: Little competition
Little competition for you all :)
It's a two part question:
a.. What's wrong with the following piece of expert analysis ?
b.. Which well know Oracle Guru published this (and continues to display it
on his web-page) ?
Sadly, Oracle9i doesn't allow you
onal. QOTD: Any clod
can have facts, having an opinion is an art !
-Original Message-From: Richard Foote
[mailto:[EMAIL PROTECTED]Sent: Thursday, December 11, 2003
6:39 AMTo: Multiple recipients of list ORACLE-LSubject:
Little competition
Little competition f
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
, December 11, 2003 6:39 AM
To: Multiple recipients of list ORACLE-L
Little competition for you all :)
**
This e-mail message is confidential, intended only for the named recipient(s) above
and may contain
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
have no idea who the guru is, but he or she hasn't been following this list.
There was quite an extensive debate about ASSM not so long ago, resolved
by Tanel Poder's detailed presentation of the new bitmap mechanism.
On 12/11/2003 06:39:26 AM, Richard Foote wrote:
Little competition for you
: 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
Thursday, December 11, 2003, 8:44:43 AM, [EMAIL PROTECTED] ([EMAIL PROTECTED]) wrote:
rcn The biggest thing about working on database in the
rcn multi-TB range is that its a nice buzzword for your
rcn resume. Its not necessarily harder.
This brings back some memories. I remember back when I moved
Thursday, December 11, 2003, 8:34:32 AM, Tim Gorman ([EMAIL PROTECTED]) wrote:
TG Neither the PCTFREE and PCTUSED clauses go inside the STORAGE clause. They
TG are independent of it. That is why the error was thrown, not because
TG PCTFREE is invalid with ASSM...
Oh my. I'm so blind! I
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
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Little competition
Little competition for you all :)
It's a two part question:
a.. What's wrong with the following piece of expert analysis ?
b.. Which well know Oracle Guru published this (and continues
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
Thursday, December 11, 2003, 8:44:32 AM, Hately, Mike (LogicaCMG) ([EMAIL PROTECTED])
wrote:
HML PS Yes, I'm aware that there will follow a list of post-7.3.4 features that
HML people consider absolutely vital. =)
And therein lies part of the challenge. I'm sure too, that
every product manager
!
Nelson
-Original Message-From:
Richard Foote [mailto:[EMAIL PROTECTED]Sent: Thursday,
December 11, 2003 6:39 AMTo: Multiple recipients of list
ORACLE-LSubject: Little competition
Little competition for you all :)
It's a two part question:
What's wrong
Thursday, December 11, 2003, 8:44:25 AM, Mercadante, Thomas F ([EMAIL PROTECTED])
wrote:
MTF And I think a condensed documentation set is a great
MTF idea. I wonder if there is a market for it?
If I just wrote the book? No, I doubt it would sell in
high-enough numbers. The Oracle book market is
]
cc:
Subject:Little competition
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
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
33 matches
Mail list logo
