FAQ
Hi
I am thinking to change our few dictinary manages tablespace to locally
managed tablespace.Can any one experienced any issues with locally managed
tablespace?
Do any one experience what gain after changing to locally managed
tablespace?

Thx
-Seema

Unlimited Internet access for only $21.95/month.  Try MSN!
http://resourcecenter.msn.com/access/plans/2monthsfree.asp

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET: oracledbam_at_hotmail.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Markham, Richard at Oct 24, 2002 at 7:25 pm
    Metalink Note: 93771.1

    -----Original Message-----
    Sent: Thursday, October 24, 2002 2:49 PM
    To: Multiple recipients of list ORACLE-L

    Hi
    I am thinking to change our few dictinary manages tablespace to locally
    managed tablespace.Can any one experienced any issues with locally managed
    tablespace?
    Do any one experience what gain after changing to locally managed
    tablespace?

    Thx
    -Seema

    Unlimited Internet access for only $21.95/month.  Try MSN!
    http://resourcecenter.msn.com/access/plans/2monthsfree.asp

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Seema Singh
    INET: oracledbam_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message

    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Markham, Richard
    INET: RMarkham_at_hafeleamericas.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message

    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • DENNIS WILLIAMS at Oct 24, 2002 at 8:04 pm
    Seema - While you are planning your conversion, be sure to carefully read
    the paper:
    How to stop defragmenting and start living: The definitive word on
    fragmentation by Himatsingka and Loaiza so you really understand how to
    receive the benefits of LMTs.

    It is available on http://www.hotsos.com
    and on http://otn.oracle.com/deploy/availability/pdf/defrag.pdf

    Dennis Williams
    DBA, 40%OCP

    Lifetouch, Inc.
    dwilliams_at_lifetouch.com

    -----Original Message-----
    Sent: Thursday, October 24, 2002 1:49 PM
    To: Multiple recipients of list ORACLE-L

    Hi
    I am thinking to change our few dictinary manages tablespace to locally
    managed tablespace.Can any one experienced any issues with locally managed
    tablespace?
    Do any one experience what gain after changing to locally managed
    tablespace?

    Thx
    -Seema

    Unlimited Internet access for only $21.95/month.  Try MSN!
    http://resourcecenter.msn.com/access/plans/2monthsfree.asp

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Seema Singh
    INET: oracledbam_at_hotmail.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message

    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: DENNIS WILLIAMS
    INET: DWILLIAMS_at_LIFETOUCH.COM

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message

    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • JApplewhite_at_austin.isd.tenet.edu at Oct 24, 2002 at 8:35 pm
    Seema,

    Our production Student Information database (8.1.7 under Win2k) has 40,000
    tables and 60,000 indexes. It's a third party app designed for dBaseIV -
    go ahead and laugh, we do all the time (when we're not crying). Anyhow, we
    have to regularly clone out the data to a couple of other databases, both
    on HPUX. The different OS means we have to use export/import, not restore
    from hot backup or transportable tablespaces, to move the data.

    Both of the recipient databases (with dictionary-managed tablespaces)
    started out needing about 2 hours to drop all the tables and indexes
    (tables change, so we can't truncate) and about 6 hours to import the full
    dataset. After several "refreshes" the time requirement grew to almost 30
    hours for each DB. I think the data dictionary tables that record info.
    about tables, indexes, and extents (someone else on this list could
    probably name the very ones) got totally mucked up (a techical term) after
    so many massive drops and creates.

    After I recreated the recipient tablespaces as locally-managed, drop and
    import times returned to 2 and 6 hours, respectively, and have remained
    there through numerous subsequent "refreshes". Needless to say, we are
    *very* happy with LMTs.

    BTW, our Student Info. system is clunky (we're going to redesign it into a
    couple hundred partitioned tables with 40,000 views and 120,000 Instead-Of
    Triggers, but that's another story) but several thousand teachers and
    administrators basically like the way it manages our 80,000 students.
    How's that for a client base?

    Jack C. Applewhite
    Database Administrator
    Austin Independent School District
    Austin, Texas
    512.414.9715
    JApplewhite_at_austin.isd.tenet.edu

    "Seema Singh"

    Sent by: cc:
    root_at_fatcity.c Subject: LOCALLY MANAGED TABLESPACE
    om

    10/24/2002
    01:49 PM
    Please respond
    to ORACLE-L

    Hi
    I am thinking to change our few dictinary manages tablespace to locally
    managed tablespace.Can any one experienced any issues with locally managed
    tablespace?
    Do any one experience what gain after changing to locally managed
    tablespace?

    Thx
    -Seema

    --
    Author: Seema Singh
    INET: oracledbam_at_hotmail.com

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author:
    INET: JApplewhite_at_austin.isd.tenet.edu

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Jamadagni, Rajendra at Oct 25, 2002 at 1:04 pm
    The only issue we faced was convincing the management that in LMT having 150
    extents is not really a problem.

    Raj

    Rajendra Jamadagni MIS, ESPN Inc.
    Rajendra dot Jamadagni at ESPN dot com
    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

    QOTD: Any clod can have facts, but having an opinion is an art!

    -----Original Message-----
    Sent: Thursday, October 24, 2002 1:49 PM
    To: Multiple recipients of list ORACLE-L

    Hi
    I am thinking to change our few dictinary manages tablespace to locally
    managed tablespace.Can any one experienced any issues with locally managed
    tablespace?
    Do any one experience what gain after changing to locally managed
    tablespace?

    Thx
    -Seema

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Jamadagni, Rajendra
    INET: Rajendra.Jamadagni_at_espn.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    text/plain attachment: ESPN_Disclaimer.txt
  • Leonard, George at Oct 25, 2002 at 2:28 pm
    Same here


    Getting management to first understand the extent issue on Dictionary
    managed was a interesting exercise. Now trying to break that understanding
    down when wanting to use LMT is like double the work, painful.


    Difficult thing trying to educate them enough to understand something but
    not leaving at the same time halve way where you start getting these
    interesting architecture decisions or ideas.


    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za <http://www.didata.co.za>


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!
    -----Original Message-----
    Sent: 25 October 2002 13:04 PM
    To: Multiple recipients of list ORACLE-L


    The only issue we faced was convincing the management that in LMT having 150
    extents is not really a problem.
    Raj

    Rajendra Jamadagni MIS, ESPN Inc.
    Rajendra dot Jamadagni at ESPN dot com
    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

    QOTD: Any clod can have facts, but having an opinion is an art!
    -----Original Message-----
    Sent: Thursday, October 24, 2002 1:49 PM
    To: Multiple recipients of list ORACLE-L


    Hi
    I am thinking to change our few dictinary manages tablespace to locally
    managed tablespace.Can any one experienced any issues with locally managed
    tablespace?
    Do any one experience what gain after changing to locally managed
    tablespace?
    Thx
    -Seema

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Leonard, George
    INET: george.leonard_at_farnell.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Deshpande, Kirti at Oct 25, 2002 at 2:28 pm
    In a 'converted/migrated' LMT, tables/indexes can not take advantage of
    UNIFORM or SYSTEM (autoallocate) policy of extent management. Those objects
    still grow with their old 'next' extent sizes. For full benefits of LMT,
    consider creating new LMT tablespaces and moving objects to them. Search
    Metalink. There are a number of documents/notes on converting DMT to LMT.


    Kirti

    -----Original Message-----
    Sent: Friday, October 25, 2002 8:04 AM
    To: Multiple recipients of list ORACLE-L

    The only issue we faced was convincing the management that in LMT having 150
    extents is not really a problem.

    Raj

    Rajendra Jamadagni MIS, ESPN Inc.
    Rajendra dot Jamadagni at ESPN dot com
    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

    QOTD: Any clod can have facts, but having an opinion is an art!

    -----Original Message-----
    Sent: Thursday, October 24, 2002 1:49 PM
    To: Multiple recipients of list ORACLE-L

    Hi
    I am thinking to change our few dictinary manages tablespace to locally
    managed tablespace.Can any one experienced any issues with locally managed
    tablespace?
    Do any one experience what gain after changing to locally managed
    tablespace?

    Thx
    -Seema

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Deshpande, Kirti
    INET: kirti.deshpande_at_verizon.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message

    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Tim Gorman at Oct 25, 2002 at 2:28 pm
    RE: LOCALLY MANAGED TABLESPACEwhy did management care?

    Original Message -----
    From: Jamadagni, Rajendra
    To: Multiple recipients of list ORACLE-L
    Sent: Friday, October 25, 2002 7:04 AM
    Subject: RE: LOCALLY MANAGED TABLESPACE

    The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem.

    Raj

    Rajendra Jamadagni MIS, ESPN Inc.
    Rajendra dot Jamadagni at ESPN dot com
    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
    QOTD: Any clod can have facts, but having an opinion is an art!

    -----Original Message-----
    Sent: Thursday, October 24, 2002 1:49 PM
    To: Multiple recipients of list ORACLE-L

    Hi
    I am thinking to change our few dictinary manages tablespace to locally
    managed tablespace.Can any one experienced any issues with locally managed
    tablespace?
    Do any one experience what gain after changing to locally managed
    tablespace?

    Thx
    -Seema

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tim Gorman
    INET: Tim_at_SageLogix.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Jamadagni, Rajendra at Oct 25, 2002 at 2:58 pm
    Good question .... I don't know ...


    Raj

    Rajendra Jamadagni MIS, ESPN Inc.

    Rajendra dot Jamadagni at ESPN dot com

    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

    QOTD: Any clod can have facts, but having an opinion is an art!

    -----Original Message-----
    Sent: Friday, October 25, 2002 10:29 AM
    To: Multiple recipients of list ORACLE-L

    why did management care?

    Original Message -----
    To: Multiple recipients of list ORACLE-L
    Sent: Friday, October 25, 2002 7:04 AM

    The only issue we faced was convincing the management that in LMT having 150
    extents is not really a problem.

    Raj

    Rajendra Jamadagni MIS, ESPN Inc.
    Rajendra dot Jamadagni at ESPN dot com
    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

    QOTD: Any clod can have facts, but having an opinion is an art!

    -----Original Message-----
    Sent: Thursday, October 24, 2002 1:49 PM
    To: Multiple recipients of list ORACLE-L

    Hi
    I am thinking to change our few dictinary manages tablespace to locally
    managed tablespace.Can any one experienced any issues with locally managed
    tablespace?
    Do any one experience what gain after changing to locally managed
    tablespace?

    Thx
    -Seema

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Jamadagni, Rajendra
    INET: Rajendra.Jamadagni_at_espn.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message

    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    text/plain attachment: ESPN_Disclaimer.txt
  • Gary Weber at Oct 25, 2002 at 3:59 pm
    RE: LOCALLY MANAGED TABLESPACEPardon the ignorance, I'm simply trying to
    understand... What is meant by "management" in this context? I'm can't
    imagine a circumstance under which ANY business manager would have a say on
    what goes on in the black box called Oracle. Downtime? Cost of
    hardware/software? Vendor selection? I can see the input on those issues.
    But, all the way down to extent management?? Or am I simply lucky to not
    have that level of bureaucracy?

    Gary Weber
    Senior DBA
    Charles Jones, LLC||Superior Information Services, LLC

    -----Original Message-----
    Sent: Friday, October 25, 2002 10:29 AM
    To: Multiple recipients of list ORACLE-L

    Same here

    Getting management to first understand the extent issue on Dictionary
    managed was a interesting exercise. Now trying to break that understanding
    down when wanting to use LMT is like double the work, painful.

    Difficult thing trying to educate them enough to understand something but
    not leaving at the same time halve way where you start getting these
    interesting architecture decisions or ideas.

    George

    George Leonard

    Oracle Database Administrator

    Dimension Data (Pty) Ltd

    (Reg. No. 1987/006597/07)

    Tel: (+27 11) 575 0573

    Fax: (+27 11) 576 0573

    E-mail:george.leonard_at_za.didata.com

    Web: http://www.didata.co.za

    You Have The Obligation to Inform One Honestly of the risk, And As a Person

    You Are Committed to Educate Yourself to the Total Risk In Any Activity!

    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!

    -----Original Message-----
    Sent: 25 October 2002 13:04 PM
    To: Multiple recipients of list ORACLE-L

    The only issue we faced was convincing the management that in LMT having 150
    extents is not really a problem.

    Raj

    Rajendra Jamadagni MIS, ESPN Inc.
    Rajendra dot Jamadagni at ESPN dot com
    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.
    QOTD: Any clod can have facts, but having an opinion is an art!

    -----Original Message-----
    Sent: Thursday, October 24, 2002 1:49 PM
    To: Multiple recipients of list ORACLE-L

    Hi
    I am thinking to change our few dictinary manages tablespace to locally
    managed tablespace.Can any one experienced any issues with locally managed
    tablespace?
    Do any one experience what gain after changing to locally managed
    tablespace?

    Thx
    -Seema

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Gary Weber
    INET: gweber_at_charlesjones.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message

    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Fink, Dan at Oct 25, 2002 at 4:14 pm
    You are lucky, very lucky...
    -----Original Message-----
    Sent: Friday, October 25, 2002 9:59 AM
    To: Multiple recipients of list ORACLE-L

    Pardon the ignorance, I'm simply trying to understand... What is meant by
    "management" in this context? I'm can't imagine a circumstance under which
    ANY business manager would have a say on what goes on in the black box
    called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can
    see the input on those issues. But, all the way down to extent management??
    Or am I simply lucky to not have that level of bureaucracy?


    Gary Weber
    Senior DBA
    Charles Jones, LLC||Superior Information Services, LLC

    -----Original Message-----
    Sent: Friday, October 25, 2002 10:29 AM
    To: Multiple recipients of list ORACLE-L

    Same here


    Getting management to first understand the extent issue on Dictionary
    managed was a interesting exercise. Now trying to break that understanding
    down when wanting to use LMT is like double the work, painful.


    Difficult thing trying to educate them enough to understand something but
    not leaving at the same time halve way where you start getting these
    interesting architecture decisions or ideas.


    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za <http://www.didata.co.za>


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!
    -----Original Message-----
    Sent: 25 October 2002 13:04 PM
    To: Multiple recipients of list ORACLE-L


    The only issue we faced was convincing the management that in LMT having 150
    extents is not really a problem.
    Raj

    Rajendra Jamadagni MIS, ESPN Inc.
    Rajendra dot Jamadagni at ESPN dot com
    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

    QOTD: Any clod can have facts, but having an opinion is an art!
    -----Original Message-----
    Sent: Thursday, October 24, 2002 1:49 PM
    To: Multiple recipients of list ORACLE-L


    Hi
    I am thinking to change our few dictinary manages tablespace to locally
    managed tablespace.Can any one experienced any issues with locally managed
    tablespace?
    Do any one experience what gain after changing to locally managed
    tablespace?
    Thx
    -Seema

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Fink, Dan
    INET: Dan.Fink_at_mdx.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message

    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Jamadagni, Rajendra at Oct 25, 2002 at 4:24 pm
    Some business managers migrate (pardon the pun) from being a techie to a
    bean counter type. So they know.


    Raj

    Rajendra Jamadagni MIS, ESPN Inc.
    Rajendra dot Jamadagni at ESPN dot com
    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

    QOTD: Any clod can have facts, but having an opinion is an art!
    -----Original Message-----
    Sent: Friday, October 25, 2002 11:59 AM
    To: Multiple recipients of list ORACLE-L

    Pardon the ignorance, I'm simply trying to understand... What is meant by
    "management" in this context? I'm can't imagine a circumstance under which
    ANY business manager would have a say on what goes on in the black box
    called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can
    see the input on those issues. But, all the way down to extent management??
    Or am I simply lucky to not have that level of bureaucracy?


    Gary Weber
    Senior DBA
    Charles Jones, LLC||Superior Information Services, LLC



    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Jamadagni, Rajendra
    INET: Rajendra.Jamadagni_at_espn.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    text/plain attachment: ESPN_Disclaimer.txt
  • Leonard, George at Oct 25, 2002 at 4:39 pm
    Or am I simply lucky to not have that level of bureaucracy - You are lucky


    We are busy going into production for a big project, during the rollout and
    data take on the managers wanted to know all these things, it comes down to
    them not just accepting it when you tell them how long something takes.


    Then you have the manager that managed Oracle some time ago that remember
    DMT and have worked with LMT so converting them is difficult.


    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za <http://www.didata.co.za>


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!
    -----Original Message-----
    Sent: 25 October 2002 15:59 PM
    To: Multiple recipients of list ORACLE-L


    Pardon the ignorance, I'm simply trying to understand... What is meant by
    "management" in this context? I'm can't imagine a circumstance under which
    ANY business manager would have a say on what goes on in the black box
    called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can
    see the input on those issues. But, all the way down to extent management??
    Or am I simply lucky to not have that level of bureaucracy?


    Gary Weber
    Senior DBA
    Charles Jones, LLC||Superior Information Services, LLC
    -----Original Message-----
    Sent: Friday, October 25, 2002 10:29 AM
    To: Multiple recipients of list ORACLE-L
    Same here


    Getting management to first understand the extent issue on Dictionary
    managed was a interesting exercise. Now trying to break that understanding
    down when wanting to use LMT is like double the work, painful.


    Difficult thing trying to educate them enough to understand something but
    not leaving at the same time halve way where you start getting these
    interesting architecture decisions or ideas.


    George

    George Leonard
    Oracle Database Administrator
    Dimension Data (Pty) Ltd
    (Reg. No. 1987/006597/07)
    Tel: (+27 11) 575 0573
    Fax: (+27 11) 576 0573
    E-mail:george.leonard_at_za.didata.com
    Web: http://www.didata.co.za <http://www.didata.co.za>


    You Have The Obligation to Inform One Honestly of the risk, And As a Person
    You Are Committed to Educate Yourself to the Total Risk In Any Activity!
    Once Informed & Totally Aware of the Risk, Every Fool Has the Right to Kill
    or Injure Themselves as They See Fit!
    -----Original Message-----
    Sent: 25 October 2002 13:04 PM
    To: Multiple recipients of list ORACLE-L


    The only issue we faced was convincing the management that in LMT having 150
    extents is not really a problem.
    Raj

    Rajendra Jamadagni MIS, ESPN Inc.
    Rajendra dot Jamadagni at ESPN dot com
    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

    QOTD: Any clod can have facts, but having an opinion is an art!
    -----Original Message-----
    Sent: Thursday, October 24, 2002 1:49 PM
    To: Multiple recipients of list ORACLE-L


    Hi
    I am thinking to change our few dictinary manages tablespace to locally
    managed tablespace.Can any one experienced any issues with locally managed
    tablespace?
    Do any one experience what gain after changing to locally managed
    tablespace?
    Thx
    -Seema

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Leonard, George
    INET: george.leonard_at_farnell.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message

    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Govind.Arumugam_at_alltel.com at Oct 25, 2002 at 5:14 pm
    Folks,


    I am new to this group. Has anyone tried to convert a dictionary managed
    table space containing a lot of data to locally managed? We have tried
    this out successfully on empty table spaces or created a new LET table
    space and moved the existing objects to it.


    Thanks,
    Govind


    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author:
    INET: Govind.Arumugam_at_alltel.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Tim Gorman at Oct 25, 2002 at 5:19 pm
    RE: LOCALLY MANAGED TABLESPACEIt's a question of responsibilities, not knowledge.

    Knowing something does not mean that one should continue to be involved. Most managers (or directors or VPs) who continue to be concerned in this technical detail are not paying attention to the things to which they should be paying attention. Sure sign of a newbie manager and the most common symptom of the "Peter Principle"...

    Original Message -----
    From: Jamadagni, Rajendra
    To: Multiple recipients of list ORACLE-L
    Sent: Friday, October 25, 2002 10:24 AM
    Subject: RE: LOCALLY MANAGED TABLESPACE

    Some business managers migrate (pardon the pun) from being a techie to a bean counter type. So they know.

    Raj

    Rajendra Jamadagni MIS, ESPN Inc.

    Rajendra dot Jamadagni at ESPN dot com

    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

    QOTD: Any clod can have facts, but having an opinion is an art!

    -----Original Message-----
    From: Gary Weber
    Sent: Friday, October 25, 2002 11:59 AM
    To: Multiple recipients of list ORACLE-L
    Subject: RE: LOCALLY MANAGED TABLESPACE

    Pardon the ignorance, I'm simply trying to understand... What is meant by "management" in this context? I'm can't imagine a circumstance under which ANY business manager would have a say on what goes on in the black box called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can see the input on those issues. But, all the way down to extent management?? Or am I simply lucky to not have that level of bureaucracy?

    Gary Weber
    Senior DBA
    Charles Jones, LLC||Superior Information Services, LLC



    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Tim Gorman
    INET: Tim_at_SageLogix.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • DENNIS WILLIAMS at Oct 25, 2002 at 6:09 pm
    The other thing I've encountered is where a consultant comes in and makes a
    fuss about the number of extents. Usually privately to a manager, then
    leaves, so you don't have an opportunity to discuss the issue. Or a GUI tool
    is demonstrated that has a screen to "find problems", and usually one of the
    things the tools view is the number of extents so they can "alert you to a
    problem". Management seems to think some real experts created the tool, so
    when you claim it is bunk, they look at you in puzzlement.

    I think the problem is one that a lot of technical people face, even
    automobile mechanics. How can you be a competent technical person on one
    hand, and on the other hand, make non-technical people feel confident that
    you are really competent? Many is the highly competent technical person that
    got fired or force out of their job by nontechnical people. And very high is
    the salary of consultants that do both tasks well. You must consider not
    only the accuracy of your advice and comments, but how those remarks are
    perceived by the nontechnical people. I have often thought that keeping
    copies of the books you have authored prominently displayed is a good way,
    but then Rachel punctured that thought by saying that her authorship didn't
    play strongly in her last hire.

    Dennis Williams
    DBA, 40%OCP

    Lifetouch, Inc.
    dwilliams_at_lifetouch.com

    -----Original Message-----
    Sent: Friday, October 25, 2002 12:19 PM
    To: Multiple recipients of list ORACLE-L

    It's a question of responsibilities, not knowledge.


    Knowing something does not mean that one should continue to be involved.
    Most managers (or directors or VPs) who continue to be concerned in this
    technical detail are not paying attention to the things to which they should
    be paying attention. Sure sign of a newbie manager and the most common
    symptom of the "Peter Principle"...

    Original Message -----
    To: Multiple recipients of list ORACLE-L
    Sent: Friday, October 25, 2002 10:24 AM

    Some business managers migrate (pardon the pun) from being a techie to a
    bean counter type. So they know.


    Raj

    Rajendra Jamadagni MIS, ESPN Inc.

    Rajendra dot Jamadagni at ESPN dot com

    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

    QOTD: Any clod can have facts, but having an opinion is an art!

    -----Original Message-----
    Sent: Friday, October 25, 2002 11:59 AM
    To: Multiple recipients of list ORACLE-L

    Pardon the ignorance, I'm simply trying to understand... What is meant by
    "management" in this context? I'm can't imagine a circumstance under which
    ANY business manager would have a say on what goes on in the black box
    called Oracle. Downtime? Cost of hardware/software? Vendor selection? I can
    see the input on those issues. But, all the way down to extent management??
    Or am I simply lucky to not have that level of bureaucracy?


    Gary Weber
    Senior DBA
    Charles Jones, LLC||Superior Information Services, LLC



    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: DENNIS WILLIAMS
    INET: DWILLIAMS_at_LIFETOUCH.COM

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Jamadagni, Rajendra at Oct 25, 2002 at 6:39 pm
    Tim,


    That's not the case, these guys are techies .. now handling higher duties.
    They just haven't kept up with 9i yet ... and yes they do their job very
    well.


    Raj

    Rajendra Jamadagni MIS, ESPN Inc.
    Rajendra dot Jamadagni at ESPN dot com
    Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

    QOTD: Any clod can have facts, but having an opinion is an art!
    -----Original Message-----
    Sent: Friday, October 25, 2002 1:19 PM
    To: Multiple recipients of list ORACLE-L

    It's a question of responsibilities, not knowledge.


    Knowing something does not mean that one should continue to be involved.
    Most managers (or directors or VPs) who continue to be concerned in this
    technical detail are not paying attention to the things to which they should
    be paying attention. Sure sign of a newbie manager and the most common
    symptom of the "Peter Principle"...

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    --
    Author: Jamadagni, Rajendra
    INET: Rajendra.Jamadagni_at_espn.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

    text/plain attachment: ESPN_Disclaimer.txt

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 24, '02 at 6:49p
activeOct 25, '02 at 6:39p
posts17
users11
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase