Re: Append Bypass_recursive_check


"maria" <maria.1zg6xz@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:maria.1zg6xz@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>
> 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



.

Relevant Pages

  • Re: Oratcl Bind Queries
    ... Well, I am not an Oracle expert by any means, but I think the general ... you will need to manually 'hint' the query plan for these ... queries, based on your a priori knowledge of the value distributions in the ...
    (comp.lang.tcl)
  • Re: SQL Injection
    ... > I am currently pen-testing a web app and I am stuck in trying to execute ... two queries sequentially in Oracle. ... You won't have luck with this in Oracle. ... the end query build by a cgi-script being ...
    (Pen-Test)
  • Re: ORACLE CLIENT USERS BEWARE: Bug in Query Builder breaks SQL
    ... Can you enlighten me; you appear to be saying there are three different ways to run queries against Oracle; ... If you have to move projects from VS2003 that include such SQL queries, you have to fix it all by hand. ... When trying to use the Query Builder with Oracle, queries that create INNER JOIN syntax result in an error in Query Builder when trying to generate your schemas. ...
    (microsoft.public.vsnet.general)
  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)