SQL Queries for Parameter description

SQL> show parameter background_dump

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
background_dump_dest                 string      /u0x/oracle/PROD/db/tech_st/11
                                                 .2.0/admin/XXXX/diag/
                                                 rdbms/XXX/XXX/trace


SQL> show parameter control

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time        integer     7
control_files                        string      /u06/oracle/proddata/cntrl01.d
                                                 bf, /u06/oracle/proddata/cntrl
                                                 02.dbf, /u06/oracle/proddata/c
                                                 ntrl03.dbf
control_management_pack_access       string      DIAGNOSTIC+TUNING

SQL> show parameter log

will display all the parameters info about logs

SQL> show parameter

will display all the parameters info