¬ísrjava.util.VectorÙ—}[€;¯IcapacityIncrementI elementCount[ elementDatat[Ljava/lang/Object;xp ur[Ljava.lang.Object;ÎXŸs)lxp(srInfoPurple.Qlet à¶³§cÙTL colDetailstLjava/util/Vector;L qletLocationtLjava/awt/Point;LqletSizetLjava/awt/Dimension;LqpValuesq~LqueryStrtLjava/lang/String;LsqlWithFiltersq~ xppppsq~(uq~(tworkbook statstSelectt100tManualt300t 1-JAN-1990tYsrjava.awt.Color¥ƒ3uFfalphaIvalueLcstLjava/awt/color/ColorSpace;[ frgbvaluet[F[fvalueq~xpÿÌÌÌpppsq~ÿðììpppsq~ÿÿÿÿpppt1sr java.awt.FontÅ¡5æÌÞVsIfontSerializedDataVersionF pointSizeIsizeIstyleLfRequestedAttributestLjava/util/Hashtable;Lnameq~ xpA ptArialxsq~ÿ@@@pppt15q~sq~ÿÀÀÀpppsq~A@ pq~xq~t dd-MMM-yyyyt #########tq0q~sq~A pq~xq~tappst No_PatterntVLETsq~ÿÿÿÿpppsq~ÿppptXYWORKBOOK_STATSsrInfoPurple.DashboardSettings à¶³§cÛ¬I currPletIdxI currQletIdxxp!;tAuthor,Description etcq~q~tDEFAULTq~q~tNsrjavax.swing.JTextAreaªÄ^j¼$ÒoI columnWidthIcolumnsI rowHeightIrowsZwordZwrapxrjavax.swing.text.JTextComponentQïD›awwZcheckedInputOverrideZ dragEnabledZeditableCfocusAcceleratorZneedToSendKeyTypedEventL caretColortLjava/awt/Color;LcomposedTextAttributet%Ljavax/swing/text/SimpleAttributeSet;LcomposedTextCarett3Ljavax/swing/text/JTextComponent$ComposedTextCaret;LcomposedTextContentq~ LcomposedTextEndtLjavax/swing/text/Position;LcomposedTextStartq~7LdisabledTextColorq~4Leditort!Ljavax/swing/text/JTextComponent;LlatestCommittedTextEndq~7LlatestCommittedTextStartq~7LmargintLjava/awt/Insets;LmodeltLjavax/swing/text/Document;LnavigationFiltert#Ljavax/swing/text/NavigationFilter;LselectedTextColorq~4LselectionColorq~4xrjavax.swing.JComponentmâFB*75!ZaaTextF alignmentXF alignmentYZ autoscrollsIflagsZisAlignmentXSetZisAlignmentYSetZverifyInputWhenFocusTargetLaccessibleContextt'Ljavax/accessibility/AccessibleContext;L actionMaptLjavax/swing/ActionMap;LancestorInputMaptLjavax/swing/InputMap;LbordertLjavax/swing/border/Border;L focusInputMapq~?L inputVerifiertLjavax/swing/InputVerifier;L listenerListt%Ljavax/swing/event/EventListenerList;L popupMenutLjavax/swing/JPopupMenu;LvetoableChangeSupportt"Ljava/beans/VetoableChangeSupport;LwindowInputMaptLjavax/swing/ComponentInputMap;xrjava.awt.Container@€sý 'IcontainerSerializedDataVersionZfocusCycleRootZfocusTraversalPolicyProviderI ncomponents[ componentt[Ljava/awt/Component;L dispatchert Ljava/awt/LightweightDispatcher;L layoutMgrtLjava/awt/LayoutManager;LmaxSizeq~xrjava.awt.Component•ê¦Y×<¤š#IboundsOpIcomponentSerializedDataVersionZenabledJ eventMaskZfocusTraversalKeysEnabledZ focusableIheightZ ignoreRepaintIisFocusTraversableOverriddenZisPackedZ maxSizeSetZ minSizeSetZnameExplicitlySetZ newEventsOnlyZ prefSizeSetZvalidZvisibleIwidthIxIyLaccessibleContextq~=L backgroundq~4L changeSupportt"Ljava/beans/PropertyChangeSupport;LcursortLjava/awt/Cursor;L dropTargettLjava/awt/dnd/DropTarget;[focusTraversalKeyst[Ljava/util/Set;LfonttLjava/awt/Font;L foregroundq~4LlocaletLjava/util/Locale;LmaxSizeq~LminSizeq~Lnameq~ LpeerFontq~OLpopupsq~LprefSizeq~xp8psr javax.swing.plaf.ColorUIResourcekSùŸòêæ’xq~ÿÿÿÿpppsr java.beans.PropertyChangeSupportXÕÒdWH`»I*propertyChangeSupportSerializedDataVersionLchildrenq~LsourcetLjava/lang/Object;xppq~Qpxsrjava.awt.Cursorojw÷ ItypeLnameq~ xpt Text Cursorpur[Ljava.util.Set;>š0gj×”xpsr%java.util.Collections$UnmodifiableSet€’Ñ›€Uxr,java.util.Collections$UnmodifiableCollectionB€Ë^÷LctLjava/util/Collection;xpsrjava.util.HashSetºD…•–¸·4xpw ?@srjavax.swing.KeyStroke‚CÅ—uv >xrjava.awt.AWTKeyStroke¦Â"8ª¥|ñCkeyCharIkeyCodeI modifiersZ onKeyReleasexpÿÿ ‚xsq~\sq~`w ?@sq~bÿÿ Ãxppsrjavax.swing.plaf.FontUIResourceBćÁ"‹Gxq~A0 ptTahomaxsq~Rÿpppsrjava.util.Locale~ø`œ0ùìIhashcodeLcountryq~ Llanguageq~ Lvariantq~ xpÿÿÿÿtUStentpppppptfocusLsr1javax.swing.text.JTextComponent$MutableCaretEventÑÓæGY|ýIdotZ dragActiveImarkxrjavax.swing.event.CaretEventÉ ó[rV¯Pxrjava.util.EventObjectL Nm}¨xpq~qsq~rq~qsq~rq~qsq~rq~qsq~rq~qsq~rtmouseLq~uq~{q~vq~{q~wq~{q~xq~{q~yq~{q~zpsrjava.awt.ComponentOrientationÆê§E¡œcÌI orientationxpppxur[Ljava.awt.Component;‰ æªuxppppppxA(psrjavax.swing.ActionMap¨áÅÿz’ÐÖLparentq~>xppwxppsrjavax.swing.InputMap´¨f!ÙŸLparentq~?xpsr#javax.swing.plaf.InputMapUIResource³H¢M×›ò¶xq~‚sq~„pw7sq~bÿÿ&At selection-upsq~bÿÿ'‚tcaret-next-wordsq~bÿÿ%Ãtselection-previous-wordsq~bÿÿàAq~ˆsq~bÿÿ(t caret-downsq~bÿÿTÃtprevious-link-actionsq~bÿÿ%‚tcaret-previous-wordsq~bÿÿÿÑtcut-to-clipboardsq~bÿÿ#tcaret-end-linesq~bÿÿ!Atselection-page-upsq~bÿÿàtcaret-upsq~bÿÿt delete-nextsq~bÿÿ$‚t caret-beginsq~bÿÿ%Atselection-backwardsq~bÿÿ#‚t caret-endsq~bÿÿtdelete-previoussq~bÿÿ'Ãtselection-next-wordsq~bÿÿ%tcaret-backwardsq~bÿÿâq~©sq~bÿÿãAtselection-forwardsq~bÿÿ ‚tactivate-link-actionsq~bÿÿH‚q~¥sq~bÿÿ\‚tunselectsq~bÿÿ t insert-breaksq~bÿÿ$Atselection-begin-linesq~bÿÿ't caret-forwardsq~bÿÿ!Ãtselection-page-leftsq~bÿÿ(Atselection-downsq~bÿÿ"t page-downsq~bÿÿâAq~¡sq~bÿÿOÃttoggle-componentOrientationsq~bÿÿX‚q~•sq~bÿÿ"Ãtselection-page-rightsq~bÿÿC‚tcopy-to-clipboardsq~bÿÿã‚q~Šsq~bÿÿ#Atselection-end-linesq~bÿÿâ‚q~“sq~bÿÿ$tcaret-begin-linesq~bÿÿV‚tpaste-from-clipboardsq~bÿÿáq~sq~bÿÿA‚t select-allsq~bÿÿ'Aq~¬sq~bÿÿ#Ãt selection-endsq~bÿÿÿÍq~Åsq~bÿÿâÃq~Œsq~bÿÿT‚tnext-link-actionsq~bÿÿáAq~»sq~bÿÿ t insert-tabsq~bÿÿ&q~›sq~bÿÿ$Ãtselection-beginsq~bÿÿ"Atselection-page-downsq~bÿÿãq~·sq~bÿÿãÃq~§sq~bÿÿ!tpage-upsq~bÿÿÿÏq~Íxwxwxpsr#javax.swing.event.EventListenerList±6Æ}„êÖDxppxpppwxpppppppppppsrjavax.swing.text.PlainDocumentB×ιŅàLaddedq~L defaultRoott3Ljavax/swing/text/AbstractDocument$AbstractElement;Lremovedq~xr!javax.swing.text.AbstractDocument^öö‚çŽßLcontextt4Ljavax/swing/text/AbstractDocument$AttributeContext;Ldatat+Ljavax/swing/text/AbstractDocument$Content;LdocumentFiltert!Ljavax/swing/text/DocumentFilter;LdocumentPropertiestLjava/util/Dictionary;L listenerListq~Bxpsrjavax.swing.text.StyleContextoù~{½xñI unusedSetsLstylestLjavax/swing/text/Style;xpsr(javax.swing.text.StyleContext$NamedStyleç NÆà‚¬¥L listenerListq~BLthis$0tLjavax/swing/text/StyleContext;xpsq~åpxq~ñwtdefaultsq~òsq~åpxq~ñwt$javax.swing.text.StyleConstants.nameq~öxxxsrjavax.swing.text.GapContent©˜ž LL#xrjavax.swing.text.GapVector;#„Ò6VËIg0Ig1Larrayq~Uxp ur[C°&f°â]„¬xp psrjava.util.Hashtable»%!Jä¸F loadFactorI thresholdxp?@wsrjava.awt.font.TextAttributekxŒ è Fxr/java.text.AttributedCharacterIterator$Attributet&ÍG\Lnameq~ xpt run_directionsrjava.lang.BooleanÍ r€ÕœúîZvaluexpti18nsq~ttabSizesrjava.lang.Integerâ ¤÷‡8Ivaluexrjava.lang.Number†¬• ”à‹xpxsq~åpxsq~uq~ ppppppppppxsr/javax.swing.text.AbstractDocument$BranchElementQ)fö<ñðI lastIndexI nchildren[childrent4[Ljavax/swing/text/AbstractDocument$AbstractElement;Lthis$0t#Ljavax/swing/text/AbstractDocument;xr1javax.swing.text.AbstractDocument$AbstractElementϲxï¼7ÍÙLparenttLjavax/swing/text/Element;Lthis$0q~xppq~îwxur4[Ljavax.swing.text.AbstractDocument$AbstractElement;êt9w:Ñxpsr-javax.swing.text.AbstractDocument$LeafElementjñÓôŠc‘ÉLthis$0q~xq~q~q~îwxq~îwxpq~îsq~uq~ ppppppppppxpppxtNxppsrInfoPurple.Plet à¶³§cÚäL pletLocationq~LpletSizeq~LppValuesq~LqueryStrq~ xpsrjava.awt.Point¶ÄŠr4~È&IxIyxp(srjava.awt.DimensionAŽÙ׬_DIheightIwidthxp2—sq~uq~(t EUL OwnersrdbUtil.dbInstance à¶³§cØðLdbDriverq~ L dbPasswordq~ LdbURLq~ LdbUserq~ xpt* Oracle - oracle.jdbc.driver.OracleDrivertapps_devtlink-obyone:1525:DEVtappstALLtownert'ID1't'ID2't'ID3't'ID4't'ID5'srInfoPurple.PletValue à¶³§cÛHL descriptionq~ L displayValueq~ Lid1q~ Lid2q~ Lid3q~ Lid4q~ Lid5q~ L internalValueq~ xpptXXLS_APPS_EUL_UStID1tID2tID3tID4tID5psq~ÿf™ÿpppsq~ÿ3™pppsq~A@ ptArialxtappstNONEtPLETtp31tNq~CtAuthor,Description etctYt1tNsq~28pq~Ssq~Tpq~Hpxsq~Wt Text Cursorpuq~Zsq~\sq~`w ?@q~dxsq~\sq~`w ?@q~gxppq~iq~ksq~lÿÿÿÿq~nq~oq~pppppppq~qsq~rq~qsq~rq~qsq~rq~qsq~rq~{q~Rq~{q~Sq~{q~Tq~{q~Upsq~|ppxuq~~pppppxA(psq~€pwxppsq~‚sq~„q~†wxwxpsq~åpxpppwxpppppppppppsq~çsq~ïsq~òsq~åpxq~]wtdefaultsq~òsq~åpxq~]wq~ùq~`xxxsq~ú uq~ý psq~ÿ?@wq~sq~ti18nsq~ttabSizesq~ xsq~åpxsq~uq~ ppppppppppxsq~pq~\wxuq~sq~q~nq~\wxq~\wxpq~\sq~uq~ ppppppppppxpppxppppppppppppppppxt-FROM all_tables WHERE table_name = 'EUL5_BAS'sq~sq~¶(sq~!2sq~uq~(t Period Rangeq~'tALLtvaluet'ID1't'ID2't'ID3't'ID4't'ID5'sq~3pt30tID1tID2tID3tID4tID5psq~ÿøú¬pppsq~ÿpppsq~A@ ptArialxtappstNONEtPLETtp32tNtYtAuthor,Description etctYt1tYsq~28pq~Ssq~Tpq~–pxsq~Wt Text Cursorpuq~Zsq~\sq~`w ?@q~dxsq~\sq~`w ?@q~gxppq~iq~ksq~lÿÿÿÿq~nq~oq~pppppppq~qsq~rq~qsq~rïïq~qsq~rq~qsq~rq~{q~ q~{q~¡q~{q~¢q~{q~£psq~|ppxuq~~pppppxA(psq~€pwxppsq~‚sq~„q~†wxwxpsq~åpxpppwxpppppppppppsq~çsq~ïsq~òsq~åpxq~«wtdefaultsq~òsq~åpxq~«wq~ùq~®xxxsq~úïßuq~ýàimport InfoPurple.Global; import InfoPurple.PortletInterface; try { PortletInterface p = Global.getPortletObject("g32"); if (p!=null) { p.refreshPortlet(true); } p = Global.getPortletObject("g37"); if (p!=null) { p.refreshPortlet(true); } p = Global.getPortletObject("g34"); if (p!=null) { p.refreshPortlet(true); } p = Global.getPortletObject("g35"); if (p!=null) { p.refreshPortlet(true); } p = Global.getPortletObject("q42"); if (p!=null) { p.refreshPortlet(true); } } catch (Exception ex) { } psq~ÿ?@wq~sq~ti18nsq~ttabSizesq~ xsq~åpxsq~*uq~Psq~sq~pq~ªwx)*uq~Pq~¼sq~q~½q~ªwxq~ªw>xsq~q~½q~ªwxq~ªw>?xsq~q~½q~ªwxq~ªw?Cxsq~q~½q~ªwxq~ªwCExsq~q~½q~ªwxq~ªwEFxsq~q~½q~ªwxq~ªwFGxsq~q~½q~ªwxq~ªwGHxsq~q~½q~ªwxq~ªwH‡xsq~q~½q~ªwxq~ªw‡xsq~q~½q~ªwxq~ªw¨xsq~q~½q~ªwxq~ªw¨Ìxsq~q~½q~ªwxq~ªwÌ×xsq~q~½q~ªwxq~ªwרxsq~q~½q~ªwxq~ªwØxsq~q~½q~ªwxq~ªwxsq~q~½q~ªwxq~ªw(xsq~q~½q~ªwxq~ªw(Lxsq~q~½q~ªwxq~ªwLWxsq~q~½q~ªwxq~ªwW†xsq~q~½q~ªwxq~ªw†œxsq~q~½q~ªwxq~ªwœ§xsq~q~½q~ªwxq~ªw§Ëxsq~q~½q~ªwxq~ªwËÖxsq~q~½q~ªwxq~ªwÖxsq~q~½q~ªwxq~ªwxsq~q~½q~ªwxq~ªw$xsq~q~½q~ªwxq~ªw$Hxsq~q~½q~ªwxq~ªwHSxsq~q~½q~ªwxq~ªwSTxsq~q~½q~ªwxq~ªwT‚xsq~q~½q~ªwxq~ªw‚˜xsq~q~½q~ªwxq~ªw˜£xsq~q~½q~ªwxq~ªw£Çxsq~q~½q~ªwxq~ªwÇÒxsq~q~½q~ªwxq~ªwÒÓxsq~q~½q~ªwxq~ªwÓÔxsq~q~½q~ªwxq~ªwÔÕxsq~q~½q~ªwxq~ªwÕ×xsq~q~½q~ªwxq~ªw×ìxsq~q~½q~ªwxq~ªwìîxsq~q~½q~ªwxq~ªwîðxppppppppppppppppppppppppppppppppppppppq~ªq~ªwxq~ªwxq~¿q~Àq~Áq~Âq~Ãq~Äq~Åq~Æq~Çq~Èq~Éq~Êq~Ëq~Ìq~Íq~Îq~Ïq~Ðq~Ñq~Òq~Óq~Ôq~Õq~Öq~×q~Øq~Ùq~Úq~Ûq~Üq~Ýq~Þq~ßq~àq~áq~âq~ãq~äq~åq~æq~çppppppppppppppppppppppppppppppppppppppxq~½sq~uq~(sq~q~½q~ªwxq~ªwðxpppppppppppppppppppppppppppppppppppppppxpppxppppppppppppppppxtØfrom ( select 7 value from dual union all select 15 from dual union all select 30 from dual union all select 45 from dual union all select 60 from dual union all select 180 from dual union all select 360 from dual )sq~sq~Ýsq~!2dsq~uq~(tSort byq~'tALLt column_namet'ID1't'ID2't'ID3't'ID4't'ID5'sq~3pt rows_fetchedtID1tID2tID3tID4tID5psq~ÿÌÿÿpppsq~ÿ™pppsq~A@ ptArialxtappstNONEtPLETtp33tNtNtAuthor,Description etctYt1tYsq~28pq~Ssq~Tpq~pxsq~Wt Text Cursorpuq~Zsq~\sq~`w ?@q~dxsq~\sq~`w ?@q~gxppq~iq~ksq~lÿÿÿÿq~nq~oq~pppppppq~qsq~rq~qsq~rq~qsq~rññq~qsq~rq~{q~q~{q~q~{q~q~{q~psq~|ppxuq~~pppppxA(psq~€pwxppsq~‚sq~„q~†wxwxpsq~åpxpppwxpppppppppppsq~çsq~ïsq~òsq~åpxq~#wtdefaultsq~òsq~åpxq~#wq~ùq~&xxxsq~úñßuq~ýàimport InfoPurple.Global; import InfoPurple.PortletInterface; try { PortletInterface p = Global.getPortletObject("q50"); if (p!=null) { p.refreshPortlet(true); } } catch (Exception ex) { }rtletObject("g39"); if (p!=null) { p.refreshPortlet(true); } p = Global.getPortletObject("g71"); if (p!=null) { p.refreshPortlet(true); } p = Global.getPortletObject("q87"); if (p!=null) { p.refreshPortlet(true); } p = Global.getPortletObject("g123"); if (p!=null) { p.refreshPortlet(true); } } catch (Exception ex) { } psq~ÿ?@wq~sq~ti18nsq~ttabSizesq~ xsq~åpxsq~uq~(sq~sq~pq~"wxuq~(q~4sq~q~5q~"wxq~"w>xsq~q~5q~"wxq~"w>?xsq~q~5q~"wxq~"w?Cxsq~q~5q~"wxq~"wCExsq~q~5q~"wxq~"wEFxsq~q~5q~"wxq~"wF…xsq~q~5q~"wxq~"w…›xsq~q~5q~"wxq~"w›¦xsq~q~5q~"wxq~"w¦Êxsq~q~5q~"wxq~"wÊÕxsq~q~5q~"wxq~"wÕÖxsq~q~5q~"wxq~"wÖ×xsq~q~5q~"wxq~"w×Ùxsq~q~5q~"wxq~"wÙîxsq~q~5q~"wxq~"wîðxsq~q~5q~"wxq~"wðòxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wxsq~q~5q~"wxq~"wòxq~"q~"wxq~"wxq~7q~8q~9q~:q~;q~q~?q~@q~Aq~Bq~Cq~Dq~Eq~Fpppppppppppppppppppppppxq~5sq~uq~(sq~q~5q~"wxq~"wòxpppppppppppppppppppppppppppppppppppppppxpppxppppppppppppppppxt‚from ( select 'cost' column_name from dual union all select 'elapsed_time' from dual union all select 'rows_fetched' from dual )srInfoPurple.Glet à¶³§cÜL GletLocationq~LGletSizeq~L colDetailsq~LgpValuesq~LqueryStrq~ xpsq~lsq~!$/psq~uq~(tAverage Runs by Dayq~'t100tBartWeek DaytRunstManualt1440sq~ÿÛÑÆpppsq~A@ ptArialxsq~ÿppptYtg32q~stappst No_PatterntGlett q~sq~stVerticalt30q~ssq~Apq~qxt##.#q~stAUTOtAUTOtYsq~28pq~Ssq~Tpq~€pxsq~Wt Text Cursorpuq~Zsq~\sq~`w ?@q~dxsq~\sq~`w ?@q~gxppq~iq~ksq~lÿÿÿÿq~nq~oq~pppppppq~qsq~rq~qsq~rq~qsq~r ö öq~qsq~rq~qsq~rq~qsq~rq~qsq~rq~{q~Šq~{q~‹q~{q~Œq~{q~q~{q~Žq~{q~q~{q~psq~|ppxuq~~pppppxA(psq~€pwxppsq~‚sq~„q~†wxwxpsq~åpxpppwxpppppppppppsq~çsq~ïsq~òsq~åpxq~˜wtdefaultsq~òsq~åpxq~˜wq~ùq~›xxxsq~ú ö5uq~ý6//import the necessary classes import org.jfree.*; import org.jfree.chart.axis.CategoryAxis; //import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.axis.NumberAxis; //import org.jfree.chart.labels.CategoryItemLabelGenerator; //import org.jfree.chart.labels.StandardCategoryItemLabelGenerator; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.plot.PiePlot3D; import org.jfree.chart.plot.PlotOrientation; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.BarRenderer3D; //import org.jfree.chart.renderer.category.CategoryItemRenderer; //import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.ui.GradientPaintTransformType; import org.jfree.ui.StandardGradientPaintTransformer; BarRenderer barRenderer = (BarRenderer)plot.getRenderer(); barRenderer.setDrawBarOutline(false); barRenderer.setOutlinePaint(Color.blue); barRenderer.setOutlineStroke(new BasicStroke(1.1f, BasicStroke.JOIN_ROUND, BasicStroke.JOIN_BEVEL)); GradientPaint gp0 = new GradientPaint( 0.0f, 0.0f, Color.blue, 0.0f, 0.0f,Color.cyan ); GradientPaint gp1 = new GradientPaint( 0.0f, 0.0f, Color.green, 0.0f, 0.0f, Color.lightGray ); GradientPaint gp2 = new GradientPaint( 0.0f, 0.0f, Color.red, 0.0f, 0.0f, Color.lightGray ); barRenderer.setSeriesPaint(0, gp0); barRenderer.setSeriesPaint(1, gp1); barRenderer.setSeriesPaint(2, gp2); barRenderer.setGradientPaintTransformer( new StandardGradientPaintTransformer( GradientPaintTransformType.HORIZONTAL)); float h = displayFrame.getHeight(); float w = displayFrame.getWidth(); // GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.WHITE, h, w, Color.green.darker()); //plot.setBackgroundPaint(gradientPaint); chart.setBackgroundPaint(new GradientPaint(0,0,Color.blue,0,h, new Color(102,0,102))); CategoryAxis domainAxis = plot.getDomainAxis(); domainAxis.setTickLabelPaint(Color.white); domainAxis.setTickLabelFont(new Font("Arial",Font.BOLD,12)); domainAxis.setLabelPaint(Color.white); NumberAxis rangeAxis = (NumberAxis) plot.getRangeAxis(); rangeAxis.setTickLabelPaint(Color.WHITE); rangeAxis.setTickLabelFont(new Font("Arial",Font.BOLD,12)); rangeAxis.setLabelPaint(Color.white); chart.getTitle().setPaint(Color.white); //chart.getTitle().setText("Top 5 Tables by Row Count"); float h = displayFrame.getHeight(); float w = displayFrame.getWidth(); // GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.WHITE, h, w, Color.green.darker()); //plot.setBackgroundPaint(gradientPaint); chart.setBackgroundPaint(new GradientPaint(0,0,Color.blue,0,h, new Color(102,0,102))); psq~ÿ?@wq~sq~ttabSizesq~ ti18nsq~xsq~åpxsq~;uq~Psq~sq~pq~—wx:;uq~hq~©sq~q~ªq~—wxq~—w3xsq~q~ªq~—wxq~—w3]xsq~q~ªq~—wxq~—w]“xsq~q~ªq~—wxq~—w“»xsq~q~ªq~—wxq~—w»÷xsq~q~ªq~—wxq~—w÷;xsq~q~ªq~—wxq~—w;exsq~q~ªq~—wxq~—weŒxsq~q~ªq~—wxq~—wŒ¹xsq~q~ªq~—wxq~—w¹ïxsq~q~ªq~—wxq~—wï'xsq~q~ªq~—wxq~—w'hxsq~q~ªq~—wxq~—wh©xsq~q~ªq~—wxq~—w©Ùxsq~q~ªq~—wxq~—wÙxsq~q~ªq~—wxq~—wxsq~q~ªq~—wxq~—wQxsq~q~ªq~—wxq~—wQzxsq~q~ªq~—wxq~—wz{xsq~q~ªq~—wxq~—w{ªxsq~q~ªq~—wxq~—wªxsq~q~ªq~—wxq~—wxsq~q~ªq~—wxq~—wxsq~q~ªq~—wxq~—wñxsq~q~ªq~—wxq~—wñ_xsq~q~ªq~—wxq~—w_ˆxsq~q~ªq~—wxq~—wˆ±xsq~q~ªq~—wxq~—w±Õxsq~q~ªq~—wxq~—wÕÖxsq~q~ªq~—wxq~—wÖ×xsq~q~ªq~—wxq~—w×Rxsq~q~ªq~—wxq~—wRSxsq~q~ªq~—wxq~—wS{xsq~q~ªq~—wxq~—w{¢xsq~q~ªq~—wxq~—w¢xsq~q~ªq~—wxq~—wKxsq~q~ªq~—wxq~—wKLxsq~q~ªq~—wxq~—wL°xsq~q~ªq~—wxq~—w°±xsq~q~ªq~—wxq~—w±âxsq~q~ªq~—wxq~—wâ xsq~q~ªq~—wxq~—w Jxsq~q~ªq~—wxq~—wJqxsq~q~ªq~—wxq~—wqrxsq~q~ªq~—wxq~—wr«xsq~q~ªq~—wxq~—w«Õxsq~q~ªq~—wxq~—wÕ xsq~q~ªq~—wxq~—w  7xsq~q~ªq~—wxq~—w 7 8xsq~q~ªq~—wxq~—w 8 `xsq~q~ªq~—wxq~—w ` ™xsq~q~ªq~—wxq~—w ™ šxsq~q~ªq~—wxq~—w š Âxsq~q~ªq~—wxq~—w  éxsq~q~ªq~—wxq~—w é ]xsq~q~ªq~—wxq~—w ] ’xsq~q~ªq~—wxq~—w ’ “xsq~q~ªq~—wxq~—w “ ÷xpppppppppppppppppppppppppppppppppppppppppppppq~—q~—wxq~—wxq~¬q~­q~®q~¯q~°q~±q~²q~³q~´q~µq~¶q~·q~¸q~¹q~ºq~»q~¼q~½q~¾q~¿q~Àq~Áq~Âq~Ãq~Äq~Åq~Æq~Çq~Èq~Éq~Êq~Ëq~Ìq~Íq~Îq~Ïq~Ðq~Ñq~Òq~Óq~Ôq~Õq~Öq~×q~Øq~Ùq~Úq~Ûq~Üq~Ýq~Þq~ßq~àq~áq~âq~ãq~äq~åpppppppppppppppppppppxq~ªsq~uq~Psq~q~ªq~—wxq~—w ÷xpppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppxpppxt1pppppppppxtbselect week_day||'-'||run_day Day, 'Average Runs',trunc(sum(runs)/count(run_day)) average_runs from ( select run_month,week_day,run_day,month_day,run_year,count(*) runs from ( select qs_cost cost , qs_act_cpu_time cpu_time , qs_act_elap_time elapsed_time , qs_num_rows rows_fetched , qs_doc_owner doc_owner , qs_doc_name workbook , qs_doc_details worksheet , qs_created_date run_date , to_char(qs_created_date,'D') week_day , to_char(qs_created_date,'DD') month_day , to_char(qs_created_date,'Day') run_day , to_char(qs_created_date,'Mon') run_month , to_char(qs_created_date,'HH24') run_hour , to_char(qs_created_date,'YYYY') run_year from G_PARAM.eul5_qpp_stats where qs_created_date between sysdate - G_PARAM and sysdate ) stats group by run_month,week_day,run_day,month_day,run_year ) group by run_day,week_day order by week_daysq~sq~uq~ srInfoPurple.ColumnPropertyValues à¶³§cÙ¸L colPropValuesq~L drillValuesq~L parentQlettLInfoPurple/Qlet;xpsq~uq~tCategoryt130sq~ÿðììpppsq~ÿ@@@pppsq~ÿÿÿÿpppt1q~ösq~A ptArialxtNAtNt ##########t dd-MMM-yyyytYsq~A pq~úxtCategorytDEFAULTtYpppxsq~uq~ ppppppppppxq~ësq~îsq~uq~tCNTt54q~õq~öq~÷t1q~ösq~A@ ptArialxtNAtNt ##########t dd-MMM-yyyyq~ sq~A@ pq~ xtCnttDEFAULTtYpppxsq~uq~ ppppppppppxq~ëppppppppxsq~·˜sq~!ö¾sq~(uq~(tSummaryq~'t100tManualt300t 1-JAN-1990tYsq~ÿÌÌÌpppq~õq~÷t1q~ q~öt20q~!sq~ÿÀÀÀpppsq~A@ pq~ xq~öt dd-MMM-yyyyt #########tq42q~öq~q~!tappst No_PatterntQLETsq~ÿÿÿÿpppsq~ÿppptXXDBNAMEq~xtAuthor,Description etcq~!q~#tDEFAULTq~!q~!tNsq~28pq~Ssq~Tpq~3pxsq~Wt Text Cursorpuq~Zsq~\sq~`w ?@q~dxsq~\sq~`w ?@q~gxppq~iq~ksq~lÿÿÿÿq~nq~oq~pppppppq~qsq~rq~qsq~rq~qsq~rq~qsq~rq~qsq~rq~qsq~rq~{q~=q~{q~>q~{q~?q~{q~@q~{q~Aq~{q~Bpsq~|ppxuq~~pppppxA(psq~€pwxppsq~‚sq~„q~†wxwxpsq~åpxpppwxpppppppppppsq~çsq~ïsq~òsq~åpxq~Jwtdefaultsq~òsq~åpxq~Jwq~ùq~Mxxxsq~ú uq~ý psq~ÿ?@wq~sq~ti18nsq~ttabSizesq~ xsq~åpxsq~uq~ ppppppppppxsq~pq~Iwxuq~sq~q~[q~Iwxq~Iwxpq~Isq~uq~ ppppppppppxpppxtNxtOselect 'New Workbooks' "Category", count(*) cnt from G_PARAM.EUL5_DOCUMENTS where doc_created_date between sysdate- G_PARAM and sysdate union all select 'Updated Workbooks' catg, count(*) from G_PARAM.EUL5_DOCUMENTS where doc_updated_date between sysdate-G_PARAM and sysdate union all select 'Un-Used Workbooks', count(*) from G_PARAM.EUL5_DOCUMENTS doc where doc.doc_name not in ( select distinct qs_doc_name from G_PARAM.eul5_qpp_stats stats where qs_created_date between sysdate-G_PARAM and sysdate ) union all select 'Business Areas' "Objects", count(*) Total from G_PARAM.EUL5_bas union all select 'Folders', count(*) from G_PARAM.EUL5_objs union all select 'Items' , count(*) from G_PARAM.EUL5_expressionstNsq~bsq~šsq~!ûŠpsq~uq~(tAverage Runs by Hourq~'t100tBartHours (0 - 23)tRunstManualt1440sq~ÿÛÑÆpppsq~A@ ptArialxsq~ÿppptYtg35q~stappst No_PatterntGletq~xq~sq~stVerticalt0q~ssq~Apq~qxt##.#q~stAUTOq~|q~ÿsq~28pq~Ssq~Tpq~}pxsq~Wt Text Cursorpuq~Zsq~\sq~`w ?@q~dxsq~\sq~`w ?@q~gxppq~iq~ksq~lÿÿÿÿq~nq~oq~pppppppq~qsq~rq~qsq~rq~qsq~r ™ ™q~qsq~r œ œq~qsq~rq~qsq~rq~qsq~rq~{q~‡q~{q~ˆq~{q~‰q~{q~Šq~{q~‹q~{q~Œq~{q~psq~|ppxuq~~pppppxA(psq~€pwxppsq~‚sq~„q~†wxwxpsq~åpxpppwxpppppppppppsq~çsq~ïsq~òsq~åpxq~•wtdefaultsq~òsq~åpxq~•wq~ùq~˜xxxsq~ú œ5uq~ý6//import the necessary classes import org.jfree.*; import org.jfree.chart.axis.CategoryAxis; //import org.jfree.chart.axis.CategoryLabelPositions; import org.jfree.chart.axis.NumberAxis; //import org.jfree.chart.labels.CategoryItemLabelGenerator; //import org.jfree.chart.labels.StandardCategoryItemLabelGenerator; import org.jfree.chart.plot.CategoryPlot; import org.jfree.chart.plot.PiePlot3D; import org.jfree.chart.plot.PlotOrientation; import org.jfree.chart.renderer.category.BarRenderer; import org.jfree.chart.renderer.category.BarRenderer3D; //import org.jfree.chart.renderer.category.CategoryItemRenderer; //import org.jfree.chart.renderer.category.LineAndShapeRenderer; import org.jfree.ui.GradientPaintTransformType; import org.jfree.ui.StandardGradientPaintTransformer; BarRenderer barRenderer = (BarRenderer)plot.getRenderer(); barRenderer.setDrawBarOutline(false); barRenderer.setOutlinePaint(Color.blue); barRenderer.setOutlineStroke(new BasicStroke(1.1f, BasicStroke.JOIN_ROUND, BasicStroke.JOIN_BEVEL)); GradientPaint gp0 = new GradientPaint( 0.0f, 0.0f, Color.yellow, 0.0f, 0.0f,Color.orange ); GradientPaint gp1 = new GradientPaint( 0.0f, 0.0f, Color.green, 0.0f, 0.0f, Color.lightGray ); GradientPaint gp2 = new GradientPaint( 0.0f, 0.0f, Color.red, 0.0f, 0.0f, Color.lightGray ); barRenderer.setSeriesPaint(0, gp0); barRenderer.setSeriesPaint(1, gp1); barRenderer.setSeriesPaint(2, gp2); barRenderer.setGradientPaintTransformer( new StandardGradientPaintTransformer( GradientPaintTransformType.HORIZONTAL)); float h = displayFrame.getHeight(); float w = displayFrame.getWidth(); // GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.WHITE, h, w, Color.green.darker()); //plot.setBackgroundPaint(gradientPaint); chart.setBackgroundPaint(new GradientPaint(0,0,Color.blue,w,h, new Color(102,0,102))); CategoryAxis domainAxis = plot.getDomainAxis(); domainAxis.setTickLabelPaint(Color.white); domainAxis.setTickLabelFont(new Font("Arial",Font.BOLD,12)); domainAxis.setLabelPaint(Color.white); NumberAxis rangeAxis = (NumberAxis) plot.getRangeAxis(); rangeAxis.setTickLabelPaint(Color.WHITE); rangeAxis.setTickLabelFont(new Font("Arial",Font.BOLD,12)); rangeAxis.setLabelPaint(Color.white); chart.getTitle().setPaint(Color.white); //chart.getTitle().setText("Top 5 Tables by Row Count"); psq~ÿ?@wq~sq~ttabSizesq~ ti18nsq~xsq~åpxsq~4uq~Psq~sq~pq~”wx34uq~hq~¦sq~q~§q~”wxq~”w3xsq~q~§q~”wxq~”w3]xsq~q~§q~”wxq~”w]“xsq~q~§q~”wxq~”w“»xsq~q~§q~”wxq~”w»÷xsq~q~§q~”wxq~”w÷;xsq~q~§q~”wxq~”w;exsq~q~§q~”wxq~”weŒxsq~q~§q~”wxq~”wŒ¹xsq~q~§q~”wxq~”w¹ïxsq~q~§q~”wxq~”wï'xsq~q~§q~”wxq~”w'hxsq~q~§q~”wxq~”wh©xsq~q~§q~”wxq~”w©Ùxsq~q~§q~”wxq~”wÙxsq~q~§q~”wxq~”wxsq~q~§q~”wxq~”wQxsq~q~§q~”wxq~”wQzxsq~q~§q~”wxq~”wz{xsq~q~§q~”wxq~”w{ªxsq~q~§q~”wxq~”wªxsq~q~§q~”wxq~”wxsq~q~§q~”wxq~”w…xsq~q~§q~”wxq~”w…õxsq~q~§q~”wxq~”wõcxsq~q~§q~”wxq~”wcŒxsq~q~§q~”wxq~”wŒµxsq~q~§q~”wxq~”wµÙxsq~q~§q~”wxq~”wÙÚxsq~q~§q~”wxq~”wÚÛxsq~q~§q~”wxq~”wÛVxsq~q~§q~”wxq~”wVWxsq~q~§q~”wxq~”wWxsq~q~§q~”wxq~”w¦xsq~q~§q~”wxq~”w¦xsq~q~§q~”wxq~”wOxsq~q~§q~”wxq~”wOPxsq~q~§q~”wxq~”wP´xsq~q~§q~”wxq~”w´µxsq~q~§q~”wxq~”wµæxsq~q~§q~”wxq~”wæxsq~q~§q~”wxq~”wNxsq~q~§q~”wxq~”wNuxsq~q~§q~”wxq~”wuvxsq~q~§q~”wxq~”wv¯xsq~q~§q~”wxq~”w¯Ùxsq~q~§q~”wxq~”wÙ xsq~q~§q~”wxq~”w  ;xsq~q~§q~”wxq~”w ; .eul5_qpp_stats where qs_created_date between sysdate - G_PARAM and sysdate ) stats group by run_month,month_day,run_hour ) group by run_hour sq~bsq~Jhsq~!&,psq~uq~(t Runs Todayq~'t100tDialtXtYtManualt1440sq~ÿÛÑÆpppsq~A@ ptArialxsq~ÿpppq~êtg34q~êtappst No_PatterntGletq~xq~êq~êtVerticalt0q~êsq~Apq~ïxt##.#q~êtAUTOq~ùq~sq~28pq~Ssq~Tpq~úpxsq~Wt Text Cursorpuq~Zsq~\sq~`w ?@q~dxsq~\sq~`w ?@q~gxppq~iq~ksq~lÿÿÿÿq~nq~oq~pppppppq~qsq~rq~qsq~rq~qsq~r „ „q~qsq~r q~qsq~rq~qsq~rq~qsq~rq~{q~q~{q~q~{q~q~{q~q~{q~q~{q~ q~{q~ psq~|ppxuq~~pppppxA(psq~€pwxppsq~‚sq~„q~†wxwxpsq~åpxpppwxpppppppppppsq~çsq~ïsq~òsq~åpxq~wtdefaultsq~òsq~åpxq~wq~ùq~xxxsq~ú [uq~ý\import org.jfree.chart.JFreeChart; import org.jfree.experimental.chart.plot.dial.DialPlot; import org.jfree.experimental.chart.plot.dial.SimpleDialFrame; import org.jfree.experimental.chart.plot.dial.DialTextAnnotation; import org.jfree.experimental.chart.plot.dial.StandardDialRange; import org.jfree.experimental.chart.plot.dial.StandardDialScale; import org.jfree.experimental.chart.plot.dial.DialBackground; import org.jfree.experimental.chart.plot.dial.DialCap; import org.jfree.experimental.chart.plot.dial.DialPointer; import org.jfree.experimental.chart.plot.dial.DialValueIndicator; import org.jfree.data.general.DefaultValueDataset; import org.jfree.ui.GradientPaintTransformType; import org.jfree.ui.StandardGradientPaintTransformer; DialPlot plot = (DialPlot)(chart.getPlot()); SimpleDialFrame dialFrame = new SimpleDialFrame(); dialFrame.setBackgroundPaint(Color.lightGray); dialFrame.setForegroundPaint(Color.darkGray); plot.setDialFrame(dialFrame); GradientPaint gp = new GradientPaint(new Point(), new Color(255, 255, 255), new Point(), new Color(0,90, 0)); DialBackground db = new DialBackground(gp); db.setGradientPaintTransformer(new StandardGradientPaintTransformer(GradientPaintTransformType.VERTICAL)); plot.setBackground(db); DialTextAnnotation annotation1 = new DialTextAnnotation("Runs"); annotation1.setFont(new Font("Dialog", Font.BOLD, 14)); annotation1.setRadius(0.7); plot.addLayer(annotation1); DialValueIndicator dvi = new DialValueIndicator(0, " "); plot.addLayer(dvi); StandardDialScale scale = new StandardDialScale(0, 120, -120, -300); scale.setTickRadius(0.88); scale.setTickLabelOffset(0.15); scale.setTickLabelFont(new Font("Dialog", Font.PLAIN, 14)); plot.addScale(0, scale); StandardDialRange range = new StandardDialRange(0.0, 50.0, Color.green); range.setInnerRadius(0.52); range.setOuterRadius(0.58); plot.addLayer(range); StandardDialRange range2 = new StandardDialRange(50.0, 80.0, Color.blue); range2.setInnerRadius(0.52); range2.setOuterRadius(0.58); plot.addLayer(range2); StandardDialRange range3 = new StandardDialRange(80.0, 120.0, Color.red); range3.setInnerRadius(0.52); range3.setOuterRadius(0.58); plot.addLayer(range3); DialPointer needle = new DialPointer.Pointer(); plot.addLayer(needle); DialCap cap = new DialCap(); cap.setRadius(0.1); plot.setCap(cap); float h = displayFrame.getHeight(); float w = displayFrame.getWidth(); // GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.WHITE, h, w, Color.green.darker()); //plot.setBackgroundPaint(gradientPaint); chart.setBackgroundPaint(new GradientPaint(0,0,Color.blue,0,h, Color.cyan)); ; 0,102))); psq~ÿ?@wq~sq~ttabSizesq~ ti18nsq~xsq~åpxsq~:uq~Psq~sq~pq~wx9:uq~fq~#sq~q~$q~wxq~w#[xsq~q~$q~wxq~w[šxsq~q~$q~wxq~wšÜxsq~q~$q~wxq~wÜxsq~q~$q~wxq~w^xsq~q~$q~wxq~w^œxsq~q~$q~wxq~wœÓxsq~q~$q~wxq~wÓxsq~q~$q~wxq~wPxsq~q~$q~wxq~wPƒxsq~q~$q~wxq~wƒ³xsq~q~$q~wxq~w³éxsq~q~$q~wxq~wéêxsq~q~$q~wxq~wêxsq~q~$q~wxq~wRxsq~q~$q~wxq~wRƒxsq~q~$q~wxq~wƒ¹xsq~q~$q~wxq~w¹ßxsq~q~$q~wxq~wßUxsq~q~$q~wxq~wU‰xsq~q~$q~wxq~w‰üxsq~q~$q~wxq~wüxsq~q~$q~wxq~wexsq~q~$q~wxq~we¥xsq~q~$q~wxq~w¥Éxsq~q~$q~wxq~wÉíxsq~q~$q~wxq~wí.xsq~q~$q~wxq~w.Jxsq~q~$q~wxq~wJŸxsq~q~$q~wxq~wŸÂxsq~q~$q~wxq~wÂêxsq~q~$q~wxq~wê.xsq~q~$q~wxq~w.Oxsq~q~$q~wxq~wO xsq~q~$q~wxq~w Äxsq~q~$q~wxq~wÄèxsq~q~$q~wxq~wèxsq~q~$q~wxq~wXxsq~q~$q~wxq~wX}xsq~q~$q~wxq~w}¢xsq~q~$q~wxq~w¢Áxsq~q~$q~wxq~wÁ xsq~q~$q~wxq~w  8xsq~q~$q~wxq~w 8 ]xsq~q~$q~wxq~w ] |xsq~q~$q~wxq~w | ´xsq~q~$q~wxq~w ´ Óxsq~q~$q~wxq~w Ó øxsq~q~$q~wxq~w ø xsq~q~$q~wxq~w  .xsq~q~$q~wxq~w . /xsq~q~$q~wxq~w / Wxsq~q~$q~wxq~w W ~xsq~q~$q~wxq~w ~ òxsq~q~$q~wxq~w ò 'xsq~q~$q~wxq~w ' (xsq~q~$q~wxq~w ( ‚xppppppppppppppppppppppppppppppppppppppppppppq~q~wxq~w#xq~&q~'q~(q~)q~*q~+q~,q~-q~.q~/q~0q~1q~2q~3q~4q~5q~6q~7q~8q~9q~:q~;q~q~?q~@q~Aq~Bq~Cq~Dq~Eq~Fq~Gq~Hq~Iq~Jq~Kq~Lq~Mq~Nq~Oq~Pq~Qq~Rq~Sq~Tq~Uq~Vq~Wq~Xq~Yq~Zq~[q~\q~]q~^ppppppppppppppppppppppxq~$sq~uq~Psq~q~$q~wxq~w ‚xpppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppppxpppxt1pppppppppxtIselect count(*) runs from ( select qs_cost cost , qs_act_cpu_time cpu_time , qs_act_elap_time elapsed_time , qs_num_rows rows_fetched , qs_doc_owner doc_owner , qs_doc_name workbook , qs_doc_details worksheet , qs_created_date run_date , to_char(qs_created_date,'D') week_day , to_char(qs_created_date,'DD') month_day , to_char(qs_created_date,'Day') run_day , to_char(qs_created_date,'Mon') run_month , to_char(qs_created_date,'HH24') run_hour , to_char(qs_created_date,'YYYY') run_year from G_PARAM.eul5_qpp_stats where trunc(qs_created_date) = trunc(sysdate) ) statssq~bsq~Hjsq~!%þpsq~uq~(t Max Run Timeq~'t100tMetertXtYtManualt1440sq~ÿÛÑÆpppsq~A@ ptArialxsq~ÿpppq~mtg37q~mtappst No_PatterntGletq~xq~mq~mtVerticalt0q~msq~Apq~rxt##.#q~mtAUTOq~|q~ÿsq~28pq~Ssq~Tpq~}pxsq~Wt Text Cursorpuq~Zsq~\sq~`w ?@q~dxsq~\sq~`w ?@q~gxppq~iq~ksq~lÿÿÿÿq~nq~oq~pppppppq~qsq~rq~qsq~rq~qsq~r··q~qsq~rq~qsq~rq~qsq~rq~{q~‡q~{q~ˆq~{q~‰q~{q~Šq~{q~‹q~{q~Œpsq~|ppxuq~~pppppxA(psq~€pwxppsq~‚sq~„q~†wxwxpsq~åpxpppwxpppppppppppsq~çsq~ïsq~òsq~åpxq~”wtdefaultsq~òsq~åpxq~”wq~ùq~—xxxsq~ú· Suq~ý Timport org.jfree.chart.JFreeChart; import org.jfree.chart.plot.DialShape; import org.jfree.chart.plot.MeterInterval; import org.jfree.chart.plot.MeterPlot; import org.jfree.data.Range; MeterPlot plot = (MeterPlot)(chart.getPlot()); plot.setUnits("Mins"); plot.setRange(new Range(0, 60)); plot.addInterval(new MeterInterval("Normal", new Range(0.0, 5.0), Color.lightGray, new BasicStroke(2.0f), new Color(0, 255, 0, 64))); plot.addInterval(new MeterInterval("Warning", new Range(5.0, 10.0), Color.lightGray, new BasicStroke(2.0f), new Color(255, 255, 0,64))); plot.addInterval(new MeterInterval("Slow..", new Range(10.0, 60.0), Color.lightGray, new BasicStroke(2.0f), new Color(255, 0, 0, 128))); plot.setNeedlePaint(Color.darkGray); plot.setDialBackgroundPaint(Color.white); plot.setDialOutlinePaint(Color.gray); plot.setDialShape(DialShape.CHORD); plot.setMeterAngle(260); plot.setTickLabelsVisible(true); plot.setTickLabelFont(new Font("Dialog", Font.BOLD, 10)); plot.setTickLabelPaint(Color.darkGray); plot.setTickSize(5.0); plot.setTickPaint(Color.lightGray); plot.setValuePaint(Color.black); float h = displayFrame.getHeight(); float w = displayFrame.getWidth(); // GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.WHITE, h, w, Color.green.darker()); //plot.setBackgroundPaint(gradientPaint); chart.setBackgroundPaint(new GradientPaint(0,0,Color.cyan,0,h, Color.blue)); plot.setValueFont(new Font("Dialog", Font.BOLD, 14));OLD, 14)); psq~ÿ?@wq~sq~ti18nsq~ttabSizesq~ xsq~åpxsq~#uq~(sq~sq~pq~“wx"#uq~Fq~¥sq~q~¦q~“wxq~“w#Jxsq~q~¦q~“wxq~“wJuxsq~q~¦q~“wxq~“wuœxsq~q~¦q~“wxq~“wœ¹xsq~q~¦q~“wxq~“w¹ºxsq~q~¦q~“wxq~“wºêxsq~q~¦q~“wxq~“wêxsq~q~¦q~“wxq~“w1xsq~q~¦q~“wxq~“w1|xsq~q~¦q~“wxq~“w|µxsq~q~¦q~“wxq~“wµáxsq~q~¦q~“wxq~“wá.xsq~q~¦q~“wxq~“w.ƒxsq~q~¦q~“wxq~“wƒÐxsq~q~¦q~“wxq~“wÐ xsq~q~¦q~“wxq~“w 6xsq~q~¦q~“wxq~“w6cxsq~q~¦q~“wxq~“wc•xsq~q~¦q~“wxq~“w•Ãxsq~q~¦q~“wxq~“wÃïxsq~q~¦q~“wxq~“wïxsq~q~¦q~“wxq~“w9xsq~q~¦q~“wxq~“w9{xsq~q~¦q~“wxq~“w{«xsq~q~¦q~“wxq~“w«Êxsq~q~¦q~“wxq~“wÊöxsq~q~¦q~“wxq~“wöÿxsq~q~¦q~“wxq~“wÿ(xsq~q~¦q~“wxq~“w(Pxsq~q~¦q~“wxq~“wPwxsq~q~¦q~“wxq~“wwëxsq~q~¦q~“wxq~“wë xsq~q~¦q~“wxq~“w !xsq~q~¦q~“wxq~“w!¸xpppppppppppppppppppppppppppppppppppq~“q~“wxq~“w#xq~¨q~©q~ªq~«q~¬q~­q~®q~¯q~°q~±q~²q~³q~´q~µq~¶q~·q~¸q~¹q~ºq~»q~¼q~½q~¾q~¿q~Àq~Áq~Âq~Ãq~Äq~Åq~Æq~Çq~Èq~Épppppxq~¦sq~uq~(sq~q~¦q~“wxq~“w¸xpppppppppppppppppppppppppppppppppppppppxpppxt1pppppppppxt”select round(max(elapsed_time)/60) max_run_time from ( select qs_cost cost , qs_act_cpu_time cpu_time , qs_act_elap_time elapsed_time , qs_num_rows rows_fetched , qs_doc_owner doc_owner , qs_doc_name workbook , qs_doc_details worksheet , qs_created_date run_date , to_char(qs_created_date,'D') week_day , to_char(qs_created_date,'DD') month_day , to_char(qs_created_date,'Day') run_day , to_char(qs_created_date,'Mon') run_month , to_char(qs_created_date,'HH24') run_hour , to_char(qs_created_date,'YYYY') run_year from G_PARAM.eul5_qpp_stats where trunc(qs_created_date) between trunc(sysdate - G_PARAM) and trunc(sysdate) ) statssq~sq~uq~ sq~îsq~uq~tWORKBOOKt178sq~ÿðììpppsq~ÿ@@@pppsq~ÿÿÿÿpppt1q~Øsq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~ sq~A pq~ÜxtWorkbooktDEFAULTtYpppxsq~uq~ ppppppppppxq~Ïsq~îsq~uq~t WORKSHEETt43q~×q~Øq~Ùt1q~Øq~ÛtNAtNt ##########t dd-MMM-yyyyq~ q~át WorksheettDEFAULTtYpppxsq~uq~ ppppppppppxq~Ïsq~îsq~uq~tCPU_TIMEt38q~×q~Øq~Ùt1q~Øq~ÛtNAtNt ##########t dd-MMM-yyyyq~ q~átCpu TimetDEFAULTtYpppxsq~uq~ ppppppppppxq~Ïsq~îsq~uq~t ELAPSED_TIMEt51q~×q~Øq~Ùt1q~Øq~ÛtNAtNt ##########t dd-MMM-yyyyq~ q~át Elapsed TimetDEFAULTtYpppxsq~uq~ ppppppppppxq~Ïsq~îsq~uq~t ROWS_FETCHEDt51q~×q~Øq~Ùt1q~Øq~ÛtNAtNt ##########t dd-MMM-yyyyq~ q~át Rows FetchedtDEFAULTtYpppxsq~uq~ ppppppppppxq~Ïpppppxsq~sq~!%Ésq~(uq~(t Top Reportsq~'t100tManualt300t 1-JAN-1990tYsq~ÿÌÌÌpppq~×q~Ùt1q~Ûq~Øt15q~,sq~ÿÀÀÀpppsq~A@ pq~Üxq~Øt dd-MMM-yyyyt #########tq50q~Øq~áq~,tappst No_PatterntQLETsq~ÿÿÿÿpppsq~ÿppptXXDBNAMEq~xtAuthor,Description etcq~,q~.tDEFAULTq~,q~,tNsq~28pq~Ssq~Tpq~>pxsq~Wt Text Cursorpuq~Zsq~\sq~`w ?@q~dxsq~\sq~`w ?@q~gxppq~iq~ksq~lÿÿÿÿq~nq~oq~pppppppq~qsq~rq~qsq~rq~qsq~rq~qsq~rq~qsq~rq~qsq~rq~{q~Hq~{q~Iq~{q~Jq~{q~Kq~{q~Lq~{q~Mpsq~|ppxuq~~pppppxA(psq~€pwxppsq~‚sq~„q~†wxwxpsq~åpxpppwxpppppppppppsq~çsq~ïsq~òsq~åpxq~Uwtdefaultsq~òsq~åpxq~Uwq~ùq~Xxxxsq~ú uq~ý psq~ÿ?@wq~sq~ti18nsq~ttabSizesq~ xsq~åpxsq~uq~ ppppppppppxsq~pq~Twxuq~sq~q~fq~Twxq~Twxpq~Tsq~uq~ ppppppppppxpppxtNxt´select * from ( select qs_doc_name workbook , qs_doc_details worksheet , round(avg(nvl(qs_cost,0))) cost , round(avg(qs_act_cpu_time)) cpu_time , round(avg(qs_act_elap_time)) elapsed_time , round(avg(qs_num_rows)) rows_fetched from G_PARAM.eul5_qpp_stats where trunc(qs_created_date) between trunc(sysdate- G_PARAM ) and sysdate group by qs_doc_name,qs_doc_details ) order by G_PARAM descq~bppppppppppppppppppppppppppppppx