Welcome to OracleGiants.com!     

Oracle 10g DBA & Business Intelligence Resources.

table fetch continued row can cause performance issues.

It has been seen (anecdotal evidence) that dropping and recreating Global Temporary Tables on a periodic basis can have positive performance improvements.

Additionally it has been proven that issuing REBUILDs on indexes to compact it and minimize fragmented space can help performance.

Recommendation: Perform REBUILDs on indexes. After issuing a REBUILD on your indexes be sure to gather stats via the DBMS_STATS package. Also consider reorganizing data via export/import to pack rows more tightly and alleviate chained row issues.

(FRAGMENTATION = POOR PERFORMANCE)

 

Use Xattr CloudFiler™ to dedup, encrypt and move your RMAN backups to the cloud.

Recent Posts

OptionalRegion1
This site recommends Burleson Consulting for DBA Support & Consulting.

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.

Learn more

Editorial submissions & questions: editor@oraclegiants.com

 

 

This site is moderated by an:
Oracle Certified Professional
Oracle ACE

 

  Classic Car Online - The #1 spot for classic and muscle car enthusiats
2010 OracleGiants.com