on 10-13-2010 8:29 AM
Hi experts,
can I add a particular hints when I execute at run time a query bex ?
My main scope is that when I run a bex query, the corresponding query may use an oracle parallel hint in order to increase the performance.
Do you think that I can do it ?
Thank'you in advance !
> can I add a particular hints when I execute at run time a query bex ?
No, you can't.
> My main scope is that when I run a bex query, the corresponding query may use an oracle parallel hint in order to increase the performance.
Usually there's a good reason for BEX queries not to use the parallel query feature.
That reason is: parallel query turns your multi-user database into a single-user query machine.
This single sql session will aquire way more resources than a standard query - eventually blocking other activities.
In order to speed up your BEX query better check the execution plan and figure out what makes the query too slow.
Open a support message for it if you cannot do this yourself - there are quite some bugs around (even with Oracle 10.2.0.4) that lead to bad quey performance.
Of course - the first things to check would be to install the current Oracle patchset, patches and setup the parameters correctly. More than 90% of all performance support messages are solved just by that!
regards,
Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.