Tag: Oracle

Testing Out Oracle’s Unbreakable Enterprise Kernel 2

I’m going to test Oracle’s Unbreakable Enterprise Kernel out, and an obvious way to do this would be using Amazon EC2, providing high-capacity instances on demand. After some blind allies getting the Oracle Linux UEK2 kernel working with Amazon EC2 and Oracle VM, I found that I could make it work without Oracle VM, with Amazon’s default Xen hypervisor. Here are the steps I used.

Read More >

Oracle Database Appliance – Urgent Patch 2.1.0.3.1

Just a quick heads up to the ODA customers — there is a critical patch 2.1.0.3.1 out that is applied on top of ODA patch bundle 2.1.0.3.0. This patch has an important fix for a bug causing ODA servers to shutdown in some situations when an ASM disk is lost.

Read More >

Disabling Oracle triggers on a per-session basis

The method of disabling triggers requires Oracle 11.2.0.2+ or 10.2.0.5+, plus execute permissions on sys.dbms_xstream_gg. Since it’s a call to an XStream package, it may also require a XStream license. So if I haven’t scared you away yet, here’s a quick testcase:

Read More >

Oracle Database Appliance — Storage expansion with NFS (dNFS, HCC)

The biggest objection to Oracle Database Appliance (ODA) we hear from customers is about 4TB usable space limit (tripple mirrored 12TB of raw storage). I think most of the times this is more a perceived barrier rather than objective — more along the lines of being afraid to hit the limit if the system grows a lot. Nevertheless, Oracle has been always listening customers’ concerns when it comes to purchasing barriers. Of course, this time is no exception.

Read More >

2001: Oracle Database Appliance by Dell — Déjà vu

Stumbled upon this Dell’s article from 2001, So what do we see 10 years later? Singe device, no fuss, everything pre-configured, Oracle RAC, simplified operations — dream of 2001 finally coming true?

Read More >

Log Buffer #264, A Carnival of the Vanities for DBAs

There is so much to learn out there. So much to accomplish and so much to devour technically. It can be daunting and overwhelming to have so much in one’s plate, and that is why this Log Buffer Edition has culled some top notch blog posts for you in Log buffer #264.

Read More >

See you in Perth, Australia next Wednesday 28th of March 2012

Hello Friends, This is a short blog post to let you know that I am going to give my RMAN and SCAN talks to WA OUG (AUSOUG) folks in Perth next week. Here are the details:

Read More >

Looking for Missing Memory Using R

The forwarded case didn’t have many details. Its a 9i system that started experiencing ORA-4031 errors sporadically over the last few weeks. Marc suggested using R to explore how the various SGA components changed sizes over the last few weeks and see whether we can find any interesting trends that can indicate memory leaks. So we did just that. The first step is to get the actual data out of the system, and we used the following query

Read More >

Log Buffer #263, A Carnival of the Vanities for DBAs

In this Log Buffer Edition, March madness with method continues with plethora of blog posts from across different database technologies. Enjoy this Log Buffer #263.

Read More >

Oracle ACE Directors + 1 — Gwen Shapira

Quick post congratulating Gwen Shapira on becoming Oracle ACE Director. Gwen has be an Oracle ACE for a while by now and been very active in the community. Congratulations Gwen!

Read More >
Page 49 of 147« First Page...10...4748495051...60...Last Page »