Hi,

One of my application teams running a shell script which does some DML operations in the beginning then calls a function and does some DDL & DML inside the function.

The script is hanging when it call the function. I have traced the session using dbms_system.set_sql_trace_in_session, tkprof it but nothing is showing in the tkprof log.

This is the only session connected to DB. Log switch (50MB) is happening once in every two minutes but nothing is showing in sql trace.

Can some one shed some light?

Thanks,