DBA HIST Views‎ > ‎

DBA_HIST_PARAMETER


 desc DBA_HIST_PARAMETER
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                   NOT NULL NUMBER
 DBID                                      NOT NULL NUMBER
 INSTANCE_NUMBER                           NOT NULL NUMBER
 PARAMETER_HASH                            NOT NULL NUMBER
 PARAMETER_NAME                            NOT NULL VARCHAR2(64)
 VALUE                                              VARCHAR2(512)
 ISDEFAULT                                          VARCHAR2(9)
 ISMODIFIED                                         VARCHAR2(10)



 col parameter_name for a30
 col value for a20
select parameter_name,value from dba_hist_parameter where lower(parameter_name) like '%&1%'

Comments