Hello,

We are managing 15 companies in one oracle 8 database on one single server, i.e. about 40,000 tables.
Our base has about 130 Go in 10 tablespaces.
Our performances and response time are very good.

I have to create a new archieve company and 2500 tables more.

Do you think this number of tables could be a problem ?
Have you some experience with even more companies/tables on one database/server ?

Regards

Richard

Connected to:
Oracle8i Release 8.1.7.4.1 - Production
JServer Release 8.1.7.4.1 - Production

SQL> select count(*) from dba_tables where owner = 'BAANDB';

COUNT(*)
----------
80781

SQL>

works fine for many years.

Regards,
Han Brinkman

Hi Richard,

the number of tables is no problem, but you might consider to create a new Oracle instance for archive companies anyway. This will give you some benefits in regards to backup and recovery, if your archive companies become big enough.


Regards

Markus

The number of tables can become a problem for your system tables when not using LMT. Several system tables get fragmented and can only be reorganized by re-creating the database. Therefore I advise to use LMT or edit the sql.bsq file before creating the database.

Kind regards,
Dick

PS. Editing the sql.bsq file should only be done by experienced people and can lead to unsupported environments. Therefore I don't give the things that should be changed.