Oracle processes taking mucho memory

[DQuinn]

Hi,

We have recently upgraded from 8.1.7.4 to 9.2.0.5

We are getting into memory problems even though we have 8GB.
It seems that the Oracle processes are taking up to 80Mb.
Is this to be expected?
If not, what is the best way to reduce the amount of memory
each process uses?

BTW..we have about 30 instances on this dev server.

Thanks

[tamilselvan]

30 instances?

Put each instance in one Desktop PC.

Tamil

[DaPi]

If you "Ask Tom" you'll find one instance per server as his recommendation. For example: http://asktom.oracle.com/pls/ask/f?p...:4347545437371

[DQuinn]

Thanks,

Makes sense to me....


Denis

[DQuinn]

What is the best way to go about "gathering" all the different "applications" or "Schemas" together?

Denis

[DaPi]

My 2¢

To see which applications could "cohabit" I think you'll need to look at:

- will the different applications ever need to run with different versions of Oracle?
- are some db's in archivelog mode and others not?
- do you have the same schema name in different db's - if so what would be the impact of changing it (e.g. do you have code like "select ... from schema1.my_table ...")
- any impact on external systems


Realistically I wouldn't expect you to end up with only one instance, but 4-5 big ones would be better than 30 small ones. (Though Tamil's suggestion is not 100% flipant - it depends on the licensing impact - per CPU ouch!).

When(?) you do merge, you might want to have a tablespace per application so that backup/restore/recovery could maintain the same level of independance as now.

Traditionally exp/imp was the way to implement this . . . it seems to me that TRANSPORTABLE TABLESPACES would have some place in the operation.

[slimdave]

Let me add to that whether the different application are running under CBO or RBO, and whether they have many different init parameters. Based on this some re-tuning may be required.