pga_aggregate_target and db_cache_size

In his blog article Analysing Statspack(8), Jonathan Lewis has talked about 2 rules:

pga_aggregate_target - A comfortable figure for an OLTP system would be in the 2M - 4M range per process.

db_cache_size - is always at least as large as 1M per process.

Take a note first and check reason later.

Oracle 9.2.0.8 and 10.2.0.4 Patch download list

Oracle 9.2.0.8 patch:
ftp://updates.oracle.com/4547809/p4547809_92080_AIX64-5L.zip
ftp://updates.oracle.com/4547809/p4547809_92080_AXP.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HP64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_HPUX-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_LINUX-S390.zip
ftp://updates.oracle.com/4547809/p4547809_92080_LINUX.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-IA64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_Linux-x86-64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_MVS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS.zip
ftp://updates.oracle.com/4547809/p4547809_92080_SOLARIS64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_TRU64.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT.zip
ftp://updates.oracle.com/4547809/p4547809_92080_WINNT64.zip

Oracle 10.2.0.4 patch:
ftp://updates.oracle.com/6810189/p6810189_10204_AIX5L.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-IA64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_HPUX-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Solaris-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86-64.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Linux-x86.zip
ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip
ftp://updates.oracle.com/6810189/p6810189_10204_MSWIN-x86-64.zip

Search Oracle Book on Google Book and Read online

Nowadays there is no much time to read Oracle books (I mean the real books). We rather to search in Metalink, Google or other Oracle related sites. As we all know, those books are not cheap. If we do want to buy them, we would like the company to pay for the bills:-)

Actually, we can find lots of Oracle books for online reading. Here is an example. You can search Oracle book by using Google Book:

http://books.google.com/books?q=Oracle&lr=&sa=N&start=0

You can even fine-tune your search. Here are some books for your reference:

Oracle Essentials: Oracle Database 10g
Oracle Performance Tuning
Oracle High Performance Tuning for 9i and 10g
Oracle Performance Troubleshooting: With Dictionary Internals SQL & Tuning

Be aware: you can NOT read full pages of the above books. If you feel those books really good, you will have to buy by yourself or company. Anyway, enjoy!