I had a chat recently with a colleague who was asking about sizing a Siebel Database. On checking the Bookshelf guidelines on sizing, I see that Oracle recommends a fairly straightforward approach to estimating your table space sizes: simply add up the column sizes of a ‘Siebel record’ and extrapolate across your estimated record volumes. That got me thinking, what exactly is a ‘Siebel record’ and how could I programatically determine it’s size?
That’s when I came up with the Siebel Sizer:
It’s a pretty simple tool that lets you:
- Connect to a running Object Manager on your development or test system
- Pick a Business Object and any combination of Business Components active on that BO
- Pick a sample size, or simply let it calculate the maximum based on underlying field definitions
- Pick either a ‘random x’ or ‘first x’ record set to sample
- Click the button to tally up a sample set of data from your database across the entire BO
- You then multiply through by the number of contacts, for example, then apply the Siebel Consultant Magic Formula for Sizing (multiply by two for good luck)
Before I post a link to this tool, and it’s source, I wondered: would any of you out there have interest in such a tool? Is database sizing something you do and is this the approach you would take? Are there other tools out there that do the same thing but use a more intelligent approach? Better tools that do a different thing and achieve a better result?
I’d love to hear from any readers who have an interest in this or some advice on how to progress with a little project such as this.