[askdba] Re: How to tune tables for inserts and Updates?

  • From: "Irfan Khan" <irfan.khan@xxxxxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 1 Oct 2004 02:14:41 -0400

do proper growth planning so that extents are not required to extend =
dynamically and frequently.

have good inittrans and look at the pctfree and pctincrease value.

Also see the contention issues and denedping on whether its query or =
write intensive, layout the indexes for these tables accordingly.

see if partitioning can help if the records are gonna be in million.

This all off the cuff, will update it later.

Irfan, Khan
Senior ERP & Database Administrator
Converge Asia Pte. Ltd.
29 International Business Park
#02-03 Acer Building Tower B
Phone :- 65 67998078
Fax :- 65 67998096

-----Original Message-----
From: Chirag DBA [mailto:ChiragDBA@xxxxxxxxx]
Sent: Friday, October 01, 2004 2:10 PM
To: askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: [askdba] How to tune tables for inserts and Updates?

Hi friends,

I have a Database in which few tables are for Transaction.

As the number of transactions will be more than 10000 per day, I need
to decide the tuning strategy for the tables having more hits.

I m planning to put them ina different tablespace.

Any other idea how I can do that.

 - Chirag Majmundar

Other related posts: