• 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

How to get the outline hint in oracle and use for tuning

May 18, 2023 by techgoeasy Leave a Comment

Outline hints of the sql statement are the hints which are required to reproduce the same plan.This can be useful in many ways(a) You can enforce the same plan on the same query with different literal(b) we could use them between two slightly different queries also(c) These are the same hints used in the custom […]

Filed Under: Oracle, Oracle Database

How to implement custom Sql Profile in Oracle

May 17, 2023 by techgoeasy Leave a Comment

We all know about SQL profiles in Oracle and How they add hints and scaling factors that help in the Performance of the sql in Oracle. We have two types of sql profile This is the standard one that we get from sql tuning advisor. It tunes the sql statement using hint and scaling factors. […]

Filed Under: Oracle, Oracle Database

how to find if the sql is using the sql profile

May 16, 2023 by techgoeasy Leave a Comment

When we implement the sql profile for the statement, we will also like to confirm if the sql has started using the sql profile or not. we can use the below query to find out if the sql is using the sql profile how to find if the sql is using the sql profile col […]

Filed Under: Oracle, Oracle Database

How to verify stats for the table in EBS

May 12, 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

STATISTICS_LEVEL in Oracle

May 11, 2023 by techgoeasy Leave a Comment

The STATISTICS_LEVEL parameter was introduced in Oracle version 9 (9.2) to control allmajor statistics collections or advisories in the database. The level of the setting affects a number of statistics and advisories that are enabled. These listed below are for 10g and above The TYPICAL level is recommended for most production databases to enable the […]

Filed Under: Oracle, Oracle Database

Move SQL Profiles from One Database to Another in Oracle

May 10, 2023 by techgoeasy Leave a Comment

In this post, we will check out how to move SQL Profiles from One Database to Another  How to move the sql profiles in Oracle Suppose you have created a sql profile in System A and Now you want to transfer that sql profile to System B. Step 1On System A: Creating a staging table […]

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

  • Top Queries on Sql plan Management
  • 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

Copyright © 2023 : TechGoEasy

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