Setup/tear down Oracle schema for CI build without fragmenting catalog

I would like to have a CI build (e.g., Hudson) set up and tear down an Oracle 11g schema as part of a nightly build/test cycle for a fairly vanilla JSF/JPA application.

The most obvious way to do this is by dropping and re-creating all tables. While this feels fairly standard (at least, that's what the Hibernate/JPA tools would do automatically for you), I've had Oracle DBAs warn me that the Oracle catalog will get fragmented after repeated object create/drop cycles. Eventually this will cause performance problems because the SYSTEM tablespace cannot be defragmented/coalesced.

My questions are:

  • is fragmentation a genuine concern, or is not something you need to worry about in a typical webapp development environment?
  • if fragmentation really is a concern, is there a better way to tear down and recreate a schema in Oracle than DROP TABLE/CREATE TABLE?

Thanks!

Answers


Don't believe those DBAs

At least with 10g and above when using locally managed tablespaces (LMT) this should not be a problem.

And even if that did cause any fragmentation I very much doubt that you could measure its impact - especially on a database that is used for CI.


Need Your Help

Char array to a class

.net c++ managed

I have a incoming stream of bytes (unsigned char) from either a file or network. I need this data placed in a class, and is looking for a NET-way of doing this.

Are “Application Client Container” and “Embedded Enterprise Bean Container” the same?

java oracle java-ee containers sun

Is the "Application Client Container" (see here) the same as the "Embedded Enterprise Bean Container" (see here)?

Why won't my DataContext use SQL Server Compact Edition 4, rather than trying to use 3.5?

linq-to-sql asp.net-mvc-2 sql-server-ce sql-server-ce-4

I'm playing around with SQL Server Compact Edition 4 CTP1 as I'd like to use it as a datastore for a low-traffic web app. When I try to create a DataContext with a connection string specifying

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.