NAME: Purge Obsolete Generic File Manager Data
SHORT CODE: FNDGFMPR
MODULE: Oracle Application Object Library

Description: Purge Obsolete Generic File Manager Data
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• Expired : Purge expired data only
• Program Name : Program name to process (blank for all)
• Program Tag : Program tag to process (blank for all)

NAME: Gather Column Statistics
SHORT CODE: FNDGCLST
MODULE: Oracle Application Object Library

Description: Gather Column Statistics
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• Table Owner : Table Owner
• Table Name : Table Name
• Column Name : Column Name
• Estimate Percent : Estimate Percent
• Degree of Parallelism : Degree of Parallelism
• Bucket Size : Bucket Size
• Backup Flag : Backup Flag

NAME: Analyze All Index Column Statistics
SHORT CODE: FNDGAICST
MODULE: Oracle Application Object Library

Description: Analyze All Index Column Statistics
Navigation: Oracle Application Object Library Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• Owner Name : Owner Name
• Estimate Percent : Estimate Percent
• Bucket Size : Bucket Size