Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the INSTANCE and SID name via SQL
V$INSTANCE.INSTANCE_NAME is the name of the instance, what is the SID.
V$DATABASE.NAME is the name of the database, specified in the init.ora as
db_name.
All Oracle documentation can be found online at http://tahiti.oracle.com
Lanying & Manfred Chen-Fischer <manfis_at_chen-fischer.de> schreef in
berichtnieuws aqlho6$df2$05$1_at_news.t-online.com...
| Hello my friends,
|
| I don't have any manuals...
|
| How to get the INSTANCE name and the SID name
| via SQL statement. Is there any SYSTEM table or view?
|
| Have a nice weekend
|
| Manfred
|
|
Received on Sun Nov 10 2002 - 07:19:32 CST