Thanks Padders that was a good read. Normally my Dadhas awesome advice and is able to filter and put into laymens terms all the rhetoric Oracle spews. However, just because one man says one thing doesn't mean it's the be all truth. In this particular case I'm going to have to disagree with him and the reason I am is because the code doesn't lie.
If you look at the DBMS_PIPE package that I pinned in my database yesterday from the above post and look at it this morning.
Originally posted by OracleDoc
Move to Obfuscation Unlimited ??
WHY? The kind of discussion you propose is EXACTLY what should be going on here.
My 2¢: Tom takes the official Oracle line (he has to). The official Oracle line is to have an infinite amount of memory and an infinite number of disks. Those of us who have to compromise might need to pin? resize SGA? etc? etc. At least with the query you gave, there is some basis for logical action and some means of measuring the effect of changes.
The big question: how does it reflect on response time or throughput?