Re: Oracle 9i Latching Issue
From: Johne_uk <edgarj_at_tiscali.co.uk>
Date: Sat, 29 Mar 2008 13:09:14 -0700 (PDT)
Message-ID: <3e416c0c-fb1f-493b-968b-26816b654705@i12g2000prf.googlegroups.com>
Date: Sat, 29 Mar 2008 13:09:14 -0700 (PDT)
Message-ID: <3e416c0c-fb1f-493b-968b-26816b654705@i12g2000prf.googlegroups.com>
I'd just like to thank everyone who contributed.
One last thing - is there anything I could to to the SYS index below to reduce latch waits.
"There was also high waits on the SYS.I_OBJ2 index on the sys.I_OBJ2 table. "
SEGMENT_NAME TCH
SYS.I_OBJ2 2028
Received on Sat Mar 29 2008 - 15:09:14 CDT