Wednesday, October 30, 2019

How to check oracle database is either 32 bit or 64bit

SQL> conn / as sysdba
Connected.
SQL>  select length(addr)*4 || '-bits' word_length from v$process where rownum=1;

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

SQL>

-- using cmd in Windows machine

C:\Users\rajam>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Oct 30 17:36:27 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production

SQL>
SQL> select length(addr)*4 || '-bits' word_length from v$process where rownum=1;

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

SQL>

No comments:

Post a Comment

Delete Row Button to all records of Interactive Report in Oracle Apex

 1. add 'Delete' Del column to Report Query 2. Set the Following Properties for the DEL Column Type: Link Heading: Delete Targ...