Checks after Oracle Database Installation

col parameter format a40
col value format a20
SELECT * FROM gv$option;
col comp_name format a30
SELECT comp_name, version, status FROM dba_registry;


set linesize 131
col property_name format a28
col property_value format a28
col description format a70
SELECT *FROM database_properties ORDER BY 1;
or
set pagesize 0
set linesize 121
col value$ format a40
col comment$ format a36

SELECT *FROM sys.props$
 

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post