Query V$PARAMETER for current parameter settings. : V_Parameter « System Tables Views « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Tables Views
  3. V_Parameter

Query V$PARAMETER for current parameter settings.

  


SQL>
SQL> select Name,
  2         Value
  3    from V$PARAMETER
  4   where Name = 'log_buffer';



NAME
------------------------------------------------------
VALUE
------------------------------------------------------
log_buffer
2859008

1 row selected.

SQL>
SQL>








Related examples in the same category

1.Query v$parameter for database name
2.Query parameter for
3.select Name, Value, IsDefault from V$PARAMETER
4.List database parameters