Oracle Architecture and Tuning on AIX

http://www-03.ibm.com/support/techdocs/atsmastr.nsf/WebIndex/WP100883

45 pages of concise material

Finding ORA-04031 When not appear on alert

Sometimes just the user session receive the message, but it not logged on alert.
On this X$ Table you can see this.

select sum(kghlunfu) Total_4031 ,kghlunfs Size_miss from x$kghlu group by kghlunfs;

List of all X$ tables

select kqftanam from x$kqfta;