Oracle - Oracle - Toad World


Oracle Community

Oracle Blogs

Kellyn PotVin
Follow /8 Oct 2015 at 11:05pm / Oracle

Indianapolis, ECO, IOUG and Oracle Education Foundation, Ohm My!

I’ve been a bit busy traveling and speaking, but I wanted to discuss the great events I’ve been lucky enough to be part of the last couple weeks. Indianapolis Oracle User Group I spoke at the INOUG back on September 17th.  The user group...
74 0 /
Follow /7 Oct 2015 at 2:00pm / Oracle

Why go to Oracle OpenWorld?

We’re a shade under a month away from the biggest event in the calendar for those that work in the Oracle marketplace – the Oracle OpenWorld Conference. It runs every year in San Francisco and draws a massive 60,000 attendees from 145 countries...
53 0 /
Abu Fazal Abbas
Follow /7 Oct 2015 at 11:50am / Oracle

ONLINE statistics collection in Oracle Database 12c : Part 2

Today’s discussion is again on the ONLINE statistics collection in Oracle database 12c. In one of my earlier post , I had discussed about the extensions/enhancements made to the online statistics collections in Oracle 12c. We have seen that Oracle...
87 0 /
Dan Hotka
Follow /6 Oct 2015 at 9:41pm / Oracle

SQL Tuning- lessons learned from a lifetime in Explain Plans (part 13)

Hi! Here is a cool tip. When tuning SQL with sub-queries, did you know since Oracle10 there is a label you can add that shows up in the PLAN_TABLE? I submitted my findings to the Toad crew and they added it to Toad! The QB_NAME(<label>...
71 0 /
Dan Hotka
Follow /6 Oct 2015 at 9:36pm / Oracle

The Importance of Index Monitoring

Hi! One might wonder, indexes are good, why do I need to monitor them? Well, monitor their usage then. Indexes are good for SQL when they are used. Oracle10 was a big change for the cost-based optimizer (CBO). The older CBO and the old rule...
88 1 /