Re: A question about ORA-04031 error

In <1823117.1032236072_at_dbforums.com> roobaron <member_at_dbforums.com> writes:

>Hi Stan,

>Have a search on this group for 4031 errors, i suspect it has been
>done to death.

>The fragmentation error is not at the OS level, it is Oracle's shared
>pool which has become fragmented.
>If the db has been up for all those months it has just taken time to hit
>the fragmented error -> need to see what is/has been running on the db.

>Have a search first though as there should be lots of answers to this.

Thanks, a google search on this group and 4031 provided a wealth of useful information.

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin