Hi

Can someone please tell.me the steps to increase the memory available to an oracle instance.

I would like to know both methods ...ie when database has been configured to use automatic memory management.

And also when database has not been configured to use auto memory management.

I would like to know if a database restart is required for changes to come into affect.

I also want the changes to be permanent.

I have searched the web but not found any easy step by step approach.

Please assume I will have enough memory on the server to double the memory size.

Thanks in advance