Oracle-L: How to use these MTS TUning Scripts

From: Bunyamin Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Thu, 04 Jul 2002 04:58:17 -0800
Message-ID: <F001.0048FC0A.20020704045817@fatcity.com>

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: bunyamink_at_havelsan.com.tr

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: ListGuru_at_fatcity.com (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). Received on Thu Jul 04 2002 - 07:58:17 CDT