DBA view slow

From: M Rothwell <ThisIsABadAddress_at_toobad.com>
Date: Wed, 13 Oct 2004 14:53:48 -0700
Message-ID: <416da527$1@usenet01.boi.hp.com>

Oracle 9.2.0.4 on HP-UX

I have a dev tool that runs a bunch of queries at start-up and when I'm monitoring the db.

The following query can take several minutes to return.

SELECT 1
FROM SYS.DBA_EXTENTS
WHERE ROWNUM = 1 I tried to do an explain plan on it, but dont have the proper privs. The powers that be (corp DBA's) say that you shouldn't run stats on sys tables.

I cant change the query, or add a hint because it's embedded in the tool. Is there anything I can have the DBA's do to make this query perform better. I cant even figure out why the tool is running this query.

Thanks

Michael Received on Wed Oct 13 2004 - 16:53:48 CDT