I have one application server separate from an Oracle server (one physical server). I have three instances on one Oracle Database Server (another physical server).
I want to have three environments to work in, Development, Test, and Production.
Should these be three Instances or three Schemas that use the same Instance? Edit: The server can physically handle it either way (i.e. has enough space, memory, and so on.)