How do i get the physical read write io for whole session in plsql?

[A Sundar]

Hi,

  I'm looking for logging read and write io in bytes in a pl/sql procedure inclusive all parallel query io.

I've tried to get it from V$MYSTAT, but I didn't get any physical write in bytes.

How do I get the total read and write io in bytes in a pl/sql procedure for the whole session and dependent parallel sessions (RAC)?

Regards,

Sundar

[Michael Moore]

I don't have a direct answer for you, but If I wast trying to figure it out, I would use TOAD and turn on ability to capture all SQL statements. Then I would go into session manager and click on desired stats. Then I would see what SQL statements TOAD used to get this information . I don't know if SQL Developer has the same ability.

--
--
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle...@googlegroups.com
To unsubscribe from this group, send email to
Oracle-PLSQL...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en

---
You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to oracle-plsql...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.