OraNA :: Oracle News Aggregator

Just a short notice to those interested that I’m very proud to be in the lineup for Enkitec’s Extreme Exadata Expo. The event takes place August 5-6, 2013 and is held in the Four Seasons Resort & Spa, Irving, Texas. There is plenty of time for you to register.

I (more...)

If you have seen a colored scripts like a fish from “Session Snapper v.4″ by Tanel Poder or OraLatencyMap by Luca Canali, you may be also want to colorize your scripts.
I’ve created the script for this purposes with predefined substitution variables.
Just download colors.sql and use (more...)

#12 All NoCOUG emails automatically go to your spam folder, including this one. You rely on Outlook for career guidance. #11 They won’t send a stretch limousine to pick you up and take you back. #10 They talked up SQL for 25 years but now, they’re all, like, “No SQL. (more...)

New advancements in cloud-based business process management (BPM) software is empowering different departments to connect and share information more easily, while automation is driving new opportunities for improving efficiency. With remote database support, companies can migrate these systems to the cloud for optimal functionality and to immediately leverage other benefits.

(more...)

Obligatory Melodrama

No matter how much time goes by I still remember it. The day my database was crippled beyond reckoning. That moment when I saw my hopes for a bright and shining future with my database spill through my fingers like so many cracker crumbs falling on a clean (more...)

Business intelligence (BI) analytics have become a top priority for enterprises in every industry, as these solutions can drive valuable insights that lead to higher staff performance, lower operational costs and enhanced customer service. While some firms may struggle to adequately leverage these advantages, dba services can support more successful (more...)

We’ve had a couple of short lived, but very inconvenient I/O latency issues recently. I’ve been using the awesome Latency Heat Map Visualization by Luca Canali as one of the tools to investigate this.

I’m guessing this isn’t the type of I/O latency heat map most people would want to (more...)

I ran some SLOB tests over the weekend using the new SLOBv2 kit and noticed some interesting results. I was using SLOB to generate physical I/O but the “anomaly” is best demonstrated by putting SLOB in “Logical I/O mode”, i.e. by having a large enough buffer cache to satisfy (more...)

With the expansion of big data, mobile technologies, cloud computing and virtualization, many companies have become overwhelmed by a greater need for database management. And as harnessing and deriving value from data is the key to a competitive advantage, corporations depend on support from dba services.

Datamation reported that according (more...)

I wanted to read a new book for new idea. Maybe, it's about something startup. Yes! For something new, that's a good idea. I chose to read "Managing Startups: Best Blog Posts" book By Thomas Eisenmann. This book, Harvard Business School Professor Tom Eisenmann annually compiles the best (more...)

Big Data – The New Information Before asking the crystal ball what can Big Data do for you, sit back and think about these four questions: Where’s the new information? Where could it be? If it was in the right place, what could happen? (Challenges of the main industries) What are the (more...)

Imagine someone has deleted your spfile or you have modified it in depth that you are now unable to even startup your database.
Your only option is to restore your spfile and this step is easy if you have not forgot to setup your RMAN environment to use the AUTOBACKUP (more...)

You're joking. Right?

Oracle performance analysis has come a long way in the last 20 years. First there was the “just add more resources” approach and tuning the blatantly poor SQL. Then there was ratio analysis, followed by wait event analysis, time based analysis, and unit of work time based (more...)

Practice makes perfect, but it does not have to be difficult. Please don’t short yourself by not trying to understand what is going on.

This is my third RAC install and I got tired of doing it the hard manual way; hence, decided to script what I can.

ASM will (more...)

At the time of writing this post, Oracle Forms 11g installations are configured by default to work with a specific JPI (Java Plug-In) version: 1.6.0_12. You can verify this by checking your formsweb.cfg file: grep jpi-version formsweb.cfg #jpi_mimetype=application/x-java-applet;jpi-version=1.6.0_12 Unfortunately, it seems Firefox is very particular when it (more...)

Chapterhouse Dune is the last in the Dune series by Frank Herbert.

It’s really hard for me to make a judgement about Chapterhouse: Dune. On the one hand there are some excellent characters and the general story line is great. On the other, there are parts I found really boring. (more...)

How do you want to start the day? I’m guessing it’s not to be called out to the front of the room by a speaker and used as a guinea pig, while they ask you trick questions to make you look stupid. Tom Kyte, you will pay. Oh yes! You will (more...)

So Day 1 (part 2) didn’t go to plan because I forgot to take my camera or my phone to the party.

Suffice to say, lots of food, lots of drink (for those that do) and most importantly lots of dancing. Yes, I once again murdered the traditional dances of (more...)