Interested to Buy Any Domain ? << Click Here >> for more details...
How would you identify the shared_pool_size parameter that needs to be adjusted?
- 1 Answers
- 6 Views
- I also Faced
- E-Mail Answers
Answer / Ankush Sharma
To identify if the shared_pool_size parameter needs adjustment, you can check the SGA_TARGET and DB_CACHE_SIZE parameters. If the shared_pool_size is using a large portion of the total SGA (System Global Area), or if there are high numbers of hard parses, it may be necessary to increase the shared_pool_size.
| Is This Answer Correct ? | 0 Yes | 0 No |
Mention what is split brain syndrome in rac?
What is required by oracle rac database to connect to a network?
Mention what is the difference between instance recovery and crash recovery?
What is new feature in oracle asm 12c?
How can you determine what protocol is being used for interconnect traffic?
What is the difference between media recovery & crash recovery?
What is a system tablespace and why do we need it?
What is the function of grid naming service used in oracle rac
Where does the clusterware write when there is a network or storage issue?
What is the load balancing advisory?
Mention what is new feature in oracle asm 12c?
What do you mean by database normalization and why is it important?
Oracle General 
