在一個(gè)繁忙的系統(tǒng)中，發(fā)現(xiàn)一個(gè)復(fù)雜且非常長的查詢，產(chǎn)生40多個(gè)子游標(biāo)和大量的硬解析，占用很多的內(nèi)存、CPU資源；
SQL> @sql 3168229204
Show SQL text, child cursors and execution stats for SQL hash value 3168229204 child GGT report
HASH_VALUE CH# PLAN_HASH FIRST_LOAD_TIME LAST_LOAD_TIME SQL_PROFIL
---------- ----- ---------- -------------------- -------------------- ----------
3168229204 0 1144031096 2016-09-21/15:52:45 2016-11-03/16:43:40
3168229204 1 1144031096 2016-09-21/15:52:45 2016-11-03/17:39:50
3168229204 2 1144031096 2016-09-21/15:52:45 2016-11-03/18:52:26
3168229204 3 1144031096 2016-09-21/15:52:45 2016-11-04/08:41:15
3168229204 4 1144031096 2016-09-21/15:52:45 2016-11-05/08:12:52
3168229204 5 1144031096 2016-09-21/15:52:45 2016-11-07/08:00:49
3168229204 6 1144031096 2016-09-21/15:52:45 2016-11-07/13:15:24
3168229204 7 1144031096 2016-09-21/15:52:45 2016-11-08/08:07:12
3168229204 8 1144031096 2016-09-21/15:52:45 2016-11-09/08:11:57
3168229204 9 1144031096 2016-09-21/15:52:45 2016-11-09/08:31:15
3168229204 10 1144031096 2016-09-21/15:52:45 2016-11-09/08:46:13
3168229204 11 532057913 2016-09-21/15:52:45 2016-11-09/09:01:21
3168229204 12 1144031096 2016-09-21/15:52:45 2016-10-26/08:10:30
3168229204 13 1144031096 2016-09-21/15:52:45 2016-10-27/08:06:34
3168229204 14 1144031096 2016-09-21/15:52:45 2016-10-27/10:30:49
3168229204 15 1144031096 2016-09-21/15:52:45 2016-10-28/08:06:48
3168229204 16 1144031096 2016-09-21/15:52:45 2016-10-31/08:00:14
3168229204 17 1144031096 2016-09-21/15:52:45 2016-10-29/11:15:32
3168229204 18 1144031096 2016-09-21/15:52:45 2016-11-01/08:02:00
3168229204 19 1144031096 2016-09-21/15:52:45 2016-11-01/08:16:02
3168229204 44 532057913 2016-09-21/15:52:45 2016-10-25/08:36:46
21 rows selected.
CH# PARENT_HANDLE OBJECT_HANDLE PARSES H_PARSES EXECUTIONS FETCHES ROWS_PROCESSED LIOS PIOS SORTS CPU_MS ELA_MS USERS_EXECUTING
----- ---------------- ---------------- ---------- ---------- ---------- ---------- -------------- ---------- ---------- ---------- ---------- ---------- ---------------
0 000000099DC30528 000000099DC62120 1 117 1 11 20619 56
