Search

Top 60 Oracle Blogs

Recent comments

March 2014

12c pq_replicate

Another day, another airport lounge – another quick note: one of the changes that appeared in 12c was a tweak to the “broadcast” distribution option of parallel queries. I mentioned this in a footnote to a longer article a couple of months ago; this note simply expands on that brief comment with an example. We’ll start with a simple two-table hash join – which I’ll first construct and demonstrate in 11.2.0.4:

Recurring Conversations – Incremental Statistics (Part 3)

As Connor pointed out in his comment on the last post, Incremental Statistics might still turn out to be a bit trickier than you thought once you start using them on many or very large tables, even once you've got the basics right. 

Which is why there's still a place for the detailed technical blog posts, once you've got the basics clear. The problem with not having the basics clear is that I've had people tell me things about Incremental Stats based on the blog posts and, when I read them, they make sense to me but I can also see why they might confuse others. Anyway, for completeness, here are some terrific posts about Incremental Stats.

JIRA_UTL Tutorial 1: Creating an issue

So the first tutorial will show how to create a jira issue directly from the database. We will create two types of issues, a bug and a subtask to an existing issue. .... Read more on my blog

Twitter Oracle Security Open Chat Thursday 6th March

I will be co-chairing/hosting a twitter chat on Thursday 6th March at 7pm UK time with Confio. The details are here . The chat is done over twitter so it is a little like the Oracle security round table sessions....[Read More]

Posted by Pete On 05/03/14 At 10:17 AM

OTN Yathra 2014 : It’s a Wrap

The OTN Yathra 2014 tour is over and I’m back home now. Here are all the blog posts from the tour.

Managing database dependent development

Application developers frequently experiment to achieve higher quality builds, they try things out, make mistakes and find fixes. Database design can be like that too, but rapidly changing the schema in traditional shared environment tends to break the application.

In this webinar, Kyle Hailey will explore how different types of cloning technology work and their benefits and limitations. The webinar will also demonstrate how you can setup and coordinate risk-free database experiments using Delphix and Red Gate’s Oracle tools.

Kyle Hailey and James Murtagh

Index Rebuild, the Need vs the Implications Support Note 989093.1 (Getting Better)

Once upon a time, Oracle Support had a note called Script: Lists All Indexes that Benefit from a Rebuild (Doc ID 122008.1) which lets just say I didn’t view in a particularly positive light :) Mainly because it gave dubious advice which included that indexes should be rebuilt if: Deleted entries represent 20% or more of […]

Pure Storage and Delphix

chocolate_peanutbutter

Joint webinar:

Super Charge Database Deployments

 

 

pure_storage  delphix_logo_color

Oracle EMEA Virtual Developer Days 2014

Aanstaande dinsdag 4 maart wordt er door Oracle een Oracle EMEA Virtual Developer Day georganiseerd. Je kunt je hiervoor gratis inschrijven en live, via het...
class="readmore">Read More

Hotsos 2014 Presentation

Just a quick note that I’ve added a zip file with my presentation at Hotsos yesterday which includes the scripts that I demoed. You can find it on the Whitepapers/Presentations page. Or you can just click this link:

SQL Gone Bad – But Plan Not Changed!