Eddie Awad

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, 2013. | Permalink | Add a comment | Topic: Oracle | Tags: performance

Related articles:

• Delete Column Histograms to Improve SQL Plan Stability
• Oracle Community Membership Statistics
• What you need to know about calling functions from SQL

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 that we’ve just launched Logger 2.0.0 Beta.

Instrumentation, logging and debugging utilities are essential in any PL/SQL development project.

★

© Eddie Awad's Blog, 2013. | Permalink | Add a comment | Topic: Oracle | Tags: framework, pl/sql

Related articles:

• I’m upgraded and updated
• New Oracle PL/SQL Error Management Framework Released
• Insert into DUAL

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… Continue reading...

© Eddie Awad's Blog, 2013. | Permalink | 2 comments | Topic: Oracle | Tags: sql

Related articles:

• Here is How to Unpersist Your Persistent PL/SQL Package Data
• Give Me The Current Date Please
• OracleCommunity.net the Social Network for Oracle People

@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 latency, so if you see an average latency of 8ms on random reads (db file sequential read), for example, you know there is potential for reducing latency to an eighth of its previous average value.
• I/O forms a significant percentage of Database Time. If I/O is only responsible for 5% of database time, no amount of lightening-fast flash is going to give you a big performance boost… your problems are elsewhere. On the other hand, if I/O is comprising a large portion of database time, you have lots of room for improvement.

★

© Eddie Awad's Blog, 2013. | Permalink | Add a comment | Topic: Links, Oracle | Tags: flash, storage

Related articles:

• How to personalize forms in Oracle Applications
• Oracle Database 11g Overview Presentation
• Get All the Cool New Features of Oracle Application Express 3.0 in Oracle Database XE

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 my dose of fresh news, it was also the backend feed aggregation engine that has powered OraNA.info since 2006.

With GR going away soon, I have been working over the past several days to detach it from OraNA.

I’m glad to report to you that the migration off of GR is done. OraNA now aggregates all of its syndicated feeds via its own feed aggregation engine.

OraNA has been operating since the beginning of 2006. In the process of updating it, I took the opportunity to do spring cleaning on the blogs that it aggregates.

Blogs that no longer exist have been deleted from the aggregator.

Blogs that still exist but have had no new posts since January 2012 are no longer aggregated by OraNA.

I was surprised at the number of blogs that fell into the two categories above.

The number of aggregated blogs fell from 508 to 323 (plus the blogs.oracle.com feed).

Here is a live list of all the blogs that OraNA aggregates.

I guess the enthusiasm for long form blogging has fizzled out over the years. Lazy bloggers (including yours truly) find it much easier and quicker to “micro” blog using Twitter, Facebook or Google+.

On a personal note, I have moved my daily dose intake of news from GR to Feedly.

© Eddie Awad's Blog, 2013. | Permalink | 2 comments | Topic: Oracle | Tags: aggregator, blog, Google

Related articles:

• OraNA powered by Google and FeedBurner
• Oracle News Aggregator Flooded
• Oracle OpenWorld News Aggregator