Posts by Venkatesh GK

OEM Fix For Agent Shows Availability Evaluation Error

Please run the below command from <Agent base>/agent_inst/bin of the agent monitoring the target host. ./emctl config agent addinternaltargets ./emctl secure agent ./emctl config agent listtargets ./emctl stop agent ./emctl secure agent…

Read More

Query to get source code in database from back end

set verify off set feedback off set lines 300 set pages 0 set heading off set space 0 column text format a79 column line noprint select DECODE(line,1,’create or replace ‘,”)||text,…

Read More

Query to get SQL changed Performance

SPO sql_performance_changed.txt; DEF days_of_history_accessed = ’31’; DEF captured_at_least_x_times = ‘1’; DEF captured_at_least_x_days_apart = ‘1’; DEF med_elap_microsecs_threshold = ‘1e4’; DEF min_slope_threshold = ‘0.1’; DEF max_num_rows = ’20’; SET lin 500 ver…

Read More

Query to get concurrent Manager status from back end.

SELECT DECODE ( CONCURRENT_QUEUE_NAME, ‘FNDICM’, ‘Internal Manager’, ‘FNDCRM’, ‘Conflict Resolution Manager’, ‘AMSDMIN’, ‘Marketing Data Mining Manager’, ‘C_AQCT_SVC’, ‘C AQCART Service’, ‘FFTM’, ‘FastFormula Transaction Manager’, ‘FNDCPOPP’, ‘Output Post Processor’, ‘FNDSCH’, ‘Scheduler/Prereleaser…

Read More