Posts Tagged ‘Oracle R12’

Clearing Cache In R12

January 3rd, 2018, posted in Oracle
Share

For clearing EBS middle tier cache :

Login to front end application.
Navigate to Functional Administrator responsibility 
Click on (Core Services) Tab
Click on Caching Framework
Select ‘Global Configuration’ on left side menu
Clear All Cache

Finally Bounce the apache and oacore services.

Share

Query to find sessions generating more Archives

April 27th, 2015, posted in Oracle Queries
Share

This Query is to find the session that is generating more Archives.

 

select to_char(sysdate,'hh24:mi'), username, program , a.sid, a.serial#, b.name, c.value
from v$session a, v$statname b, v$sesstat c
where b.STATISTIC# =c.STATISTIC#
and c.sid=a.sid and b.name like 'redo%'
order by value;
Share