UNYOUG

I learned a valuable lesson today with index tuning.  I was tuning a "process" that looked through old history.. There was an index on widget, but no index on Date.. I figured .. Opportunity to tune the process wahoo.. I added a composite index on widget and date..  My testing of the query...

If you haven't checked out 11gr2 yet, you should.. There are tons of new features, and big changes for ASM.. If you are a user of ASM you are going to want to take a big look at this..  You can create your own volumes and take your own snapshots.. This is amazing compared to plain old ASM.  You can ...

If you aren't familiar with this free oracle tool, it's about time you learn about it!!  First of all it is free.. It is a web based tool you install in the database, in fact with 11g it's already built in.. you just set up the port for the webserver to listen to. First question is why do I want to ...

I was just attending a session at Oracle on Database Replay AKA RAT.  one of the first items discussed was segmenting your test.  The presenter mentioned that you should limit what you are recording during your test, so that you won't have to replay everything later.  Basically segment your recordin...

All,  By now you have probably heard of this product that is part of 11g.  What you might not know is that the record (capture) piece of it was backported  to 10.2.0.4 .. You are probably asking yourself... Why do I care ?? Well, I found a great use for RAT capture, and testing a migration to 11g.  ...

Ever want to put down a new second copy of your oracle software that the current version PLUS an additional patch ? Maybe you want to test a patch, or make for quicker patch time.  Think you have to go through the installer and re-install the software, and put on the same patches ? Well you don't ha...

For those of you who heard Tom Kyte speak today, he talked about opening up you physical standby, then flashing it back and putting it back in recovery. The above items are even more feasable using this 11g feature.

Don Burleson... Many of you in Rochester have met him.. Personally, I've followed his path and been at three of the companies he's worked for. Love him, or hate him, he has a great site to get a second opionion on your AWR.. Just copy and paste a text AWR, and it will highlight what you should look ...

If you are using a physical standby database in your environment, you can take advantage of this database for other items.  First remember if this is your DR site, using your standby for other items may increase your recovery time. To accomplish this open up your standby for write, and then recover ...

This is a Tom Kyte trick, that I found very useful. I have a query that runs slow , and after looking at the explain plan, I see a full table scan, and what the cost is. I was wondering what the cost would be if I put a composite index on 2 columns to stop a full table scan. This being an inuse perf...

Last week I talked about all the wonderful reasons to use services.   This week I will cover why Services are especially important in RAC.   First lets cover the 2 ways to create services. For my example, I will create 2 services for my 2 instances.. The instances are db1 and db2.  the 2 services ar...

This weeks topic is services.   From the beginning for those who are old enough to remember (pre-RAC) connection strings. All we really cared about was Host:database:port Then with Oracle 9, service_names was introduced. Over time, if you were like me, you got used to the new connect string format u...

Bind variables... Every wonder what the bind variables are that were used to create an explain plan ?? This a way to find out what bind variables were used, so you can use those same values to try to find your performance issue. STEPS 1) Find the sql_id for the sql statement you are trying to track...