Tuning/Efficiency Archives | Official TuningSQL.com Blog
Skip to content
  • TuningSQL.com
  • TuningSQL.com
Official TuningSQL.com Blog

Official TuningSQL.com Blog

Oracle Database SQL, Tuning, Features, and Toubleshooting

Category: Tuning/Efficiency

  • Home
  • Oracle
  • Tuning/Efficiency

Calculating Scalar Subquery Cache Size, Part 2

January 23, 2021February 3, 2021 Kaley Crum

I’ve written earlier about how to calculate a query’s scalar subquery cache size, and I’ve had an interesting thought since the last blog entry. The last entry was all about scalar subqueries that appear in a query’s select clause, but… Read More

Caching, Oracle, Tuning/EfficiencyLeave a comment

How to Get A Query’s Execution Plan (With All The Details)

January 10, 2021January 10, 2021 Kaley Crum

In Oracle, if you want to view an execution plan for a query, you use the DBMS_XPLAN.DISPLAY_CURSOR() procedure. NOTE: The execution plan is totally different than an explain plan; don’t confuse these two. The easiest way to get an execution… Read More

Execution Plans, Oracle, Tuning/Efficiencyexecution plan, execution plansLeave a comment

Using DBMS_UTILITY.EXPAND_SQL_TEXT

January 9, 2021January 9, 2021 Kaley Crum

If you have a query that contains views, or a query where the columns are not all qualified, the DBMS_UTILITY.EXPAND_SQL_TEXT function might be useful. The DBMS_UTILITY.EXPAND_SQL_TEXT function shows you what your query looks like without the views, and with all… Read More

DBMS_UTILITY, Oracle, Tuning/Efficiency, Writing Queries for Performancedbms_utility, expand_sql_textLeave a comment

How to Get Row Source Statistics In Oracle

January 7, 2021January 7, 2021 Kaley Crum

One great way to get time analysis information for a query in Oracle is to use row source statistics. Not everyone has the tuning and diagnostic pack, meaning not everyone can generate SQL Monitor reports. Row source statistics serves as… Read More

Execution Plans, Oracle, Row Source Statistics, Tuning/EfficiencyLeave a comment

How to Create a 10046 Trace File in Oracle

January 6, 2021January 6, 2021 Kaley Crum

This article will show you how to create a 10046 trace file in Oracle. There are multiple different ways of creating a SQL trace file, including doing an alter session set sql_trace = true but if you want the most… Read More

Oracle, Tuning/Efficiency10046 trace file, oracle trace file, wait event trace fileLeave a comment

How To Create A SQL Monitor Report

September 21, 2020September 21, 2020 Kaley Crum

First of all, you want to ensure that you have the tuning and diagnostic pack for your database–if you do not have the tuning and diagnostic pack, Oracle does not authorize you to create SQL Monitor Reports. Important Information About… Read More

Oracle, SQL Monitor Reports, Tuning/EfficiencyLeave a comment

How to Tell If Statistics are Stale in Oracle

August 14, 2020August 14, 2020 Kaley Crum

There are two ways to tell if statistics are stale in Oracle. One way is to allow Oracle to tell you if it thinks the statistics are stale. The other way is to compare the statistics of what Oracle thinks… Read More

Oracle, Table Statistics, Tuning/EfficiencyLeave a comment

Index Range Scan vs. Leading Wildcard

July 2, 2020August 13, 2020 Kaley Crum

Can you use an index range scan with a LIKE if you have a leading wildcard in your expression? e.g. Most people would say “no” but, I actually found a way to “trick” Oracle into doing so using bind variables,… Read More

Bind Variables, Execution Plans, OracleLeave a comment

The *LOWEST* Possible Cost For a Query

May 24, 2020August 13, 2020 Kaley Crum

Quick: If you had to pick the least-expensive-cost query you could think of, what would that query look like? …(hums Jeopardy theme)…. Ding! Time’s up!! Most people respond with something “select from a one-block table.” Let’s give it a shot:… Read More

Database Objects, Explain Plans, Hash Clusters, Oracle, Tuning/EfficiencyLeave a comment

Are Single-Table Hash Clusters USELESS?!?

April 20, 2020August 13, 2020 Kaley Crum

I remember being at an Oracle conference a few years ago, and I attended a session that was related to SQL Tuning. One of the things that was discussed in this lecture was Oracle Single Table Hash Clusters, and I… Read More

Database Objects, Hash Clusters, Oracle, Tuning/Efficiencyhash clusters, oracle, single table, single table hash clusterLeave a comment

Posts navigation

Older posts

FREE Sql Tuning Tips!

Get FREE tips and tricks for FASTER Oracle SQL queries delivered directly to your email inbox!

Just a minute...

Awesome! You're subscribed!!

Recent Posts

  • How to Make a “God User” in Oracle
  • View Hidden Parameters in Oracle
  • KUP-01005: syntax error: found “hash” (How to fix on an External Table)
  • Finding mod(power(x,y)) for Larger Values
  • Writing Efficient Pl/SQL is Hard

Categories

  • Approximate Query Processing
  • Arrays
  • Autonomous
  • Baselines
  • Bind Variables
  • Caching
  • Certification
  • Creating Users
  • Cursors
  • Custom Aggregation
  • Data Dictionary Views
  • Data Types
  • Database Objects
  • Day to Second Interval
  • DBMS_METADATA
  • DBMS_UTILITY
  • Dirty Hacks
  • Execution Plans
  • Explain Plans
  • External Table Problems
  • FORALL
  • Hash Clusters
  • Hash Joins
  • Hints
  • Keywords
  • Network Connections
  • NULL Values
  • NULL Values
  • Oracle
  • Oracle Error Messages
  • Oracle SQL Developer
  • Parameters
  • Pl/SQL
  • Pl/SQL Compiler Flags
  • Pluggable Databases
  • Pragmas
  • Privileges
  • Problems and Troubleshooting
  • Regular Expressions
  • Row Level Security
  • Row Source Statistics
  • Scalar Subqueries
  • Scripts and Queries
  • SQL
  • SQL Monitor Reports
  • SQL Plan Management
  • Table Definition
  • Table Statistics
  • Tuning/Efficiency
  • Uncategorized
  • User Profiles
  • Users
  • Version
  • Virtual Columns
  • Wrapping Pl/SQL Code
  • Writing Queries for Performance
Copyright © TuningSQL.com All rights reserved.
Business Cast by Axle Themes