Problem solve Get help with specific problems with your technologies, process and projects.

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