Re: Append Bypass_recursive

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 3 Dec 2005 08:43:48 +0000 (UTC)
Message-ID: <dmrls4$97t$1@nwrdmz03.dmz.ncs.ea.ibs-infra.bt.com>

"maria" <maria.1zg6xz_at_no-mx.forums.yourdomain.com.au> wrote in message news:maria.1zg6xz_at_no-mx.forums.yourdomain.com.au...
>
> Hi all, does anybody knows why, all of a sudden, queries to slow and
> freeze with
> APPEND BYPASS_RECURSIVE_CHECK hint and recursive insert into temp
> dynamic system tables?
>
> Oracle 9.0.2.0
>
> thanks a lot
>
>
> --
> maria
> ------------------------------------------------------------------------
> maria's Profile: http://www.highdots.com/forums/m1519
> View this thread: http://www.highdots.com/forums/t3127633
>

Could you offer a little more explanation of what you're doing and, how you are seeing "temp dynamic system tables" and SQL with this particular hint. Also the version of Oracle. This might help us to help you. For example, there are some known issues with star
transformation and temp table transformation that might be relevant - if you are on 8.1.?? and your are expecting your queries to do star transformations.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 29th Nov 2005

Received on Sat Dec 03 2005 - 02:43:48 CST

Re: Append Bypass_recursive_check