Title: AW: How to create two db-links within one schema when global_names=tr
In
their scope...
View
v$parameter shows current settings for a session.
View
v$system_parameter shows system wide parameter settings.
See below:
SQL> select name, value from
v$system_parameter where name li
Title: AW: How to create two db-links within one schema when global_names=tr
Nirmal,
When the instance starts up both have same
information. If you set a session's value using ALTER SESSION SET
= then the newvalue is shown in
V$PARAMETER but not in V$SYSTEM_PARAMETER.
for instance
SQL
Title: AW: How to create two db-links within one schema when global_names=tr
I
believe that the distinction is that V$Parameter is at the session level, where
v$system_parameter is at the instance level.
Thus,
if you issue an alter session set shared_pool= 1024000, the setting in
v$parameter