Reading SPFILE

Can we read directly from SPFILE what parameters are defined?

Can we read directly from SPFILE what parameters are defined?
The V$SPPARAMETER view will show you the contents of the SPFILE. This view differs from V$PARAMETER. V$PARAMETER will show you the settings of the parameters for the instance.

Dig Deeper on Oracle database backup and recovery

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close