Views being damaged

I have a very large view on an Oracle set of tables.

After the create view, it works very fast a few times then, all of a sudden, there is something that goes wrong somewhere and every use of the view generates thousands (read sometimes millions) of recursive calls. The server uses 100% of its CPU, every user has a bad response time and, the user sending the select never receives any response until the unix process is killed.

We run Oracle 7.1.3 under Sun Solaris. We think that the problem was not present with Oracle 7.0.16.

Does somebody ever get that kind of problem?

Michel Keable
Universite Laval

Michel.Keable_at_sit.ulaval.ca Received on Mon Oct 02 1995 - 00:00:00 CET