Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd7cy2so!shaw.ca!news-out.superfeed.net!propagator2-maxim!news-in-maxim.spamkiller.net!news.shlink.de!fu-berlin.de!uni-berlin.de!p508d7186.dip.t-dialin.NET!not-for-mail From: Joachim Zobel Newsgroups: comp.databases.oracle.server Subject: Re: very poor SYS view performance (8i) / fragmented data dictionary Date: Fri, 12 Dec 2003 22:05:14 +0100 Lines: 19 Message-ID: References: <3fd6f6f7$0$1025$afc38c87@news.optusnet.com.au> <73e20c6c.0312101732.66f4a54e@posting.google.com> NNTP-Posting-Host: p508d7186.dip.t-dialin.net (80.141.113.134) Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 8bit X-Trace: news.uni-berlin.de 1071263114 2283702 80.141.113.134 ([248]) User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity. (Debian GNU/Linux)) Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:250019 On Thu, 11 Dec 2003 08:30:47 -0800, Uwe Kuechler wrote: > 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. Yeah. Writing software is easy. Reading software is not that easy. And getting rid of it is the part that is _really_ hard. :-) Joachim -- Warnung: \" kann Augenkrebs verursachen.