optimal storage parameters for heavy inserts tables

From: Syed Jaffar Hussain <sjaffarhussain_at_hotmail.com>
Date: Mon, 29 Mar 2004 11:44:14 +0300
Message-ID: <Law10-OE39REGcvcoCr0000c43f@hotmail.com>

Hi List,

Some of our tables have very heavy inserts and a couple of tables among them have heavy updates as well. What are the good storage parameters for these tables. Right now I have initial = 1024, next=initial and pct_increase=0. We still uses DMT TBS and our version is 8.1.7.4. We are starting new season, so we have truncated all the old data and starting a fresh. I would like to have some good storage parameters settings for those tables.

I am planning to create a new TBS as LMT and move those heavey inserts tables as uniform extent size as 1m.

I would be thankful to you if you can suggest good storage parameters for these tables.

Best Regards,
Syed Jaffar Hussain

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Mon Mar 29 2004 - 02:47:28 CST