Printable View
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
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.
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.