• 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 create sql baseline from AWR repository without STS

June 1, 2023 by techgoeasy Leave a Comment

We have seen that sql baseline can be created with AWR using sql tuning set. With 12c, Oracle provided a way to directly create sql baseline using AWR without creating the tuning set. It is through procedure  DBMS_SPM.LOAD_PLANS_FROM_AWR. In this post, we will check how to create sql baseline from the AWR repository without STS […]

Filed Under: Oracle, Oracle Database

how to create sql baseline from Sql tuning set in Oracle

May 31, 2023 by techgoeasy Leave a Comment

Sql baseline can be created from cursor cache, AWR and Sql tuning set. In this post, we will check out how to create sql baseline from Sql tuning set in Oracle How to create the Sql tuning set This can be done using the DBMS_SQLTUNE.CREATE_SQLSET procedure. In the following example, we’re creating a SQL Tuning […]

Filed Under: Oracle, Oracle Database

How to create sql baseline from cursor cache in Oracle

May 30, 2023 by techgoeasy Leave a Comment

SQL Plan Baselines in Oracle Database are a method for maintaining the consistency of SQL statements’ performance.SQL baseline can be created from cursor cache, AWR, Sql tuning set etc. In this post, We will be looking at How to create sql baseline from the cursor cache in Oracle If you want to create a SQL […]

Filed Under: Oracle, Oracle Database

how to create sql baseline in oracle 19c

May 29, 2023 by techgoeasy Leave a Comment

What is sql baseline? SQL Plan Baselines in Oracle Database are a way to maintain the performance stability of SQL statements. When an SQL statement is executed, the Oracle optimizer determines the optimal execution plan for that statement based on various factors such as statistics, system settings, and bind variables. However, sometimes the optimizer might […]

Filed Under: Oracle, Oracle Database

Sql plan Management in Oracle

May 26, 2023 by techgoeasy Leave a Comment

SQL Plan Management (SPM) in Oracle is a preventative mechanism that provides a level of control over the execution plans used by the Oracle optimizer. It ensures that regression due to changes in execution plans doesn’t occur, even as the database undergoes changes such as database upgrades, a gathering of new statistics, or changes to […]

Filed Under: Oracle, Oracle Database

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

  • Page 1
  • Page 2
  • Page 3
  • …
  • Page 122
  • 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 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
  • Sql plan Management in Oracle

Copyright © 2023 : TechGoEasy

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