From:
<chr...@be...> - 2008-01-28 17:33:46
|
Hi, during my test I found that some results in the Server Tuning section are wrong for Oracle 10 DBs because the statistcs# value has changed from Oracle 9i to Oracle 10g. E.g. the Indicator for database buffer quality showed results like -90,000. If added the code below to totuning.cpp which should give correct results for Oracle 10G too. I've done a compile on my Linux box and at a first glance everything seems to work fine. Can someone integrate this into SVN? Christoph Index: /home/kuem01/.eclipse/tora-1.4/tora/src/totuning.cpp =================================================================== --- /home/kuem01/.eclipse/tora-1.4/tora/src/totuning.cpp (revision 2485) +++ /home/kuem01/.eclipse/tora-1.4/tora/src/totuning.cpp (working copy) @@ -181,6 +181,13 @@ "Data buffer cache hit ratio (%). > 60% - 70%", "0800"); +static toSQL SQLDataCache10("toTuning:Indicators:Important ratios:3DataCache", + "SELECT (1-SUM(DECODE(statistic#,54,value,0))/SUM(DECODE(statistic#,47,value,50,value,0)))*100,' %'\n" + " FROM v$sysstat\n" + " WHERE statistic# IN (47,50,54)", + "", + "1000"); + static toSQL SQLDataCache9("toTuning:Indicators:Important ratios:3DataCache", "SELECT (1-SUM(DECODE(statistic#,42,value,0))/SUM(DECODE(statistic#,40,value,41,value,0)))*100,' %'\n" " FROM v$sysstat\n" @@ -200,6 +207,11 @@ "Redo log space requests. Close to 0", "0800"); +static toSQL SQLLogRedo10("toTuning:Indicators:Redo log contention:1LogSpace", + "select value from v$sysstat where statistic# = 141", + "", + "1000"); + static toSQL SQLLogRedo9("toTuning:Indicators:Redo log contention:1LogSpace", "select value from v$sysstat where statistic# = 122", "", @@ -217,6 +229,13 @@ "System undo header waits (%). < 1%", "0800"); +static toSQL SQLSystemHeadUndo10("toTuning:Indicators:RBS contention:1SystemHeadUndo", + "SELECT count/blocks*100,' %'\n" + " FROM (SELECT MAX(count) count FROM v$waitstat WHERE class = 'system undo header') a,\n" + " (SELECT SUM(value) blocks FROM v$sysstat WHERE statistic# IN (47,50)) b", + "", + "1000"); + static toSQL SQLSystemHeadUndo9("toTuning:Indicators:RBS contention:1SystemHeadUndo", "SELECT count/blocks*100,' %'\n" " FROM (SELECT MAX(count) count FROM v$waitstat WHERE class = 'system undo header') a,\n" @@ -238,6 +257,13 @@ "System undo block waits (%). < 1%", "0800"); +static toSQL SQLSystemBlockUndo10("toTuning:Indicators:RBS contention:2SystemBlockUndo", + "SELECT count/blocks*100,' %'\n" + " FROM (SELECT MAX(count) count FROM v$waitstat WHERE class = 'system undo block') a,\n" + " (SELECT SUM(value) blocks FROM v$sysstat WHERE statistic# IN (47,50)) b", + "", + "1000"); + static toSQL SQLSystemBlockUndo9("toTuning:Indicators:RBS contention:2SystemBlockUndo", "SELECT count/blocks*100,' %'\n" " FROM (SELECT MAX(count) count FROM v$waitstat WHERE class = 'system undo block') a,\n" @@ -259,6 +285,13 @@ "Undo head waits (%). < 1%", "0800"); +static toSQL SQLHeadUndo10("toTuning:Indicators:RBS contention:3HeadUndo", + "SELECT count/blocks*100,' %'\n" + " FROM (SELECT MAX(count) count FROM v$waitstat WHERE class = 'undo header') a,\n" + " (SELECT SUM(value) blocks FROM v$sysstat WHERE statistic# IN (47,50)) b", + "", + "1000"); + static toSQL SQLHeadUndo9("toTuning:Indicators:RBS contention:3HeadUndo", "SELECT count/blocks*100,' %'\n" " FROM (SELECT MAX(count) count FROM v$waitstat WHERE class = 'undo header') a,\n" @@ -280,6 +313,13 @@ "Undo block waits (%). < 1%", "0800"); +static toSQL SQLBlockUndo10("toTuning:Indicators:RBS contention:4BlockUndo", + "SELECT count/blocks*100,' %'\n" + " FROM (SELECT MAX(count) count FROM v$waitstat WHERE class = 'undo block') a,\n" + " (SELECT SUM(value) blocks FROM v$sysstat WHERE statistic# IN (47,50)) b", + "", + "1000"); + static toSQL SQLBlockUndo9("toTuning:Indicators:RBS contention:4BlockUndo", "SELECT count/blocks*100,' %'\n" " FROM (SELECT MAX(count) count FROM v$waitstat WHERE class = 'undo block') a,\n" @@ -329,6 +369,15 @@ "Generate chart of physical I/O of database.", "0800"); +static toSQL SQLChartsPhysical10("toTuning:Charts:1BBPhysical I/O", + "select SYSDATE,\n" + " sum(decode(statistic#,42,value,0)) \"Physical reads\",\n" + " sum(decode(statistic#,46,value,0)) \"Physical writes\",\n" + " sum(decode(statistic#,119,value,0)) \"Redo writes\"\n" + " from v$sysstat where statistic# in (54,62,138)", + "", + "1000"); + static toSQL SQLChartsPhysical9("toTuning:Charts:1BBPhysical I/O", "select SYSDATE,\n" " sum(decode(statistic#,42,value,0)) \"Physical reads\",\n" @@ -357,6 +406,16 @@ "Generate chart of physical I/O of database.", "0800"); +static toSQL SQLChartsLogical10("toTuning:Charts:2BBLogical I/O", + "select SYSDATE,\n" + " sum(decode(statistic#,47,value,0)) \"Block gets\",\n" + " sum(decode(statistic#,50,value,0)) \"Consistent gets\",\n" + " sum(decode(statistic#,59,value,0)) \"Block changes\",\n" + " sum(decode(statistic#,60,value,0)) \"Consistent changes\"\n" + " from v$sysstat where statistic# in (47,50,59,60)", + "", + "1000"); + static toSQL SQLChartsLogical9("toTuning:Charts:2BBLogical I/O", "select SYSDATE,\n" " sum(decode(statistic#,40,value,0)) \"Block gets\",\n" @@ -471,6 +530,18 @@ "don't correspond exactly to the column data in the chart. Each group of two are divided with each other before drawn.", "0800"); +static toSQL SQLChartsCacheMisses10("toTuning:Charts:5CPCache misses", + "select sysdate,\n" + " pread \"Data buffer cache\",read \"Dictionary row cache\",\n" + " getmiss \"Library cache\",gets \" \",\n" + " reloads \" \",pins \" \"\n" + " from (select 100*SUM(DECODE(statistic#,54,value,0)) pread,SUM(DECODE(statistic#,47,value,50,value,0)) read\n" + " from v$sysstat where statistic# IN (47,50,54)) \"Data buffer cache\",\n" + " (select 100*sum(getmisses) getmiss,sum(gets) gets from v$rowcache) \"Dictionary row cache\",\n" + " (select 100*sum(reloads) reloads,sum(pins) pins from v$librarycache) \"Library cache\"\n", + "", + "1000"); + static toSQL SQLChartsCacheMisses9("toTuning:Charts:5CPCache misses", "select sysdate,\n" " pread \"Data buffer cache\",read \"Dictionary row cache\",\n" @@ -503,6 +574,14 @@ "Used to generate chart for redo I/O statistics.", "0800"); +static toSQL SQLChartsRedo10("toTuning:Charts:7BSRedo log I/O", + "select SYSDATE,\n" + " sum(decode(statistic#,134,value,0))/:unit<int> \"Redo size\",\n" + " sum(decode(statistic#,136,value,0))/:unit<int> \"Redo wastage\"\n" + " from v$sysstat where statistic# in (134,136)", + "", + "1000"); + static toSQL SQLChartsRedo9("toTuning:Charts:7BSRedo log I/O", "select SYSDATE,\n" " sum(decode(statistic#,115,value,0))/:unit<int> \"Redo size\",\n" @@ -510,7 +589,6 @@ " from v$sysstat where statistic# in (115,117)", "", "0900"); - static toSQL SQLChartsRedo7("toTuning:Charts:7BSRedo log I/O", "select SYSDATE,\n" " sum(decode(statistic#,85,value,0))/:unit<int> \"Redo size\",\n" @@ -536,6 +614,13 @@ "Buffer hitrate", "0800"); +static toSQL SQLOverviewBufferHit10("toTuning:Overview:BufferHit", + "SELECT SYSDATE,(1-SUM(DECODE(statistic#,54,value,0))/SUM(DECODE(statistic#,47,value,50,value,0)))*100\n" + " FROM v$sysstat\n" + " WHERE statistic# IN (47,50,54)", + "", + "1000"); + static toSQL SQLOverviewBufferHit9("toTuning:Overview:BufferHit", "SELECT SYSDATE,(1-SUM(DECODE(statistic#,42,value,0))/SUM(DECODE(statistic#,40,value,41,value,0)))*100\n" " FROM v$sysstat\n" @@ -556,9 +641,15 @@ "Bytes sent to client", "0800"); +static toSQL SQLOverviewClientInput10("toTuning:Overview:ClientInput", + "select sysdate,value/:f1<int>\n" + " from v$sysstat where statistic# = 338", + "", + "1000"); + static toSQL SQLOverviewClientInput9("toTuning:Overview:ClientInput", "select sysdate,value/:f1<int>\n" - " from v$sysstat where statistic# = 223", + " from v$sysstat where statistic# = 244", "", "0900"); @@ -574,9 +665,15 @@ "Bytes sent from client", "0800"); +static toSQL SQLOverviewClientOutput10("toTuning:Overview:ClientOutput", + "select sysdate,value/:f1<int>\n" + " from v$sysstat where statistic# = 339", + "", + "1000"); + static toSQL SQLOverviewClientOutput9("toTuning:Overview:ClientOutput", "select sysdate,value/:f1<int>\n" - " from v$sysstat where statistic# = 224", + " from v$sysstat where statistic# = 245", "", "0900"); @@ -592,9 +689,15 @@ "Execute count", "0800"); +static toSQL SQLOverviewExecute10("toTuning:Overview:Execute", + "select sysdate,value\n" + " from v$sysstat where statistic# = 337", + "", + "1000"); + static toSQL SQLOverviewExecute9("toTuning:Overview:Execute", "select sysdate,value\n" - " from v$sysstat where statistic# = 222", + " from v$sysstat where statistic# = 243", "", "0900"); @@ -610,9 +713,15 @@ "Parse count", "0800"); +static toSQL SQLOverviewParse10("toTuning:Overview:Parse", + "select sysdate,value\n" + " from v$sysstat where statistic# = 333", + "", + "1000"); + static toSQL SQLOverviewParse9("toTuning:Overview:Parse", "select sysdate,value\n" - " from v$sysstat where statistic# = 219", + " from v$sysstat where statistic# = 240", "", "0900"); @@ -628,6 +737,12 @@ "Redo entries", "0800"); +static toSQL SQLOverviewRedoEntries10("toTuning:Overview:RedoEntries", + "select sysdate,value\n" + " from v$sysstat where statistic# = 133", + "", + "1000"); + static toSQL SQLOverviewRedoEntries9("toTuning:Overview:RedoEntries", "select sysdate,value\n" " from v$sysstat where statistic# = 114", @@ -646,6 +761,12 @@ "Redo blocks written", "0800"); +static toSQL SQLOverviewRedoBlocks10("toTuning:Overview:RedoBlocks", + "select sysdate,value\n" + " from v$sysstat where statistic# = 139", + "", + "1000"); + static toSQL SQLOverviewRedoBlocks9("toTuning:Overview:RedoBlocks", "select sysdate,value\n" " from v$sysstat where statistic# = 120", @@ -664,6 +785,12 @@ "Blocks read", "0800"); +static toSQL SQLOverviewLogicalRead10("toTuning:Overview:LogicalRead", + "select sysdate,sum(value)\n" + " from v$sysstat where statistic# in (47,50)", + "", + "1000"); + static toSQL SQLOverviewLogicalRead9("toTuning:Overview:LogicalRead", "select sysdate,sum(value)\n" " from v$sysstat where statistic# in (40,41)", @@ -682,6 +809,12 @@ "Blocks written", "0800"); +static toSQL SQLOverviewLogicalWrite10("toTuning:Overview:LogicalWrite", + "select sysdate,sum(value)\n" + " from v$sysstat where statistic# in (59,60)", + "", + "1000"); + static toSQL SQLOverviewLogicalWrite9("toTuning:Overview:LogicalWrite", "select sysdate,sum(value)\n" " from v$sysstat where statistic# in (43,44)", @@ -700,6 +833,12 @@ "Blocks physically read", "0800"); +static toSQL SQLOverviewPhysicalRead10("toTuning:Overview:PhysicalRead", + "select sysdate,value\n" + " from v$sysstat where statistic# = 54", + "", + "1000"); + static toSQL SQLOverviewPhysicalRead9("toTuning:Overview:PhysicalRead", "select sysdate,value\n" " from v$sysstat where statistic# = 42", @@ -718,6 +857,12 @@ "Blocks physically written", "0800"); +static toSQL SQLOverviewPhysicalWrite10("toTuning:Overview:PhysicalWrite", + "select sysdate,value\n" + " from v$sysstat where statistic# = 62", + "", + "1000"); + static toSQL SQLOverviewPhysicalWrite9("toTuning:Overview:PhysicalWrite", "select sysdate,value\n" " from v$sysstat where statistic# = 46", |
From: Neulinger, N. <nn...@ms...> - 2008-01-28 22:28:55
|
Please resend as an attachment, and I'll get it committed. Patch is = malformed due to sending inline. -- Nathan ------------------------------------------------------------ Nathan Neulinger nn...@ms... Missouri S&T Information Technology (573) 341-6679 System Administrator - Principal =20 > -----Original Message----- > From: Christoph K=FCmmel-Schulte [mailto:christoph.kuemmel- > sc...@be...] > Sent: Monday, January 28, 2008 11:34 AM > To: Neulinger, Nathan; Mike Johnson > Cc: tor...@li... > Subject: Wrong results in Server Tuning >=20 > Hi, >=20 > during my test I found that some results in the Server Tuning > section > are wrong for Oracle 10 DBs because the statistcs# value has > changed > from Oracle 9i to Oracle 10g. E.g. the Indicator for database > buffer > quality showed results like -90,000. >=20 > If added the code below to totuning.cpp which should give correct > results for Oracle 10G too. I've done a compile on my Linux box and > at a > first glance everything seems to work fine. Can someone integrate > this > into SVN? >=20 > Christoph >=20 > Index: /home/kuem01/.eclipse/tora-1.4/tora/src/totuning.cpp > = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D > --- /home/kuem01/.eclipse/tora-1.4/tora/src/totuning.cpp > (revision 2485) > +++ /home/kuem01/.eclipse/tora-1.4/tora/src/totuning.cpp > (working copy) > @@ -181,6 +181,13 @@ > "Data buffer cache hit ratio (%). > 60% > - 70%", > "0800"); >=20 > +static toSQL SQLDataCache10("toTuning:Indicators:Important > ratios:3DataCache", > + "SELECT > (1- > SUM(DECODE(statistic#,54,value,0))/SUM(DECODE(statistic#,47,value,5 > 0,value,0)))*100,' > %'\n" > + " FROM v$sysstat\n" > + " WHERE statistic# IN (47,50,54)", > + "", > + "1000"); > + > static toSQL SQLDataCache9("toTuning:Indicators:Important > ratios:3DataCache", > "SELECT > (1- > SUM(DECODE(statistic#,42,value,0))/SUM(DECODE(statistic#,40,value,4 > 1,value,0)))*100,' > %'\n" > " FROM v$sysstat\n" > @@ -200,6 +207,11 @@ > "Redo log space requests. Close to 0", > "0800"); >=20 > +static toSQL SQLLogRedo10("toTuning:Indicators:Redo log > contention:1LogSpace", > + "select value from v$sysstat where > statistic# > =3D 141", > + "", > + "1000"); > + > static toSQL SQLLogRedo9("toTuning:Indicators:Redo log > contention:1LogSpace", > "select value from v$sysstat where > statistic# > =3D 122", > "", > @@ -217,6 +229,13 @@ > "System undo header waits (%). < > 1%", > "0800"); >=20 > +static toSQL SQLSystemHeadUndo10("toTuning:Indicators:RBS > contention:1SystemHeadUndo", > + "SELECT count/blocks*100,' %'\n" > + " FROM (SELECT MAX(count) count > FROM > v$waitstat WHERE class =3D 'system undo header') a,\n" > + " (SELECT SUM(value) blocks > FROM > v$sysstat WHERE statistic# IN (47,50)) b", > + "", > + "1000"); > + > static toSQL SQLSystemHeadUndo9("toTuning:Indicators:RBS > contention:1SystemHeadUndo", > "SELECT count/blocks*100,' %'\n" > " FROM (SELECT MAX(count) count > FROM > v$waitstat WHERE class =3D 'system undo header') a,\n" > @@ -238,6 +257,13 @@ > "System undo block waits (%). < > 1%", > "0800"); >=20 > +static toSQL SQLSystemBlockUndo10("toTuning:Indicators:RBS > contention:2SystemBlockUndo", > + "SELECT count/blocks*100,' %'\n" > + " FROM (SELECT MAX(count) count > FROM > v$waitstat WHERE class =3D 'system undo block') a,\n" > + " (SELECT SUM(value) blocks > FROM > v$sysstat WHERE statistic# IN (47,50)) b", > + "", > + "1000"); > + > static toSQL SQLSystemBlockUndo9("toTuning:Indicators:RBS > contention:2SystemBlockUndo", > "SELECT count/blocks*100,' %'\n" > " FROM (SELECT MAX(count) count > FROM > v$waitstat WHERE class =3D 'system undo block') a,\n" > @@ -259,6 +285,13 @@ > "Undo head waits (%). < 1%", > "0800"); >=20 > +static toSQL SQLHeadUndo10("toTuning:Indicators:RBS > contention:3HeadUndo", > + "SELECT count/blocks*100,' %'\n" > + " FROM (SELECT MAX(count) count FROM > v$waitstat WHERE class =3D 'undo header') a,\n" > + " (SELECT SUM(value) blocks FROM > v$sysstat WHERE statistic# IN (47,50)) b", > + "", > + "1000"); > + > static toSQL SQLHeadUndo9("toTuning:Indicators:RBS > contention:3HeadUndo", > "SELECT count/blocks*100,' %'\n" > " FROM (SELECT MAX(count) count FROM > v$waitstat WHERE class =3D 'undo header') a,\n" > @@ -280,6 +313,13 @@ > "Undo block waits (%). < 1%", > "0800"); >=20 > +static toSQL SQLBlockUndo10("toTuning:Indicators:RBS > contention:4BlockUndo", > + "SELECT count/blocks*100,' %'\n" > + " FROM (SELECT MAX(count) count FROM > v$waitstat WHERE class =3D 'undo block') a,\n" > + " (SELECT SUM(value) blocks FROM > v$sysstat WHERE statistic# IN (47,50)) b", > + "", > + "1000"); > + > static toSQL SQLBlockUndo9("toTuning:Indicators:RBS > contention:4BlockUndo", > "SELECT count/blocks*100,' %'\n" > " FROM (SELECT MAX(count) count FROM > v$waitstat WHERE class =3D 'undo block') a,\n" > @@ -329,6 +369,15 @@ > "Generate chart of physical I/O of > database.", > "0800"); >=20 > +static toSQL SQLChartsPhysical10("toTuning:Charts:1BBPhysical > I/O", > + "select SYSDATE,\n" > + " > sum(decode(statistic#,42,value,0)) \"Physical reads\",\n" > + " > sum(decode(statistic#,46,value,0)) \"Physical writes\",\n" > + " > sum(decode(statistic#,119,value,0)) \"Redo writes\"\n" > + " from v$sysstat where statistic# > in > (54,62,138)", > + "", > + "1000"); > + > static toSQL SQLChartsPhysical9("toTuning:Charts:1BBPhysical I/O", > "select SYSDATE,\n" > " > sum(decode(statistic#,42,value,0)) \"Physical reads\",\n" > @@ -357,6 +406,16 @@ > "Generate chart of physical I/O of > database.", > "0800"); >=20 > +static toSQL SQLChartsLogical10("toTuning:Charts:2BBLogical I/O", > + "select SYSDATE,\n" > + " > sum(decode(statistic#,47,value,0)) \"Block gets\",\n" > + " > sum(decode(statistic#,50,value,0)) \"Consistent gets\",\n" > + " > sum(decode(statistic#,59,value,0)) \"Block changes\",\n" > + " > sum(decode(statistic#,60,value,0)) \"Consistent changes\"\n" > + " from v$sysstat where statistic# > in > (47,50,59,60)", > + "", > + "1000"); > + > static toSQL SQLChartsLogical9("toTuning:Charts:2BBLogical I/O", > "select SYSDATE,\n" > " > sum(decode(statistic#,40,value,0)) \"Block gets\",\n" > @@ -471,6 +530,18 @@ > "don't correspond exactly to the > column data in the chart. Each group of two are divided with each > other > before drawn.", > "0800"); >=20 > +static toSQL SQLChartsCacheMisses10("toTuning:Charts:5CPCache > misses", > + "select sysdate,\n" > + " pread \"Data buffer > cache\",read \"Dictionary row cache\",\n" > + " getmiss \"Library > cache\",gets \" \",\n" > + " reloads \" \",pins \" > \"\n" > + " from (select > 100*SUM(DECODE(statistic#,54,value,0)) > pread,SUM(DECODE(statistic#,47,value,50,value,0)) read\n" > + " from v$sysstat where > statistic# IN (47,50,54)) \"Data buffer cache\",\n" > + " (select > 100*sum(getmisses) > getmiss,sum(gets) gets from v$rowcache) \"Dictionary row > cache\",\n" > + " (select > 100*sum(reloads) > reloads,sum(pins) pins from v$librarycache) \"Library cache\"\n", > + "", > + "1000"); > + > static toSQL SQLChartsCacheMisses9("toTuning:Charts:5CPCache > misses", > "select sysdate,\n" > " pread \"Data buffer > cache\",read \"Dictionary row cache\",\n" > @@ -503,6 +574,14 @@ > "Used to generate chart for redo I/O > statistics.", > "0800"); >=20 > +static toSQL SQLChartsRedo10("toTuning:Charts:7BSRedo log I/O", > + "select SYSDATE,\n" > + " > sum(decode(statistic#,134,value,0))/:unit<int> \"Redo size\",\n" > + " > sum(decode(statistic#,136,value,0))/:unit<int> \"Redo wastage\"\n" > + " from v$sysstat where statistic# in > (134,136)", > + "", > + "1000"); > + > static toSQL SQLChartsRedo9("toTuning:Charts:7BSRedo log I/O", > "select SYSDATE,\n" > " > sum(decode(statistic#,115,value,0))/:unit<int> \"Redo size\",\n" > @@ -510,7 +589,6 @@ > " from v$sysstat where statistic# in > (115,117)", > "", > "0900"); > - > static toSQL SQLChartsRedo7("toTuning:Charts:7BSRedo log I/O", > "select SYSDATE,\n" > " > sum(decode(statistic#,85,value,0))/:unit<int> \"Redo size\",\n" > @@ -536,6 +614,13 @@ > "Buffer hitrate", > "0800"); >=20 > +static toSQL SQLOverviewBufferHit10("toTuning:Overview:BufferHit", > + "SELECT > SYSDATE,(1- > SUM(DECODE(statistic#,54,value,0))/SUM(DECODE(statistic#,47,value,5 > 0,value,0)))*100\n" > + " FROM v$sysstat\n" > + " WHERE statistic# IN > (47,50,54)", > + "", > + "1000"); > + > static toSQL SQLOverviewBufferHit9("toTuning:Overview:BufferHit", > "SELECT > SYSDATE,(1- > SUM(DECODE(statistic#,42,value,0))/SUM(DECODE(statistic#,40,value,4 > 1,value,0)))*100\n" > " FROM v$sysstat\n" > @@ -556,9 +641,15 @@ > "Bytes sent to client", > "0800"); >=20 > +static toSQL > SQLOverviewClientInput10("toTuning:Overview:ClientInput", > + "select > sysdate,value/:f1<int>\n" > + " from v$sysstat where > statistic# > =3D 338", > + "", > + "1000"); > + > static toSQL > SQLOverviewClientInput9("toTuning:Overview:ClientInput", > "select > sysdate,value/:f1<int>\n" > - " from v$sysstat where > statistic# > =3D 223", > + " from v$sysstat where > statistic# > =3D 244", > "", > "0900"); >=20 > @@ -574,9 +665,15 @@ > "Bytes sent from client", > "0800"); >=20 > +static toSQL > SQLOverviewClientOutput10("toTuning:Overview:ClientOutput", > + "select > sysdate,value/:f1<int>\n" > + " from v$sysstat where > statistic# =3D 339", > + "", > + "1000"); > + > static toSQL > SQLOverviewClientOutput9("toTuning:Overview:ClientOutput", > "select > sysdate,value/:f1<int>\n" > - " from v$sysstat where > statistic# =3D 224", > + " from v$sysstat where > statistic# =3D 245", > "", > "0900"); >=20 > @@ -592,9 +689,15 @@ > "Execute count", > "0800"); >=20 > +static toSQL SQLOverviewExecute10("toTuning:Overview:Execute", > + "select sysdate,value\n" > + " from v$sysstat where > statistic# =3D 337", > + "", > + "1000"); > + > static toSQL SQLOverviewExecute9("toTuning:Overview:Execute", > "select sysdate,value\n" > - " from v$sysstat where > statistic# =3D 222", > + " from v$sysstat where > statistic# =3D 243", > "", > "0900"); >=20 > @@ -610,9 +713,15 @@ > "Parse count", > "0800"); >=20 > +static toSQL SQLOverviewParse10("toTuning:Overview:Parse", > + "select sysdate,value\n" > + " from v$sysstat where statistic# > =3D 333", > + "", > + "1000"); > + > static toSQL SQLOverviewParse9("toTuning:Overview:Parse", > "select sysdate,value\n" > - " from v$sysstat where statistic# > =3D 219", > + " from v$sysstat where statistic# > =3D 240", > "", > "0900"); >=20 > @@ -628,6 +737,12 @@ > "Redo entries", > "0800"); >=20 > +static toSQL > SQLOverviewRedoEntries10("toTuning:Overview:RedoEntries", > + "select sysdate,value\n" > + " from v$sysstat where > statistic# > =3D 133", > + "", > + "1000"); > + > static toSQL > SQLOverviewRedoEntries9("toTuning:Overview:RedoEntries", > "select sysdate,value\n" > " from v$sysstat where > statistic# > =3D 114", > @@ -646,6 +761,12 @@ > "Redo blocks written", > "0800"); >=20 > +static toSQL > SQLOverviewRedoBlocks10("toTuning:Overview:RedoBlocks", > + "select sysdate,value\n" > + " from v$sysstat where > statistic# > =3D 139", > + "", > + "1000"); > + > static toSQL > SQLOverviewRedoBlocks9("toTuning:Overview:RedoBlocks", > "select sysdate,value\n" > " from v$sysstat where > statistic# > =3D 120", > @@ -664,6 +785,12 @@ > "Blocks read", > "0800"); >=20 > +static toSQL > SQLOverviewLogicalRead10("toTuning:Overview:LogicalRead", > + "select sysdate,sum(value)\n" > + " from v$sysstat where > statistic# > in (47,50)", > + "", > + "1000"); > + > static toSQL > SQLOverviewLogicalRead9("toTuning:Overview:LogicalRead", > "select sysdate,sum(value)\n" > " from v$sysstat where > statistic# > in (40,41)", > @@ -682,6 +809,12 @@ > "Blocks written", > "0800"); >=20 > +static toSQL > SQLOverviewLogicalWrite10("toTuning:Overview:LogicalWrite", > + "select > sysdate,sum(value)\n" > + " from v$sysstat where > statistic# in (59,60)", > + "", > + "1000"); > + > static toSQL > SQLOverviewLogicalWrite9("toTuning:Overview:LogicalWrite", > "select > sysdate,sum(value)\n" > " from v$sysstat where > statistic# in (43,44)", > @@ -700,6 +833,12 @@ > "Blocks physically read", > "0800"); >=20 > +static toSQL > SQLOverviewPhysicalRead10("toTuning:Overview:PhysicalRead", > + "select sysdate,value\n" > + " from v$sysstat where > statistic# =3D 54", > + "", > + "1000"); > + > static toSQL > SQLOverviewPhysicalRead9("toTuning:Overview:PhysicalRead", > "select sysdate,value\n" > " from v$sysstat where > statistic# =3D 42", > @@ -718,6 +857,12 @@ > "Blocks physically written", > "0800"); >=20 > +static toSQL > SQLOverviewPhysicalWrite10("toTuning:Overview:PhysicalWrite", > + "select sysdate,value\n" > + " from v$sysstat where > statistic# =3D 62", > + "", > + "1000"); > + > static toSQL > SQLOverviewPhysicalWrite9("toTuning:Overview:PhysicalWrite", > "select sysdate,value\n" > " from v$sysstat where > statistic# =3D 46", |
From:
<chr...@be...> - 2008-01-28 22:34:07
Attachments:
tuning.patch
|
Hi Nathan, here's the patch. Christoph |