Dominic Giles Blog

Some times I feel like Ia??ve missed out on a whole chunk on functionality in Oracle products. One little nugget is the a??timinga?? function in SQL*Plus. This allows you to time groups of operations.

Obviously turning on is achieved with the a??set timing ona?? operation. i.e

SQL > set timing on

SQL > select count(1) from all_objects;

COUNT(1)
----------
68653

Elapsed: 00:00:03.95

SQL>

Which is great but what if want to time mulitiple operations. Use the timing function and simply give the timer a name, in this case statement timer.

SQL> timing start statement_timer
SQL> select count(1) from all_objects;

COUNT(1)
----------
68653

SYS@orcl > /

COUNT(1)
----------
68653

SQL> timing show statement_timer;
timing for: statement_timer
Elapsed: 00:00:30.85
SQL>

Which times anything that went on in between the timer starting and finishing. In this case also my typing of the commands. Its a fantastic utility for timing stages in a batch job including call outs to os operations.

Ia??ve added some new pages describing how to build large scale a??SOEa?? and a??SHa?? schemas. Ia??ve tested them both to 500GB in size and will create larger scale versions as soon as I can borrow hardware to test them at multi terabyte levels. If youa??re interested in giving it ago let me know via the comments page and I can try and assist. You can find the the instructions on how to do create 100GB+ schemas for a??SOEa?? here and the how to create 100GB+ a??SHa?? schemas here

I've uploaded a new build of datagenerator. New features include

a?? Support for indexes and sequences
a?? New command line options
a?? Better multi threading support
a?? New scaleable data builds
a?? Number generators can reference row counts from other tables
a?? Better database performance
a?? Ability to generate only the DDL of a schema
a?? Numerous bug fixes

The new build can be downloaded here

Ia??ve also updated the install, and added some additional walk throughs (in the swingbench section)

More details can be found here