418: select 'Y' into l_run_ok from all_objects
419: where owner='SYS' and object_type='PACKAGE BODY'
420: and object_name='DBMS_PROFILER';
421:
422: select 'Y' into l_run_ok from all_tables
423: where table_name='PLSQL_PROFILER_RUNS' and rownum =1 and owner like '%';
424: select 'Y' into l_run_ok from all_tables
425: where table_name='PLSQL_PROFILER_UNITS' and rownum =1 and owner like '%';
426: select 'Y' into l_run_ok from all_tables
420: and object_name='DBMS_PROFILER';
421:
422: select 'Y' into l_run_ok from all_tables
423: where table_name='PLSQL_PROFILER_RUNS' and rownum =1 and owner like '%';
424: select 'Y' into l_run_ok from all_tables
425: where table_name='PLSQL_PROFILER_UNITS' and rownum =1 and owner like '%';
426: select 'Y' into l_run_ok from all_tables
427: where table_name='PLSQL_PROFILER_DATA' and rownum =1 and owner like '%';
428: EXCEPTION
422: select 'Y' into l_run_ok from all_tables
423: where table_name='PLSQL_PROFILER_RUNS' and rownum =1 and owner like '%';
424: select 'Y' into l_run_ok from all_tables
425: where table_name='PLSQL_PROFILER_UNITS' and rownum =1 and owner like '%';
426: select 'Y' into l_run_ok from all_tables
427: where table_name='PLSQL_PROFILER_DATA' and rownum =1 and owner like '%';
428: EXCEPTION
429: WHEN NO_DATA_FOUND THEN
430: dlog('Profiler Package and/or Profiler Tables could not be accessed.');