Purging Strategy for eBusiness Suite 11i [ID 732713.1]

最新推荐文章于 2020-12-11 10:37:02 发布

cuanshu0986

最新推荐文章于 2020-12-11 10:37:02 发布

阅读量120

点赞数

Purging Strategy for eBusiness Suite 11i [ID 732713.1]

		修改时间 18-JAN-2009 类型 WHITE PAPER 状态 PUBLISHED

In this Document
  Abstract
  Document History
  Purging Strategy for eBusiness Suite 11i
     Concurrent Jobs to purge data
     Additional Notes
  Summary
  References

Applies to:

Oracle Application Object Library - Version: 11.5.9 to 11.5.10.2
Information in this document applies to any platform.

Abstract

There is no single Archive/Purge routine that is called by all modules within eBusiness Suite, instead each module has module specific archive/purge procedures.

This note lists the Purging routines available for the "System Administrator" (FND module) Not all of these purging processes will be appropriate for all customers, so review the documentation to confirm which are necessary for your own environment and how often they should be run.

Update : November 2008 - since this note was written, a much more comprehensive article has been published in Note 752322.1 "Reducing Your Oracle E-Business Suite Data Footprint using Archiving, Purging, and Information Lifecycle Management"

Document History

Author : Mike Shaw
Create Date 18-Aug-2008

Purging Strategy for eBusiness Suite 11i

Concurrent Jobs to purge data

Purge Obsolete Workflow Runtime Data (FNDWFPR)

Oracle Applications System Administrator’s Guide - Maintenance Release 11i (Part No. B13924-04)
Note 132254.1 Speeding up and Purging Workflow
Note 277124.1 FAQ on Purging Oracle Workflow Data
Note 337923.1 A closer examination of the Concurrent Program Purge Obsolete Workflow Runtime Data

Purge Debug Log and System Alerts (FNDLGPRG)

Note 332103.1 Purge Debug Log And System Alerts Performance Issues

Purge Signon Audit data (FNDSCPRG)

Note 1016344.102 What Tables Does the Purge Signon Audit Data Concurrent Program Affect?
Note 388088.1 How To Clear The Unsuccessful Logins

Purge Concurrent Request and/or Manager Data (FNDCPPUR)

Oracle Applications System Administrator’s Guide - Maintenance Release 11i (Part No. B13924-04)
   Note 565942.1   Which Table Column And Timing Period Does The FNDCPPUR Purge Program Use
   Note 104282.1  Concurrent Processing Tables and Purge Concurrent Request and/or Manager Data Program (FNDCPPUR)
Note 92333.1   How to Optimize the Process of Running Purge Concurrent Request and/or Manager Data (FNDCPPUR)

Delete Diagnostic Logs (DELDIAGLOG)

Note 466593.1 How To Delete Diagnostic Logs and Statistics?

Delete Diagnostic Statistics (DELDIAGSTAT)

Note 466593.1 How To Delete Diagnostic Logs and Statistics?

Purge FND_STATS History Records (FNDPGHST)

Oracle Applications System Administrator’s Guide - Configuration Release 11i (Part No. B13925-06)
Note 423177.1 Date Parameters For "Purge Fnd_stats History Records" Do Not Auto-Increment

Page Access Tracking Purge Data (PATPURGE)

  Note 413795.1   Page Access Tracking Data Purge Concurrent Request Fails With Ora-942
  Note 461897.1   Which Tables store the Page Access Tracking Data?
  Note 402116.1   Page Access Tracking in Oracle Applications Release 12

Purge Obsolete Generic File Manager Data (FNDGFMPR)

Oracle Applications System Administrator’s Guide - Configuration Release 11i (Part No. B13925-06)
Note 298698.1 Avoiding abnormal growth of FND_LOBS table in Application
Note 555463.1 How to Purge Generic or Purchasing Attachments from the FND_LOBS Table

Summarize and Purge Concurrent Request Statistics (FNDCPCRS)

(no references found)

Purge Inactive Sessions (ICXDLTMP)

Note 397118.1 Where Is 'Delete Data From Temporary Table' Concurrent Program - ICXDLTMP.SQL

Purge Obsolete ECX Data (FNDECXPR)

  Note 553711.1   Purge Obsolete Ecx Data Error ORA-06533: Subscript. Beyond Count
  Note 338523.1   Cannot Find ''Purge Obsolete Ecx Data'' Concurrent Request
  Note 444524.1   About Oracle Applications Technology ATG_PF.H Rollup 6

Purge Rule Executions (FNDDWPURG)

(no references found)

Additional Notes

You can monitor and run purging programs through OAM by navigating to the Site Map--&gt Maintenence --&gt Purge section.

Summary

Purging of unneeded data is an activity that needs to be performed on all systems to ensure best performance and minimize disk space requirements. This note outlines some of the processes that may be required from the FND perspective

References

NOTE:387459.1 - ATG Supplied Data Purge Requests
NOTE:752322.1 - Reducing Your Oracle E-Business Suite Data Footprint using Archiving, Purging, and Information Lifecycle Management

Copyright © 2008 Oracle. All rights reserved. Oracle is a registered trademark of Oracle. Various product and service names referenced herein may be trademarks of Oracle. All other product and service names mentioned may be trademarks of their respective owners.

Disclaimer: This document is provided for information purposes only and the contents hereof are subject to change without notice. Oracle does not warrant that this document is error-free, nor does it provide any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. Oracle specifically disclaims any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form. or by any means, electronic or mechanical, for any purpose, without the prior written permission of Oracle.

显示相关信息 相关的