Oracle PL/SQL Tutorial/System Tables Data Dictionary/user libraries

Query user_libraries

   <source lang="sql">

SQL> SQL> SQL> SQL> select library_name, file_spec, dynamic from user_libraries; no rows selected SQL> SQL></source>