You'll find below the text of the case I registered at BGS.
If someone allready encountered such situation and/or have an idea, let me know. Thanks

"
I've just performed two fresh installation of BaanERP5.0c SP3 with Loc2.0 on two different systems:
- the first one is a Dell Laptop Piii 650 Mhz 256Mo Ram running Win2000server sp2 and MS-Sql7 sp2,
- the second is a Dell Server (2 Piii Xeon 700Mhz, 1Mo L2, 1Go RAM) running NT4server SP6 with Oracle 8.1.7

I performed the same installation excepted that I installed only two of the demo companies for Localization (920 and 925) on my laptop and all the demo companies on the server (920 to 947).
For both installation I used the database created by the Setup.exe. with defaults values.

On my laptop the database (MS-Sql7) is only 3.2 Go with 360 Mo free.
On the server the DB (Oracle8i) is huge :
- 4 Go allocated for data (1Go free in the TBS) : 3 Go of data
- 5 Go allocated for index (750 Mo free ) : 4.25 Go index
- ROLLBACK_DATA : 170 Mo used
- SYSTEM : 670 Mo used
The whole database is more than 10 Go.

Is this normal ?
What can I do to reduce the size of the database ?
"

I guess the installer program uses larger values for Oracle installations? My preference is always to create any database manually, not really into all those wizard thingies for db creatioms :)

I would export the full database with Oracle8i EXP utility (compress on) and recreate the database manually with smaller default storage values. Then import your database dump with the IMP utility.

What about "Reorganize Tables" with Tables and index = Yes after having change the storage parameters ?
I put initial = next = 16K instead of 40, and PCT_INCREASE=0 instead of 50. BD_BLOCK_SIZE is 8K.
BTW I'm not a DBA neither sysadmin.

PCT_INCREASE of 50? Wow, no wonder your database 'seems' to be big :) The Reorganize tables will reshuffle the tables inside the database but will not actually decrease the file system usage of your data files. For that you really need to scratch and recreate these.

Look at your segment sizes. I have had similar problems in the past where our segment sizses were huge. We were reserving about .5 Mb with the first record of a file. For the hundreds of very small tables (such as Company and Type codes) you are reserving many MB of empty space.

Stephen Ruger
Lodestar Consulting
215-785-6756
sr@mylodestar.com