Category: Tuning

Oracle 12c Upgrade Issues

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 …

Continue reading

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.         …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading

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 …

Continue reading