Viewing Keys (indexes) at Oracle Level

select * from system.dba_ind_columns where table_name='ps_table_name';

Application Engine Tracing

You can turn on tracing for a distinct Application Engine process by appending AE parameters. Append parameter "-TRACE 3" to enable the tracing.