MSAMM
Back to course

Oracle Apps DBA: Keeping E-Business Suite Alive · Module 12 · Space, growth and purging

Deciding what history to keep

Lesson 128 of 184 · 3 min

A BUSINESS DECISION, not a technical one. Who to ask, and THE AUDIT ANSWER THAT OVERRIDES YOUR PREFERENCE. The retention number is the only real decision in this module and it is not yours to make. WHAT YOU CAN CONTRIBUTE IS THE COST, AND THAT IS GENUINELY USEFUL. Five years of history is this many gigabytes, adds this much to every backup, and this much to a restore — Module 5 Lesson 10's number. Those figures make the trade visible; without them the business will always say keep everything, because keeping everything appears free. WHO TO ASK IS THE PART PEOPLE GET WRONG, AND IT IS NOT THE IT MANAGER. Ask finance about financial history and audit requirements. Ask whoever owns compliance, because they may have a legal retention period nobody else knows about. Ask the people who actually look things up, because their answer is concrete: "we never look

The full lesson is part of the course

The video, the complete written lesson and the module quiz are included in Oracle Apps DBA: Keeping E-Business Suite Alive, with a certificate on completion and a fourteen-day refund window.

Get the free lessons by email

We will email you a link to every free lesson in this course. No account needed, and one message only.

In this module: Module 12 · Space, growth and purging

  1. 1What fills up, and in what order
  2. 2Monitoring space before it matters
  3. 3Growing a tablespace
  4. 4The standard purge programs
  5. 5Deciding what history to keep
  6. 6Purging safely the first time
  7. 7Reclaiming space, and when you cannot
  8. 8What breaks: three space failures
  9. 9Lab briefing · Fill it up on purpose