-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|