Hello,

I'm an SQLServer dba and a newbee in Oracle. What "spooling" is (in context
of logins, connections or user sessions)?

As I suppose it's a way to use a connection in a multy-tier applications, am
I right?

Thank you for your time!

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 --

Vladimir wrote:
> Hello,
>
> I'm an SQLServer dba and a newbee in Oracle. What "spooling" is (in context
> of logins, connections or user sessions)?
>
> As I suppose it's a way to use a connection in a multy-tier applications, am
> I right?
>
> Thank you for your time!

Spooling is a way to write a file to the operating system that is a
duplication of that which normally scrolls across the monitor.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu
(replace 'x' with 'u' to respond)