D
dbeavon
Guest
Keith/George, Secret menus? I'm not a DBA, and have little experience with the OE database at this level. Anyway, I found it. For those of us who don't know the deep secrets, its like so: From: pugchallenge.org/.../332_debghb_v2.pptx Start promon Enter: R&D (also works in lower case starting in V10) Enter: debghb You have now entered the debghb “zone” Two main differences in the world of debghb Extensions to some existing R&D screens Enables access to “This menu is not here Menu” Enter: “6” even though there is no visible option 6 See next slide ------------ Anyway here is the screen I used to see my transaction thruput and the latch waits. (Notice that I have a real heavy workload where index data maintenance is concerned. I think half our indexes aren't even used so it kind of annoys me...) 03/08/16 Activity: Performance Indicators 10:44:54 03/08/16 10:44 to 03/08/16 10:44 (10 sec) Total Per Min Per Sec Per Tx Commits 4427 26562 442.70 1.00 Undos 0 0 0.00 0.00 Index operations 136291 817746 13629.10 30.79 Record operations 36843 221058 3684.30 8.32 Total o/s i/o 10977 65862 1097.70 2.48 Total o/s reads 3071 18426 307.10 0.69 Total o/s writes 7906 47436 790.60 1.79 Background o/s writes 7718 46308 771.80 1.74 Partial log writes 3 18 0.30 0.00 Database extends 0 0 0.00 0.00 Total waits 2966 17796 296.60 0.67 Lock waits 0 0 0.00 0.00 Resource waits 2966 17796 296.60 0.67 Latch timeouts 1735 10410 173.50 0.39 ===================================== More on indexes.... 03/08/16 Activity: Index 10:45:21 03/08/16 10:45 to 03/08/16 10:45 (10 sec) Total Per Min Per Sec Per Tx Find index entry 17776 106656 1777.60 4.24 Create index entry 0 0 0.00 0.00 Delete index entry 111143 666858 11114.30 26.53 Remove locked entry 0 0 0.00 0.00 Split block 0 0 0.00 0.00 Free block 29 174 2.90 0.01 ================================ Finally the latches: 03/08/16 Activity: Latch Times 11:17:45 03/08/16 11:17 to 03/08/16 11:17 (10 sec) Locks Lk usec Wt usec Lk usec Wt usec /Sec /Lock /Lock /Sec /Sec MTX 15888 0 0 0 0 USR 0 0 0 0 0 OM 14611 0 0 0 0 BIB 15782 0 0 0 0 SCH 0 0 0 0 0 LKP 6658 0 0 0 0 GST 0 0 0 0 0 TXT 1408 0 0 0 0 LKT 5253 0 0 0 0 LKT 5209 0 0 0 0 LKT 5273 0 0 0 0 LKT 5317 0 0 0 0 SEQ 0 0 0 0 0 AIB 0 0 0 0 0 TXQ 20439 0 0 0 0 =========================================== counts: 03/08/16 Activity: Latch Counts 11:21:57 03/06/16 02:08 to 03/08/16 11:21 (57 hrs 13 min) ----- Locks ----- ------ Busy ------ Naps - --------- Spins ----------- ----- Nap Max ----- Owner Total /Sec /Sec Pct /Sec / Sec /Lock /Busy Total HWM MTX -- 712129433 3457 0 0.0 28 13 051 3 3234870 138 250 USR -- 194110 0 0 0.0 0 0 0 0 0 0 OM -- 1347954788 6544 0 0.0 0 1 858 0 1867741 370 10 BIB -- 699531877 3396 0 0.0 0 1 384 0 1926612 35 250 SCH -- 370730 1 0 0.0 0 0 0 0 0 0 LKP -- 286422796 1390 0 0.0 0 102 0 18128 110 10 GST -- 253893 1 0 0.0 0 0 0 0 0 0 TXT -- 102473565 497 0 0.0 0 3 0 218623 1 10 LKT -- 314458151 1526 0 0.0 0 0 0 621 39 10 LKT -- 271685318 1319 0 0.0 0 0 0 464 14 10 LKT -- 255297769 1239 0 0.0 0 0 0 400 1 20 LKT -- 253810487 1232 0 0.0 0 0 0 431 44 10 SEQ -- 129452 0 0 0.0 0 0 0 0 0 0 AIB -- 39067 0 0 0.0 0 0 0 0 0 0 TXQ -- 896593025 4352 0 0.0 6 994 0 171644 1 40 Enter for more, A, L, R, S, U, Z, P, T, or X (? for help): 03/08/16 Activity: Latch Counts 11:22:00 03/06/16 02:08 to 03/08/16 11:21 (57 hrs 13 min) ----- Locks ----- ------ Busy ------ Naps - --------- Spins ----------- ----- Nap Max ----- Owner Total /Sec /Sec Pct /Sec / Sec /Lock /Busy Total HWM EC -- 0 0 0 0.0 0 0 0 0 0 0 LKF -- 690158906 3350 0 0.0 0 365 0 171000 81 10 BFP -- 2 0 0 0.0 0 0 0 0 0 0 BHT -- 7093100330 34437 0 0.0 0 2 295 0 31513724 491 10 PWQ -- 408399 1 0 0.0 0 0 0 0 0 0 CPQ -- 34280260 166 0 0.0 0 0 0 11073 0 0 LRU -- 6465601420 31390 0 0.0 1 4 811 0 69780 874 10 LRU -- 376621493 1828 0 0.0 0 0 0 0 0 0 BUF -- 3519010800 17084 0 0.0 0 8 525 0 3850820 3 20 BUF -- 3615680361 17554 0 0.0 2 17 875 1 39168405 14 20 BUF -- 3579977569 17380 0 0.0 3 3 003 0 2850957 69 20 BUF -- 3553969436 17254 0 0.0 3 4 998 0 14921600 2 40 INC -- 0 0 0 0.0 0 0 0 0 0 0 L29 -- 0 0 0 0.0 0 0 0 0 0 0 L30 -- 0 0 0 0.0 0 0 0 0 0 0 L31 -- 0 0 0 0.0 0 0 0 0 0 0
Continue reading...
Continue reading...
