RE: Time estimate for patches from Oracle

I was in a similar situation last year, and after escalating it to a Sev1 on the Oracle Support side, and engaging our account rep I raised it to our CIO. He had a "nice" talk with the Oracle account rep after which we got temporarily upgraded to a "critical account" and Oracle Support was a bit more responsive.

In summary, if you can't get them to respond appropriately, get the person that is paying the Oracle support bill to chat with your account rep.

And don't let your account rep tell you that he has no influence over development. If he is any good, he has the right contacts, otherwise get another account rep so that you won't have the same issue again.

Regards,

Vlado Barun, M.Sc.
Senior Enterprise Database Architect

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bill Ferguson Sent: Monday, April 21, 2008 12:15 PM
To: rjoralist_at_society.servebeer.com
Cc: oracle-l_at_freelists.org
Subject: Re: Time estimate for patches from Oracle

All -

Thanks for the input so far. This is escalated to a severity 1, as the database is completely unusable. It seems to be a combination of Undo and the flashback archive (total recall). Not quite sure what the 'magic' combination is, but something I'm doing in the database keeps generating an error message of "Out of transaction slots in transaction table", and once that happens all I can do is a "shutdown abort" and then restart again.

The problem with this is that once I do, then most of the undo needs to be re-applied back (roughly 35GB, that takes about 6 hours), and then the system seems to crash shortly afterwards again. It's also generating around 20GB of trace file activity every 6 hours as well.

And even though I'm on Windows, it turns out that this bug was originally found and fixed for Linux platforms, as that's what all of the previous bug reports were for. Evidently I'm the first to report it on Windows, and the guy from Oracle Support said they had to work on a backport, which seems to be done. It sounds like what they need to do now is figure out how to 'package' it as a patch, etc., but I haven't received a timeframe from them yet.

Needless to say the users are getting a bit fed up and I don't know to tell them. Things were running fine here on 11g for a bit over 4 months, so it's a bit difficult trying to figure out how to move back to 10.2, besides the lose of 4 months of data. I'm not sure what other data problems would occur taking everything back from 11g to 10.2, besides the lose of all changes made to the data since we moved to 11g (which was the primary reason to do it).

--

• Bill Ferguson
  --
  http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Apr 22 2008 - 07:46:29 CDT