What do you get when you run the query

select tablespace_name,
extent_management,
segment_space_management
from dba_tablespaces

What about the lifecycle of an average row?

Realistically, the default settings will be acceptable for most
applications in most circumstances.

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Kevin Daniels
[mailto:oracledba-ezmlmshield-x58080476.[Email address protected]
Sent: Wednesday, June 01, 2005 4:26 PM
To: LazyDBA Discussion
Subject: RE: Determining TABLE Specs

We are using Oracle 9i.2.
Pretty much accepted all defaults on database creation.

LMT ... is that the difference between explicit and auto calculation?

-----Original Message-----
From: Justin Cave (DDBC)
[mailto:oracledba-ezmlmshield-x50633979.[Email address protected]
Sent: Wednesday, June 01, 2005 3:17 PM
To: LazyDBA Discussion
Subject: RE: Determining TABLE Specs

What version of Oracle?

Are you using locally managed tablespaces (LMT) or are you still using
dictionary managed tablespaces? If you are using LMT's, are you using
manual or automatic segment space management?

Describe the lifecycle of an average row. Is it inserted once and never
modified? Inserted, updated occasionally, and then deleted? Is it
inserted with 100 columns set to NULL which are slowly filled in over
time?

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Kevin Daniels
[mailto:oracledba-ezmlmshield-x52877427.[Email address protected]
Sent: Wednesday, June 01, 2005 4:06 PM
To: LazyDBA Discussion
Subject: Determining TABLE Specs

Any good advice for determining optimal tables specs?

Or is default ok?



TIA,

Kevin Daniels



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page