Skip to content

Instantly share code, notes, and snippets.

@christopherdtaylor1994

christopherdtaylor1994/gist:3879343

Created October 12, 2012 14:06
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save christopherdtaylor1994/3879343 to your computer and use it in GitHub Desktop.
Save christopherdtaylor1994/3879343 to your computer and use it in GitHub Desktop.
Download ZIP
SQL with adjusted _OPTIMIZER_MAX_PERMUTATIONS,
Raw
gistfile1.txt
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| 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| 9392K| 5656K| 148K (1)| 00:11:02 | | | 161K|00:00:18.73 | 51970 | 2225 |
| 4 | PARTITION LIST SINGLE | | 1 | 222K| 3041K| | 2265 (1)| 00:00:11 | KEY | KEY | 228K|00:00:00.23 | 1924 | 0 |
|* 5 | TABLE ACCESS FULL | WQ_ORG_ACCOUNT | 1 | 222K| 3041K| | 2265 (1)| 00:00:11 | KEY | KEY | 228K|00:00:00.01 | 1924 | 0 |
|* 6 | HASH JOIN | | 1 | 163K| 7164K| 9512K| 140K (1)| 00:10:30 | | | 161K|00:00:17.98 | 50046 | 2225 |
|* 7 | HASH JOIN | | 1 | 243K| 6654K| | 57572 (1)| 00:04:18 | | | 245K|00:00:03.64 | 16189 | 0 |
| 8 | PARTITION LIST SINGLE | | 1 | 80157 | 1095K| | 4974 (1)| 00:00:23 | KEY | KEY | 80480 |00:00:00.40 | 4199 | 0 |
|* 9 | TABLE ACCESS FULL | MON_ACCOUNT | 1 | 80157 | 1095K| | 4974 (1)| 00:00:23 | KEY | KEY | 80480 |00:00:00.24 | 4199 | 0 |
| 10 | VIEW | index$_join$_002 | 1 | 1935K| 25M| | 52570 (1)| 00:03:55 | | | 1954K|00:00:08.40 | 11990 | 0 |
|* 11 | HASH JOIN | | 1 | | | | | | | | 1954K|00:00:08.40 | 11990 | 0 |
| 12 | INDEX FAST FULL SCAN| MON_ACCT_PAYER_FK_MON_ACCT | 1 | 1935K| 25M| | 9196 (1)| 00:00:42 | | | 1954K|00:00:00.01 | 7572 | 0 |
| 13 | INDEX FAST FULL SCAN| MON_ACCT_PAYER_PK | 1 | 1935K| 25M| | 5449 (2)| 00:00:25 | | | 1954K|00:00:00.01 | 4418 | 0 |
| 14 | VIEW | index$_join$_003 | 1 | 1275K| 20M| | 67448 (1)| 00:05:02 | | | 1287K|00:00:14.23 | 33857 | 2225 |
|* 15 | HASH JOIN | | 1 | | | | | | | | 1287K|00:00:12.95 | 33857 | 2225 |
| 16 | INDEX FAST FULL SCAN | MAPCS_LATEST_MAPY_CLAIM_ID | 1 | 1275K| 20M| | 7594 (1)| 00:00:34 | | | 1287K|00:00:03.87 | 6272 | 1956 |
| 17 | INDEX FAST FULL SCAN | MAPCS_LATEST_PK | 1 | 1275K| 20M| | 33581 (1)| 00:02:31 | | | 1287K|00:00:01.29 | 27585 | 269 |
|* 18 | INDEX RANGE SCAN | MAPY_CALC_SVC_PERF1 | 161K| 2 | | | 2 (0)| 00:00:01 | | | 197K|00:00:01.43 | 323K| 0 |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment