Without querying the v$ tables is there a way I can tell what instance I am running on? I am running something in a production database that changes every few days. I need to set some variables different between production and development because I am currently going between Oracle 9i and Oracle 10g. I need to know the HOST or the SID or anything that will differentiate between the two systems.
The following query is an alternative to querying V$DATABASE or V$INSTANCE:
SELECT property_value FROM database_properties
But probably a better way would be to query your session's properties with the following:
select sys_context('userenv','db_name') from dual;
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.