Tag: Oracle

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

Welcome to the 139th edition of Log Buffer, the weekly review of database blogs. Let us begin with a look at the best from the Oracle ‘sphere.

Read More >

Jserv JVM Issues with Many SSWA Users

If your configuration matches the following setup, then this blog could be helpful to you. Set up: OS: Redhat Enterprise Linux 3 or 4, JDK: Sun Java 1.3 or 1.4, Apps: 11.5.9 or 11.5.10, Users: many Oracle Self Service Web Applications Users e.g., iProc, iRec, Timecard, and HR self-service With this setup, you might have already faced issues like the Apps login page not responding, or browsers timing out in loading SSWA pages. You might have raised numerous long-running TARs with Oracle support on this and ended up uploading lot of Apache and Jserv debug logs, and you always end up recycling or bouncing the Apache service to fix the issue. Don’t worry—you are not alone here.

Read More >

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 >
Page 94 of 145« First Page...10...9293949596...100...Last Page »