Re: Remote table performance on complex queries/views
- From: Rich J <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 13 Sep 2016 07:40:32 -0500
On 2016/09/13 07:18, Patrick Jolliffe wrote:
At the risk of stating the obvious have you considered setting cursor_
sharing equals force at the schema level.. Of course some risks with this,
although I would guess maybe less than with trying to run the application
over database link. (By the way are you sure the queries coming in via the db
link not still cause lots of hard parsing?)
I've been down that cruel CS=F part of hell before (self-inflicted,
9iR2). For the sake of completeness, I searched MOS for CURSOR_SHARING
and limited the results to just 11.2.0.3 of Oracle EE. Doesn't look like
it's any more stable.
Thanks for the suggestion, but that cure has side-effects more severe
than my illness. :)
Rich
Other related posts: