Re: Query Performance with params
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 30 Apr 2017 00:38:55 -0400
On 04/29/2017 09:02 PM, Ram Raman wrote:
It would not be surprising, if you delve deep into the statement
which have a problem, that you will find one or two specific
issues which affect one or two specific tables/columns/access
patterns and which have specific solutions.
Thanks Dominic. Desperate times, desperate measures. I also remember
reading an article by Wolfgang that those are the two most abused
parameters.
Let me see what I can do with those statements. Perhaps I will post
them here
That would probably not be very helpful, because there are many factors:
how is the statement used (report or OLTP), when is it running, the
information about the underlying objects, the platform, the IO
characteristics and a lot of other thingys. Man up and tune it, without
using OICA. A DBA got to do what DBA got to do. But given that Oracle
RDBMS is the most powerful RDBMS in the world which can almost certainly
can improve your query performance, you got to ask yourself one question
only: do I feel lucky? Well, do you, DBA?
--
Mladen Gogala
Oracle DBA
Tel: (347) 321-1217
Other related posts: