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.