|
|
|
|
|
|
|
|
| Re: INIT.ORA parameters to SCALE UP INSTANCE [message #360125 is a reply to message #360095] |
Wed, 19 November 2008 12:30   |
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 #360133 is a reply to message #360095] |
Wed, 19 November 2008 13:11 |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
