YourecentlycreatedadatabaseandconfiguredtheSPFILEwiththefollowingparametersettingstoensurethatOracleautomaticallyadjuststhememoryfortheProgramGlobalArea(PGA):
SORT_AREA_SIZE=150M
HASH_AREA_SIZE=150M
BITMAP_MERGE_AREA_SIZE=150M
CREATE_BITMAP_AREA_SIZE=150M
WORKAREA_SIZE_POLICY=AUTO
YouhavenotincludedthePGA_AGGREGATE_TARGETinitializationparameterintheSPFILEandtheSystemGlobalArea(SGA)iscurrentlysizedat4G.
WhatisthetotalPGAmemoryallocatedacrossalldatabaseserverprocesses?()