Impact on oracle performance

[skasu]

hi everbody,

i want to know, what kind performance will i have in an oracle database with tables having more than 200 columns.
I created a repository using a third party tool that has these tables, right know the tables are empty, but once they get loaded will million rows, what should i look for, in terms of performance,

like migrated rows, block size, .... etc.

thank you

skasu

[Halo]

Watch out for row chaining or migration. Also watch out for the various LONG datatypes. I have seen imports running slow with LONG datatypes. Create indexes appropriately.

[tamilselvan]

Load some test data.
Analyze table.
Check row migration in that table.
If a row data does not fit into one block, increase the block size to 16K or 32K.
Any how large block size will improve overall performance.