Finding a high CPU consuming database session

If you find an oracle process consuming a high amount of CPU, you can use the following to find user session details of the user and go and break their fingers (or start to identify why they are a high

Tagged with: , , ,
Posted in DBA Admin

Tracing SQL sessions

In my recent performance tuning exercises I came across a problem – no admin GUI – Shock horror. I had to perform sql tracing manually. Well it took a while for the old grey cells to start firing on this

Tagged with: , , ,
Posted in Performance

Using Baselines to force execution plans

Been on site doing some performance enhancements for 3rd Party application for the past few days. The application is designed and coded to run on SQL Server, is about 5 years past end of life and the vendor only supports

Tagged with: , , ,
Posted in Performance

DBMS_XPLAN and the “User has no SELECT privilege on V$….” error

Doing some testing for another post today and i came across the following error when trying to get the explain table using dbms_xplan.display_cursor. SQL> select * from table(dbms_xplan.display_cursor(format=>’BASIC +COST’)); PLAN_TABLE_OUTPUT ——————————————————————————– User has no SELECT privilege on V$SQL_PLAN Execution Plan

Posted in Performance

When did a process start?

Had an interesting issue today, where i needed to find the start time of a process. The process spawned in 2014 as shown below:- acs-ggate-n01:oracle@GGTEST > ps -ef | grep OSW oracle 1125 1        0 2014 ?  

Posted in LINUX Admin

ASM: Device “X” is already labeled for ASM disk “”

Been doing some ASM cross training over the past couple of days and hit an interesting feature while dropping and adding disks. So I have partitioned the disks using fdisk and installed ASMLib to prepare and manage the disks for

Tagged with: , , , , ,
Posted in ASM, LINUX Admin

RMAN Duplicate fails with ORA-30012 when the wrong undo tablespace is specified for the auxiliary

Problem: I was working at a client site, due to one thing or another they had to knock up a new environment for a 5Tb database and get it available within 24 Hours, not a small task considering the restore

Tagged with: , , , ,
Posted in RMAN

Get every new post delivered to your Inbox.