Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Anybody more familiar with "_use_old_connect_by" than I am?
Hello,
anybody have used the setting "_use_old_connect_by" ?
We had to use it (instance level) in our migrated 9.2.0.7 to
10.2.0.2database (win32) because certain hierarchical queries were
chewing up all
the cpu. After we set "_use_old_connect_by" to TRUE, cpu usage went back to
normal. This suggestion was made by the metalink support analyst as one of
many attempts to fix the cpu problem which almost brought down the oracle
server.
Appearantly it influences the execution of connect-by queries in 10g. But
since Metalink doesn't have much on this setting I am not sure which
unwanted side effects to expect (eg, wrong resultsets, influence on
other type of queries, other bugs)
Kind regards,
Andre v Winssen
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Nov 05 2006 - 16:24:49 CST
![]() |
![]() |