srjava.util.Vectorٗ}[;IcapacityIncrementI elementCount[ elementDatat[Ljava/lang/Object;xp*ur[Ljava.lang.Object;Xs)lxpPsrInfoPurple.Qlet ඳcTL colDetailstLjava/util/Vector;L qletLocationtLjava/awt/Point;LqletSizetLjava/awt/Dimension;LqpValuesq~LqueryStrtLjava/lang/String;LsqlWithFiltersq~ xppppsq~(uq~(t DBA MonitortSelectt100tManualt300t 1-JAN-1990tYsrjava.awt.Color3uFfalphaIvalueLcstLjava/awt/color/ColorSpace;[ frgbvaluet[F[fvalueq~xppppsq~pppsq~pppt1sr java.awt.Fontš5VsIfontSerializedDataVersionF pointSizeIsizeIstyleLfRequestedAttributestLjava/util/Hashtable;Lnameq~ xpA@ ptArialxsq~@@@pppt18q~sq~pppsq~A@ pq~xsq~fpppt dd-MMM-yyyyt #########tq0q~sq~A@ pq~xtNtappst No_PatterntVLETsq~pppsq~pppt UUDBA_MONITORsrInfoPurple.DashboardSettings ඳc۬I currPletIdxI currQletIdxxp"tAuthor,Description etctNq~tDEFAULTq~q~2q~2srjavax.swing.JTextArea^j$oI columnWidthIcolumnsI rowHeightIrowsZwordZwrapxrjavax.swing.text.JTextComponentQDawwZcheckedInputOverrideZ dragEnabledZeditableCfocusAcceleratorZneedToSendKeyTypedEventL caretColortLjava/awt/Color;LcomposedTextAttributet%Ljavax/swing/text/SimpleAttributeSet;LcomposedTextCarett3Ljavax/swing/text/JTextComponent$ComposedTextCaret;LcomposedTextContentq~ LcomposedTextEndtLjavax/swing/text/Position;LcomposedTextStartq~9LdisabledTextColorq~6Leditort!Ljavax/swing/text/JTextComponent;LlatestCommittedTextEndq~9LlatestCommittedTextStartq~9LmargintLjava/awt/Insets;LmodeltLjavax/swing/text/Document;LnavigationFiltert#Ljavax/swing/text/NavigationFilter;LselectedTextColorq~6LselectionColorq~6xrjavax.swing.JComponentmFB*75!ZaaTextF alignmentXF alignmentYZ autoscrollsIflagsZisAlignmentXSetZisAlignmentYSetZverifyInputWhenFocusTargetLaccessibleContextt'Ljavax/accessibility/AccessibleContext;L actionMaptLjavax/swing/ActionMap;LancestorInputMaptLjavax/swing/InputMap;LbordertLjavax/swing/border/Border;L focusInputMapq~AL 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.ComponentY<#IboundsOpIcomponentSerializedDataVersionZenabledJ eventMaskZfocusTraversalKeysEnabledZ focusableIheightZ ignoreRepaintIisFocusTraversableOverriddenZisPackedZ maxSizeSetZ minSizeSetZnameExplicitlySetZ newEventsOnlyZ prefSizeSetZvalidZvisibleIwidthIxIyLaccessibleContextq~?L backgroundq~6L changeSupportt"Ljava/beans/PropertyChangeSupport;LcursortLjava/awt/Cursor;L dropTargettLjava/awt/dnd/DropTarget;[focusTraversalKeyst[Ljava/util/Set;LfonttLjava/awt/Font;L foregroundq~6LlocaletLjava/util/Locale;LmaxSizeq~LminSizeq~Lnameq~ LpeerFontq~QLpopupsq~LprefSizeq~xp8psr javax.swing.plaf.ColorUIResourcekSxq~pppsr java.beans.PropertyChangeSupportXdWH`I*propertyChangeSupportSerializedDataVersionLchildrenq~LsourcetLjava/lang/Object;xppq~Spxsrjava.awt.CursorojwItypeLnameq~ xpt Text Cursorpur[Ljava.util.Set;>0gjהxpsr%java.util.Collections$UnmodifiableSetяUxr,java.util.Collections$UnmodifiableCollectionB^LctLjava/util/Collection;xpsrjava.util.HashSetD4xpw ?@srjavax.swing.KeyStrokeCŗuv >xrjava.awt.AWTKeyStroke"8|CkeyCharIkeyCodeI modifiersZ onKeyReleasexp xsq~^sq~bw ?@sq~d xppsrjavax.swing.plaf.FontUIResourceBć"Gxq~A0 ptTahomaxsq~Tpppsrjava.util.Locale~`0IhashcodeLcountryq~ Llanguageq~ Lvariantq~ xptUStentpppppptfocusLsr1javax.swing.text.JTextComponent$MutableCaretEventGY|IdotZ dragActiveImarkxrjavax.swing.event.CaretEvent [rVPxrjava.util.EventObjectL Nm}xpq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~ttmouseLq~wq~q~xq~q~yq~q~zq~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~psrjava.awt.ComponentOrientationEcI orientationxpppxur[Ljava.awt.Component; uxppppppxA(psrjavax.swing.ActionMapzLparentq~@xppwxppsrjavax.swing.InputMapf!ٟLparentq~Axpsr#javax.swing.plaf.InputMapUIResourceHMכxq~sq~pw7sq~d&At selection-upsq~d'tcaret-next-wordsq~d%tselection-previous-wordsq~dAq~sq~d(t caret-downsq~dTtprevious-link-actionsq~d%tcaret-previous-wordsq~dtcut-to-clipboardsq~d#tcaret-end-linesq~d!Atselection-page-upsq~dtcaret-upsq~dt delete-nextsq~d$t caret-beginsq~d%Atselection-backwardsq~d#t caret-endsq~dtdelete-previoussq~d'tselection-next-wordsq~d%tcaret-backwardsq~dq~sq~dAtselection-forwardsq~d tactivate-link-actionsq~dHq~sq~d\tunselectsq~d t insert-breaksq~d$Atselection-begin-linesq~d't caret-forwardsq~d!tselection-page-leftsq~d(Atselection-downsq~d"t page-downsq~dAq~sq~dOttoggle-componentOrientationsq~dXq~sq~d"tselection-page-rightsq~dCtcopy-to-clipboardsq~dq~sq~d#Atselection-end-linesq~dq~sq~d$tcaret-begin-linesq~dVtpaste-from-clipboardsq~dq~sq~dAt select-allsq~d'Aq~sq~d#t selection-endsq~dq~sq~dq~sq~dTtnext-link-actionsq~dAq~sq~d t insert-tabsq~d&q~sq~d$tselection-beginsq~d"Atselection-page-downsq~dq~sq~dq~sq~d!tpage-upsq~dq~xwxwxpsr#javax.swing.event.EventListenerList6}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~Dxpsrjavax.swing.text.StyleContexto~{xI unusedSetsLstylestLjavax/swing/text/Style;xpsr(javax.swing.text.StyleContext$NamedStyle NL listenerListq~DLthis$0tLjavax/swing/text/StyleContext;xpsq~pxq~wtdefaultsq~ sq~pxq~wt$javax.swing.text.StyleConstants.nameq~ xxxsrjavax.swing.text.GapContent LL#xrjavax.swing.text.GapVector;#6VIg0Ig1Larrayq~Wxp ur[C&f]xp psrjava.util.Hashtable%!JF loadFactorI thresholdxp?@wsrjava.awt.font.TextAttributekx Fxr/java.text.AttributedCharacterIterator$Attributet&G\Lnameq~ xpt run_directionsrjava.lang.Boolean r՜ZvaluexpttabSizesrjava.lang.Integer⠤8Ivaluexrjava.lang.Number xpti18nsq~xsq~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ϲx7LparenttLjavax/swing/text/Element;Lthis$0q~)xppq~wxur4[Ljavax.swing.text.AbstractDocument$AbstractElement;t9w:ѝxpsr-javax.swing.text.AbstractDocument$LeafElementjcLthis$0q~)xq~*q~,q~wxq~wxpq~sq~uq~ ppppppppppxpppxtYxppsrInfoPurple.Plet ඳcL pletLocationq~LpletSizeq~LppValuesq~LqueryStrq~ xpsrjava.awt.PointĊr4~&IxIyxpQsrjava.awt.DimensionA׬_DIheightIwidthxp2dsq~uq~(tStatussrdbUtil.dbInstance ඳcL dbConnectNameq~ LdbDriverq~ L dbPasswordq~ LdbURLq~ LdbUserq~ LuserTypeq~ xptORA_APPSt(Oracle - oracle.jdbc.driver.OracleDrivert californiat#link-obyone.cisco.com#1532#lnkfindvtappst DATABASE_USERtALLtmeaningt lookup_codet'ID2't'ID3't'ID4't'ID5'srInfoPurple.PletValue ඳcHL descriptionq~ L displayValueq~ Lid1q~ Lid2q~ Lid3q~ Lid4q~ Lid5q~ L internalValueq~ xppt ALL Valuest%q~Oq~Oq~OtALLpsq~pppsq~fpppsq~A@ ptArialxtappstNONEtPLETtp34tYtNtAuthor,Description etctYt1tYsq~48pq~Usq~Vpq~_pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~t""q~ssq~tq~ssq~tq~ssq~tq~q~iq~q~jq~q~kq~q~lq~q~mq~q~nq~q~oq~q~pq~q~qq~q~rq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zpsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~wtdefaultsq~ sq~pxq~wq~q~xxxsq~"Guq~H//<REFRESH_LIST>g94</REFRESH_LIST> psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~uq~ ppppppppppxsq~'pq~wxuq~-sq~/q~q~wxq~w#xpq~sq~uq~ ppppppppppxpppxppppppppppppppppxtHfrom fnd_lookups where lookup_type='CP_STATUS_CODE' and enabled_flag='Y'sq~4sq~6sq~82dsq~uq~(tPhaseq~>tALLtmeaningt lookup_codet'ID2't'ID3't'ID4't'ID5'sq~Lpq~Nq~Oq~Oq~Oq~Oq~Ppq~Qq~Rsq~A@ pq~TxtappstNONEtPLETtp33tYtNtAuthor,Description etctYt1q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~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~q~wxq~wxpq~sq~uq~ ppppppppppxpppxppppppppppppppppxtGfrom fnd_lookups where lookup_type='CP_PHASE_CODE' and enabled_flag='Y'sq~4sq~6Zsq~82sq~uq~(t Period Bucketq~>tALLtdayst'ID1't'ID2't'ID3't'ID4't'ID5'sq~Lpt180tID1tID2tID3tID4tID5psq~pppq~Rsq~A@ ptArialxtappstNONEtPLETtp32tNq~tAuthor,Description etctYt1tYsq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~t""q~ssq~t&&q~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~&psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~.wtdefaultsq~ sq~pxq~.wq~q~1xxxsq~&Guq~H//<REFRESH_LIST>g92,g94</REFRESH_LIST> psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~uq~ ppppppppppxsq~'pq~-wxuq~-sq~/q~?q~-wxq~-w'xpq~-sq~uq~ ppppppppppxpppxppppppppppppppppxt'from ( select 1 days from dual union select 7 days from dual union select 15 days from dual union select 30 days from dual union select 45 days from dual union select 60 days from dual union select 90 days from dual union select 180 days from dual union select 360 days from dual ) order by dayssrInfoPurple.Glet ඳcL GletLocationq~LGletSizeq~L colDetailsq~LgpValuesq~LqueryStrq~ xpsq~63sq~88psq~uq~(tLibrary Cache Hit Ratio%q~>t100tMetertXtYtManualt1440sq~pppsq~A@ ptArialxsq~pppq~Otg64tNtappst Tuning InfotGlett q~Oq~OtVerticalt0q~Osq~Apq~Txt##.#q~OtAUTOq~`tYsq~48pq~Usq~Vpq~bpxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~lq~q~mq~q~nq~q~oq~q~pq~q~qq~q~rq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zq~q~{q~q~|q~q~}q~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~ Suq~ T//<ANCHOR>g39=TOPRIGHT</ANCHOR> import 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("%"); plot.setRange(new Range(0, 110)); plot.addInterval(new MeterInterval("Normal >99", new Range(99.0, 110.0), Color.lightGray, new BasicStroke(2.0f), new Color(0, 255, 0, 64))); plot.addInterval(new MeterInterval("Warning", new Range(0.0, 99.0), Color.lightGray, new BasicStroke(2.0f), new Color(255, 255, 0,64))); // plot.addInterval(new MeterInterval("Critical", new Range(50.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.blue,w,h, new Color(102,0,102))); plot.setValueFont(new Font("Dialog", Font.BOLD, 14)); psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~$uq~(sq~/sq~'pq~wx#$uq~-Fq~sq~/q~q~wxq~w Cxsq~/q~q~wxq~wCjxsq~/q~q~wxq~wjxsq~/q~q~wxq~wxsq~/q~q~wxq~wxsq~/q~q~wxq~wxsq~/q~q~wxq~w xsq~/q~q~wxq~w xsq~/q~q~wxq~wIxsq~/q~q~wxq~wIxsq~/q~q~wxq~wxsq~/q~q~wxq~wxsq~/q~q~wxq~wMxsq~/q~q~wxq~wMxsq~/q~q~wxq~wxsq~/q~q~wxq~w.xsq~/q~q~wxq~w.]xsq~/q~q~wxq~w]xsq~/q~q~wxq~wxsq~/q~q~wxq~wxsq~/q~q~wxq~wxsq~/q~q~wxq~w7xsq~/q~q~wxq~w7`xsq~/q~q~wxq~w`xsq~/q~q~wxq~wxsq~/q~q~wxq~wxsq~/q~q~wxq~wxsq~/q~q~wxq~w&xsq~/q~q~wxq~w&Oxsq~/q~q~wxq~wOwxsq~/q~q~wxq~wwxsq~/q~q~wxq~wxsq~/q~q~wxq~wGxsq~/q~q~wxq~wGHxsq~/q~q~wxq~wHxppppppppppppppppppppppppppppppppppq~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~q~ppppxq~sq~uq~(sq~/q~q~wxq~wxpppppppppppppppppppppppppppppppppppppppxpppxt1pppppppppxtSSELECT (1 -(Sum(reloads)/(Sum(pins) + Sum(reloads)))) * 100 FROM v$librarycachesq~Esq~63sq~88psq~uq~(t Hit Ratio%q~>t100tMetertXtYtManualt1440sq~pppsq~A@ ptArialxsq~pppq~tg39q~Wtappst Tuning InfotGletq~[q~q~tVerticalt0q~sq~Apq~xt##.#q~tAUTOq~tYsq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~wtdefaultsq~ sq~pxq~wq~q~xxxsq~ Suq~ T//<ANCHOR>q38=BOTTOMLEFT</ANCHOR> import 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("%"); plot.setRange(new Range(0, 100)); plot.addInterval(new MeterInterval("Normal", new Range(89.0, 100.0), Color.lightGray, new BasicStroke(2.0f), new Color(0, 255, 0, 64))); plot.addInterval(new MeterInterval("Warning", new Range(0.0,89.0), Color.lightGray, new BasicStroke(2.0f), new Color(255, 0, 0,64))); // plot.addInterval(new MeterInterval("Critical", new Range(50.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.blue,w,h, new Color(102,0,102))); plot.setValueFont(new Font("Dialog", Font.BOLD, 14)); psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~&uq~(sq~/sq~'pq~wx%&uq~-Fq~ sq~/q~!q~wxq~w"Exsq~/q~!q~wxq~wElxsq~/q~!q~wxq~wlxsq~/q~!q~wxq~wxsq~/q~!q~wxq~wxsq~/q~!q~wxq~wxsq~/q~!q~wxq~w xsq~/q~!q~wxq~w !xsq~/q~!q~wxq~w!Kxsq~/q~!q~wxq~wKLxsq~/q~!q~wxq~wLxsq~/q~!q~wxq~wxsq~/q~!q~wxq~wxsq~/q~!q~wxq~wq~?q~@q~Aq~Bq~Cq~Dq~Eq~Fq~Gppxq~!sq~uq~(sq~/q~!q~wxq~wxpppppppppppppppppppppppppppppppppppppppxpppxt1pppppppppxt}SELECT Round(((Sum(Decode(a.name, 'consistent gets', a.value, 0)) + Sum(Decode(a.name, 'db block gets', a.value, 0)) - Sum(Decode(a.name, 'physical reads', a.value, 0)) )/ (Sum(Decode(a.name, 'consistent gets', a.value, 0)) + Sum(Decode(a.name, 'db block gets', a.value, 0)))) *100,2) "Hit Ratio %" FROM v$sysstat asq~sq~uq~ ppppppppppxsq~6jsq~8]5sq~(uq~(tCache Hit Ratioq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~sq~@@@pppq~ q~Yq~!q~"q~#t dd-MMM-yyyyt #########tq38q~\q~'q~(tappst Tuning InfotQLETsq~pppsq~ppptXXDBNAMEq~[tAuthor,Description etctNq~[tDEFAULTq~Yq~gq~gsq~48pq~Usq~Vpq~ipxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zq~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~psq~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~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~gxtVSELECT Sum(Decode(a.name, 'consistent gets', a.value, 0)) "Consistent Gets", Sum(Decode(a.name, 'db block gets', a.value, 0)) "DB Block Gets", Sum(Decode(a.name, 'physical reads', a.value, 0)) "Physical Reads", Round(((Sum(Decode(a.name, 'consistent gets', a.value, 0)) + Sum(Decode(a.name, 'db block gets', a.value, 0)) - Sum(Decode(a.name, 'physical reads', a.value, 0)) )/ (Sum(Decode(a.name, 'consistent gets', a.value, 0)) + Sum(Decode(a.name, 'db block gets', a.value, 0)))) *100,2) "Hit Ratio %" FROM v$sysstat atNsq~sq~uq~ srInfoPurple.ColumnPropertyValues ඳcٸL colPropValuesq~L drillValuesq~L parentQlettLInfoPurple/Qlet;xpsq~uq~tBANNERt434sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyytYsq~AP ptArialxtBannertDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppppxsq~6Osq~8Xsq~(uq~(tVersionq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~q~ q~q~!q~"q~#t dd-MMM-yyyyt #########tq47q~q~'q~(tappstDatabase InformationtQLETsq~pppsq~ppptXXDBNAMEq~[tCPredicts how changes to the buffer cache will affect physical readstNq~tDEFAULTq~q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~wtdefaultsq~ sq~pxq~wq~q~xxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~ wxuq~-sq~/q~q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxq~xtSELECT * FROM v$versionq~sq~sq~uq~ sq~sq~uq~tOBJECTt210sq~pppsq~@@@pppsq~pppt1q~.sq~A ptArialxtNAtNt ##########t dd-MMM-yyyytNsq~A pq~2xtObjecttDEFAULTtYpppxsq~uq~ srInfoPurple.DrillSettings ඳcL drillColumnsq~L drillNameq~ L drillQletIDq~ xpsq~uq~ tOBJECTpppppppppxtObject Detailstq36pppppppppxq~%sq~sq~uq~tTYPEt58q~-q~.q~/t1q~.q~1tNAtNt ##########t dd-MMM-yyyyq~7q~8tTypetDEFAULTtYpppxsq~uq~ ppppppppppxq~%sq~sq~uq~tSIDt35q~-q~.q~/t1q~.q~1tNAtNt ##########t dd-MMM-yyyyq~7q~8t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~%sq~sq~uq~tPROGRAMt200q~-q~.q~/t1q~.q~1tNAtNt ##########t dd-MMM-yyyyq~7q~8t Display NametDEFAULTtYpppxsq~uq~ ppppppppppxq~%ppppppxsq~6sq~8.Isq~(uq~(tAccessed Objects by Ownerq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~.q~ q~{q~!q~"q~#t dd-MMM-yyyyt #########tq33q~.q~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctNq~}tDEFAULTq~{q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~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~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~xtSELECT distinct a.object, a.type FROM v$access a, v$session b WHERE a.sid = b.sid AND a.owner = 'G_PARAM' /*username*/ ORDER BY a.objecttNsq~sq~uq~ sq~sq~uq~tCOMPONENT_NAMEt250sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyytNsq~A pq~xtComponent NametDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppppxsq~6Tsq~8sq~(uq~(tWorkflow Mailer Statusq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~q~ tYq~!q~"q~#t dd-MMM-yyyyt #########tq89q~q~'q~(tappst02. Oracle ERPtQLETsq~pppsq~ppptXXDBNAMEq~tAuthor,Description etctNq~tDEFAULTq~q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~&wtdefaultsq~ sq~pxq~&wq~q~)xxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~%wxuq~-sq~/q~7q~%wxq~%wxpq~%sq~uq~ ppppppppppxpppxq~xtbSELECT Component_name, Component_Status FROM FND_SVC_COMPONENTS WHERE component_type = 'WF_MAILER'q~sq~sq~uq~ ppppppppppxsq~6sq~8sq~(uq~(tUnusable Indexesq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~sq~@@@pppq~ q~Iq~!q~"q~#t dd-MMM-yyyyt #########tq62q~Lq~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tCPredicts how changes to the buffer cache will affect physical readstNq~KtDEFAULTq~Iq~Wq~Wsq~48pq~Usq~Vpq~Ypxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~cq~q~dq~q~eq~q~fq~q~gq~q~hq~q~iq~q~jq~q~kq~q~lq~q~mq~q~nq~q~oq~q~pq~q~qq~q~rq~q~sq~q~tq~q~uq~q~vq~q~wq~q~xq~q~yq~q~zq~q~{q~q~|psq~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~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~WxtSELECT owner, index_name FROM dba_indexes WHERE owner = 'G_PARAM' /*username*/ AND status NOT IN ('VALID', 'N/A') ORDER BY owner, index_nameq~sq~sq~uq~ ppppppppppxsq~6sq~8sq~(uq~(t Hot Blocksq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~sq~@@@pppq~ q~q~!q~"q~#t dd-MMM-yyyyt #########tq58q~q~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tCPredicts how changes to the buffer cache will affect physical readstNq~tDEFAULTq~q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~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~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~xtSELECT * FROM (SELECT name, gets, misses, sleeps FROM v$latch_children WHERE name = 'cache buffers chains' AND misses > 0 ORDER BY misses DESC) WHERE rownum < 11q~sq~sq~uq~ ppppppppppxsq~6sq~8Gqsq~(uq~(t)Buffer Cache vs Physical Reads predictionq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~sq~@@@pppq~ q~q~!q~"q~#t dd-MMM-yyyyt #########tq42q~q~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~tCPredicts how changes to the buffer cache will affect physical readstNq~tDEFAULTq~q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~0q~q~1q~q~2q~q~3q~q~4q~q~5q~q~6q~q~7q~q~8q~q~9psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~Awtdefaultsq~ sq~pxq~Awq~q~Dxxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~@wxuq~-sq~/q~Rq~@wxq~@wxpq~@sq~uq~ ppppppppppxpppxq~xtQSELECT size_for_estimate, buffers_for_estimate, estd_physical_read_factor, estd_physical_reads FROM v$db_cache_advice WHERE name = 'DEFAULT' AND block_size = (SELECT value FROM v$parameter WHERE name = 'db_block_size') AND advice_status = 'ON'q~sq~sq~uq~ sq~sq~uq~tSIDt39sq~pppsq~@@@pppsq~pppt1q~asq~A ptArialxtNAtNt ##########t dd-MMM-yyyytNsq~A pq~extSidtDEFAULTtYpppxsq~uq~ sq~>sq~uq~ q~^pppppppppxtGet SQLtq107pppppppppxq~Xsq~sq~uq~tOBJECTt204q~`q~aq~bt1q~aq~dtNAtNt ##########t dd-MMM-yyyyq~jq~ktObjecttDEFAULTtYpppxsq~uq~ ppppppppppxq~Xsq~sq~uq~tOWNERt50q~`q~aq~bt1q~aq~dtNAtNt ##########t dd-MMM-yyyyq~jq~ktOwnertDEFAULTtYpppxsq~uq~ ppppppppppxq~Xsq~sq~uq~tTYPEt105q~`q~aq~bt1q~aq~dtNAtNt ##########t dd-MMM-yyyyq~jq~ktTypetDEFAULTtYpppxsq~uq~ ppppppppppxq~Xppppppxsq~6sq~8sq~(uq~(t Object Locksq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~aq~ q~q~!q~"q~#t dd-MMM-yyyyt #########tq108q~aq~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctNq~tDEFAULTq~q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~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~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~xtSELECT a.type, Substr(a.owner,1,30) owner, a.sid, Substr(a.object,1,30) object FROM v$access a WHERE a.owner NOT IN ('SYS','PUBLIC') and a.object like 'param' ORDER BY 1,2,3,4tYsq~sq~uq~ sq~sq~uq~tLOCKWAITt60sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~7sq~A pq~xtLockwaittDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tSTATUSt51q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~7q~tStatustDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tSIDt38q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~7q~tSidtDEFAULTtYpppxsq~uq~ sq~>sq~uq~ tSIDpppppppppxtGet SQLq~upppppppppxq~sq~sq~uq~tOSUSERt49q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~7q~tOsusertDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~t LOGON_TIMEt125q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~7q~t Logon TimetDEFAULTtYpppxsq~uq~ ppppppppppxq~sq~sq~uq~tMODULEt149q~q~q~t1q~q~tNAtNt ##########t dd-MMM-yyyyq~jq~tModuletDEFAULTtYpppxsq~uq~ ppppppppppxq~ppppxsq~6sq~8,sq~(uq~(tActive Sessionsq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~q~ q~dq~!q~"q~#t dd-MMM-yyyyt #########tq32q~q~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctNq~ftDEFAULTq~dq~rq~rsq~48pq~Usq~Vpq~tpxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~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~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~rxtSELECT NVL(s.username, '(oracle)') AS username, s.osuser, s.sid, s.serial#, p.spid, s.lockwait, s.status, s.module, s.machine, s.program, TO_CHAR(s.logon_Time,'DD-MON-YYYY HH24:MI:SS') AS logon_time FROM v$session s, v$process p WHERE s.paddr = p.addr AND s.status = 'ACTIVE' ORDER BY s.username, s.osusertNsq~sq~uq~ sq~sq~uq~tSQL_TEXTt486sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~jsq~A pq~xtSql TexttDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppppxsq~6sq~8,sq~(uq~(t Session SQLq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~q~ q~q~!q~"q~#t dd-MMM-yyyyt #########q~uq~q~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~ptAuthor,Description etctNq~tDEFAULTq~q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~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~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~xtSELECT a.sql_text FROM v$sqltext a, v$session b WHERE a.address = b.sql_address AND a.hash_value = b.sql_hash_value AND b.sid = param ORDER BY a.piecetYsq~sq~uq~ sq~sq~uq~tDB_LINKt142q~sq~@@@pppsq~pppt1q~'sq~A ptArialxtNAtNt ##########t dd-MMM-yyyytNsq~A ptArialxtDb LinktDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppppxsq~6sq~8sq~(uq~(tDB Linksq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~'q~ q~Aq~!q~"q~#t dd-MMM-yyyyt #########tq55q~'q~'q~(tappstDatabase InformationtQLETsq~pppsq~ppptXXDBNAMEq~ptCPredicts how changes to the buffer cache will affect physical readstNq~CtDEFAULTq~Aq~Nq~Nsq~48pq~Usq~Vpq~Ppxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~Zq~q~[q~q~\q~q~]q~q~^q~q~_q~q~`q~q~aq~q~bq~q~cq~q~dq~q~eq~q~fq~q~gq~q~hq~q~iq~q~jq~q~kq~q~lq~q~mq~q~nq~q~oq~q~pq~q~qq~q~rq~q~spsq~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~zwxuq~-sq~/q~q~zwxq~zwxpq~zsq~uq~ ppppppppppxpppxq~NxtfSELECT owner, db_link, username, host FROM dba_db_links ORDER BY owner, db_linkq~sq~sq~uq~ sq~sq~uq~t PROPERTY_NAMEt224q~sq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~0sq~A ptArialxt Property NametDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppppxsq~6sq~8sq~(uq~(t DB Propertiesq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~q~ q~q~!q~"q~#t dd-MMM-yyyyt #########tq56q~q~'q~(tappstDatabase InformationtQLETsq~pppsq~ppptXXDBNAMEq~ptCPredicts how changes to the buffer cache will affect physical readstNq~tDEFAULTq~q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~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~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~xt]SELECT property_name, property_value FROM database_properties ORDER BY property_nameq~sq~sq~uq~ sq~sq~uq~tOBJECTt205q~sq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~0sq~A pq~ xtObjecttDEFAULTtYpppxsq~uq~ ppppppppppxq~ pppppppppxsq~6sq~8sq~(uq~(tAccessed Detailsq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~ q~ q~ $q~!q~"q~#t dd-MMM-yyyyt #########q~Dq~ q~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctNq~ &tDEFAULTq~ $q~ 1q~ 1sq~48pq~Usq~Vpq~ 3pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~ =q~q~ >q~q~ ?q~q~ @q~q~ Aq~q~ Bq~q~ Cq~q~ Dq~q~ Eq~q~ Fq~q~ Gq~q~ Hq~q~ Iq~q~ Jq~q~ Kq~q~ Lq~q~ Mq~q~ Nq~q~ Oq~q~ Pq~q~ Qq~q~ Rq~q~ Sq~q~ Tq~q~ Uq~q~ Vq~q~ Wq~q~ Xpsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~ `wtdefaultsq~ sq~pxq~ `wq~q~ cxxxsq~ uq~ psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~uq~ ppppppppppxsq~'pq~ _wxuq~-sq~/q~ qq~ _wxq~ _wxpq~ _sq~uq~ ppppppppppxpppxq~ 1xtSELECT a.object, a.type, a.sid, b.username, b.osuser, b.program FROM v$access a, v$session b WHERE a.sid = b.sid AND a.owner = 'G_PARAM' /*username*/ and a.object = 'param' ORDER BY a.objecttYsq~sq~uq~ ppppppppppxsq~6mQsq~83{sq~(uq~(tInterface Error Detailsq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~sq~@@@pppq~ q~ q~!q~"q~#t dd-MMM-yyyyt #########tq101q~ q~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~ptAuthor,Description etctNq~ tDEFAULTq~ q~ q~ sq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~ psq~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~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxq~ xt$select * from paramq~sq~Esq~6.4sq~86psq~uq~(tDictionary Catche Hit Ratio%q~>t100tMetertXtYtManualt1440sq~pppsq~A@ ptArialxsq~pppq~ tg63q~Wtappst Tuning InfotGlett q~ q~ tVerticalt0q~ sq~Apq~ xt##.#q~ tAUTOq~ tYsq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~ wtdefaultsq~ sq~pxq~ wq~q~ xxxsq~ Suq~ T//<ANCHOR>g64=TOPRIGHT</ANCHOR> import 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("%"); plot.setRange(new Range(0, 100)); plot.addInterval(new MeterInterval("Normal", new Range(90.0, 100.0), Color.lightGray, new BasicStroke(2.0f), new Color(0, 255, 0, 64))); // plot.addInterval(new MeterInterval("Warning", new Range(35.0, 50.0), // Color.lightGray, new BasicStroke(2.0f), new Color(255, 255, 0,64))); plot.addInterval(new MeterInterval("Critical", new Range(0.0, 90.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.blue,w,h, new Color(102,0,102))); plot.setValueFont(new Font("Dialog", Font.BOLD, 14));olor(102,0,102))); plot.setValueFont(new Font("Dialog", Font.BOLD, 14)); psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~#uq~(sq~/sq~'pq~ wx"#uq~-Fq~ #sq~/q~ $q~ wxq~ w Cxsq~/q~ $q~ wxq~ wCjxsq~/q~ $q~ wxq~ wjxsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ w xsq~/q~ $q~ wxq~ w xsq~/q~ $q~ wxq~ wIxsq~/q~ $q~ wxq~ wIxsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ wCxsq~/q~ $q~ wxq~ wCxsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ w!xsq~/q~ $q~ wxq~ w!Nxsq~/q~ $q~ wxq~ wN{xsq~/q~ $q~ wxq~ w{xsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ w(xsq~/q~ $q~ wxq~ w(Qxsq~/q~ $q~ wxq~ wQxsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ w@xsq~/q~ $q~ wxq~ w@hxsq~/q~ $q~ wxq~ whxsq~/q~ $q~ wxq~ wxsq~/q~ $q~ wxq~ w8xsq~/q~ $q~ wxq~ w89xsq~/q~ $q~ wxq~ w9xsq~/q~ $q~ wxq~ wxppppppppppppppppppppppppppppppppppq~ 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~ Gpppppxq~ $sq~uq~(sq~/q~ $q~ wxq~ wxpppppppppppppppppppppppppppppppppppppppxpppxt1pppppppppxtTSELECT (1 - (Sum(getmisses)/(Sum(gets) + Sum(getmisses)))) * 100 FROM v$rowcachesq~sq~uq~ sq~sq~uq~tRATIOt171sq~pppsq~@@@pppsq~pppt1q~ Wsq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~0sq~A pq~ [xtRatiotDEFAULTtYpppxsq~uq~ ppppppppppxq~ Nsq~sq~uq~tSUGGESTED_ACTIONt336q~ Vq~ Wq~ Xt1q~ Wq~ ZtNAtNt ##########t dd-MMM-yyyyq~0q~ `tSuggested ActiontDEFAULTtYpppxsq~uq~ ppppppppppxq~ Nsq~sq~uq~t RATIO_VALUEt40q~ Vq~ Wq~ Xt1q~ Wq~ ZtNAtNt ##########t dd-MMM-yyyyq~0q~ `t Ratio ValuetDEFAULTtYpppxsq~uq~ ppppppppppxq~ Npppppppxsq~6<sq~8fsq~(uq~(t Tuning Tipsq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~ Wq~ q~ q~!q~"q~#t dd-MMM-yyyyt #########tq67q~ Wq~'q~(tappst Tuning InfotQLETsq~pppsq~ppptXXDBNAMEq~ tAuthor,Description etctNt0tDEFAULTq~ q~ q~ sq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~t!!q~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~ wtdefaultsq~ sq~pxq~ wq~q~ xxxsq~Euq~F//<ANCHOR>g63=BOTTOMLEFT</ANCHOR> psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~ wxuq~-sq~/q~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxq~ xt select ratio,ratio_value, case when ratio='Dictionary Cache Hit >90' and ratio_value<=90 then 'Increase SHARED_POOL_SIZE parameter to bring value above 90%' when ratio='Library Cache Hit >99' and ratio_value<=99 then 'Increase SHARED_POOL_SIZE parameter to bring value above 99%' when ratio='Buffer Cache Hit >89' and ratio_value<=89 then 'Increase DB_BLOCK_BUFFERS parameter to bring value above 89%' when ratio='Latch Hit >98' and ratio_value<=98 then 'Increase number of latches to bring the value above 98%' when ratio='Disk Sort Ratio <5' and ratio_value>5 then 'Increase SORT_AREA_SIZE parameter to bring value below 5%' when ratio='Rollback Segment Waits <5' and ratio_value>=5 then 'Increase number of Rollback Segments to bring the value below 5%' when ratio='Dispatcher Workload <50' and ratio_value>=50 then 'Increase MTS_DISPATCHERS to bring the value below 50%' else 'Value is OK' end suggested_action from ( SELECT 'Dictionary Cache Hit >90' ratio, (1 - (Sum(getmisses)/(Sum(gets) + Sum(getmisses)))) * 100 ratio_value FROM v$rowcache union SELECT 'Library Cache Hit >99' ,(1 -(Sum(reloads)/(Sum(pins) + Sum(reloads)))) * 100 FROM v$librarycache union SELECT 'Buffer Cache Hit >89',(1 - (phys.value / (db.value + cons.value))) * 100 FROM v$sysstat phys, v$sysstat db, v$sysstat cons WHERE phys.name = 'physical reads' AND db.name = 'db block gets' AND cons.name = 'consistent gets' union SELECT 'Latch Hit >98',(1 - (Sum(misses) / Sum(gets))) * 100 FROM v$latch union SELECT 'Disk Sort Ratio <5',(disk.value/mem.value) * 100 FROM v$sysstat disk, v$sysstat mem WHERE disk.name = 'sorts (disk)' AND mem.name = 'sorts (memory)' union SELECT 'Rollback Segment Waits <5',(Sum(waits) / Sum(gets)) * 100 FROM v$rollstat union SELECT 'Dispatcher Workload <50', NVL((Sum(busy) / (Sum(busy) + Sum(idle))) * 100,0) FROM v$dispatcher )tNsq~sq~uq~ ppppppppppxsq~6sq~8sq~(uq~(tFile IOq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~sq~@@@pppq~ q~ q~!q~"q~#t dd-MMM-yyyyt #########tq57q~ q~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~ tCPredicts how changes to the buffer cache will affect physical readstNq~ tDEFAULTq~ q~ q~ sq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~ psq~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~ 7q~ %wxq~ %wxpq~ %sq~uq~ ppppppppppxpppxq~ xtSELECT Substr(d.name,1,50) "File Name", f.phyblkrd "Blocks Read", f.phyblkwrt "Blocks Writen", f.phyblkrd + f.phyblkwrt "Total I/O" FROM v$filestat f, v$datafile d WHERE d.file# = f.file# ORDER BY f.phyblkrd + f.phyblkwrt DESCq~ sq~sq~uq~ ppppppppppxsq~6sq~8sq~(uq~(tUser Hit Ratioq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~sq~@@@pppq~ q~ Iq~!q~"q~#t dd-MMM-yyyyt #########tq59q~ Lq~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~ tCPredicts how changes to the buffer cache will affect physical readstNq~ KtDEFAULTq~ Iq~ Wq~ Wsq~48pq~Usq~Vpq~ Ypxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~ cq~q~ dq~q~ eq~q~ fq~q~ gq~q~ hq~q~ iq~q~ jq~q~ kq~q~ lq~q~ mq~q~ nq~q~ oq~q~ pq~q~ qq~q~ rq~q~ sq~q~ tq~q~ uq~q~ vq~q~ wq~q~ xq~q~ yq~q~ zq~q~ {q~q~ |psq~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~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxq~ WxtSELECT a.username "Username", b.consistent_gets "Consistent Gets", b.block_gets "DB Block Gets", b.physical_reads "Physical Reads", Round(100* (b.consistent_gets + b.block_gets - b.physical_reads) / (b.consistent_gets + b.block_gets),2) "Hit Ratio %" FROM v$session a, v$sess_io b WHERE a.sid = b.sid AND (b.consistent_gets + b.block_gets) > 0 AND a.username IS NOT NULLq~ sq~sq~uq~ sq~sq~uq~tMANAGERt258sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~sq~A pq~ xtManagertDEFAULTtYpppxsq~uq~ ppppppppppxq~ pppppppppxsq~6sq~8sq~(uq~(tInactive Concurrent Managersq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~ q~ q~ q~!q~"q~#t dd-MMM-yyyyt #########tq82q~ q~'q~(tappst01. Concurrent ManagertQLETsq~pppsq~ppptXXDBNAMEt tAuthor,Description etctNq~ tDEFAULTq~ q~ q~ sq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~ wtdefaultsq~ sq~pxq~ wq~q~ xxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~ wxuq~-sq~/q~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxq~ xteSelect Application_Name, Concurrent_Queue_Id QId, User_Concurrent_Queue_Name Manager, Node_Name Node from Fnd_Concurrent_Queues_Vl Q, Fnd_Application_Vl A where A.Application_Id = Q.Application_ID And Max_Processes = 0 And Running_Processes = 0 And Q.Concurrent_Queue_ID != 1 order by Application_Name, User_Concurrent_Queue_Name tNsq~sq~uq~ ppppppppppxsq~6sq~8sq~(uq~(tConcurrent Manager Locksq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~sq~@@@pppq~ q~ q~!q~"q~#t dd-MMM-yyyyt #########tq83q~ q~'q~(tappst01. Concurrent ManagertQLETsq~pppsq~ppptXXDBNAMEq~ tAuthor,Description etctNq~ tDEFAULTq~ q~ "q~ "sq~48pq~Usq~Vpq~ $pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~ .q~q~ /q~q~ 0q~q~ 1q~q~ 2q~q~ 3q~q~ 4q~q~ 5q~q~ 6q~q~ 7q~q~ 8q~q~ 9q~q~ :q~q~ ;q~q~ q~q~ ?q~q~ @psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~ Hwtdefaultsq~ sq~pxq~ Hwq~q~ Kxxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~ Gwxuq~-sq~/q~ Yq~ Gwxq~ Gwxpq~ Gsq~uq~ ppppppppppxpppxq~ "xtselect SH.OSUSER, SH.PROCESS, SH.MACHINE, SH.TERMINAL, SH.PROGRAM from V$SESSION SH, V$LOCK LW, V$LOCK LH, V$SESSION SW, FND_CONCURRENT_PROCESSES where LH.SID = SH.SID and LH.SID != SW.SID and LH.ID1 = LW.ID1 and LH.ID2 = LW.ID2 and LW.KADDR = SW.LOCKWAIT and SW.LOCKWAIT is not null and SW.PROCESS = OS_PROCESS_ID and QUEUE_APPLICATION_ID = 0 and CONCURRENT_QUEUE_ID = 4 q~ sq~sq~uq~ ppppppppppxsq~6 $sq~8sq~(uq~(t!Concurrent Managers with Problemsq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~sq~@@@pppq~ q~ kq~!q~"q~#t dd-MMM-yyyyt #########tq81q~ nq~'q~(tappst01. Concurrent ManagertQLETsq~pppsq~ppptXXDBNAMEq~ tAuthor,Description etctNq~ mtDEFAULTq~ kq~ yq~ ysq~48pq~Usq~Vpq~ {pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~ wtdefaultsq~ sq~pxq~ wq~q~ xxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~ wxuq~-sq~/q~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxq~ yxtSelect distinct '$FND_TOP/log/W'||Concurrent_Process_Id Look_At, Concurrent_Process_Id cpid, Oracle_Process_ID Opid, Os_Process_ID Osid, User_Concurrent_Queue_Name Manager, P.Node_Name Node, To_Char(P.Process_Start_Date, 'MM-DD-YY HH:MI:SSAM') Started_At from Fnd_Concurrent_Processes P, Fnd_Concurrent_Queues_Vl Q where Q.Application_Id = Queue_Application_ID And Q.Concurrent_Queue_ID = P.Concurrent_Queue_ID And P.Concurrent_Queue_ID != 1 And (Os_Process_ID ) Not in ( Select Spid from FND_V$PROCESS Where Spid Is Not Null ) And ( Process_Status_Code = 'A' OR Process_Status_Code = 'R' OR Process_Status_Code = 'T' ) Order by Os_Process_Id, Concurrent_Process_ID, Q.User_Concurrent_Queue_Nameq~ sq~sq~uq~ ppppppppppxsq~6Nsq~8sq~(uq~(tConcurrent Manager Detailsq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~sq~@@@pppq~ q~ q~!q~"q~#t dd-MMM-yyyyt #########tq80q~ q~'q~(tappst01. Concurrent ManagertQLETsq~pppsq~ppptXXDBNAMEq~ tAuthor,Description etctNq~ tDEFAULTq~ q~ q~ sq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~ wtdefaultsq~ sq~pxq~ wq~q~ xxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~ wxuq~-sq~/q~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxq~ xt@Select distinct Concurrent_Process_Id CpId, PID Opid, Os_Process_ID Osid, Q.User_Concurrent_Queue_Name Manager, P.Node_Name Node, To_Char(P.Process_Start_Date, 'MM-DD-YY HH:MI:SSAM') Started_At from Fnd_Concurrent_Processes P, Fnd_Concurrent_Queues_Vl Q, FND_V$Process where Q.Application_Id = Queue_Application_ID And (Q.Concurrent_Queue_ID = P.Concurrent_Queue_ID) And ( Spid = Os_Process_ID ) And Process_Status_Code not in ('K','S') Order by Os_Process_Id, Concurrent_Process_ID, Q.User_Concurrent_Queue_Name q~ sq~sq~uq~ ppppppppppxsq~6sq~8sq~(uq~(tInternal Manager Locksq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~sq~@@@pppq~ q~ q~!q~"q~#t dd-MMM-yyyyt #########tq79q~ q~'q~(tappst01. Concurrent ManagertQLETsq~pppsq~ppptXXDBNAMEq~ tAuthor,Description etctNq~ tDEFAULTq~ q~ 'q~ 'sq~48pq~Usq~Vpq~ )pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~q~ 3q~q~ 4q~q~ 5q~q~ 6q~q~ 7q~q~ 8q~q~ 9q~q~ :q~q~ ;q~q~ q~q~ ?q~q~ @q~q~ Aq~q~ Bq~q~ Cq~q~ Dq~q~ Epsq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~ Mwtdefaultsq~ sq~pxq~ Mwq~q~ Pxxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~ Lwxuq~-sq~/q~ ^q~ Lwxq~ Lwxpq~ Lsq~uq~ ppppppppppxpppxq~ 'xtselect SH.OSUSER, SH.PROCESS, SH.MACHINE, SH.TERMINAL, SH.PROGRAM from V$SESSION SH where SH.SID in (select LH.SID from V$LOCK LW, V$LOCK LH, V$SESSION SW, FND_CONCURRENT_PROCESSES where LH.SID != SW.SID and LH.ID1 = LW.ID1 and LH.ID2 = LW.ID2 and LW.KADDR = SW.LOCKWAIT and SW.LOCKWAIT is not null and SW.PROCESS = OS_PROCESS_ID and QUEUE_APPLICATION_ID = 0 and CONCURRENT_QUEUE_ID = 1) q~ sq~sq~uq~ sq~sq~uq~tGroupt47sq~pppsq~@@@pppsq~pppt1q~ msq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~(sq~A ptArialxtGrouptDEFAULTtYpppxsq~uq~ ppppppppppxq~ dsq~sq~uq~tLogfilet209q~ lq~ mq~ nt1q~ mq~ ptNAtNt ##########t dd-MMM-yyyyq~(q~ vtLogfiletDEFAULTtYpppxsq~uq~ ppppppppppxq~ dppppppppxsq~6sq~8sq~(uq~(tLog Fileq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~ mq~ q~ q~!q~"q~#t dd-MMM-yyyyt #########tq54q~ mq~'q~(tappstDatabase InformationtQLETsq~pppsq~ppptXXDBNAMEq~[tCPredicts how changes to the buffer cache will affect physical readstNq~ tDEFAULTq~ q~ q~ sq~48pq~Usq~Vpq~ pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~ psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~ wtdefaultsq~ sq~pxq~ wq~q~ xxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~ wxuq~-sq~/q~ q~ wxq~ wxpq~ sq~uq~ ppppppppppxpppxq~ xtSELECT l.group# "Group", Substr(l.member,1,60) "Logfile", NVL(l.status,'UNKNOWN') "Status" FROM v$logfile l ORDER BY 1,2q~sq~sq~uq~ sq~sq~uq~tDatafilet331sq~pppsq~@@@pppsq~pppt1q~ sq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~(sq~A ptArialxtDatafiletDEFAULTtYpppxsq~uq~ ppppppppppxq~ pppppppppxsq~6sq~8sq~(uq~(t DB DataFileq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~ q~ q~ q~!q~"q~#t dd-MMM-yyyyt #########tq53q~ q~'q~(tappstDatabase InformationtQLETsq~pppsq~ppptXXDBNAMEq~[tCPredicts how changes to the buffer cache will affect physical readstNq~ tDEFAULTq~ q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~0q~q~1q~q~2q~q~3q~q~4q~q~5q~q~6q~q~7q~q~8q~q~9q~q~:q~q~;q~q~t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~dq~ q~}q~!q~"q~#t dd-MMM-yyyyt #########tq52q~dq~'q~(tappstDatabase InformationtQLETsq~pppsq~ppptXXDBNAMEq~[tCPredicts how changes to the buffer cache will affect physical readstNq~tDEFAULTq~}q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~wtdefaultsq~ sq~pxq~wq~q~xxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~wxuq~-sq~/q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~xtsSELECT Substr(c.name,1,60) "Controlfile", NVL(c.status,'UNKNOWN') "Status" FROM v$controlfile c ORDER BY 1q~sq~sq~uq~ sq~sq~uq~tNAMEt175sq~pppsq~@@@pppsq~pppt1q~sq~AP ptArialxtNAtNt ##########t dd-MMM-yyyyq~(sq~AP ptArialxtNametDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppppxsq~6sq~8sq~(uq~(tDB SGAq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~q~ q~q~!q~"q~#t dd-MMM-yyyyt #########tq50q~q~'q~(tappstDatabase InformationtQLETsq~pppsq~ppptXXDBNAMEq~[tCPredicts how changes to the buffer cache will affect physical readstNq~tDEFAULTq~q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~$psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~,wtdefaultsq~ sq~pxq~,wq~q~/xxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~+wxuq~-sq~/q~=q~+wxq~+wxpq~+sq~uq~ ppppppppppxpppxq~xt,SELECT a.name, a.value FROM v$sga aq~sq~sq~uq~ sq~sq~uq~t INSTANCE_NAMEt49sq~pppsq~@@@pppsq~pppt1q~Lsq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~(sq~AP ptArialxt Instance NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Csq~sq~uq~tINSTANCE_NUMBERt50q~Kq~Lq~Mt1q~Lq~OtNAtNt ##########t dd-MMM-yyyyq~(q~UtInstance NumbertDEFAULTtYpppxsq~uq~ ppppppppppxq~Csq~sq~uq~t HOST_NAMEt82q~Kq~Lq~Mt1q~Lq~OtNAtNt ##########t dd-MMM-yyyyq~(q~Ut Host NametDEFAULTtYpppxsq~uq~ ppppppppppxq~Cpppppppxsq~6sq~8oTsq~(uq~(t DB Instanceq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~Lq~ q~q~!q~"q~#t dd-MMM-yyyyt #########tq49q~Lq~'q~(tappstDatabase InformationtQLETsq~pppsq~ppptXXDBNAMEq~[tCPredicts how changes to the buffer cache will affect physical readstNq~tDEFAULTq~q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~wtdefaultsq~ sq~pxq~wq~q~xxxsq~ uq~ psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~wxuq~-sq~/q~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~xtSELECT * FROM v$instanceq~sq~sq~uq~ sq~sq~uq~tDBIDt75sq~pppsq~@@@pppsq~pppt1q~sq~A ptArialxtNAtNt ##########t dd-MMM-yyyytNsq~AP ptArialxtDbidtDEFAULTtYpppxsq~uq~ ppppppppppxq~pppppppppxsq~6Isq~8~?sq~(uq~(tDatabase Detailsq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~q~ q~q~!q~"q~#t dd-MMM-yyyyt #########tq46q~q~'q~(tappstDatabase InformationtQLETsq~pppsq~ppptXXDBNAMEq~[tCPredicts how changes to the buffer cache will affect physical readstNq~tDEFAULTq~q~q~sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~t!!q~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~+psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~3wtdefaultsq~ sq~pxq~3wq~q~6xxxsq~!Euq~F//<ANCHOR>q47=BOTTOMLEFT</ANCHOR> psq~?@wq~sq~ttabSizesq~ti18nsq~xsq~pxsq~uq~ ppppppppppxsq~'pq~2wxuq~-sq~/q~Dq~2wxq~2w"xpq~2sq~uq~ ppppppppppxpppxq~xtSELECT * FROM v$databaseq~sq~sq~uq~ sq~sq~uq~tNAMEt234sq~pppsq~@@@pppsq~pppt1q~Ssq~A ptArialxtNAtNt ##########t dd-MMM-yyyyq~7sq~A pq~WxtNametDEFAULTtYpppxsq~uq~ ppppppppppxq~Jpppppppppxsq~6sq~8sq~(uq~(tDynamic Memory Poolsq~>t100tManualt300t 1-JAN-1990tYsq~pppq~q~t1q~q~Sq~ q~kq~!q~"q~#t dd-MMM-yyyyt #########tq31q~Sq~'q~(tappst No_PatterntQLETsq~pppsq~ppptXXDBNAMEq~[tAuthor,Description etctNq~mtDEFAULTq~kq~xq~xsq~48pq~Usq~Vpq~zpxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~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~psq~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~q~wxq~wxpq~sq~uq~ ppppppppppxpppxq~xxtZSELECT name, value FROM v$parameter WHERE SUBSTR(name, 1, 1) = '_' ORDER BY nameq~sq~Esq~6UVsq~8psq~uq~(tTop Concurrent Programsq~>t15tBartProgramst Time(Mins)tManualt1440sq~pppsq~A@ ptArialxsq~ppptYtg92tNtappst02. Oracle ERPtGletq~[q~q~tVerticalt30q~sq~A ptArialxt##.#q~t150tAUTOq~ sq~48pq~Usq~Vpq~pxsq~Yt Text Cursorpuq~\sq~^sq~bw ?@q~fxsq~^sq~bw ?@q~ixppq~kq~msq~nq~pq~qq~rppppppq~ssq~tq~ssq~tq~ssq~t ' 'q~ssq~tq~ssq~t t tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~tq~ssq~t q~ssq~tq~ssq~tq~ssq~tq~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~psq~ppxuq~pppppxA(psq~pwxppsq~sq~q~wxwxpsq~pxpppwxpppppppppppsq~sq~sq~ sq~pxq~wtdefaultsq~ sq~pxq~wq~q~xxxsq~ #uq~$//<ANCHOR>p32=TOPLEFT,p33=TOPLEFT,p34=TOPLEFT,g94=TOPRIGHT,g97=BOTTOMLEFT,g105=BOTTOMRIGHT,q99=TOPRIGHT</ANCHOR> 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.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(true); barRenderer.setOutlinePaint(Color.yellow); barRenderer.setOutlineStroke(new BasicStroke(1.5f, BasicStroke.JOIN_ROUND, BasicStroke.JOIN_BEVEL)); barRenderer.setGradientPaintTransformer( new StandardGradientPaintTransformer( GradientPaintTransformType.HORIZONTAL)); GradientPaint gp0 = new GradientPaint( 0.0f, 0.0f, Color.YELLOW, 0.0f, 500.0f,new Color(200,0,0,100) ); 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); float h = displayFrame.getHeight(); float w = displayFrame.getWidth(); // GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.WHITE, h, w, Color.red.brighter().brighter()); // plot.setBackgroundPaint(gradientPaint); chart.setBackgroundPaint(new GradientPaint(0,0,Color.black ,0,displayFrame.getHeight(), Color.red)); CategoryAxis domainAxis = plot.getDomainAxis(); domainAxis.setLabelPaint(Color.white); domainAxis.setTickLabelPaint(Color.white); domainAxis.setTickLabelFont(new Font("Arial",Font.BOLD,11)); chart.getTitle().setPaint(Color.white); NumberAxis rangeAxis = (NumberAxis) plot.getRangeAxis(); rangeAxis.setTickLabelPaint(Color.WHITE); rangeAxis.setTickLabelFont(new Font("Arial",Font.BOLD,12)); rangeAxis.setLabelPaint(Color.white); psq~?@wq~sq~ti18nsq~ttabSizesq~xsq~pxsq~/uq~Psq~/sq~'pq~wx./uq~-Rq~sq~