You need to refer the following Note to understand the execution of the scripts
APSCHECK.sql Provides Information Needed for Diagnosing VCP and GOP Applications Issues, also available in Note: 246150.1
APScheck_parser.pl provides the analysis of multiple data points produced by APSCHECK.sql. To be used to assist analyzing ASPCHECK.sql output. This parser output will be included with the submission of ASPCHECK.sql soon.
ASCP_COLLECTIONS_ANALYZER provides analysis of the VCP data collection environment, also available in Note: 1596457.1
VCP_PARTITION_ANALYZER provides analysis of the VCP partitions environment, also available in Note: 2159104.1
Hope this helps
Where do I run it? in applmgr (apps user) or, oracle (db user)?
It should be application user (apps)