Re: ORA-01575 messages/slow response time

Hi all;

A few weeks ago I posted the following in regards to one of my production databases. I received several responses, all of which have been extremely helpful. I wanted to pass on something that happened to me yesterday. I have a TAR opened with Oracle for this problem, and at their request put a systemstate event in my init.ora for error #1575. Well, shortly thereafter the database died with an ora-0600. I was very suspicious of the event, and, eventually, Oracle support confirmed that there was a known bug (# 319040) whereby setting a trace event for a 1575 error can cause on ORA-0600. I certainly learned the hard way that it can, and just thought i'd pass this on.

> About 2 weeks ago my production 7.1.4 database running on a Dec Alpha 8400
> with Digital Unix 3.2d started logging ora-01575 messages (timeout waiting for
> space management resource) to the alert log. We experienced this problem a
> while back after changing % increase on our application tablespaces to get the
> free space to coalesce. The oracle documnets that deal with ora-01575 indicate
> that these messages can occur because SMON may be coalescing free space. The
> problem was resolved by changing % increase back to zero. That was a few
> months ago. We're now experiencing 01575's again. I would very much like to
> hear any advise anyone may have in regards to determining what is happening to
> cause these messages. I do have the documents "solving ORA-01575", and
> "ORA-01575 under heavy database workload" which have yet to provide a solution
> for me. Any thoughts anyone?--

David J. DeWolfe
Systems Programmer III
Statewide Office of Information Services University of Alaska
907.474.7399
sxdjd_at_orca.alaska.edu

In a vicious struggle for survival intelligence emerges as the weapon of  choice. - Nova, In Search of Human Origins Received on Wed Oct 30 1996 - 00:00:00 CST