Re: all time worst question I have been ever asked as a DBA
Date: Tue, 26 Jul 2011 15:52:05 -0400
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
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-lReceived on Tue Jul 26 2011 - 14:52:05 CDT