Did you gather statistics on the SYS objects in 9i? I know that
Powerbuilder doesn't like that when accessing the data dictionary. Maybe
DBArtisan has the same issue, as it expects rule based.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Sybrand Bakker" <gooiditweg_at_sybrandb.verwijderdit.demon.nl> wrote in
message news:a5mkh0h4l1mjhurm3lmv7rlu2ia2u39mnc_at_4ax.com...
> On Wed, 11 Aug 2004 09:48:27 -0700, M Rothwell
> <ThisIsABadAddress_at_toobad.com> wrote:
>
> >We just upgraded from an 8i db to a 9i db on HP-UX.
> >
> >I access the db from a Windows XP box with DBArtisan.
> >
> >When we had the 8i db, I never had any problems, but every since we
> >upgraded to 9i I sometimes hang while navigating different objects in
> >DBArtisan. I also have a 9i db local (on same XP box) that has no
> >problems with DBArtisan. This leads me to believe that it is a TNS
> >issue. I've checked logs on client and server and cannot find anything
> >odd. When it hangs, it is generally about 3 minutes, then everthing is
> >ok.
> >
> >Any ideas what would/could cause this?
> >
> >Thank you,
>
>
> A better analysis would be in order.
> Identify the sid of your session, then use v$session_wait to check out
> what it is waiting for.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Wed Aug 11 2004 - 13:20:22 CDT
