my questions:
1. If I have two instances on my box, does this mean that I have two oracle databases?

2. can I have these two instances share the same tablespace and datafile etc. what about the controlfiles.

3. can I choose which instance I want to log into, or is it transparent at this point.


thank you for your responds.