Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance tuning

907143Dec 22 2011 — edited Dec 23 2011
With so much in ora tuning ...

xplan, tkprof, trace events , statspack(now AWR) ...

finding difficult to understand the right approach for oracle perf. tuning....


I know , many will point to oracle online documentation ... very useful stuff ..

but what i am looking for is basically examples/scenarios .. and then going through some pre-defined steps/analysis ..
which would lead to the solution ...


i know it comes with lot of experience only ...

but to start with .... any advice .. so that i can learn tuning practically with some examples..

Thanks you all
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 20 2012
Added on Dec 22 2011
8 comments
264 views