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