RE: How I save Cingular Wireless USD 30M

 
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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.

Other related posts: