OraFAQ Forum: Performance Tuning » sample tuning help

Home » RDBMS Server » Performance Tuning » sample tuning help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sample tuning help [message #142728]

Mon, 17 October 2005 07:55

kartal
Messages: 3
Registered: October 2005

Junior Member

hi
I Have a sample abaut tuning
can you help me tuning this sample
Running too slow and I want to make it better
thanks...

[Updated on: Mon, 17 October 2005 08:44]

Report message to a moderator

Re: sample tuning help [message #142736 is a reply to message #142728]

Mon, 17 October 2005 08:18

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please explain. what are we supposed to look into here?
Is it running too fast and you want to slow it down?
Or
Running too slow and you want to make it better?
or
whatever?
Please read this first
http://www.orafaq.com/forum/t/51267/42800/

Post your OS,Oracle versions. Have you updated the statistics for tables and indexes?
Are columns indexed accordingly?
Could you also explain the data distribution?
Post your execution plan/tkrof/statspack output or whatever.

Report message to a moderator

Re: sample tuning help [message #142740 is a reply to message #142728]

Mon, 17 October 2005 08:38

kartal
Messages: 3
Registered: October 2005

Junior Member

how can I use Hints
using hints is advantage or disadvantage

Report message to a moderator

Re: sample tuning help [message #142743 is a reply to message #142740]

Mon, 17 October 2005 08:48

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> how can I use Hints
Find it in the manuals.
>>using hints is advantage or disadvantage
Depends.
HINTS are like little sticky notes that may or may not help the CBO.
In an utopian oracle database, CBO will not need any hints at all.
If nothing helps, try hints.

Report message to a moderator

Previous Topic:	How can I prove plan invalidations
Next Topic:	bind variable peeking and collecting statistics

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 16:24:17 CST 2024