Admin/admin

To check if your Oracle Binary is 32 bit or 64 bit

Qhtlr 2007. 7. 18. 08:49

To check if your Oracle Binary is 32 bit or 64 bit

file $ORACLE_HOME/bin/oracle
oracle:         executable (RISC System/6000) or object module not stripped

SQL> SELECT Length(addr)*4 || '-bits' word_length FROM v$process WHERE ROWNUM =1;

WORD_LENGTH
---------------------------------------------
32-bits


file $ORACLE_HOME/bin/oracle
oracle: 64-비트 XCOFF 실행 파일 또는 오브젝트 모듈 스트립되지 않음

SQL> SELECT Length(addr)*4 || '-bits' word_length FROM v$process WHERE ROWNUM =1;

WORD_LENGTH
---------------------------------------------
64-bits