Top 60 Oracle Blogs

Recent comments

October 2012

DOUG presentation on dbms_xplan

Please join us at the DOUG (DALLAS ORACLE USERS GROUP) Oracle Database Forum meeting on Thursday, October 25, 2012 from 5 pm – 7 pm.
Presented by Riyaj Shamsudeen, OraInternals, & Sahil Thapar:

“Out with the old way, Enter dbms_xplan: A Swiss army knife for performance engineers”

Rough outline:
(i) Ability to query access path from memory, AWR repository
(ii) Ability to use cardinality feedback method to understand access plan issues. Few tips from a real world experience will be provided too.
(iii) Ability to understand issues with database links etc.
(iv) Options such as ADVANCED, ALLSTATS etc
(v) Why should you choose dbmx_xplan over tkprof+sql_trace combination?
(vi) Disadvantages of dbms_xplan and a quick introduction to dbms_monitor.

Refreshments sponsored by me :)

oci-24550 [3221225477] [Unhandled exception: Code=c0000005 Flags=0

October 22, 2012 Lately, I have been busy with a couple of items that are not completely Oracle Database specific.  I tried experimenting with high definition 1080p security cameras.  After wasting an unacceptable amount of money to purchase two Y-Cam Wireless High Definition 1080p video cameras (model YCBLHD6), and spending in excess of 38 hours fighting with the cameras [...]

What Cancer Cannot Do

For my sister and all those who battle cancer...

Cancer is so limited...
It cannot cripple love.
It cannot shatter hope.
It cannot corrode faith.
It cannot eat away peace.
It cannot destroy confidence.
It cannot kill friendship.
It cannot shut out memories.
It cannot quench the spirit.
It cannot silence courage.
It cannot reduce eternal life.

Bring Your Own Device (BYOD) : Context is everything…

Bring Your Own Device (BYOD) is definitely an important issue for companies and IT departments, but what the vast majority of reporters and CEOs seem to forget is that context is extremely important.

Looking at this from a company perspective, when we are talking about phones and tablets, then BYOD is a pretty important issue. It seems to be creeping into the laptop side of business a little, but as far as desktops are concerned, BYOD it is virtually non-existent. So when Marc Benioff talks about the affect of BYOD on Windows 8 uptake I think he is living in some sort of dream land. I’m not suggesting Windows 8 will be a success in business, but it’s failure will not be down to BYOD.

ZFS Home Storage Network at 10GbE

About a year ago I've decided to put all my data on a home built ZFS storage server. The growing amount of devices around my household prompted for an easier and much faster way to share the data. Since then the box was happily serving both CIFS as well as iSCSI over 1GbE network without any issues.

I was keen on upgrading to 10GbE for quite some time as both my server as well as clients could easily saturate 1GbE link when ZFS had all the required data in ARC. 32GB RAM in my storage server usually left me with the ARC of about 20GB which in most cases happened to be enough to cache the entire workset I was working with. Bottom line is the box rarely had to touch the disk and even if it did there was 120GB L2ARC SSD to even the bumps capable of maxing out 1GbE link as well.

It so happened that I managed to get my hands on a pair of 10GBASE-T Emulex OCe11102-NT NICs which I bought at a significant discount.

WebLogic and Forms & Reports Services Articles Updated…

I ran through a Forms & Reports Services installation on WebLogic 10.3.6 this morning, so I made some minor tweaks to my existing 10.3.5 articles on that subject.

The current spin of Forms & Reports Services has a prerequisite check for 10.3.5, so you just have to turn off the prerequisites check using this.

$ ./runInstaller -ignoreSysPrereqs

Apart from that it’s pretty much business as usual.




I came across a nice bit of code on OTN recently that someone had written several years ago (in 2007, in fact)  to demonstrate the different ways in which the optimizer would handle “select count({something}) from table;”. If you want to copy and repeat the test code, you may need to adjust it slightly – it references a type vc2s, which I changed to dbms_stats.chararray, and it references a plan table called toad_plan_table, which I replaced with references to the standard plan_table (getting rid of the truncate as I did so).

Adaptive Log File Sync: Oracle, Please Don’t Do That Again

Disclaimer: Much of what follows is pure speculation on my part. It could be completely wrong, and I’m putting it out there in the hopes that it’ll eventually be proven one way or the other.

Friday Philosophy – Is the CBO becoming way too complex?

I was at the SIOUG annual conference in Slovenia this week (and a very good conference it was too) and I was watching a presentation by Christian Antognini about how the CBO learns by it’s mistakes. This was of course mostly about adaptive cursor sharing and cardinality feedback. Chris was also able to share a few tid-bits about 12c enhancements in this area. I can’t go into details, but basically it looks like the CBO is going to not only enhance those two features but there is a new one where the CBO can change the plan on the fly, as the same query progresses.

Adaptive Log File Sync: Oracle, Please Don’t Do That Again

Disclaimer: much that follows is pure speculation on my part. It could be completely wrong and I’m putting it out there in the hopes that it’ll eventually be proven one way or the other.