In Windows, go to Control Panel->Administrative Tools->Services and look for any service with a name similar to...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
'OracleServiceSID.' The SID is your instance name. There will be one instance for each database.
In Unix/Linux, look for a file called "oratab" in either the /var/opt/oracle directory or the /etc directory. This file will contain one entry for each instance.
Unfortunately, there is no native method in SQL*Plus to see the above information.
To see the list of tables in the database, you can query the DBA_TABLES Data Dictionary view, similar to the following:
SELECT owner,table_name FROM dba_tables;
The Data Dictionary views are fully described in the Oracle 10g Reference Guide.
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.