I'm looking for a script that creates an ora_storage file with good initial and next values.

You can try this one. No garanty as I haven't updated it since 2 years or so.

Kind regards,
Dick

It is not necessary to set those parameters in the ora_storage file. Just identify the tablespaces that you want each table and index to occupy. Set your initial and next values in your tablespaces. As the tables and indexes are created they will inherit those values. As for what are good values, read the Oracle article: "How to stop defragmenting and start living: The definitive word on fragmentation" by Bhaskar Himatsingka and Juan Loaiza. This is a very insightful look at best practice for space management. You can find this article and many others on Oracle's MetaLink web pages.

Gilbert Guymer
Database Administrator
Lufkin Industries, Inc.

Gilbert,

You are right. I directly tought about my script and forgot to mention that fragmentation is mostly not a key thing to look at.

With the introduction of LMT this task can even be removed from the DBA's list.

Dick