create table plsql_profiler_runs

(

runid number primary key, -- unique run identifier,

-- from plsql_profiler_runnumber

related_run number, -- runid of related run (for client/

-- server correlation)

run_owner varchar2(32), -- user who started run

run_date date, -- start time of run

run_comment varchar2(2047), -- user provided comment for this run

run_total_time number, -- elapsed time for this run

run_system_info varchar2(2047), -- currently unused

run_comment1 varchar2(2047), -- additional comment

spare1 varchar2(256) -- unused

);

'Run-specific information for the PL/SQL profiler';

create table plsql_profiler_units

(

runid number references plsql_profiler_runs,

unit_number number, -- internally generated library unit #

unit_type varchar2(32), -- library unit type

unit_owner varchar2(32), -- library unit owner name

unit_name varchar2(32), -- library unit name

-- timestamp on library unit, can be used to detect changes to

-- unit between runs

unit_timestamp date,

total_time number DEFAULT 0 NOT NULL,

spare1 number, -- unused

spare2 number, -- unused

--

primary key (runid, unit_number)

);

'Information about each library unit in a run';

create table plsql_profiler_data

(

runid number, -- unique (generated) run identifier

unit_number number, -- internally generated library unit #

line# number not null, -- line number in unit

total_occur number, -- number of times line was executed

total_time number, -- total time spent executing line

min_time number, -- minimum execution time for this line

max_time number, -- maximum execution time for this line

spare1 number, -- unused

spare2 number, -- unused

spare3 number, -- unused

spare4 number, -- unused

--

primary key (runid, unit_number, line#),

foreign key (runid, unit_number) references plsql_profiler_units

);

'Accumulated data from all profiler runs';

create sequence plsql_profiler_runnumber start with 1 nocache;