1 Reply Latest reply: Nov 26, 2013 6:10 AM by Flávio Soares RSS

    TOP SQL ordered by Sharable Memory

    Cherif bh

      Hi ,

      I have query appear more than once on the top SQL ordered by Sharable Memory:

       

      I need to know :

      1) the impact of having a query important sharable memory on performance?

      2) how to proceed on this case.

       

       

      Many thanks

       

      Snap IdSnap TimeSessionsCursors/Session
      Begin Snap:4546520-Nov. -13 11:00:0354310.8
      End Snap:4547320-Nov. -13 15:00:125507.9

       

       

      Sharable Mem (b)Executions% TotalSQL IdSQL ModuleSQL Text
      59,562,715180.12fzvu9z9dnun05XXXXXINSERT INTO XXXXX
      21,660,331180.04fzvu9z9dnun05XXXXXINSERT INTO XXXXX
      20,321,515180.04fzvu9z9dnun05XXXXXINSERT INTO XXXXX
        • 1. Re: TOP SQL ordered by Sharable Memory
          Flávio Soares

          Hi guy,

           

          This query can help you, check it:

           

           

          SQL>  select * from (
          1   select to_char(round(sharable_mem/1024/1024,2),'999,999,999.00') SIZE_MB, sql_id, executions, version_count
          2   from v$sqlarea
          3  order by 1 desc
          4  ) where rownum < 10;
          

           

          SIZE_MB   SQL_ID  EXECUTIONS VERSION_COUNT

          --------------- ------------- ---------- -------------

          6.36 g9hzfwusavzrz5066469     209
          3.10 gpujfmjf0r97g103515      77
          2.94 fskw6cpnx52983460129     289
          2.07 8f1sjvfxuup9w  101       8
          1.00 2tkw12w5k68vd 1143      19
          .81 ba7tkp8n59fbm46147      30
          .81 dcstr36r0vz0d  199      20
          .78 90f9smmd3avzd  218       3
          .74 d6s6rw4fwsmd6569582      14