I am a Jr. level DBA and I am just into learning DB Administration.
Since two consecutive days I am getting this error :
ORA-04031: unable to allocate 4224 bytes of shared memory ("shared pool","USER_ACCESS_LOG","sga heap(1,0)","library cache")
When I had restarted the database, went on well. I am working in Oracle 9i.
I will be grateful if any experts can give me a permanent solution to get rid of this.
expecting solution soon.