Migrating to a 64-bit architecture will allow native support for a large SGA and will optimize performance overall by removing the extended buffer cache mechanism. This also allows for other dynamic pools to be added for performance reasons.
Hugepages could optionally be implemented to present a small improvement in performance on the current 32-bit architecture. However, the greatest improvement comes from going to a 64-bit environment and using hugepages.
Use Xattr CloudFiler™ to dedup, encrypt and move your RMAN backups to the cloud.
We
are currently paying for accepted Oracle 10g DBA & Business
Intelligence articles, scripts, tips & tricks. Send
yours to the editor and we will review within three weeks.