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 three folder "bdump/udump/cdump".
In that folder database will create the trace files

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

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

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

-$INST_TOP/logs/ora/appltmp
OF*.t

-$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] <