Tag: Oracle

Log Buffer #138: A Carnival of the Vanities for DBAs

Welcome to the 138th edition of Log Buffer, the weekly review of database blogs.

Read More >

RMAN Redundancy is not a Viable Retention Policy

I have always had a preternatural dislike for using REDUNDANCY as a retention policy for Oracle RMAN, greatly preferring RECOVERY WINDOW instead, simply because REDUNDANCY doesn’t really guarantee anything valuable to me, whereas RECOVERY WINDOW guarantees that I’ll be able to do a point-in-time recovery to anytime within the past x days. The two biggest points to take away are: Tape backup failures are still serious backup failures and should be treated as such, even if you backup to disk first; and, REDUNDANCY is not a viable retention policy. In my house, it is configuration non grata.

Read More >

Creating a test database in 5 minutes

What is the most boring part of being a DBA? Many of us reply with “installing and creating a database”. Really, that is not true, at least not creating a database. If you think create database is a boring ad-hoc work and takes a whole day to do, that is because you used wrong tool or you misunderstood what is going on. DBCA is what you need to create a test database in only 5 mins. Let me show you.

Read More >

How to become an Oracle Certified Master (OCM)

A turning point in a DBA’s career is when he/she is recognized by Oracle as an elite Oracle professional. I was happily surprised to find out I became an Oracle Certified Master (OCM). I got another surprise right away, “You are the 2nd OCM at the Pythian Group”. Well, I am very happy that I have been working among brilliant people here. Believe it or not, after I became an Oracle 10g OCM, everybody else wanted to know how to become one. Let me show you the way to become an Oracle Certified Master (OCM).

Read More >

SunFire T2000 servers are best suited for Oracle MiddleTier

Recently, an Oracle-L discussion on Sun T2000 servers got me thinking. The T2000 servers have Sun’s new line of processors, UltraSPARC-T1. These processors come with 8 physical cores, and each core has 4 threads (similar to hyperthreading in Intel Xeon Processors). So each UltraSPARC-T1 processor shows up as 32 Processors (8 cores * 4 threads) at the operating system (OS) level. Sun termed this technology “Cool Threads”. It is supposed to give high-volume throughput along with saving millions on power and cooling costs. But many discussion forums have more complaints against these T2000 servers than praises.

Read More >

Log Buffer #136: A Carnival of the Vanities for DBAs

This is the 136th edition of Log Buffer, the weekly review of database blogs. Welcome.

Read More >

How To Choose Your Oracle Database ID (DBID)

You can choose a DBID when you rename your Oracle database. This is probably a bad, unsupported, and useless idea. I assume this hidden feature can help you to mess up all your backups. So my advice would be: “don’t use it.” I performed this test with Oracle 11.1.0.7 on Linux x86. It consists in using dbms_backup_restore instead of nid to rename the database. You’ll find below the few steps require to get to it.

Read More >

Twitter — Tracking Production Actions?

don’t want to post the link to this (perhaps, it was left public unintentional?) but here is what I stumbled upon recently. This is a log of production maintenance of IT systems in Perth, Western Australia (as far as I could say): Good idea but shouldn’t companies keep this sort of information private?

Read More >

Google Charts for DBA: Tablespaces Allocation

Pythian DBA’s have daily reports for each monitored database and some of the components are using charts to visualize the data. I’m a big fan of charts myself (when applied appropriately) and want to show how you can generate simple charts directly from the database. You’d be very surprised how easy it can be done from *any* database without installing any additional software or configuring something special.

Read More >

RMOUG: Day Two

Day 2 finished yesterday. It was quite a busy day, with some excellent sessions. Have a look.

Read More >
Page 93 of 144« First Page...10...9192939495...100...Last Page »