-
db block size difference in performance
I have converted my application from an 8.1.7db to a 9.2.0.1db. It takes the 9i db twice as long as 8i to processes the same queries. I have converted all indexes and analyzed all tables. When I created the db I made the mistake of using a 4k block size on 9i but had an 8k block size on 8i. Should this effect performance this severely?
Other differences:
o 9i uses LMT as opposed DMT
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
|