Re: very poor SYS view performance (8i) / fragmented data dictionary

wizofoz2k_at_yahoo.com.au (Noons) wrote in message news:<73e20c6c.0312101732.66f4a54e_at_posting.google.com>...
>
> Bummer. How about complaining to said 3rd party that their
> SQL with missing join conditions is cactus (to put it mildly)?
>

I also thought about that, but it would be a slow solution to the problem. Anyway, this should be addressed.

> Having said that, I believe your case is simpler. It's a combination
> of truly bad SQL and the version you're running. Vanilla 8.1.7.0 has
> some very nasty bugs in its optimiser.

I can only hope that this may help a lot. I do remember many troubles with the first 8i releases and I wonder why they still stick to this release, while other systems in this company run on 8.1.7.4. I'll also try to find some docu on re-organizing SYS's objects - do you have any links (other than orafaq.com, ixora.com or dbaclick.com)?

> Any chance of ditching that 3rd party software
> that is causing the problem? What's it got to do with the dictionary
> anyway and why is it looking at constraints?

Well, this project environment is rather new to me and I still have to figure out what all those scheduled applications are supposed to do. This specific application issues the very same data dictionary selects over and over again for minutes and then suddenly changes to other tasks for the next minutes. Looks a bit weird, but I'm afraid the consultants in this project wouldn't want to dump that piece of software.

Again, thanks for your suggestions Received on Thu Dec 11 2003 - 10:30:47 CST