Atif Apps wrote:This table cannot be purged -- http://etrm.oracle.com/pls/trm120/etrm_pnav.show_object?c_name=HZ_GEOGRAPHIES&c_owner=AR&c_type=TABLE
I am seeing the below huge logical reads on the HZ_GEOGRAPHIES table. Can you please suggest me what things i should look into.
we are using Apps 12.0.4 & Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi and running PMF module.
It is a two node architecture with db running on one node and CP,FORMS,admin , web on the other node.
The db node is having 4 CPUS and 8GB RAM which i suppose is very less and needs to be upgraded.
Owner Tablespace Name Object Name Subobject Name Obj. Type Logical Reads %Total
AR APPS_TS_TX_DATA HZ_GEOGRAPHIES TABLE 2,132,201,408 92.28
Kindly provide your inputs and the checks i need to perform to get this application running smoothly.