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 like 'timed_stat%';
NAME VALUE
-------------------- --------------------
timed_statistics TRUE
SQL> alter session set timed_statistics = false;
Session altered.
SQL> select name, value from v$system_parameter where name like 'timed_stat%';
NAME VALUE
-------------------- --------------------
timed_statistics TRUE
SQL> c/system_//
1* select name, value from v$parameter where name like 'timed_stat%'
SQL> /
NAME VALUE
-------------------- --------------------
timed_statistics FALSE
SQL>
HTH,
- Kirti
-----Original Message-----
From: Nirmal Kumar Muthu Kumaran [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 08, 2003 7:29 AM
To: Multiple recipients of list ORACLE-L
Subject: V$SYSTEM_PARAMETER vs V$PARAMETER
Hi,
Where
these two, V$SYSTEM_PARAMETER, V$PARAMETER dynamic view are
differs?
Both
of them looks the same in structure and data as
well.
Anybody have any idea.
Nirmal.
