Oracle Archives | Page 2 of 6 | 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: Oracle

  • Home
  • Oracle
  • Page 2

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

Using PRAGMA AUTONOMOUS_TRANSACTION in a Function

November 19, 2020November 19, 2020 Kaley Crum

Here’s a quick example of how to use the AUTONOMOUS_TRANSACTION pragma in a function: If you use the AUTONOMOUS_TRANSACTION pragma in Pl/SQL, it creates a separate transaction from the transaction you are currently working in. Because we included it in… Read More

Oracle, Pl/SQL, Pragmas1 Comment

Easiest Way to Wrap Pl/SQL Code

November 8, 2020February 1, 2021 Kaley Crum

In this article, I’ve included the easiest possible way to wrap any piece of existing Pl/SQL code, using an anonymous Pl/SQL block. If you’ve stumbled on this page wondering “what does it mean to wrap Pl/SQL?” just know that it… Read More

Oracle, Pl/SQL, Wrapping Pl/SQL Code5 Comments

ORA-12954: The request exceeds the maximum allowed database size of 12 GB

October 14, 2020October 14, 2020 Kaley Crum

Today, I was gathering statistics on a table when I received ORA-12954: The request exceeds the maximum allowed database size of 12 GB. This threw me for a complete loop, because of a few things: I had a USERS tablespace,… Read More

Oracle, Problems and Troubleshooting3 Comments

Where did the DBA_PARAMETERS View Go in Oracle?

October 1, 2020October 1, 2020 Kaley Crum

If you’re searching for DBA_PARAMETERS or ALL_PARAMETERS or USER_PARAMETERS…it’s because (like me) you’ve forgotten that the name is DBA_ARGUMENTS, not DBA_PARAMETERS. There are 3 steps you can follow to prevent this from happening in the future: 1.) Go clear your… Read More

Data Dictionary Views, OracleLeave 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 Fix “ORA-01489: Result of String Concatenation is Too Long” When Using Listagg

August 19, 2020November 16, 2020 Kaley Crum

If you’re using the LISTAGG() function in Oracle, and you’ve encountered the error ORA-01489: result of string concatenation is too long it’s because you’re trying to create a comma-delimited list that is too long for a VARCHAR2. In Oracle, a… Read More

Oracle, Oracle Error Messages, Problems and Troubleshooting, SQL20 Comments

How to Unexpire a Password in Oracle (ORA-28001: the password has expired)

August 18, 2020August 18, 2020 Kaley Crum

What This Error Means You’re trying to login to an Oracle database and you get ORA-28001: the password has expired. Yikes! This means that the user’s profile forces them to periodically change their password, due to a security precaution. So,… Read More

Oracle, Oracle Error Messages, Problems and Troubleshooting, User Profiles, UsersLeave a comment

ORA-12727: Invalid Back Reference In Regular Expression

August 17, 2020August 17, 2020 Kaley Crum

If you’ve run across ORA-12727: invalid back reference in regular expression, it’s because you’ve referenced a group (a group is an expression enclosed in parenthesis) either that doesn’t exist, or doesn’t exist yet. There are two common reasons for this… Read More

Oracle, Oracle Error Messages, Problems and Troubleshooting, Regular ExpressionsLeave 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

Posts navigation

Older posts
Newer 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