Posts by Venkatesh GK

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