Good afternoon I got ORA-04031: unable to allocate 27160 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","session param values") on the produciton database and no new session can connect to database. Any immediate action can take to solve the problem? Any help. Thanks Sarah Chen -- //www.freelists.org/webpage/oracle-l