12 responses

  1. James
    July 25, 2013

    Another great post Jeff. It uncovered an issue though for me in SQL Dev 4. I’m running a desktop resolution of 1366×768 on my laptop and when I open a new report window it is vertically too large for my screen. That means the ‘Apply’ button is off the bottom of the screen and no amount of dragging or attempting to resize the window will let me see the buttons.

    • thatjeffsmith
      thatjeffsmith
      July 25, 2013

      Bugged!

      Now, what can we do about getting you a nicer monitor/video card?

      • James
        July 25, 2013

        Ha Ha. Don’t worry too much Jeff, it’s only on my laptop I noticed the issue! My desktop is much nicer. That said, if Oracle want to start providing a 29″ widescreen monitor with every SQL Developer 4.0 download I won’t say no ;)

    • Jari Hämäläinen
      August 29, 2013

      I have the same issue. Hopefully this is going to be fixed in the next version.

      • thatjeffsmith
        thatjeffsmith
        August 29, 2013

        Jari & James – it’s fixed. In the next build the window is resizable so you can squeeze it down to fit.

  2. Jamie T
    April 2, 2014

    Is the HTML chart output size able to be modified? Semms like my chart Axis ID’s are being cut off.

    • thatjeffsmith
      thatjeffsmith
      April 3, 2014

      Does it render OK in SQL Developer, but not when you send it to HTML? If so, that sounds like a bug.

  3. Stephen Keilholz
    September 22, 2014

    Jeff, is there a way to include bind variables in a chart title? For instance, if the data in the query is being selected by a date range, it would be important to show that on the chart, lest it be misinterpreted as all-inclusive.

    • thatjeffsmith
      thatjeffsmith
      September 22, 2014

      I don’t think so…but I’m betting there’s another way to encompass that info in the report somehow. Are you not showing the date range in the chart on the axis?

      • Stephen Keilholz
        September 22, 2014

        No. The report is documenting the count of transactions (vertical axis) that take certain number of seconds (horizontal axis) by category.

        Here’s my SQL:
        WITH xa_durations AS
        (SELECT xa_id, xa_type, MAX(xa_ts) – MIN(xa_ts) AS DUR,
        TRUNC(EXTRACT (SECOND FROM (MAX(xa_ts)-MIN(xa_ts)))) DELTA_GROUP
        FROM xa_log
        WHERE xa_date BETWEEN to_date(:earliest_date,’mm/dd/yyyy’) AND to_date(:latest_date,’mm/dd/yyyy’)
        AND xa_type IS NOT NULL
        GROUP BY xa_id, inf_nm
        ORDER BY xa_id DESC
        )
        SELECT delta_group, , COUNT(*)
        FROM xa_durations
        GROUP BY delta_group, xa_type
        ORDER BY delta_group ASC, xa_type ASC

  4. Stephen Keilholz
    September 22, 2014

    EDIT – please remove this line and my previous comment
    No. The report is documenting the count of transactions (vertical axis) that take certain number of seconds (horizontal axis) by category.

    Here’s my SQL:
    WITH xa_durations AS
    (SELECT xa_id, xa_type, MAX(xa_ts) – MIN(xa_ts) AS DUR,
    TRUNC(EXTRACT (SECOND FROM (MAX(xa_ts)-MIN(xa_ts)))) DELTA_GROUP
    FROM xa_log
    WHERE xa_date BETWEEN to_date(:earliest_date,’mm/dd/yyyy’) AND to_date(:latest_date,’mm/dd/yyyy’)
    AND xa_type IS NOT NULL
    GROUP BY xa_id, inf_nm
    ORDER BY xa_id DESC
    )
    SELECT delta_group, xa_type, COUNT(*)
    FROM xa_durations
    GROUP BY delta_group, xa_type
    ORDER BY delta_group ASC, xa_type ASC

  5. subrahmanyam
    October 13, 2014

    Hi jeff,

    I want to generate a html report of all the procedures and function Schema “Test Run on codecoverage ” report. that is commad line and UI Mode.

Leave a Reply

 

 

 

Back to top
mobile desktop