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 irfan.khan@xxxxxxxxxxxx Phone :- 65 67998078 Fax :- 65 67998096 www.converge.com -----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 Chirag@xxxxxx