Success is about Imagination

How does one clone in a few minutes and for almost no storage the entire EBS stack including the database, EBS application stack and...

Companies rely on applications to supply the information that business uses to make decisions that generate revenue. Companies are...

I love this video on “getting dreadful database performance” by Stephane Faroult. The video is hilarious and informative:...

One  small but bothersome  issue I’ve had for 20 years is  how to drive a program like SQL*Plus with a shell script to make it...

Oracle wait events took years to become widely known for their power in performance tuning. Similarly it has taken years for most DBAs to...

Any intelligent fool can make things bigger and more complex. It takes a touch of genius – and a lot of courage – to move in the opposite...

Yahoo shut  Altavista down a couple of years ago. Why did Google succeed when Altavista had index the web before Google ever started? Dan...

Dates are a surprising pain for correlating data an at the same time being understandable to the human reader. For a generic form we can...

DBA_HIST_EVENT_HISTOGRAM has a history of I/O latency histograms. DBA_HIST_EVENT_HISTOGRAM is only on 11g, so for 10g, it requires...

Can you version control database? How do you manage databases in application development?  For all the advances in application...

When mounting NFS file systems there is an option to set the max rsize requested. For example: mount -o rsize=1048576,wsize=1048576,proto...

A customer  was working with a clone copy of their production database for reports, but the cloned database reports were running slower...

Every so often a DSS query that usually takes 10 minutes ends up taking over an hour.  (or one that takes an hour never seems to finish)...

What happens with I/O requests over NFS and more specifically with Oracle? How does NFS affect performance and what things can be done to...

What is right deep verses left deep? Good question. In join trees (not VST) the object on the left is acted upon first then the object on...

How long does it take to create a clone of an Oracle RAC database? How complicated is it? How much experience does it take? How about no...

About year ago or more, Oracle came out with a way to create thin clone copies of a database in EM 12c called “Snap Clone”. Not sure this...

Performance testing requires full, fresh data Many organizations don’t even attempt to test performance until very late in their...

Followup: The tweets from the datachat are available at http://www.confio.com/logicalread/oracle-db-performance-80-percent-hardware-dc01/...

Maximum manageable storage per VM by ESX version 4.1: 32TB (vmdk) / 120TB (RDM) 5.0: 60TB (vmdk) / 3.75PB (RDM) 5.1: 60TB (vmdk) / 3.75PB...