Tutorial about STORAGE parameters

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 27 Feb 2003 17:10:14 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7035BFB6C@lnewton.leeds.lfs.co.uk>

Afternoon Francesco,

have a look on Metalink for a doc called 'how to stop defragmenting and start living'. That will tell you how to set up 4 tablespaces with uniform extent sizings whioch will suffice for (almost) all your needs.

Then create Locally Managed Tablespaces (if you have 8.1.7.4 onwards - a bit flaky before then) using the 'extent management local uniform size' options.

From then on, you won't have much in the way of worries.

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Francesco M. [mailto:fmarchioniNIENTESPAM_at_libero.it] Posted At: Thursday, February 27, 2003 4:53 PM Posted To: server
Conversation: Tutorial about STORAGE parameters Subject: Tutorial about STORAGE parameters

Hi Oracle users,
I'm looking for a tutorial/articles that shows me how to choose the correct storage parameters for TableSpace-Table tuning.
Anybody has a got a link ?
Thanks a lot
Francesco Received on Thu Feb 27 2003 - 11:10:14 CST