Locally Managed Tablespace Survey

From: Jonathan Gennick <jonathan_at_gennick.com>
Date: Thu, 15 Jun 2000 14:42:16 -0400
Message-Id: <10529.109446@fatcity.com>

I'm writing a magazine article on locally managed tablespaces, and I'd like to get some opinions and feedback from anyone who might be using these in a production environment. If you are using locally managed tablespaces, and you could find the time to answer the following questions, I'd be grateful. I'm sure others on this list would find the answers interesting as well.

Are you currently using locally managed tablespaces in a production environment?

Do you see locally managed tablespaces as the preferred tablespace type going forward?=20

Have you kept any tablespaces as dictionary managed, and why?

Have you used the AUTOALLOCATE feature to allow Oracle to size your extents automatically?

Have you encountered any specific problems with locally managed tablespaces that other DBAs should be aware of?

Do you over use DBMS_SPACE_ADMIN to verify or fix the bitmaps in your locally managed tablespaces? Do you do this on a regular basis, or only when a problem occurs?

Have you ever had a problem where you _needed_ to run DBMS_SPACE_ADMIN in order to fix it?

Have you noticed any measurable performance improvement as a result of using locally managed tablespaces?

That's it. Not too many questions, I hope. Of course, if you can think of anything useful to add that I havn't asked about, that would be great too.

Thanks,

Jonathan

---

jonathan_at_gennick.com =20
http://gennick.com Received on Thu Jun 15 2000 - 13:42:16 CDT