Impact of increasing number of connections
1. I wanted to find out if I need to increase the setting for open_cursors if I am bumping up the processes parameter.
2. Besides the system level semaphore settings what additional things I should be looking at ? eg db_block_buffer, shared_pool, sort_area_size.
3. How do I calculate the amt of memory taken by once connection? This will help in calculating how much additional I need to add for the delta in the increase in connections?
Click Here to Expand Forum to Full Width