Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

large data files vs. small files

5410May 4 2006 — edited May 4 2006

All,

I am in the process of migrating a database from Postgres to Oracle 10g on Linux AS3. Currently in the production Pg database, the files have grown to over 5G and performance (i.e. INSERTS) has become very slow. Someone is recommending that we deal with the large files by rebuilding the file system to support large files (vs. small files) before migrating over to Oracle. This database is not partitioned so everything is going into one file. The database is small with about 20 tables and 1 table that currently have about 5 million records.

Before the file system is rebuilt to support the large file, I want to get other opinions. Are there other opinions I should consider?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2006

Added on May 4 2006

#general-database-discussions

3 comments

180 views