I recently upgraded a critical production system from Oracle 11.2.0.4 to 12.1.0.2. This is also a 3-node Oracle RAC database. I ran into a few issues which needed resolution after the upgrade. Hopefully this helps out others in their upgrades. The first issue was related to a Global Temp Table that is central to our …
Category: Tuning
Oct 02
12c Adaptive Plans in SQL Developer
I’ve been working on tuning some SQL statements in a newly upgraded database, from Oracle 11.2.0.4 to 12.1.0.2. As I typically do, I like to use SQL Developer to see the Explain Plan. I was surprised to see some gray text in the Explain Plan output, which you can see below. …
Sep 30
Tuning SQL Statements in SQL Developer
This video shows a few tips on how I use SQL Developer when tuning a SQL statement. I hope it helps someone. IVF remains more complicated for Obese Women viagra uk buy and they require a decent number of meds to correct the issue. Blood gushes into the spongy erectile tissues to make the …
Aug 18
Video: Oracle 12c IDENTITY Column Performance on RAC
I’m trying to branch out a bit and craft a few videos. This one is my first attempt and I discuss the new 12c IDENTITY column performance, specifically for Oracle RAC databases. It provides results buying levitra from canada from its first dose. IF you can’t consume tablets: Then kamagra also comes in oral on …
Jul 27
Remember RAC Instances in Perf Tools
I was using Lighty to examine performance of a new Oracle RAC database that went into service today. You can see something similar in Oracle Enterprise Manager 12c Cloud Control if you choose. Anyway, here is the performance graph of the RAC database in question. It is common wisdom that if …
Jul 23
Lighty In A Nutshell
As you may know from a previous post on this blog, or if you follow me on Twitter (BPeaslandDBA), I like Lighty for Oracle, a product by Orachrome. I love this product and how easy it is to obtain performance diagnostic information. I’m very familiar with Oracle’s Enterprise Manager and I use EM12c all the time when …
Jun 25
TNS-12519 w/o Max Processes Reached
I got a call from someone that they were getting TNS-12519 errors in their application. Sure enough, those messages were in the listener.log file as well. TNS-12519: TNS:no appropriate service handler found For those that aren’t familiar with this error, it typically means one of two things. Either the service name is not registered with …
May 21
SQL Monitoring in SQL Developer
In my last article for SearchOracle (referenced in my last post to this blog) I showed an example of how I quickly got to the root cause of a poor performing query using SQL Monitoring in Enterprise Manager. Today, That Jeff Smith of SQL Developer These phones have made human lives easier and include much …
May 19
Proper Tools Make Tuning Fast Work
I am starting to write articles for publishing on SearchOracle.com. I have been loosely affiliated with them since 2001, mostly in their Ask The Experts section. My first article is on the benefits that tools can play in making your tuning life much easier. Jelly is only a soft and suppler form of viagra in …
Mar 02
GWFG in Oracle RAC
I have a deadlock being reported in my 3-node Oracle RAC database (version 11.2.0.4) as can be seen in the Alert Log. Being that this is an Oracle RAC database, resources are managed globally and the Lock Manager Daemon (LMD) gets involved. The message in the alert log pointed me to a LMD trace file …