Home » RDBMS Server » Performance Tuning » DB performance keys
DB performance keys [message #547867] Sat, 17 March 2012 11:57 Go to next message
Amine
Messages: 264
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
Re: DB performance keys [message #547868 is a reply to message #547867] Sat, 17 March 2012 12:20 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
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
Re: DB performance keys [message #547875 is a reply to message #547867] Sat, 17 March 2012 12:38 Go to previous messageGo to next message
Michel Cadot
Messages: 59293
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: DB performance keys [message #547877 is a reply to message #547875] Sat, 17 March 2012 12:49 Go to previous messageGo to next message
Amine
Messages: 264
Registered: March 2010
Senior Member

I'm disappointed dears, I do not expect that from you...
Re: DB performance keys [message #547880 is a reply to message #547877] Sat, 17 March 2012 13:32 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
when all else fails, Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/server.112/e16638/toc.htm
Re: DB performance keys [message #551048 is a reply to message #547880] Sun, 15 April 2012 01:53 Go to previous messageGo to next message
Kevin Meade
Messages: 1940
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 Go to previous messageGo to next message
Amine
Messages: 264
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.
Re: DB performance keys [message #551125 is a reply to message #551124] Sun, 15 April 2012 14:06 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
when all else fails Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/server.112/e10822/toc.htm
Re: DB performance keys [message #551152 is a reply to message #551124] Mon, 16 April 2012 00:01 Go to previous message
Kevin Meade
Messages: 1940
Registered: December 1999
Location: Connecticut USA
Senior Member
Well thank you for reading some of my material. I hope is helps you. Kevin
Previous Topic: ADDM report
Next Topic: query with high cpu usage
Goto Forum:
  


Current Time: Thu Oct 02 01:33:54 CDT 2014

Total time taken to generate the page: 0.13168 seconds