Locally managed vs. Dictionary managed tablespaces
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Locally managed vs. Dictionary managed tablespaces

  1. #1
    Join Date
    Feb 2001
    Posts
    295
    I'd like to know your opinion about what kind of tablespace to choose for. Oracle documentation says about the advantages of locally managed tablespaces, like "simplified space allocation", "no need to coalesce" etc.

    Have you used locally managed tablespaces before? What I want to know is: Locally managed tablespaces are ALWAYS the best choose? If not, in what situation is better to use dictionary managed tablespaces?

    Please give me some "real life" feedback about it.



    Adriano.




  2. #2
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    I had read an article in one of the recent Oracle magazine, which discussed the use of locally managed ts. It said that it's use is ideal for Temp ts. I suggest you take a look at it.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    A quote from Mr. Thomas Kyte from Oracle Corp.:

    "I no longer use dictionary managed tablespaces for anything other then SYSTEM (which must currently be dictionary managed)."

    If you don't know who Tom Kyte is - he is one of the most knowledged persons in this planet regarding Oracle RDBMS. He has been helping Oracle users community termendously for last few years over usenet discussion groups comp.databases.oracle.*. Now he has his column in Oracle Magazine ("Ask Tom") and also publish his answers to various questions about Oracle daily on [url]http://asktom.oracle.com.[/url]
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I have been using locally managed tablespace for a few months and I havent faced any problems yet. It has indeed many advantages, by using locally managed tbs I dont need to worry about sizing objects, fragmentation etc
    However I havent faced a recovery situation yet, I guess it should be same as those dictionary managed tablespaces but I will have to start testing it soon before I come across a recovery situation with locally managed tablespaces :o

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width