Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Increase of SGA in Oracle9i

654586Sep 10 2008 — edited Sep 11 2008

I have a sga of following :

Total System Global Area 639075872 bytes
Fixed Size 730656 bytes
Variable Size 603979776 bytes
Database Buffers 33554432 bytes
Redo Buffers 811008 bytes

I can increase my SGA to 4GB from current 610MB size.
I wanted to know its just that alter system set sga_max_size and sga_target would do or there is something that have to be done?

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 9 2008

Added on Sep 10 2008

#9i, #general-database-discussions

15 comments

1,042 views