How can I use these scripts below to tune MTS ? Bunyamin SQL> select paddr,type,queued,wait,totalq, 2 decode(totalq,0,0,wait/totalq) "AVG WAIT" from v$queue;
PADDR TYPE QUEUED WAIT TOTALQ AVG WAIT -------- ---------- ---------- ---------- ---------- ---------- 00 COMMON 0 13158 5196771 ,002531957 140E11EC DISPATCHER 0 136409 548604 ,248647476 140E1514 DISPATCHER 0 178022 977429 ,182132922 140E183C DISPATCHER 0 438185 2406714 ,182067749 140E1B64 DISPATCHER 0 277110 1054844 ,262702352 140E1E8C DISPATCHER 0 146121 671815 ,217501842 SQL> select name "NAME", paddr,requests, 2 (busy/(busy + idle)) * 100 "%TIME BUSY" from v$shared_server; NAME PADDR REQUESTS %TIME BUSY ---- -------- ---------- ---------- S000 140DD2CC 2004637 15,3597284 S001 140DD5F4 1380026 9,76323755 S002 140DD91C 862050 5,642241 S003 140DDC44 532685 2,77508729 S004 140DDF6C 261459 1,34762108 S005 140DE294 107879 ,521803133 S006 140DE5BC 35905 ,227110307 S007 140DE8E4 14320 ,102182328 S008 140DEC0C 4316 ,04232294 S009 140DEF34 1527 ,013207575 S010 140DF25C 436 ,006863212 NAME PADDR REQUESTS %TIME BUSY ---- -------- ---------- ---------- S011 140DF584 40 ,006196229 S012 140DF8AC 9 ,004030979 S013 140DFBD4 8 ,003254756 S014 140DFEFC 5 ,001988269 S015 140E0224 9 ,00106223 S016 140E054C 5 ,000068091 S017 140E0874 5 ,000136184 S018 140E0B9C 5 ,000027237 S019 140E0EC4 7 ,000068092 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
