Home » RDBMS Server » Performance Tuning » Criteria for Initial Extents and Next Extents of Blank Table and Having Rows in above 8 Lakhs
Criteria for Initial Extents and Next Extents of Blank Table and Having Rows in above 8 Lakhs [message #64801] Thu, 05 February 2004 21:22 Go to next message
Arvind Bhandari
Messages: 50
Registered: May 2003
Member
Hello Good Morning, We have a table having 8.8 Lakh Records. Earlier system was running fast. Now we have changed New Harddisk and Install Oracle8i and import Dump file. here for this table (having rows 8.8 Lakh) we have first create the table mannualy with Storate of inital extents 400K  and Next 400K. and import data from dump file.After that when we insert Records through Oracle forms 5.0(with some same process that was in earlier) it executes slow. Earlier before hard disk change the initial  Extents of that table was 117MB and next storage was 400k. Is this is the reason for slow ? . beacuse if we import with Creation of table and data through dump file then it defines inital extents app 120 MB and if we create table mannualy with inital 400K and import data then it remains 400K.

can anybody clear this doubt about the inital extents and next extents with example. or can anybody help how to initialize the size of initial extents and next extents of a table having data already exits above 8 lakhs and average growth of Record is 2000 Record per day

Thanks & Regds

Arvind

 

 
Re: Criteria for Initial Extents and Next Extents of Blank Table and Having Rows in above 8 Lakhs [message #64802 is a reply to message #64801] Fri, 06 February 2004 04:15 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
Arvind,
Is this a locally managed tablespace? If not,you should seriously consider rebuilding the tablespace as Locally Managed with uniform extent sizes ( say 2 or 4m or whatever you think is a good value depending on the sizes of your database objects in this tablespace).

Precreate the tablespace (or tablespaces) with the Uniform extent sizes and then either move or export/import the tables. That should take care of it.

By any chance,is your new filesystem on Raid 5 ?

-Thiru
Previous Topic: Query Optimization
Next Topic: Re:Table of 1.4 gb size returns 0rows
Goto Forum:
  


Current Time: Fri Mar 29 04:41:03 CDT 2024