Re: all time worst question I have been ever asked as a DBA

From: Thomas Roach <troach_at_gmail.com>
Date: Tue, 26 Jul 2011 15:52:05 -0400
Message-ID: <CAM6TEv+En+PGJg_gQQG2H7hCsC6pEWg_nRNpi_8jjqELL1vP8Q_at_mail.gmail.com>

This wasn't actually asked to me but another DBA. I just overheard the conversation.

Management : "Why is the application performing so poorly?" DBA : "Because the application is holding some locks that others want to use."
Management : "Can't we just get rid of those locks? Can we just turn them off? We don't need locks."

The DBA had a deer in the headlights look. Priceless.

On Tue, Jul 26, 2011 at 3:38 PM, Andrew Kerber <andrew.kerber_at_gmail.com>wrote:

> So, I am getting this error on one of our virtual Linux servers:
>
> ORA-00210: cannot open the specified control file
> ORA-00202: control file: '/u01/app/oracle/datafiles/devdb/control01.ctl'
> ORA-27086: unable to lock file - already in use
>
> Its probably due to a stale NFS lock. The question from my sys admin:
>
> -rw-r----- 1 oracle oinstall 10076160 Jul 22 13:33 control01.ctl
>
> can that file just be removed
>
>
>
> Ok, I am a little frustrated with him...
>
> --
> Andrew W. Kerber
>
> 'If at first you dont succeed, dont take up skydiving.'
>

-- 
Thomas Roach
813-404-6066
troach_at_gmail.com

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 26 2011 - 14:52:05 CDT