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.
On Fri, Jul 25, 2014 at 9:19 AM, A Sundar <asund...@gmail.com> wrote: > 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 > > -- > -- > 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-PLSQL@googlegroups.com > To unsubscribe from this group, send email to > oracle-plsql-unsubscr...@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+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- -- 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-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@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+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
