Have u ever installed 32-bit ORACLE on a 64-bit system by mistake nd u never realized it. Well, use this command to know whether 32 bit or 64 bit ORACLE is installed on ur system.
SELECT DISTINCT ADDRESS FROM v$sql where rownum<2;
If the address is 16 characters long like 00000000345BA23E, uve got 64 bit oracle on ur system.
But if the address is 8 characters long like 098765EA, then its 32 bit ORACLE.
No comments:
Post a Comment