Have you had new data load in recently? Maybe it's time to do "analyze
table ..."?
From: "Sharon" <[Email Address Removed] Friday, August 31, 2001 12:25 PM
Subject: Serious performance issues and possible memory leak?????
>We are running Oracle 8.1.6 on Solaris 2.7 and have been having steady
>performance degradatation over the last couple of days.
>I've checked in v$sysstat and see the following:
>session uga memory 2.5491918486856E15
>session uga memory max 1.84467440285901E19
>
>
>I'm not even sure this matters, but these values seem HUGE!
>
>
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
Oracle LazyDBA home page