Symptom
You want to get, check the current parameter value from your Oracle database.
Solution
To list out all the current parameter values that been maintained in your Oracle database.
SQL> show parameter NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ star_transformation_enabled string TRUE statistics_level string TYPICAL streams_pool_size big integer 0 tape_asynch_io boolean TRUE thread integer 0 timed_os_statistics integer 0 timed_statistics boolean TRUE trace_enabled boolean TRUE tracefile_identifier string transactions integer 1874 transactions_per_rollback_segment integer 5 ... ...
To list only specific parameter, as an example, for audit parameter.
SQL> show parameter audit NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ audit_file_dest string /oracle/audit/ audit_sys_operations boolean FALSE audit_syslog_level string audit_trail string NONE
