• 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

SQL Tuning Set in Oracle

May 25, 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 set statistics for Table/index/column in Oracle

May 23, 2023 by techgoeasy Leave a Comment

Sometimes, you want to modify the statistics for testing purposes or some other things. Oracle has provided a standard procedure to set the statistics for the Table/index/column. In this post, we will check out how to do it How to set statistics for Table This is done using the SET_TABLE_STATS procedure of the DBMS_STATS package […]

Filed Under: Oracle, Oracle Database

How to delete statistics from Table/index/column in Oracle

May 22, 2023 by techgoeasy Leave a Comment

We may sometimes need to delete the statistics on the Table/index/column in Oracle. In this post we will check out how we can do it with standard oracle defined procedures How to delete statistics from Table Oracle has provided a procedure in DBMS_STATS Package Here cascade parameters are default true which means when table stats […]

Filed Under: Oracle, Oracle Database

How to replace sql plan by another sql id sql plan

May 19, 2023 by techgoeasy Leave a Comment

We have a condition where a query is performing poorly and sql tuning advisor is not helping, we dont have a good plan also, so a custom sql profile can also not be created. The only solution is adding manual hints in the query but it is not possible to change the code. In this […]

Filed Under: Oracle, Oracle Database

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

  • « 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 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
  • how to create sql baseline in oracle 19c

Copyright © 2023 : TechGoEasy

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