Databases Reference
In-Depth Information
Foo(i);
END LOOP;
END Workload;
PROCEDURE Foo(CUSTID IN sh.sales.cust_id%TYPE) IS
BEGIN
DECLARE
l_stmt VARCHAR2(2000);
BEGIN
l_stmt := 'SELECT * FROM sh.sales s WHERE s.cust_id = ' ||
TO_CHAR(CUSTID);
EXECUTE IMMEDIATE l_stmt;
END;
END Foo;
END;
/
4.
Now we create the initial snapshot:
CONNECT PERFSTAT/PERFSTAT
EXEC statspack.snap;
5.
Execute the test workload:
CONNECT SH/SH
EXEC Chapter1.Workload;
6.
Now we can elaborate the end snapshot:
CONNECT PERFSTAT/PERFSTAT
EXEC statspack.snap;
7.
Finally we can launch the report creation:
SQL>@?/RDBMS/ADMIN/SPREPORT.SQL
8.
When asked, select the last two snapshots created to produce the
Chapter1.lst
report (naming the report accordingly).
