Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
create or replace PROCEDURE CMI_PERFTIMER AS s timestamp(9); e timestamp(9); diff interval day(3) to second(9); Hold VARCHAR2(2000); CURSOR SelectString IS SELECT selectstmt FROM cmi_perf_select; BEGIN OPEN selectstring; FETCH selectstring INTO hold; WHILE selectstring%found LOOP s:=to_timestamp(sysdate); -- for i in 1..3000 loop EXECUTE IMMEDIATE 'select count(*) from (' || hold || ')'; -- end loop; e:=to_timestamp(sysdate); diff:=e-s; INSERT INTO CMI_PERF_TIME VALUES (hold, systimestamp, diff ); COMMIT; FETCH selectstring INTO hold; END LOOP; END CMI_PERFTIMER;
|error I/O in copying in linux redhat||12||53|
|consolidate 4 lines of oracle query output to 1 line||4||25|
|PL/SQL Multiple PAYER_IDs with PAYER_TYPES are these types||3||16|
|How to quickly enable constraint with ENABLE VALIDATE for a big table in 12c||13||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!