Oracle Database Discussions

Oracle 11g - 11.1.0.7
Redht 5.3 4GB RAM
-------------------------
SGA MAX Size 1GB
SGA_target 800M
pga_aggregate_target = 600MB
========================
SQL> SHOW SGA:

Total system Global Area 1043886080
Fixed size: 2166288
Variable Size: 1002439152
Database Buffers: 33554432
redo Buffers 5726208
==========================

I was notified by 11g DB control that I need to increase my SGA size to 1000M (1GB) from 800M. I went into the server option/Intitialization file (I am using SPFILE) and only increased it by 50mb, making the SGA 850M total. I did not use the "impliment" option to increase the SGA to 1GB like 11g suggested - because normally, 800M suffices.

However, after I went into my initialization parameters, edited the "CURRENT' intit paramaters to reflect the new sga_target to be: 850MB vs. 800M, hit apply, and it just sits there waiting. I clicked on the 'Active Sessions' link on the main DB control page showing a wait activity, and I found the session that states: SGA: allocating forcing component growth." No error message, just sitting there trying to add the additonal 50MB to the current 800MB. I normally have no issues doing this, it recently started. Have I consumed all my availabe memory that Oracle can use?

Like I said, I only have 4GB in the box. Can I kill the session that is trying to execute the SQL to increase the SGA size?

Thanks,

Rob

Edited by: ronthe11gdba on May 7, 2009 11:27 AM

Edited by: ronthe11gdba on May 7, 2009 12:21 PM