Find Oracle Applications Login URL from database

Find Oracle Applications Login URL from database

SQL> SELECT home_url FROM icx_parameters;

SQL> SELECT profile_option_value FROM fnd_profile_option_values WHERE profile_option_id= (SELECT profile_option_id FROM fnd_profile_options WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT') AND level_value = 0;

Oracle R12 Forms Not Opening In Browser

Oracle R12 Forms Not Opening In Browser

Issue:

When trying to open forms in R12, following error is coming

 Solution:


1. Go to Start >  Control Panel


2. Click on Java Control Panel and select tab "security" and make Security Level "Medium"

 3. Also, add URL in the Exception Site List. For e.g http://xyz.erp.com:8000 and apply it

How to Find Sessions Generating Lots of Redo or Archive logs

How to Find Sessions Generating Lots of Redo or Archive logs (Doc ID 167492.1)

TO CHECK SESSIONS

SQL> SELECT s.sid, s.serial#, s.username, s.program,
i.block_changes
FROM v$session s, v$sess_io i
WHERE s.sid = i.sid
ORDER BY 5 desc, 1, 2, 3, 4;

TO CHECK TRANSACTIONS

SQL> SELECT s.sid, s.serial#, s.username, s.program,
t.used_ublk, t.used_urec
FROM v$session s, v$transaction t
WHERE s.taddr = t.addr
ORDER BY 5 desc, 6 desc, 1, 2, 3, 4

TO CHECK EXACT QUERY

SELECT address ,SUBSTR(sql_text,1,1000) Text, buffer_gets, executions,
buffer_gets/executions AVG
FROM v$sqlarea a, v$session s
WHERE sid = <SID>
AND s.sql_address = a.address
AND executions > 0
ORDER BY 5;


===============================

Empty the linux buffer cache

Empty the Linux buffer cache

sync && echo 3 > /proc/sys/vm/drop_caches