OraNA :: Oracle News Aggregator

SQL Plan Stability and CBO Statistics Myths Busted

Eddie Awad | May 14, 2013

Carlos Sierra:

Since lack of Histograms or freezing CBO Statistics do not guarantee Plan Stability, do not rely on these two myths. If what you are looking for is Plan Stability use then SQL Plan Management available since 11g or SQL Profiles available from 10g.

★

Logger: a PL/SQL Logging and Debugging Framework

Database Applications Development

Eddie Awad | May 6, 2013

Martin D’Souza:

Logger is a PL/SQL logging and debugging framework. It’s used in many organizations to instrument code in their Oracle applications. Tyler Muth created Logger a few years ago and has since released several upgrades, the last being 1.4.0. After some great feedback, I’m pleased to announce (more...)

Not a Fan of Public Synonyms, Here is Why

Database Applications Development

Eddie Awad | May 4, 2013

Tom is not not a fan of public synonyms, here is why:

public synonyms pollute the namespace.

public synonyms can lead to security issues.

public synonyms can lead to a maintenance headache.

public synonyms are public – no one owns them.

So, instead of public synonyms…

create PRIVATE synonyms or (more...)

When You Should Consider Flash for Database Storage

Database Applications Development

Eddie Awad | Apr 30, 2013

@flashdba:

If any of this is ticking boxes for you, it’s time to consider what flash could do for the performance of your database:

I/O wait times are high. Essentially we are looking for high latency from the existing storage system. Flash memory systems should deliver I/O with sub-millisecond (more...)

★ Oracle News Aggregator OraNA No Longer Powered by Google Reader

Database Applications Development

Eddie Awad | Mar 25, 2013

You probably heard that Google is going to shut down Google Reader (GR) on July 1st, 2013.

There are many theories, speculations and analysis as to why Google took the decision to kill Reader.

To me GR was not just a place I visit several times daily to get (more...)

★ SQL Developer/APEX Listener Bug and The Power of Social Networking in Action

Database Applications Development

Eddie Awad | Jan 3, 2013

Have you installed or recently upgraded to Oracle APEX Listener 2.0? Have you used SQL Developer 3.2 to manage APEX Listener settings? If you answered yes to both questions then you are in for an unwelcome surprise.

The surprise is that you’ll get a “500 – Internal Server Error” whenever you upload a file via any of your APEX apps or import files via the APEX Application Builder.

Hmm! Upgraded from #Oracle APEX 4.1 to 4.2.1 – now getting “500 – Internal Server Error” using file upload. APEX listener 2.0 #orclapex
— Eddie Awad (more...)

★ Event-based Scheduler Jobs and Oracle Streams Advanced Queuing: A Powerful Combination

Database Applications Development

Eddie Awad | Oct 23, 2012

Problem:

An external or internal application wants to send inbound data to your Oracle database, like for example a purchase order or a receivable invoice. You want to consume this data in real time.

Assumptions:

The version of your Oracle database is 11gR2 or above. The only “tool” you have is the Oracle database, i.e. you do not have any middleware (like SOA suite) installed. The external or internal application can connect to your Oracle database.

Solution:

Use Oracle Streams Advanced Queuing (AQ) for messaging. Use an event-based scheduler job for real time data consumption. Both are standard features (more...)

★ Video Montage of Oracle ACE Directors

Database Applications Development

Eddie Awad | Oct 11, 2012

Todd Trichler (@otnTodd) created a video montage of a bunch of Oracle ACE Directors. Ever wonder what an Oracle ACE Director is like? Check out the video below. I make an appearance at 4:02 minutes.

Bonus footage of the Oracle ACE Program wranglers Vikki Lira and Lillian Buziak (@oracleace) discussing the program.