SQL Plan Stability and CBO Statistics Myths Busted

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.


© Eddie Awad's Blog (more...)

Logger: a PL/SQL Logging and Debugging Framework

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

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

@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

OraNA.infoYou 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

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.

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

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

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.

Continue reading...


© Eddie Awad's Blog, 2012. | Permalink | Add a comment | Topic: Oracle | Tags:

★ Oracle OpenWorld 2012 – Latest and Final News (Oct04)

Selected tweets, videos and photos from the last two days of Oracle OpenWorld 2012:

Continue reading...


© Eddie Awad's Blog, 2012. | Permalink | One comment | Topic: Oracle | Tags:

★ Oracle OpenWorld 2012 – Latest News (Oct02)

Selected articles, tweets, videos and photos from Tuesday’s events:

Continue reading...


© Eddie Awad's Blog, 2012. | Permalink | Add a comment | Topic: Oracle | Tags: