You are browsing the archive for Oracle Application Object Library.

Help Reports

 

NAME: Help Reports
SHORT CODE: FNDHLPRPT
MODULE: Oracle Application Object Library

Description: Help Reports
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:

  • Application Name : Application name
  • REPORT : Report Name
  • Language : Document Language

 

Gather Table Statistics

 

NAME: Gather Table Statistics
SHORT CODE: FNDGTST
MODULE: Oracle Application Object Library

Description: Gather Table 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
  • Estimate Percent : Estimate Percent
  • Degree of parallelism : Parallel Degree
  • Partition Name : Partition Name
  • Backup Flag : Backup Flag
  • Granularity : Granularity
  • History Mode : History Mode
  • Invalidate Dependent Cursors : Invalidate Dependent Cursors

 

Gather Schema Statistics

 

NAME: Gather Schema Statistics
SHORT CODE: FNDGSCST
MODULE: Oracle Application Object Library

Description: Gather Schema 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:

  • Schema Name : Schema Name
  • Estimate Percent : Estimate Percent
  • Degree of Parallelism : Degree of Parallelism
  • Backup Flag : Internal Flag
  • Restart Request ID : Restart Request ID
  • History Mode : History Mode
  • Gather Options : Gather Options
  • Modifications Threshold : Modifications Threshold
  • Invalidate Dependent Cursors : Invalidate Dependent Cursors