Oracle Database Discussions

Hello All,

Kind of a newbie here, so please pardon my lack of skills in memory tuning or configuration. Here's my scenario:

I have a Windows 2003 Server (32 bit) with 16GB RAM. I am running Oracle 11.1.0.7 (32 bit). Nothing else running on this box. When I execute the startup command, (I'm using pfile) the following configuration appears:

ORACLE Instance started.

Total System Global Area 753278976 (about 750MB) ?
Fixed Size 1347440
variable Size 578814096
Database Buffers 167772160
Redo Buffers 5345280
Database Mounted
SQL>

Now, I'm trying to figure out where its getting 750MB total for SGA from a 16GB server? I also have 'Automatic Memory Management' Enabled and so is Automatic Shared memory Management. When I log into the instance via DB control, and access Memory advisors, I am showing 1GB Total memory Size and 1.2GB Max Memory Size. My pfile is as follows below.

per.__db_cache_size=167772160
per.__java_pool_size=16777216
per.__large_pool_size=8388608
per.__oracle_base='C:\apps\app\oracle'#ORACLE_BASE set from environment
per.__pga_aggregate_target=536870912
per.__sga_target=511705088
per.__shared_io_pool_size=0
per.__shared_pool_size=301989888
per.__streams_pool_size=8388608
*.aq_tm_processes=0
*.audit_file_dest='C:\U01\APP\ORACLE\ADMIN\PER\ADUMP'
*.audit_trail='DB'
*.compatible='11.1.0.0.0'
*.control_file_record_keep_time=10
*.control_files='C:\u01\oradata\CONTROL01.CTL','C:\u02\oradata\CONTROL02.CTL','C:\u03\ORADATA\CONTROL03.CTL'
*.db_block_size=8192
*.db_domain=''
*.db_flashback_retention_target=240
*.db_name='PER'
*.db_recovery_file_dest='C:\u01\app\oracle\flash_recovery_area'
*.db_recovery_file_dest_size=214748364800
*.diagnostic_dest='C:\u01\app\oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=PERXDB)'
*.enable_ddl_logging=FALSE
*.log_archive_dest_10='LOCATION=USE_DB_RECOVERY_FILE_DEST OPTIONAL REOPEN=300'
*.log_archive_dest_1='LOCATION=C:\u01\app\oracle\backup MANDATORY REOPEN=300'
*.memory_max_target=1258291200
*.memory_target=1048576000
*.nls_length_semantics='BYTE'
*.open_cursors=400
*.pga_aggregate_target=536870912
*.processes=400
*.remote_login_passwordfile='EXCLUSIVE'
*.resource_manager_plan=''
*.undo_retention=900
*.undo_tablespace='UNDOTBS1'

If I use an spfile and I send an 'Alter system set memory_max_target=4000m scope=spfile - it accepts this command and modifies my spfile. When I shutdown the instance and try to restart, I get the follwoing error:

ORA-27102: Out of Memory
OSD-0003: addiitonal error information.

I now have to stop the Oracle service and restart using my pfile. If I don't stop and restart the service, I will get the following error message: ORA-27100: Shared memory realm already exists.

Why will it not let me change the max memory setting to leverage some of that 16GB RAM? I inherited this host, but I believe I may be missing something..

Appreciate your inout..

RB