Re: optimal storage parameters for heavy inserts tables

From: Syed Jaffar Hussain <sjaffarhussain_at_hotmail.com>
Date: Mon, 29 Mar 2004 13:08:47 +0300
Message-ID: <LAW10-OE3540wk3skYT0000c969@hotmail.com>

MessageFirstly, thank you Steve for your valuable time. Below are the avg_row_length of those tables and I have a small question that you said allow freelist to 19, is anything calculated as 19 or just a guess. I have already given freelist as 15.

TABLE_NAME                     AVG_ROW_LEN
------------------------------            --------------------------
P_YAHAJJ_MUTAMER_PS                  16
P_YAHAJJ_TRX_PS                            16
TBL_APPLICATION                                0
YAHAJJ_MUTAMER_DATA                  64
YAHAJJ_MUTAMER_PAYMENTS         82
YAHAJJ_MUTAMER_PS                         8
YAHAJJ_MUTAMER_TRX                       0
YAHAJJ_PACKAGES                            24
YAHAJJ_PACKAGE_DETAILS                 8
YAHAJJ_TRX_PS                                    8

Note : The above output is after truncating tables.

Thanks
Jaffar

Original Message ----- From: Steve Adams To: 'Syed Jaffar Hussain' Sent: Monday, March 29, 2004 12:49 PM Subject: RE: optimal storage parameters for heavy inserts tables

What you planning is right. Also, allow plenty of freelists, say 19.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/ - For DBAs
@ http://www.christianity.net.au/ - For all

  -----Original Message-----
  From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Syed Jaffar Hussain   Sent: Monday, 29 March 2004 6:44 PM
  To: oracle-l_at_freelists.org
  Subject: optimal storage parameters for heavy inserts tables

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 - 04:12:01 CST