Oracle10g – Automatic SGA Sizing

Jonathan Lewis discusses his experience with automatic SGA sizing. I have an Oracle10g database that utilizes automatic SGA sizing. I have not experienced any problems to date, however this installation used by a development team is small and surely doesn’t see a high amount of activity other systems might.

Jonathan also provides a script he “hacked together” to query the v$sga_resize_ops view displaying the history on how the SGA components have been re-sized since the last instance startup.

Update (2-May-2007)
Jonathan Lewis recently provided some updated updated information on this subject on his blog – SGA Resizing.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: