how to Find Database is 32 bit or 64 Bit

1)login as oracle user in Linux Box And go to $ORACLE_HOME/bin

2) give the following command  ” file  rman ”

example : file  Any executable (like sqlplus,rman)

You can get header of that executable if you find 32 it/64 Number there

Then that is database Bit version

Example:

 $  file    $ORACLE_HOME/bin/sqlplus 

you should see output like
/u01/db/bin/sqlplus:  ELF 64-bit MSB executable
which means you are on 64 bit oracle
If your oracle is 32 bit you should see output like
oracle: ELF 32-bit MSB executable

Useful DBA/APPSDBA sql/Scripts

To Find The Application URL from Database

select home_url from apps.icx_parameters;

to find invalid objects in Database

select owner,object_type,count(object_name) INVALIDS from dba_objects where status =’INVALID’

To  Find Blocking Sessions in Database

select * from dba_blockers

TO Find The Product Code Level Or patchset level

select Status  ,PATCH_LEVEL from fnd_product_installations where PATCH_LEVEL like ‘%AD%’;

Ex : replace AD with desire Product

To find the Languages Installed ??

select nls_language, language_code, installed_flag from apps.fnd_languages where installed_flag in (‘I’,’B’);

how to find which node is having which service info in 11i/R12

Use fnd_table to get   the components detais..

/**** to find abt services installed in Nodes **////

select NODE_NAME , SUPPORT_CP , SUPPORT_FORMS , SUPPORT_WEB , SUPPORT_ADMIN , SUPPORT_DB
from apps.fnd_nodes ;