Hi,
This was asked to one of my friend for a senior level dba,

1) How does parallel server work;
2) What is dynamic partitioning;
3) What are the SGA Parameters that has to be tuned for having a optimum SGA performance.

Could you hint on these?
Badrinath