Tag Archives: Top 10 Apps Useful queries for APPS DBA

Top 10 Useful oracle apps queries for DBA

Oracle apps DBA has to often trouble shoot various issues. I am giving here Top 10 Useful oracle apps queries for DBA To find forms sesssion in database set linesize 1000 column username format a8 heading “User|Name” column sid format 9999 column serial# format 99999 column user_form_name format a25 column spid format a5 column unix_process format a7 heading “UNIX|Process” column user_name format a15 trunc heading … Continue reading Top 10 Useful oracle apps queries for DBA »