Home » RDBMS Server » Performance Tuning » INIT.ORA parameters to SCALE UP INSTANCE (10.2.0.3 ON LINUX)
INIT.ORA parameters to SCALE UP INSTANCE [message #360095] Wed, 19 November 2008 10:29 Go to next message
andydba
Messages: 34
Registered: September 2008
Member

Hi,

I want to know 3 init.ora parameters that can be used to scale up an oracle instance?

Andy
Re: INIT.ORA parameters to SCALE UP INSTANCE [message #360108 is a reply to message #360095] Wed, 19 November 2008 11:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is this stupid question?

Regards
Michel
Re: INIT.ORA parameters to SCALE UP INSTANCE [message #360123 is a reply to message #360095] Wed, 19 November 2008 12:19 Go to previous messageGo to next message
andydba
Messages: 34
Registered: September 2008
Member

I don't know why you got angry and replying like that. This question might be stupid for you but not for me. I want to know something and I asked it.

Re: INIT.ORA parameters to SCALE UP INSTANCE [message #360124 is a reply to message #360123] Wed, 19 November 2008 12:21 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So explain the meaning/root of the question.

Regards
Michel
Re: INIT.ORA parameters to SCALE UP INSTANCE [message #360125 is a reply to message #360095] Wed, 19 November 2008 12:30 Go to previous messageGo to next message
andydba
Messages: 34
Registered: September 2008
Member

I am new to oracle databases. A senior DBA asked me to scale up an oracle instance which means make changes to init.ora files to make database handle more and more transactions.

I told him that PGA_AGGREGATE_TARGET and SGA_TARGET modification will scale up an oracle instance. He was not satisfied with my answer and told me to do research on it. I did some research on google but could not find anything. As per my understanding about oracle databases modifying PGA_AGGREGATE_TARGET and SGA_TARGET will do the needful.

This is the reason I asked this question here.
Re: INIT.ORA parameters to SCALE UP INSTANCE [message #360126 is a reply to message #360125] Wed, 19 November 2008 12:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I did some research on google but could not find anything.

As there is nothing to find on this.
Better ask him what is the answer I would very glad to know what is it.
Or better, ask him to post his answer here, I'm sure he will profit from our answers.

Regards
Michel
Re: INIT.ORA parameters to SCALE UP INSTANCE [message #360133 is a reply to message #360095] Wed, 19 November 2008 13:11 Go to previous messageGo to next message
coleing
Messages: 213
Registered: February 2008
Senior Member
And you need to understand the word "Scale" before you can go any further than just sga and pga.

For example.

Scale 1.
Increase data volume by 10.
(eg, going from test database to productiond atabase)

Scale 2
Increase Number of Connections to a database
(eg. going from a live sized test environment to a proper live environment)

Scale 3
Increase workload on a database.
(more requirements to process the same data in different ways, more complex queries).

all of these have very different requirements

[Updated on: Wed, 19 November 2008 13:17]

Report message to a moderator

Re: INIT.ORA parameters to SCALE UP INSTANCE [message #360733 is a reply to message #360133] Sun, 23 November 2008 17:03 Go to previous message
andydba
Messages: 34
Registered: September 2008
Member

Hi Coleing,

I guess my senior dba is talking about scale2 and scale3 that you have mentioned.

Any suggestions on init.ora parameters for these?

Thanks
Andy
Previous Topic: How to make use of indexes?
Next Topic: Table size and sql performance
Goto Forum:
  


Current Time: Sat Dec 03 13:54:02 CST 2016

Total time taken to generate the page: 0.10117 seconds