A kind of... benchmark?

Is there something like a benchmark for databases (well, for Oracle DB if you wish) out there? Just a compilation of SQL statements creating tables, indexes, doing lots of inserts and DML operations, indexed access as well as full table scan, would be a nice thing to compare different platforms, isn'it? With timed_statistics=true, then it would yield performance metrics about the DB environment used. Ideally, the benchmark would leave the database in the same initial state, dropping all created objects.

Please be aware that I am not trying to know anything about performance of a specific database (meaning the schema and data contained therein), but about performance of database *environments*, i.e., the DB engine and its parameters, OS I/O system, memory management, CPU performance etc. I am interested in the administrative aspects, while efficience of work with specific relational models would be something related to database development.

If you know about something similar, please let me know!

(Of course, purists among us won't appreciate this idea, saying that "the best benchmark is your own application". Fine, but I just can't port my application to any DB of my choice - it would be an inconvenience. And I want to tune the underlying structure, not the application itself).

Thanks
Rick Denoire

PS: Perhaps there is such a benchmark based on scott's data, so results would be even comparable across different environments since this schema is delivered by Oracle out of the box. Received on Wed Aug 06 2003 - 16:53:53 CDT