有没有好的办法得到ORACLE实例名,数据库名称!

好象没有这样的数据字典!要求得到数据库的实例名,当前运行的数据库名!
---------------------------------------------------------------

到$ORACLE_BASE目录下面有实例名为名的目录,目录里面有个pfile/init***.ora文件,里面有个参数叫db_name和instance_name

---------------------------------------------------------------

database:
select name from v$database;

instance:
select instance_name from v$instance;
---------------------------------------------------------------

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus