1:- Check file location of spfile/pfile
SQL> show parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
2:- Check the value of SGA
SQL> show parameter sga_
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 20G
sga_target big integer 20G
unified_audit_sga_queue_size integer 1048576
Increase sga_max_size on Oracle 10g Windows
alter system set sga_max_size=800M scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 838860800 bytes
Fixed Size 2929936 bytes
Variable Size 390073072 bytes
Database Buffers 440401920 bytes
Redo Buffers 5455872 bytes
Database mounted.
Database opened.
SQL> alter system set sga_target=800M scope=both;
done
source : https://dbsguru.com/step-by-step-how-to-increase-sga-size-in-oracle/
https://dba.stackexchange.com/questions/121553/increase-sga-max-size-on-oracle-10g-windows
