Any bad impact if Oracle 9i and 10g instances stay in the same server.

[skdas]

Any bad impact if Oracle 9i and 10g instances stay in the same server.

In the database side , is there in problem if 9i and 10g databases stay together in a server...?

[davey23uk]

no

[skdas]

Even Oracle binaries are in different directories, does it affect any way.. Just want to make sure..

[davey23uk]

i'll repeat, NO

[ixion]

I concur, technically no issue!No overlap, seperate files seperate processes seperate memory.

However running two instances does double the work load (maybe). And might cause undue stress on your system resources. ie, running two lgwr, to dbwr etc...

For example, A "bad" impact is if the disk subsystem for redo logs are now saturated, IE both instances log to the same physical disk. That would be a "BAD" impact. This all depends significantly upon your hardware.

YMMV