To view components and their versions, loaded into the database:
SELECT comp_name, status, version FROM dba_registry;
To view version numbers of core library components, including the database:
SELECT banner FROM v$version;
To display options that are installed (the value column is ‘FALSE’ if the option is not installed)
SELECT parameter, value FROM v$option;
1 comment:
Nice post. You have shared a lot of helpful commands in your blog. Many of them I have not learnt and tried earlier. It will an interesting option to try all of them and to learn each of them that will increase my knowledge too. Thank you.
sap upgrades
Post a Comment