Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: /*+ NESTED_TABLE_GET_REFS +*/ hint

RE: /*+ NESTED_TABLE_GET_REFS +*/ hint

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Fri, 14 Dec 2001 08:05:53 -0800
Message-ID: <F001.003DCB78.20011214075521@fatcity.com>

Oracle sys tab
accesses use RBO.  I believe some have hints. check with the cognoscenti.

<FONT color=#0000ff

size=2> 
<FONT color=#0000ff

size=2>hth
 

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Amar Kumar Padhi   [mailto:TS2017_at_emirates.com]Sent: Friday, December 14, 2001 5:55   AMTo: Multiple recipients of list ORACLE-LSubject: /*+   NESTED_TABLE_GET_REFS +*/ hint
  Hi, <FONT
  face="Times New Roman">Our application runs in RBO Mode. We are frequently   getting the hint /*+ NESTED_TABLE_GET_REFS +*/  <FONT   face="Times New Roman">in the V$SQLAREA. We don't have nested tables in our   our application either.   What is the possible reason for this   hint?
  Is oracle internally adding this hint. If so,   why should it be so with our application queries?   On <FONT
  face="Times New Roman">Oracle: 8.1.7 <FONT   face="Times New Roman">front-end :Forms 6i.   rgds <FONT face=Courier
  color=#000000 size=2>amar Received on Fri Dec 14 2001 - 10:05:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US