Sunday, March 27, 2016

Housekeeping of R12 application & Database

Housekeeping of R12 application & Database

There are many files created on the file system from oracle application & database.

You can normally keep 1 month files and delete the all other unwanted files. ( recommended to take backup before deleting).

1. Database side
connect with database and check location of "bdump/udump/cdump"
show parameter back (bdump)
show parameter core (cdump)
show parameter user ( udump)
There are some other folders like "bdump/udump/cdump/alert/hm/incident/incpkg/metadata/stage/sweep/trace".
In that folder database will create the trace files

2. Application Side
-cd $INST_TOP/logs/ora/10.1.3/Apache :
access*log
error*log

-cd $INST_TOP/logs/ora/10.1.2/reports/cache
o*.txt
o*.eps
o*.xml

-cd $INST_TOP/logs/ora/10.1.2/forms
em_*.rti
frmweb_dump*

-cd $APPLTMP
OF*.t

-cd $INST_TOP/logs/appl/conc
*.txt
*.mgr
*.reg
*.log

with ROOT user
# /usr/tmp/*.tmp

Beside this there are few purge program available in the system.

How to Run the Purge Concurrent Request and/or Manager Data Program and Which Tables Does it Purge? [ID 154850.1]
How to Optimize the Process of Running Purge Concurrent Request and/or Manager Data (FNDCPPUR) [ID 92333.1]
Purge Concurrent Request and/or Manager Data Slow Performance [ID 789698.1]
Purging Strategy for eBusiness Suite 11i [ID 732713.1] 

No comments:

Post a Comment