You can use DBMS_APPLICATION_INFO package also