Guidance on how to clear JBoss and Database Cache
2 years ago
Originally Published: 2015-06-15
Article Number
000067353
Applies To
RSA Product Set: Identity Management and Governance
RSA Product/Service Type: Appliance
RSA Version/Condition: 6.8.1
Platform: JBoss
Platform (Other): null
O/S Version: N/A
Product Name: null
Product Description: null
Issue
These steps are used when running job are stuck at "Running" and does not complete for a while while there are other jobs in queue as "New".
When reviewing AWR Report, you will notice the collectors running with more than 100% CPU.
Resolution
When restarting the JBoss server and DB. I would suggest to clear JBoss cache and DB cache as that may hold Runs data/details and will start again. 

JBoss cache can be cleared by:
1)    acm stop 
2)    cd /home/oracle/jboss-4.2.2.GA/server/default
3)    mv tmp tmp-bkp
4)    mv work work-bkp
5)    mv data data-bkp 
6)    acm start

Database cache can be cleared by:
1)    sqlplus sys as sysdba 
2)    provide password 
3)    Enter query: startup force