RE: How I save Cingular Wireless USD 30M

From: Matthew Zito <mzito_at_gridapp.com>
Date: Fri, 24 Aug 2007 16:23:38 -0400
Message-ID: <C0A5E31718FC064A91E9FD7BE2F081B1B97A2E@exchange.gridapp.com>

With all due respect, and thanks for the detailed explanation, but you'll gladly give all sorts of confidential information about your employer, some of which probably could be classified as "material" under SEC rules (having to do with financial data, having to do with potential capital expenditures - $30m is a lot), put all of this out on a public mailing list, but you won't tell how you did it cause it's "Oracle Confidential"? I'd be a lot more concerned about what Cingular might think about your posting this...

Thanks,
Matt

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tom Pall

	Sent: Friday, August 24, 2007 3:14 PM
	To: oracle-l
	Subject: How I save Cingular Wireless USD 30M
	
	
	I was asked to look into a database which was deadlocking.  This

was one of dozens of databases which handled switch data. Nothing in the telecoms is small. These were up to 17 TB databases. And they were on 8i and 9i and dictionary managed.

I looked and looked. I could find a reason why the database was deadlocking except that it was running more slowly than before (vendor application which had not been changed). I opened up an iTAR with Oracle and of course got back the usual "How to tune a database" and "What causes deadlocks" citations. I was infuriated. I've been with Oracle since Oracle 2, so I didn't need this.

All in all, I saved Cingular approximately USD 30M in not losing these very vital databases and not having to continue to buy yet more hardware as they had been doing for years before this DBA cane on the scene. I achieved increase in speed of the Oracle Engine from 2-10X what it was previously.

What exactly did I do to fix the corruption. Sorry, but that is Oracle Confidential. If you have this problem I can give you names within Oracle but go no further. Yes, we eventually were able to convert to DMT (after even more corruption fixing) and now the problem is gone.

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

Received on Fri Aug 24 2007 - 15:23:38 CDT