• 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

How to restore optimizer statistics in Oracle

August 2, 2023 by techgoeasy Leave a Comment

As we know that DBMS_STATS takes a backup of the statistics every time dbms_stats is run on the table. So we can restore the statistics from the backup. In this article, we will see, How to restore optimizer statistics in Oracle, How to check the retention of the statistics How far back in time we […]

Filed Under: Oracle, Oracle Database

How to verify stats for the table in EBS

August 1, 2023 by techgoeasy Leave a Comment

Oracle has provided a procedure VERIFY_STATS in the FND_STATS package to verify stats for the table in EBS This procedure reports the statistics in the data dictionary tables for the tables, indexes, and histograms. Syntax FND_STATS.VERIFY_STATS ( schemaname VARCHAR2 DEFAULT NULL, tablelist VARCHAR2 DEFAULT NULL, days_old NUMBER DEFAULT NULL, column_stat BOOLEAN DEFAULT FALSE); To verify […]

Filed Under: Oracle, Oracle Database

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

  • « Previous Page
  • Page 1
  • Page 2
  • Page 3
  • Page 4
  • …
  • 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

  • How to drop the sql baseline in Oracle
  • how to find file based on size in linux
  • How to check automatic statistics collection in Oracle in 11g
  • Password Version in oracle
  • How to check Package version in EBS R12

Copyright © 2023 : TechGoEasy

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