Aloha!
I did an import with this parameter:
impdp system schemas=schema_name directory=DIR_IMP transform=segment_attributes:n:table dumpfile=dump101K.dmp logfile=log101K.log
the import was terminated prematurely due to this error.
ORA-04031: unable to allocate 3896 bytes of shared memory ("shared pool","select case when (bitand(u.s...","sga heap(1,0)","kglsim object batch")
ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","ALTER SESSION SET EVENTS '10...","sga heap(1,0)","kglsim heap")
When i tried to log in as sys and alter the memory setting of my instance using this script.
ALTER SYSTEM SET MEMORY_MAX_TARGET=1G SCOPE=SPFILE
ALTER SYSTEM SET MEMORY_TARGET=1G SCOPE=SPFILE
ALTER SYSTEM SET SGA_TARGET=0 SCOPE=SPFILE
I was prompted by this error:
ERROR at line 1:
ORA-01012: not logged on
Process ID: 0
Session ID: 0 Serial number: 0
When I try to shutdown the instance, I have this error:
SQL> shutdown immediate
ORA-04031: unable to allocate 4064 bytes of shared memory ("shared pool","select host,userid,password,...","sga heap(1,0)","kglsim heap")
Aside doing a physical restart. What else can i do to address the said errors?
Thanks in advance.
Regards,
Hades