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