Hi,
one question:
I an executing a pl/sql script that contains a lot of single small
SQLs. As stupid example, I use (I know it does nothing):
----8<-----
DECLARE
v1 varchar2(10);
cursor c1 is select ' ' from dual;
BEGIN
open c1;
WHILE 1=1 LOOP
fetch c1 into v1;
END LOOP;
END;
----8<----
While executing, I check on EM the 'Top SQL' and it shows me the
script as top SQL:
----8<----
Top SQL
Select Activity (%) [Sorted in descending order] SQL ID SQL Type
[CPU (98.02%)] 98.02 au9y515nbqzr0 PL/SQL EXECUTE
[CPU (.99%)] .99 b8b5jdj7khuaw SELECT
[CPU (.33%)] .33 g8b5dynmxs5xq SELECT
[CPU (.33%)] .33 ag4n74tn13tkt SELECT
[CPU (.33%)] .33 63uj9rtdp8k2a SELECT
----8<----
Does someone know how I can find out the current consuming PL/SQL by
an ordinary SQL-command without using the EM? Or: Does someone know
what SQL-Statement the EM is using to create such a result table?
I cannot find any help on the net.
Thanks in advance.
Stefan
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
