To take this even a step further I tried setting the sga_target so Oracle
can manage my SGA. I did not see any noticeable differences. My values
look the same.

Do I need to do something else to make the sga_target work?



SQL> startup;
ORACLE instance started.

Total System Global Area 419430400 bytes
Fixed Size 1979168 bytes
Variable Size 318770400 bytes
Database Buffers 92274688 bytes
Redo Buffers 6406144 bytes
Database mounted.
Database opened.
SQL> alter system set sga_target=200M;

System altered.

SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 419430400 bytes
Fixed Size 1979168 bytes
Variable Size 318770400 bytes
Database Buffers 92274688 bytes
Redo Buffers 6406144 bytes
Database mounted.
Database opened.
SQL>