How to check whether oracle is 32-bit or 64-bit

Oracle digit viewing method: Query parameter value in SQL*Plus: SELECT value FROM v$parameter WHERE name = 'compatible'. If the value is 12.1.0.2, it is 32 bits; if it is 12.2.0.1, it is 64 bits. Find process information: Execute tasklist | find "ora.exe" (Windows) or ps -ef | grep ora.exe (Linux) on the command line. If the process name is followed by "32", it is 32 bits; otherwise it is 64 bits

How to see if Oracle is 32-bit or 64-bit

View directly

In SQL*Plus, execute the following command:

 <code class="sql">SELECT value FROM v$parameter WHERE name = 'compatible';</code>

If the returned value is 12.1.0.2, Oracle is 32 bits.
If the returned value is 12.2.0.1, Oracle is 64 bits.

View process information

On the command line, execute the following command:

• Windows: tasklist | find "ora.exe"
• Linux: ps -ef | grep ora.exe

In the output, look for the "ora.exe" process.

• If the process name is followed by "32", Oracle is 32 bits.
• If there is no "32" after the process name, Oracle is 64 bits.

The above is the detailed content of How to check whether oracle is 32-bit or 64-bit. For more information, please follow other related articles on the PHP Chinese website!