• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

gather schema

Gather Schema Statistics Using FND_STATS in EBS 11i and R12

December 8, 2019 by techgoeasy Leave a Comment

How to Gather statistics in EBS In order to use Cost Based Optimizer effectively, the schema statistics must be current. Fortunately, Oracle EBS has provided some scripts and concurrent programs(Gather Schema Statistics and Gather Table statistics) to make this administrative task easier. FND_STATS is a PL/SQL package for the Applications that has numerous functions that […]

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: gather schema, Gathering Statistics in Release 11i and R12

ORA-20001 in R12 Gather schema statistics on 11g(FND_HISTOGRAM_COLS)

April 12, 2012 by techgoeasy Leave a Comment

“Gather Schema Statistics” program reported the following errors in request log files : Error #1: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_LINE_TYPE_MAP***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** Error #2: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_LOGS***ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt*** Error #3: ERROR: While GATHER_TABLE_STATS: object_name=GL.JE_BE_VAT_REP_RULES***ORA-20001: invalid column name or duplicate columns/column […]

Filed Under: Oracle, Oracle Ebuisness Suite Tagged With: FND_HISTOGRAM_COLS, gather schema, ora-20001 in Gather schema stats

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Move SQL Baseline from One Database to Another in Oracle
  • How to drop the sql baseline in Oracle
  • how to create sql baseline from AWR repository without STS
  • how to create sql baseline from Sql tuning set in Oracle
  • How to create sql baseline from cursor cache in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us
x
x