Re: Realtime experiences on performance part

deepa balu via OracleMonster.com wrote:

> Hi experts,
>
> Just curious to know about your realtime experiences on ORacle Performance tuning.
>
> Could anyone share with the a real kick off on the Performance Part.
>
> Like how a query running for hours is been turned into minutes.
> And some interesting improvements by someother tuning.
>
> Realtime experiences please.

It depends on many factors. If this is for school work ... read your textbook and the documentation. If this is an attempt to spoof an interview read the documentation and get real-world experience. If this is idle curiosity the answer is far too complex for a sound-byte answer. If you have specific issue ... run an Explain Plan and then ask it.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)