How to check the parameter from the tables?

How can I know the names and values of all Oracle database parameters which are NOT set at the default values?  Please tell me the SQL for it.

Ans:
SQL> desc v$parameter
 Name                            Null?    Type
 ------------------------------- -------- ----
 NUM                                      NUMBER
 NAME                                     VARCHAR2(64)
 TYPE                                     NUMBER
 VALUE                                    VARCHAR2(512)
 ISDEFAULT                                VARCHAR2(9)
 ISSES_MODIFIABLE                         VARCHAR2(5)
 ISSYS_MODIFIABLE                         VARCHAR2(9)
 ISMODIFIED                               VARCHAR2(10)
 ISADJUSTED                               VARCHAR2(5)
 DESCRIPTION                              VARCHAR2(64)

SQL> select name, value from v$parameter where isdefault <> 'TRUE';

NAME                           VALUE
------------------------------ ----------------------------------------
processes                      100
control_files                  /d01/dbs/control01.ctl, /d03/dbs/control
                               02.ctl, /d05/dbs/control03.ctl
db_block_size                  8192
log_archive_start              TRUE
log_archive_dest               /d01/arch
log_archive_format             %t_%s.log
log_buffer                     245760
....
 
 

Hosted by www.Geocities.ws

1