How High Can You Get?

March 2, 2006 on 12:29 pm | by Garet Keller | In Feature of the Week | 2 Comments | Print Print | Email Email

Unlike Donkey Kong where the longer you play the faster it gets, with Oracle Applications, the longer you play the slower it gets. Just ask an APPS DBA or anybody that was part of an upgrade from 10.7 to 11i.

What is a terabyte? In the world of Oracle Applications 11i it’s a lot of data and this data needs to be accessible to the user’s real time or the heavy hand of Audit and Sarbanes Oxley will strike you down “ GAME OVER. As Oracle continues to enhance its product with additional modules and “features” within a module (Example the AP AE_ACCOUNTING LINES with 11i) the tables grow and grow. IT tech folks have had few options, add disk, buy bigger servers, switch to RAC etc. Beyond the Production instance we all need QA, DEV and Support instances that grow the Prod terabyte exponentially.

There is a solution for this, it’s called ARCHIVE. Many of us functional analysts have looked at the Oracle purge routines and they are enticing (when they work) but try selling them to your business customers. It just won’t happen, the business customers don’t want to fish through an XML flat file to find audit data and I don’t either. Archiving allows the data to be moved from the production tables and placed on a history instance that can be viewed using data groups and responsibilities using your Production instance. This allows the production tables to be re-sized and reorganized for better performance and the data is still accessible to the business customers on-line on production.

There are a few companies that provide tools to do this and each has their pros and cons. I’ve worked with Applimation’s Informia Archive solution and I really liked it. The tool is easy to use and the code easy to view and modify if needed. The code is based on Oracle’s Standard purge routine.

For more information, look up the tool on this website www.applimation.com or you can reach out to me at garet@connectconsultingllc.com.

2 Comments »

RSS feed for comments on this post. TrackBack URI

  1. Great job, Garet! Welcome to It’s a Feature! Congratulations on becoming a blogger. Watch out though, you can still turn back before this thing sucks you in. :-) Your article embodies what I was hoping this weblog to become – smart, funny and original. Keep blogging, we had fun reading it.

    Marian

    Comment by Marian Crkon — March 4, 2006 #

  2. [...] Oracle Archiving using Applimation’s Informia Archive Solution, read about it in How High Can You Get article. [...]

    Pingback by The Feature » 10 Questions for Garet Keller from Connect Consulting — December 22, 2006 #

Leave a comment

XHTML: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds. Valid XHTML and CSS. ^Top^