Re: Oracle 9i Latching Issue

On Mar 28, 11:13 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> On Mar 28, 10:24 am, "Ana C. Dent" <anaced..._at_hotmail.com> wrote:
>
> snip
>
>
>
> > It appears you then must use the undocumented parameter in initSID.ora
> > _make_database_faster_=TRUE-
>
> Looks like Johne is well on the way to identifying problems and
> potential alternatives.  Nice job!
>
> The contributions of Ana Dent in this thread ... well not so much
> imho.

Also if possible check for full table scans due to lack of proper indexing.......many times these rogue full table scans has caused a lot of problems for us and you can easily catch them by monitoring the v$session_longops view and also from the sql statements in the statspack report that are ordered by buffer hits Received on Fri Mar 28 2008 - 13:27:17 CDT