• 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 database
  • Oracle Ebusiness Suite
  • Oracle weblogic
  • Oracle Performance Tuning
  • Oracle Hyperion
  • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads

Gather Schema Statistics Using FND_STATS in EBS 11i and R12

July 31, 2023 by techgoeasy Leave a Comment

How to Gather schema statistics in oracle apps R12 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 […]

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

Histograms in EBS

July 31, 2023 by techgoeasy Leave a Comment

Histograms in Oracle are required for skewed data, so it is required in the Oracle EBS database also. Histograms tell the CBO when data is not evenly distributed and can help the CBO to estimate the number of rows returned from a table join (called “cardinality”). Having histograms on the skewed columns may aid the […]

Filed Under: Oracle, Oracle Ebuisness Suite

How to delete the archive logs in Oracle

July 31, 2023 by techgoeasy Leave a Comment

Archive logs keep accumulating and we need to put things in place to delete them on a regular basis. We should not be deleting the archivelog from the filesystem directly as the Oracle Database is not aware of that and space is not released in the Flash recovery area Let’s see a few commands on […]

Filed Under: Oracle, Oracle Database

SQL Tuning Set in Oracle

July 31, 2023 by techgoeasy Leave a Comment

A SQL Tuning Set (STS) in Oracle is a database object that includes one or more SQL statements along with their execution statistics and context. It provides a means to store SQL statements for future use, such as input to the SQL Tuning Advisor or SQL Access Advisor, capturing workloads to move them from one […]

Filed Under: Oracle, Oracle Database

How to find the bind variable of the sql id

July 28, 2023 by techgoeasy Leave a Comment

Sometimes a sql_id might show a different plan because of a particular value of the bind variable. So we would like to find out the bind variable. Also, we might want to know the bind variable for the sql_id being executed by the session. In this post, we will check out How to find the […]

Filed Under: Oracle, Oracle Database

How to gather Statistics with DBMS_STATS Procedures

July 28, 2023 by techgoeasy Leave a Comment

What is DBMS_STATS The DBMS_STATS package was introduced in Oracle 8i and is Oracle’s preferred method of gathering object statistics. DBMS_STATS is a package in Oracle Database that provides procedures to manage statistics for database objects. Statistics are essential for the optimizer to make efficient execution plans for SQL statements. The package offers procedures to […]

Filed Under: Oracle, Oracle Database

  • « Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • Page 5
  • …
  • Page 123
  • Next Page »

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

  • Oracle cloud storage : Block Volume
  • Oracle Cloud :Infrastructure-as-a-Service Concepts
  • How to use Coalesce Function in Oracle
  • Oracle Database Cloud Service Overview
  • How to drop the sql baseline in Oracle

Copyright © 2023 : TechGoEasy

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