Re: What server 9.2.0 read?

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Fri, 23 May 2003 16:32:13 +0400
Message-ID: <bal4u7$dp9$1@babylon.agtel.net>

Well, this appears to be a known problem. :) Quick search on MetaLink revealed the Note 215347.1, which says, in particular, that
<quote>

The default optimizer mode (CHOOSE) is causing the slow running of the query.

You can query the dynamic performance views to extract information from them. However, only simple queries are supported. If sorts, joins, GROUP BY clauses and the like are needed, then you should copy the information from each V$ view into a table and then query from those tables.

</quote>

Suggested workarounds are:

apply /*+ ordered */ to the query - and indeed it works.
change optimizer_goal to RULE - this one certainly won't work in v10.

-- 
Vladimir Zakharychev (bob@dpsp-yes.com)                http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.

Received on Fri May 23 2003 - 07:32:13 CDT