| Tools for Database Tuning v/s Instance Tuning [message #465126] |
Mon, 12 July 2010 14:26  |
ora_dba_2000
Messages: 1
Registered: July 2010
|
Junior Member |
|
|
Looking to understand the difference between instance tuning and database tuning.
What is the difference between these two tuning exercises?
I understand that an instance is memory based structures (logical) where as database consists of physical structures.
However, how does one tune a database the physical structure?
Does it have to do with file placements/block sizes etc...
Would you agree that a lot of that is taken care by ASM now in 11g?
What tools are required/available (third party as well as oracle supplied) for these types of tuning scenarios?
Appreciate any guidance on this.
|
|
|
|
| Re: Tools for Database Tuning v/s Instance Tuning [message #465136 is a reply to message #465126] |
Mon, 12 July 2010 20:54  |
 |
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
|
Senior Member |
|
|
ora_dba_2000 wrote on Mon, 12 July 2010 14:26Looking to understand the difference between instance tuning and database tuning.
What is the difference between these two tuning exercises?
I understand that an instance is memory based structures (logical) where as database consists of physical structures.
However, how does one tune a database the physical structure?
Does it have to do with file placements/block sizes etc...
Would you agree that a lot of that is taken care by ASM now in 11g?
What tools are required/available (third party as well as oracle supplied) for these types of tuning scenarios?
Appreciate any guidance on this.
YES as you said there are 2 parts
1/ Instance Tuning.
2/ Tune physical structure.( Query )
In My view
1/ Instance Tuning
1.1/ Allocation of memory for database processes released.
1.2/ take help of DBA.
2/ Tune physical structure.( Query )
2.1/ This consist of Query tuning
2.1/ Remove database design flows
2.3/ Developer Responsibility.( design team)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
