Re: What "SPOOLING" is?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 10 Dec 2004 07:21:14 -0800
Message-ID: <1102692074.953280.221580@c13g2000cwb.googlegroups.com>

Vladimir, normally the term "spooling" in Oracle is used in relation to the SQLPlus spool command where query results are spooled to a file.

The term "pooling" can be used in relation to connections/sessions as in use of connection pools by web application front-end tools or with shared server, formerly called MTS or multi-threaded server. This is where several front-end used share one connection to the database.

You can find more information on connections/sessions in the Concepts and the DBA Administration manuals.

HTH -- Mark D Powell -- Received on Fri Dec 10 2004 - 09:21:14 CST