 |
|
Oracle - Using default values
Oracle Tips by Burleson Consulting |
In order to facilitate the
simplification of common DDL commands, Oracle allows you to set
default value that will be used whenever a specific clause is
omitted. These defaults include:
- default tablespace
- default temporary tablespace
- default init.ora parameter values
Within a specific tablespace you can also
specify default values for all objects within the tablespace (this does not
always apply when using LMT's or ASSM):
- pctfree=10
- pctused=50
- freelists=1
Personally, I don't like to use defaults
because it can lead to unexpected values, and because specifying values allows
you do run dictionary queries to find everything related to an Oracle entity.
 |
If you like Oracle tuning, see the book "Oracle
Tuning: The Definitive Reference", with 950 pages of tuning tips and
scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot of Oracle tuning scripts. |
