Re: What Would Cause....

> "Harvey" <harveyb_at_NoSpambeliveau.ccHere> wrote in message
> news:41B06DE3.9C679990_at_NoSpambeliveau.ccHere...
> > Hi All:
> >
> > I've encountered this situation twice, and I'm not sure of what the
> > cause is. If anyone has a hint of where to look I'd appreciate it.
> >
> > The problem - when looking at a database via DBA Studio I go to Storage
> > and then Tablespaces to display the list/utilization. Generally
> > speaking this takes a few seconds to load/display, however, what I'm
> > encountering are significant delays, in the order of up to ten minutes.
> > I've had two databases that were configured identically, with one
> > displaying this behavior and the other working fine. There's nothing
> > remarkable in the alert logs. Any ideas/suggestions?
> >
> > The environment - Oracle 8.1.7.4 on Solaris 8. (The environment for the
> > first encounter of this type was Oracle 8.1.7.4 on Windows 2000).
> >
> > Thanks!
> >
> > Harvey

Terry Dykstra wrote:
>
> Statistics on SYS objects comes to mind. With 8i you definitely don't want
> to have those.
>

I checked and verified there are no stats on the sys objects, and the behavior is the same. Any other ideas?

Thanks,

Harvey Received on Fri Dec 03 2004 - 13:00:37 CST