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

 

Leave a reply

Your email address will not be published. Required fields are marked *