global_name, instance_name,db_name, db_unique_name,service_name

Database►Oracle Comments

instance_name(实例名)

1
2
3
4
5
6
7
8
9
10
11
SQL> select  instance_number,instance_name from v$instance;

INSTANCE_NUMBER INSTANCE_NAME
--------------- ----------------
              1 orasidsusu

SQL> show parameters instance_name;

NAME                                 TYPE        VALUE
------------------------------------ ----------- --------
instance_name                        string      orasidsusu

sid

1
2
3
4
5
SQL> select  instance from v$thread;

INSTANCE
--------------------------------------------------------------------------------
orasidsusu

global_name(全局数据库名)

1
select * from global_name

db_name(数据库名)

1
2
3
4
5
6
7
8
9
10
11
12
SQL> select dbid,name from v$database;

      DBID NAME
---------- ---------
1311078515 SUSU

SQL> show parameters db_name;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      susu

service_name（服务名）

service_name alias（服务别名）

1

素丶素丶丶wodetian

忍一时越想越气，退一步越想越亏。