Search found 88 matches
- Wed Sep 23, 2009 2:13 pm
- Forum: DBA Topics
- Topic: Index tuning
- Replies: 0
- Views: 4114
Index tuning
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...
- Tue Sep 15, 2009 1:07 pm
- Forum: DBA Topics
- Topic: 11gr2 is out on September 1st and WOW
- Replies: 0
- Views: 4319
11gr2 is out on September 1st and WOW
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 ...
- Wed Aug 19, 2009 3:42 pm
- Forum: DBA Topics
- Topic: APEX (application Express)
- Replies: 0
- Views: 4478
APEX (application Express)
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 ...
- Tue Aug 18, 2009 3:43 pm
- Forum: DBA Topics
- Topic: How to segment data in RAT
- Replies: 0
- Views: 4366
How to segment data in RAT
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...
- Thu Jul 09, 2009 2:58 pm
- Forum: DBA Topics
- Topic: Real Application Testing (RAT) AKA Database Replay
- Replies: 0
- Views: 4315
Real Application Testing (RAT) AKA Database Replay
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. ...
- Thu May 21, 2009 11:35 pm
- Forum: DBA Topics
- Topic: Tip-of-the-week Cloning your oracle home
- Replies: 0
- Views: 4339
Tip-of-the-week Cloning your oracle home
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...
- Tue May 05, 2009 7:15 pm
- Forum: DBA Topics
- Topic: tip-of-the-week using your standby for so much more
- Replies: 1
- Views: 4666
- Tue May 05, 2009 7:09 pm
- Forum: DBA Topics
- Topic: tip-of-the-week second opinion on your AWR
- Replies: 0
- Views: 4261
tip-of-the-week second opinion on your AWR
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 ...
- Thu Apr 30, 2009 10:17 pm
- Forum: DBA Topics
- Topic: tip-of-the-week using your standby for so much more
- Replies: 1
- Views: 4666
tip-of-the-week using your standby for so much more
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 ...
- Tue Apr 14, 2009 4:04 pm
- Forum: DBA Topics
- Topic: Tip-of-the-week (hidden indexes)
- Replies: 0
- Views: 4404
Tip-of-the-week (hidden indexes)
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...
- Thu Apr 02, 2009 10:18 pm
- Forum: DBA Topics
- Topic: tip-of-the Week -- Why should I use services (cont.)
- Replies: 0
- Views: 4053
tip-of-the Week -- Why should I use services (cont.)
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...
- Fri Mar 27, 2009 12:06 pm
- Forum: DBA Topics
- Topic: tip-of-the-week - Why should I use services ?
- Replies: 0
- Views: 4133
tip-of-the-week - Why should I use services ?
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...
- Wed Mar 18, 2009 11:43 am
- Forum: DBA Topics
- Topic: Tip-of-the-week - Bind variable values on Hard parse
- Replies: 0
- Views: 4675
Tip-of-the-week - Bind variable values on Hard parse
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...