Can you please provide details ( or links to documents) about how
should we determine the size of all the memory structures given
hardware specifications or the process flow. basically what needs to
kept in mind and what things we need to know before determining the
init.ora parameters.


Thanks
Chintu

1- This is very version-dependant, please provide that info
2- You don't adjust the database memory parameters to the hardware, you
rather adjust the hardware specs to the database memory requirements.
Those depend on various factors, such as number of expected concurrent
users, number of other databases and other applications on the same
server, features enabled in the database (shared server used -> large
pool, Streams -> Streams area (in 10i), ...).
3- Provide more details about the database role (OLTP, DW, reporting,
....). Running in archivelog mode or not?
4- Which OS?

Daniel