Re: Poor response for PL/SQL queries in 9i

can you compare explain plans between 8i and 9i?

were you using the rule based optimizer before? are your tables analyzed?

Is it slow because you run it through 9iAS or is the slowdown on the database side?

the complex view parameter you are using. what kind of view model are you using? Are you using a 'layered view model'. where you have views based upon views?
>
> From: Belinda Taylor <btaylor3_at_gmu.edu>
> Date: 2003/08/12 Tue AM 08:44:23 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Poor response for PL/SQL queries in 9i
>
> All;
>
> We are using SCT Banner product for our Administrative systems. Since
> upgrading from 8i to 9i, we have been experiencing massive slow downs in
> response from PL/SQL procs/pkgs that are executing via 9iAS. We have
> tried everything from running explain plans, setting the
> _complex_view_merging=false as well as changing the
> optimizer_features_enable back to 8.1.7. Nothing seems to help. The
> problem was partially solved with the _complex_view_merging parameter;
> however, since upgrading to their recent release which required the 9i
> upgrade, the problem has gotten worse. Now queries that were fixed are
> again timing out. We have been working with their technical DBA staff
> for over a month with no success. Anyone have any other suggestions? I'm
> still in the training phase of 9i, so any help would be appreciated.
>
> Belinda Taylor
> Database Analyst
> George Mason University
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Belinda Taylor
> INET: btaylor3_at_gmu.edu
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <rgaffuri_at_cox.net
  INET: rgaffuri_at_cox.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).