Bhas
You may have meant Locally Managed Tablespaces LMT
Which do have something to do with Extent Management.
Chris has outlined below for you.
Regards
John Fak
Oracle DBA
_____________________
Accenture Workforce Solutions
mobile: +44 (0)778 655 1214
landline: +44 (0)207 844 6981
Octel : (46981)
mailto:john.[Email address protected]
-----Original Message-----
From: chrisguillaume
[mailto:oracledba-ezmlmshield-x26847691.[Email address protected]
Sent: 30 September 2004 14:57
To: LazyDBA Discussion
Subject: What is Relation between MTS and Extent Management
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
--------
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
This message is for the designated recipient only and may contain privileged, proprietary, or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited.
Oracle LazyDBA home page