There is a good paper about memory management on vldb 2002 "SQL Memory Management in Oracle9i" by Beno=EEt Dageville and Mohamed Za=EFt that explains how automatic memory management works. You can also read "If Your Memory Serves You Right..." by Richmond Shee. On Sun, 12 Dec 2004 16:46:41 -0500, rjamya <rjamya@xxxxxxxxx> wrote: > Hi all, >=20 > Any pointers to good articles on using and sizing P_A_T? config is > 9204/AIX/RAC. In one of the DBs a sr. dba has PAT enabled, but > occasionally the DB throws ora-4031 and we end up bouncing the > instance. So I want to cover my bases before I open my mouth in the > meeting about it. --=20 Edgar -- //www.freelists.org/webpage/oracle-l