« CRS to Single Instance Database | Main | IPMP - IP Multipath »

are you creating indexes parallelly or serially ??

Recently of my one old customer mailed me asking why this particular odf running forever during the upgrade, after analysis found that the odf was creating an index on one of the key Account Receivables tables which had millions of records. This one odf was skewing the upgrade timings a lot even though the boxes were powerful.

Solution was to use adpatch parallel_index_threshold=<higher value>, i had used this option in my previous upgrade and made a big difference (however it depends on how many parallel_max_servers init.ora parameter you have set)

adpatch: adpatch options

References

TrackBack

TrackBack URL for this entry:
http://blogs.oracle.com/mte1521/mt-tb.cgi/531

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

About This Entry

This page contains a single entry from the blog posted on August 31, 2007 2:31 PM.

The previous post in this blog was CRS to Single Instance Database.

The next post in this blog is IPMP - IP Multipath.

Many more can be found on the main index page or by looking through the archives.

Top Tags

Powered by
Movable Type and Oracle