Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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>