christopherdtaylor1994

Load Profile
~~~~~~~~~~~~                            Per Second       Per Transaction
                                   ---------------       ---------------
                  Redo size:          1,451,121.63            272,624.47

Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Redo NoWait %:   99.84

christopherdtaylor1994

Sorted by Avg Buf Wt(ms) DESC
------------------------------
Tablespace      Reads     AvReads/s     AvRd(ms)     AvBlks/Rd     Writes     AvWrites/s     BufferWaits     AvBufWt(ms)
ADSB_DATA02     2,822,748     5         5.21           1.26        1,151,714     2             37             32.7
ADSA_DATA02     4,783,131     8         6.38           1.26        2,130,339     4             134            31.72
ADSA_DATA05     728,786       1         113.18         28.65       15,453        0             333            30.84
ADSA_DATA01     229,664       0         523.98         56.01       245           0             52             30.77
ADSB_DATA05     276,904       0         72.41          9.77        6,745         0             266            30.75

Sorted by Buffer Waits Desc

christopherdtaylor1994

TNSNAMES.ORA (on client)
-------------------------

LISTENERS_DBNAME1 =
  (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.01)(PORT = 1599))  ---node1 vip
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.02)(PORT = 1599))  ---node2 vip
    (ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.xx.03)(PORT = 1599))  ---node3 vip
  )

christopherdtaylor1994

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Id  | Operation                   | Name                           | Starts | E-Rows |E-Bytes|E-Temp | Cost (%CPU)| E-Time   | Pstart| Pstop | A-Rows |   A-Time   | Buffers | Reads  |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|   1 |  TABLE ACCESS BY INDEX ROWID| MON_ACCOUNT_PAYER_CALC_SERVICE |      1 |      2 |    54 |       |     4   (0)| 00:00:01 |       |       |    197K|00:00:25.93 |     496K|   2307 |
|   2 |   NESTED LOOPS              |                                |      1 |    300K|    24M|       |   800K  (1)| 00:59:39 |       |       |    358K|00:30:08.52 |     375K|   2225 |
|*  3 |    HASH JOIN RIGHT SEMI     |                                |      1 |    163K|  9392

christopherdtaylor1994

SELECT /*+ gather_plan_statistics QB_NAME(OUTER_QUERY) INDEX(MAPCS, MAPY_CALC_SVC_PERF1) */
       MAPCS.ID,
       MA.ORG_ID_PROVIDER,
       MAPCS.MON_ACCT_PAYER_CALC_SUMMARY_ID,
       MAPCS.CE_SERVICE_ID
FROM
       concuity.MON_ACCOUNT MA,
       concuity.MON_ACCOUNT_PAYER MAPY,
       concuity.MON_ACCOUNT_PAYER_CALC_LATEST MAPC,
       concuity.MON_ACCOUNT_PAYER_CALC_SERVICE MAPCS

christopherdtaylor1994

SELECT /*+ gather_plan_statistics QB_NAME(OUTER_QUERY) */
       MAPCS.ID,
       MA.ORG_ID_PROVIDER,
       MAPCS.MON_ACCT_PAYER_CALC_SUMMARY_ID,
       MAPCS.CE_SERVICE_ID
FROM
       concuity.MON_ACCOUNT MA,
       concuity.MON_ACCOUNT_PAYER MAPY,
       concuity.MON_ACCOUNT_PAYER_CALC_LATEST MAPC,
       concuity.MON_ACCOUNT_PAYER_CALC_SERVICE MAPCS