Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Stored Procedure - Fetch hangs (Repost)
are the stats up to date on BOTH boxes? tables and indexes identical? Can
you post the execution plans?
Failing that sql run as a package can run under different rights than that run in sqlplus. This can produce different execution plans.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Huw Dixon" <huwdixon_at_hotmail.com> wrote in message news:8d6baabf.0204090252.119493b9_at_posting.google.com...Received on Tue Apr 09 2002 - 06:11:23 CDT
> I have a package that was developed/debugged under an 8.1.6
> environment. Runs good and all queries run (using production data) in
> a matter of < 10 seconds. The package works like a champ. My problems
> began when I moved the package into our production system which is
> 8.1.7. For some reason the code seems to "hang" at the point where
> dbms_sql.fetch_rows is called. I've checked the queries and run them
> manually - they still return the data within several seconds. I've
> tried running/debugging the code from sqlplus, sql navigator, etc. and
> each time it hangs in the same place. I've tried letting it sit for
> several minutes but it does'nt return. The CPU activity definitely
> jumps on the Oracle server and then stays there. THe DBA and I have
> poured over the init.ora parameters, double checked the SYS and
> STANDARD packages to ensure all is compiled, etc.
> I've even created another 8.1.7 environment and fresh database - same
> problem. Can anyone suggest some additional points I should be looking
> at to resolve this?
>
> Thx
>
> Huw