I have set my SGA to automatic memory management. The SGA_target is set at 1544 and SGA_max_size at 1944. The server has total memory of 6 gb.
Also, i get this recommendation from dbconsole..The SGA was inadequately sized, causing additional I/O or hard parses .. recommendation to increase sga to 1930...
Can some explain to me what is the cause of this error and how I can prevent it from occurring in the future.