moreajays wrote:Why to restart the instance? SGA_TARGET can be changed dynamically.
If its 10g and above make sure sga_target is set to non-zero (or 232 M in this case) then set shared_pool_size=0 followed by restart of the instance
853910 wrote:In my experience, this error is typical of clients creating non-shareable cursors (i.e. parsing and executing SQLs without using bind variables).
while connect database via appllication i received the following error herewith i send the sizes
ora-04031:unable to allocate 184 bytes of shared memory("shared pool") ORA:02063