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


Oracle LazyDBA home page