Tag: DBA Lounge

Scaling MySpace: Treading Water in a Tsunami

Those of you that that enjoyed my post on Stability, Agility, Scalability and Cost: The eBay example are sure to like this technical interview of the desperate efforts to stay only a bit behind the traffic demands at MySpace, written by David Carr at Baseline Magazine. A worthy read for those of you interested in the lofty heights of database scaling, where we pack oxygen and have to make some choices and compromises along the way.

Read More >

Slow rman Backups? Check This Out

If you have found rman backups slow in Oracle 10.2.0.2, you should check out note 375386.1 on metalink. It seems the CBO isn’t all its made out to be, and you have to force rman to use the RULE hint instead to make your rman backup run faster

Read More >

Calling Definer-Rights Procedure as SYSDBA – Security Hole?

In one of my previous posts I mentioned SYSTEM_PRIVILEGE_MAP view. Taking this thread further, I looked into another nice view – V$ENABLEDPRIVS – showing the privileges enabled for the session at the moment. It should be pretty useful if you decide to add some diagnostics into your application. You might also find it very helpful to call from PL/SQL.

Read More >

Yes, More and More and Moore… but Different!

We humans are not able to process large amount of precise data. In any human–readable report, we don’t need more than ten or twenty lines of numbers. Every time we look at processes or data more complex that that, we employ simplifications — graph trends, mind–mapping, aggregations, and so on. How will we make computers process information just as humans do? Perhaps we can find the answer inside ourselves if we figure out how our minds work. We recognize images even though our brain is not capable of processing huge amounts of data in milliseconds.

Read More >

SanDisk’s $600 Solid-state Drive could be a Game-changer

Read Gary Krakow’s review of SanDisk’s 32GB, 1.8-inch solid-state drive (SSD)

Read More >

Oracle 10.2.0.3 Patchset – Known Issues and Bugs

Oracle 10.2.0.3 Patchset – Known Issues and Bugs. Oracle 10.2.0.3 patchset is not functional on Solaris SPARC 64bit platform with datafiles on Veritas VxFS.

Read More >

Oracle Gotcha: Months_between 31-days-per-month assumption

Over-the-Top Tales from the Trenches:: Bringing order to the chaos of everyday DBA life.

Do you want to know a secret? Understanding it will prevent pain and gnashing of teeth, and also leave your face comfortably free of egg. Here it is: Some Oracle functions assume there are 31 days for each month of the year! The moral of the story: be careful when using MONTHS_BETWEEN for fractional dates.

Read More >

Handling the Support Pager

A short story depicting the life of an on call DBA

Read More >

The Fine Art of Baloney Detection: In honour of Dr. Carl Sagan

Carl Sagan is a personal hero of mine. Ten years ago today this gifted communicator died of cancer. And so today the community of bloggers that loved and admired Carl Sagan is having a spontaneous blogathon in his memory. You might ask, what does Carl Sagan have to do with being a good DBA? Believe it or not, a lot. Yes, really.

Read More >

The Pitfalls of Oracle’s Automatic SGA Management

Oracle thinks it can make queries run better by not having to parse them repeatedly, so it grows the shared pool to keep as many queries as it can. Problem: the shared pool is now 4G+. That takes a while to trawl through, which of course adds to the spins on the library cache lock and pushes up CPU usage. I’m going to get into more detail on this when I have the time, but for this db, I think I’m going to switch to manual SGA and set a hard limit of 500M-1G on the shared pool

Read More >
Page 48 of 60« First Page...10...4647484950...60...Last Page »