ORACLE Database Information check

 sys用户

select * from v$version;数据库相关服务的版本信息；

If shows "Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production" means enterprise;

If shows "Oracle Database 11g Release 11.2.0.1.0 - 64bit Production" means standard;

How to define ORACLE 32bits or 64bits

Method 1:
Go to ORACLE_HOME/bin
$ file oracle
oracle: ELF 32-bit MSB executable SPARC Version 1, dynamically linked, not stripped
Method 2:-
Login to sqlplus,
use the following query,
SQL> select metadata from sys.kopm$ ;
-----------------------
METADATA
-----------------------0000006001240F050B0C030C0C0504050D06090708050F0505050F05
050505050A050505050504050607080823472323081123081141B0230
083001F07D01300000000000000000000000000000000000000000
000000000000000000000000000000000

If the output has 'B023' string then the database is 32 bit else if it is B047 then it is 64 bit

Pasted from: <https://blogs.oracle.com/myoraclediary/entry/how_to_check_the_installed_oracle_software_is_3264_bit>

select * from dba_registry_database;数据库所在服务器的版本信息；

select * from v$instance;数据库实例信息；

select * from dba_registry;数据库安装了哪些组件；

select log_mode from v$database;数据库当前是否为归档模式；

select flashback_on from v$database;数据库当前是否启用flash_back；

select * from v$controlfile;数据库实例控制文件信息；

select * from v$tablespace;数据库实例表空间信息；

select * from v$datafile;数据库实例数据文件信息；

show parameter spfile;数据库实例参数文件信息；

check all the parameter which has changed value: select * from v$parameter where ISDEFAULT <>'TRUE'; 

普通用户：

select * from clos; 查询该用户名下所有列名；

select * from user_tables;查询该用户名下所有表名；