Excessive hard parsing can occur when your shared_pool_size is too small (and reentrant SQL is paged out) or when you have non-reusable SQL statements without bind variables.
Recommendation: Consider increasing shared_pool_size and ensure your SQL is using bind variables
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.