OraFAQ Forum: Performance Tuning » DB performance keys

Home » RDBMS Server » Performance Tuning » DB performance keys

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

DB performance keys [message #547867]

Sat, 17 March 2012 11:57

Amine
Messages: 376
Registered: March 2010

Senior Member

Hi dears,
What are the most important performance keys we have to calculate or take in account to preserve or to increase the DB performance in terms of response times, and whatsoever according to performance ?

Thanks in advance

Report message to a moderator

Re: DB performance keys [message #547868 is a reply to message #547867]

Sat, 17 March 2012 12:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

set parameter as below

_MAKE_SQL_FAST=TRUE

Report message to a moderator

Re: DB performance keys [message #547875 is a reply to message #547867]

Sat, 17 March 2012 12:38

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

What are the most important performance keys ... to increase the DB performance in terms of response times

Remove all the data.

Regards
Michel

Report message to a moderator

Re: DB performance keys [message #547877 is a reply to message #547875]

Sat, 17 March 2012 12:49

Amine
Messages: 376
Registered: March 2010

Senior Member

I'm disappointed dears, I do not expect that from you...

Report message to a moderator

Re: DB performance keys [message #547880 is a reply to message #547877]

Sat, 17 March 2012 13:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when all else fails, Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/server.112/e16638/toc.htm

Report message to a moderator

Re: DB performance keys [message #551048 is a reply to message #547880]

Sun, 15 April 2012 01:53

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

What kind of answer did you expect to a question like that?

Do you have a specific performance issue that needs addressing? Or are you just fishing for basic understanding on performance in relational databases in general? Or is there something else you wanted?

Maybe if you tell us why you are asking the question we can offer more relevant help. Otherwise, do as was suggested and set the hidden parameter _fast=true (of course there is no such parameter).

Kevin

[Updated on: Sun, 15 April 2012 01:53]

Report message to a moderator

Re: DB performance keys [message #551124 is a reply to message #551048]

Sun, 15 April 2012 13:59

Amine
Messages: 376
Registered: March 2010

Senior Member

Thanks Kevin for your reply. I was actually looking for general understandings on performance. And I've followed your basics on http://www.orafaq.com/forum/mv/msg/170674/505512/136107/#msg_505512 and I was well informed. Thanks another time Kevin for your advises.

Report message to a moderator