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.
- 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.
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...
- 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
- 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.
- 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.
With GR going away soon, I have been working over the past several days to detach it from OraNA.
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.
- OraNA powered by Google and FeedBurner
- Oracle News Aggregator Flooded
- Oracle OpenWorld News Aggregator