I have a report which takes a very long time to execute. I decided to add a hint in the SQL and use the option “Do Not Generate SQL”.
But BO won’t accept the hint. I keep getting a weird ORA 01858 error. as soon as I remove the hint the SQL is validate just fine.
Any idea how to make BO accept a hint
The Hint I’m trying to use is /+parallel( 8)/
arunkkk (BOB member since 2006-02-20)
Edit the connection.
Go into Customer Parameters.
Set the HInt parameter.
Hope this will help you.
Sujit Patange.
sujit_patange (BOB member since 2005-07-19)
Im not able to edit the connections in the Designer. Do I need any special privileges to do so ?
arunkkk (BOB member since 2006-02-20)
Yes, you have to have the sufficient privileges to edit connections…
Ask you supervisor about it…
BO_Chief 
(BOB member since 2004-06-06)
The easiest way is to add a special object to your universe (maybe in a special class called “Hints”). This objects contains two single quotes (so BO thinks there are characters in it 
) followed by the hint itself. So like this:
'' /*+RULE*/which will cause Oracle to execute the query RULE based instead of COST based. Position the hint object as the first object in your query. It will also show up in the group by but will do no harm there 
.
See also post here
HenkK
HenkK 
(BOB member since 2004-03-02)
This is a cool idea. thanks! 
arunkkk (BOB member since 2006-02-20)