There is no relationship between MTS (now called Shared Server in 9i) and
EXTENT MANAGEMENT LOCAL.
MTS (Multi Threaded Server in 8i)
-- to save on idle server processes you can set it up so that users share
server processes.
-- so you create dispatchers (processes that users connect to ) with the
dispatchers init.ora parm
-- you also create a set of shared servers with the shared_servers
init.ora parm
When a user connects in Shared Server Mode, they connect to the
dispatcher. All requests go through the dispatcher. When a user makes a
request, the dispatcher puts the request into a REQUEST QUEUE. The next
available Shared Server process will pull it from the REQUEST QUEUE on a
FIRST IN FIRST OUT basis. When the shared server process is done, it puts
it into the RESPONSE QUEUE for that dispatcher. The dispatcher then
returns it to the user. Shared server mode is good if your users have
alot of idle time when they are connected to the database. It is not for
everyone.
EXTENT MANAGEMENT LOCAL, simple tells oracle where to keep track of free
and used space. With locallly managed tablespaces, which is what a
tablespace is called when extent management local is specified, the free
and used blocks are kept track of in the datafile of the tablespace
instead of the data dictionary (which is done for dictionary managed
tablespaces).
Now the parms you specified below, UNDO_MANAGEMENT and UNDO_TABLESPACE,
have nothing to do with Shared Server. This deals with how you want to
handle ROLLBACK or UNDO segments. BY specifying UNDO_MANAGEMENT=AUTO, you
are telling oracle to create and and bring online the undo segments
automatically. Those undo segments will reside in the tablespace you
specify with UNDO_TABLESPACE=UNDOTBS. You must create UNDOTBS as an UNDO
tablespace( CREATE UNDO TABLESPACE <tsname> DATAFIILE <filename> SIZE
<size>;). Now the undo tablespace must be locally managed, that is a
requirement. If you specify UNDO_MANAGEMENT=MANUAL, then you must create
all the rollback segments and make sure they are brought online.
UNDO_MANAGEMENT was new in Oracle 9i.
Hope this helps.
----- Forwarded by Chris Guillaume/cguilla/DFSI on 09/30/04 08:47 AM -----
Dear All,
1. Can some body explain what is MTS, What is the relation between extent
management local and MTS.
###########################################
# MTS
###########################################
dispatchers="(PROTOCOL=TCP)(SER=MODOSE)",
"(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)",
"(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
2. What is System Managed Undo and Rollback Segments
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_management=AUTO
undo_tablespace=UNDOTBS
What will be the setting for above two.
REgards,
Bhas
Ph: +91 80 2235333 <3746>
**************************************************************************
This email (including any attachments) is intended for the sole use of the
intended recipient/s and may contain material that is CONFIDENTIAL AND
PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying
or
distribution or forwarding of any or all of the contents in this message
is
STRICTLY PROHIBITED. If you are not the intended recipient, please contact
the sender by email and delete all copies; your cooperation in this regard
is appreciated.
**************************************************************************
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page