当前位置: 首页 > 调优 > 正文

查询v$lock视图慢

最近几个客户查询v$lock视图很慢。下面以一个电信客户的系统简单分析一下。

 

1ASH中查看回话的信息

SESSION_ID SESSION_SERIAL# SQL_ID        SQL_EXEC_ID SQL_EXEC_START      EVENT                                    TRUNC(PGA_ALLOCATED/1024/1024) TRUNC(TEMP_

---------- --------------- ------------- ----------- ------------------- ---------------------------------------- ------------------------------ -----------

2015-06-04 22:15:01        1850            1771 9sqwmv4077phd    16777330 2015-06-04 22:15:01 control file sequential read                      1          0

2015-06-04 22:15:02        1850            1771 9sqwmv4077phd    16777330 2015-06-04 22:15:01 control file sequential read                      1          0

2015-06-04 22:15:03        1850            1771 18uxbzz97mwa0    16777330 2015-06-04 22:15:02 control file sequential read                      3          0

2015-06-04 22:15:04        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 control file sequential read                      4          0

2015-06-04 22:15:05        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 control file sequential read                      4          0

2015-06-04 22:15:06        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 control file sequential read                      4          0

2015-06-04 22:15:07        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 control file sequential read                      4          0

2015-06-04 22:15:08        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:09        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:10        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:11        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:12        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:13        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:14        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:15        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:16        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:17        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:18        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:19        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:20        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:21        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:22        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:23        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:24        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:25        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:26        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:27        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:28        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:29        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:30        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:31        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:32        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:33        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:34        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:35        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:36        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:37        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:38        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:39        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:40        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:41        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:42        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:43        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:44        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:45        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:46        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:47        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:48        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:49        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03                                                   6          0

2015-06-04 22:15:50        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:51        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:52        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:53        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:54        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:55        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:56        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:57        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:58        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:15:59        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:00        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:01        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:02        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:03        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:04        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:05        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:06        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:07        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:08        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:09        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:10        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:11        1850            1771 8hyrm452nja5v    16777330 2015-06-04 22:15:03 db file sequential read                           6          0

2015-06-04 22:16:13        1850            1771 dsju1nhvjj1j8    16777316 2015-06-04 22:16:12 db file sequential read                           3          0

2015-06-04 22:16:14        1850            1771 dsju1nhvjj1j8    16777316 2015-06-04 22:16:12 db file sequential read                           3          0

2015-06-04 22:16:15        1850            1771 dsju1nhvjj1j8    16777316 2015-06-04 22:16:12 db file sequential read                           4          0

2015-06-04 22:16:16        1850            1771 dsju1nhvjj1j8    16777316 2015-06-04 22:16:12                                                   4          0

2015-06-04 22:16:21        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  75          0

2015-06-04 22:16:22        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91         73

2015-06-04 22:16:23        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        107

2015-06-04 22:16:24        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        144

2015-06-04 22:16:25        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        206

2015-06-04 22:16:26        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        238

2015-06-04 22:16:27        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        303

2015-06-04 22:16:28        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        335

2015-06-04 22:16:29        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        378

2015-06-04 22:16:30        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        432

2015-06-04 22:16:31        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        464

2015-06-04 22:16:32        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        528

2015-06-04 22:16:33        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        560

2015-06-04 22:16:34        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        617

2015-06-04 22:16:35        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        656

2015-06-04 22:16:36        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        695

2015-06-04 22:16:38        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        752

2015-06-04 22:16:39        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        784

2015-06-04 22:16:40        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        848

2015-06-04 22:16:41        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        880

2015-06-04 22:16:42        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        932

2015-06-04 22:16:43        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91        976

2015-06-04 22:16:44        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1013

2015-06-04 22:16:45        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1072

2015-06-04 22:16:46        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1104

2015-06-04 22:16:47        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1152

2015-06-04 22:16:48        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1200

2015-06-04 22:16:49        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1233

2015-06-04 22:16:50        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1293

2015-06-04 22:16:51        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1328

2015-06-04 22:16:52        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1360

2015-06-04 22:16:53        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path write temp                           91       1412

2015-06-04 22:16:54        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1456

2015-06-04 22:16:55        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1488

2015-06-04 22:16:56        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1533

2015-06-04 22:16:57        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1584

2015-06-04 22:16:58        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1616

2015-06-04 22:16:59        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1648

2015-06-04 22:17:00        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1699

2015-06-04 22:17:01        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1744

2015-06-04 22:17:02        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1776

2015-06-04 22:17:03        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1835

2015-06-04 22:17:04        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1872

2015-06-04 22:17:05        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1906

2015-06-04 22:17:06        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       1965

2015-06-04 22:17:07        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2000

2015-06-04 22:17:08        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2033

2015-06-04 22:17:09        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2088

2015-06-04 22:17:10        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2129

2015-06-04 22:17:11        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2164

2015-06-04 22:17:12        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2224

2015-06-04 22:17:13        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2257

2015-06-04 22:17:14        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2306

2015-06-04 22:17:15        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2353

2015-06-04 22:17:16        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2388

2015-06-04 22:17:17        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2438

2015-06-04 22:17:18        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2480

2015-06-04 22:17:19        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2513

2015-06-04 22:17:20        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2546

2015-06-04 22:17:21        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2589

2015-06-04 22:17:22        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2641

2015-06-04 22:17:23        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2673

2015-06-04 22:17:24        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2713

2015-06-04 22:17:25        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2768

2015-06-04 22:17:26        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2801

2015-06-04 22:17:27        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2840

2015-06-04 22:17:28        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2883

2015-06-04 22:17:29        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2928

2015-06-04 22:17:30        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2961

2015-06-04 22:17:31        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       2993

2015-06-04 22:17:32        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3037

2015-06-04 22:17:33        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3088

2015-06-04 22:17:34        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3121

2015-06-04 22:17:35        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3170

2015-06-04 22:17:36        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3216

2015-06-04 22:17:37        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3249

2015-06-04 22:17:38        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3289

2015-06-04 22:17:39        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path write temp                           91       3343

2015-06-04 22:17:40        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3377

2015-06-04 22:17:41        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3409

2015-06-04 22:17:42        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3449

2015-06-04 22:17:43        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path write temp                           91       3499

2015-06-04 22:17:44        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3537

2015-06-04 22:17:45        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3569

2015-06-04 22:17:46        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3617

2015-06-04 22:17:47        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3662

2015-06-04 22:17:48        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3697

2015-06-04 22:17:49        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3729

2015-06-04 22:17:50        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3764

2015-06-04 22:17:51        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3806

2015-06-04 22:17:52        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3852

2015-06-04 22:17:53        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3889

2015-06-04 22:17:54        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3931

2015-06-04 22:17:55        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       3983

2015-06-04 22:17:56        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4017

2015-06-04 22:17:57        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4059

2015-06-04 22:17:58        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4112

2015-06-04 22:17:59        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4145

2015-06-04 22:18:00        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4202

2015-06-04 22:18:01        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4241

2015-06-04 22:18:02        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4279

2015-06-04 22:18:03        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4333

2015-06-04 22:18:04        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4369

2015-06-04 22:18:05        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4419

2015-06-04 22:18:06        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4464

2015-06-04 22:18:07        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4501

2015-06-04 22:18:08        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4557

2015-06-04 22:18:09        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4593

2015-06-04 22:18:10        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4645

2015-06-04 22:18:11        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4689

2015-06-04 22:18:12        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4731

2015-06-04 22:18:13        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4783

2015-06-04 22:18:14        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4819

2015-06-04 22:18:15        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4875

2015-06-04 22:18:16        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4913

2015-06-04 22:18:17        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       4963

2015-06-04 22:18:18        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5007

2015-06-04 22:18:19        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5041

2015-06-04 22:18:20        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5096

2015-06-04 22:18:21        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5136

2015-06-04 22:18:22        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5173

2015-06-04 22:18:23        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5229

2015-06-04 22:18:24        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5265

2015-06-04 22:18:25        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5316

2015-06-04 22:18:26        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5361

2015-06-04 22:18:27        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5406

2015-06-04 22:18:28        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5456

2015-06-04 22:18:29        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                  91       5492

2015-06-04 22:18:30        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:31        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:32        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:33        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:34        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:18:35        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:36        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:37        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:38        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:39        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:18:40        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:41        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:42        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:43        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:44        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:45        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:46        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:18:47        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:48        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:49        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:50        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:51        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:52        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:53        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:54        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:55        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:56        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:57        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:58        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:18:59        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:00        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:01        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:02        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:03        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:04        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:05        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:06        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:07        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:19:08        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:09        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:19:10        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:19:11        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:12        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:13        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:14        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:15        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:16        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:17        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:18        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:19:19        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:20        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:21        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:22        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:23        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:24        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:25        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:26        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:27        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:28        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:29        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:30        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:31        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:32        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:33        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:34        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:35        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:36        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:37        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:38        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:19:39        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:40        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:19:41        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:42        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:43        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:44        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:45        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:46        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:47        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:48        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:49        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:50        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:51        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:19:52        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:53        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:54        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:55        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:19:56        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:57        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:58        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:19:59        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:00        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:01        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:02        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:03        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:04        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:05        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:06        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:07        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:08        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:09        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:10        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:11        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:12        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:13        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:14        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:15        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:16        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:17        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:18        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:19        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:20        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:21        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:22        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:23        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:24        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:25        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:26        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:27        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:28        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:29        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:30        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:31        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:32        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:33        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:34        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:35        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:36        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:37        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:20:38        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:39        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:40        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:41        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:42        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:43        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:44        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:45        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:46        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:47        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:48        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:49        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:50        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:20:51        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:52        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:53        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:54        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:55        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:56        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:57        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:58        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:20:59        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:00        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:01        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:21:02        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:03        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:04        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:05        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:06        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:07        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:08        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:09        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:10        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:11        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:12        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:13        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:14        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:15        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:16        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:17        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:18        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:19        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:21:20        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:21        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:22        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:23        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:24        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:25        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:26        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:27        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:28        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:29        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:30        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:31        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:32        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:33        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:34        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:35        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:36        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:37        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:21:38        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:39        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:40        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:41        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:42        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:43        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:44        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:45        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:46        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:47        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:48        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:49        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:50        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:51        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:52        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:53        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:54        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:55        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:56        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:57        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:58        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:21:59        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:22:00        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:22:01        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:02        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:22:03        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:04        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:05        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:06        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:07        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:09        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:10        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:11        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:12        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:13        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:14        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:15        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:16        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:17        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:18        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:19        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:20        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:21        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:22        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:23        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:24        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:25        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:22:26        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:27        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:28        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:29        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:30        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:31        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:32        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:22:33        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:34        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:35        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:36        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:37        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:38        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:39        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:40        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:41        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:42        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:43        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:44        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20                                                   8       5548

2015-06-04 22:22:45        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:46        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:47        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:48        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read temp                             8       5548

2015-06-04 22:22:49        1850            1771 c6qh23k9h3pq0    16777316 2015-06-04 22:16:20 direct path read te

这里可以查看到回话有大量的DIRECT PATH READ TEMP等待,并且占用大量的TEMP表空间,这里可以肯定SQL肯定出问题了

 

2,查看SQL的统计信息

SQL> @sql10.sql

Enter value for sqlid: c6qh23k9h3pq0

****************************************************************************************

LITERAL SQL

****************************************************************************************

select * from table(dbms_xplan.display_cursor('c6qh23k9h3pq0',0));

****************************************************************************************

CURSOR

****************************************************************************************

SQL_ID  c6qh23k9h3pq0, child number 0

-------------------------------------

SELECT count(*) FROM V$LOCK

Plan hash value: 2384831130

---------------------------------------------------------------------------

| Id  | Operation               | Name       | Rows  | Bytes | Cost (%CPU)|

---------------------------------------------------------------------------

|   0 | SELECT STATEMENT        |            |       |       |     1 (100)|

|   1 |  SORT AGGREGATE         |            |     1 |    50 |            |

|*  2 |   HASH JOIN             |            |     1 |    50 |     0   (0)|

|   3 |    MERGE JOIN CARTESIAN |            |   100 |  3800 |     0   (0)|

|*  4 |     FIXED TABLE FULL    | X$KSUSE    |     1 |    19 |     0   (0)|

|   5 |     BUFFER SORT         |            |   100 |  1900 |     0   (0)|

|   6 |      FIXED TABLE FULL   | X$KSQRS    |   100 |  1900 |     0   (0)|

|   7 |    VIEW                 | GV$_LOCK   |    10 |   120 |     0   (0)|

|   8 |     UNION-ALL           |            |       |       |            |

|*  9 |      FILTER             |            |       |       |            |

|  10 |       VIEW              | GV$_LOCK1  |     2 |    24 |     0   (0)|

|  11 |        UNION-ALL        |            |       |       |            |

|* 12 |         FIXED TABLE FULL| X$KDNSSF   |     1 |    64 |     0   (0)|

|* 13 |         FIXED TABLE FULL| X$KSQEQ    |     1 |    64 |     0   (0)|

|* 14 |      FIXED TABLE FULL   | X$KTADM    |     1 |    64 |     0   (0)|

|* 15 |      FIXED TABLE FULL   | X$KTATRFIL |     1 |    64 |     0   (0)|

|* 16 |      FIXED TABLE FULL   | X$KTATRFSL |     1 |    64 |     0   (0)|

|* 17 |      FIXED TABLE FULL   | X$KTATL    |     1 |    64 |     0   (0)|

|* 18 |      FIXED TABLE FULL   | X$KTSTUSC  |     1 |    64 |     0   (0)|

|* 19 |      FIXED TABLE FULL   | X$KTSTUSS  |     1 |    64 |     0   (0)|

|* 20 |      FIXED TABLE FULL   | X$KTSTUSG  |     1 |    64 |     0   (0)|

|* 21 |      FIXED TABLE FULL   | X$KTCXB    |     1 |    64 |     0   (0)|

---------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

   2 - access("SADDR"="S"."ADDR" AND

              TO_CHAR(USERENV('INSTANCE'))||RAWTOHEX("RADDR")=TO_CHAR("R"."INST_ID")||

              RAWTOHEX("R"."ADDR"))

   4 - filter("S"."INST_ID"=USERENV('INSTANCE'))

   9 - filter(USERENV('INSTANCE') IS NOT NULL)

  12 - filter((("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND

              "INST_ID"=USERENV('INSTANCE') AND BITAND("KSSOBFLG",1)<>0))

  13 - filter((("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND

              "INST_ID"=USERENV('INSTANCE') AND BITAND("KSSOBFLG",1)<>0))

  14 - filter((("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND

              "INST_ID"=USERENV('INSTANCE') AND BITAND("KSSOBFLG",1)<>0))

  15 - filter((("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND

              "INST_ID"=USERENV('INSTANCE') AND BITAND("KSSOBFLG",1)<>0))

  16 - filter((("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND

              "INST_ID"=USERENV('INSTANCE') AND BITAND("KSSOBFLG",1)<>0))

  17 - filter((("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND

              "INST_ID"=USERENV('INSTANCE') AND BITAND("KSSOBFLG",1)<>0))

  18 - filter((("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND

              "INST_ID"=USERENV('INSTANCE') AND BITAND("KSSOBFLG",1)<>0))

  19 - filter((("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND

              "INST_ID"=USERENV('INSTANCE') AND BITAND("KSSOBFLG",1)<>0))

  20 - filter((("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND

              "INST_ID"=USERENV('INSTANCE') AND BITAND("KSSOBFLG",1)<>0))

  21 - filter((("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND

              "INST_ID"=USERENV('INSTANCE') AND BITAND("KSSPAFLG",1)<>0))

****************************************************************************************

SQL WAIT HIST

****************************************************************************************

                                                                                 WAIT

PROGRAM                        EVENT                                       TOTAL CLASS

------------------------------ ---------------------------------------- -------- ---------------

JDBC Thin Client               CPU                                         1,811 CPU

                               direct path read temp                       1,041 User_IO

                               direct path write temp                         37 User_IO

3,收集统计信息

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KSUSE);

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KSQRS'   );

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KDNSSF'  );

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KSQEQ'   );

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KTADM'   );

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KTATRFIL');

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KTATRFSL');

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KTATL'   );

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KTSTUSC' );

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KTSTUSS' );

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KTSTUSG');

exec dbms_stats.gather_table_stats(OWNNAME=>'SYS',tabname=>'X$KTCXB');

收集统计信息后,执行计划马上对了

SQL> select count(*) from v$lock;

  COUNT(*)

----------

      2447

Execution Plan

----------------------------------------------------------

Plan hash value: 3730480328

---------------------------------------------------------------------------------------

| Id  | Operation                | Name       | Rows  | Bytes | Cost (%CPU)| Time     |

---------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT         |            |     1 |    36 |    21 (100)| 00:00:01 |

|   1 |  SORT AGGREGATE          |            |     1 |    36 |            |          |

|*  2 |   HASH JOIN              |            | 25274 |   888K|    21 (100)| 00:00:01 |

|*  3 |    HASH JOIN             |            |   101 |  2424 |    16 (100)| 00:00:01 |

|   4 |     VIEW                 | GV$_LOCK   |   101 |  1212 |    16 (100)| 00:00:01 |

|   5 |      UNION-ALL           |            |       |       |            |          |

|*  6 |       FILTER             |            |       |       |            |          |

|   7 |        VIEW              | GV$_LOCK1  |    93 |  1116 |    11 (100)| 00:00:01 |

|   8 |         UNION-ALL        |            |       |       |            |          |

|*  9 |          FIXED TABLE FULL| X$KDNSSF   |     1 |    16 |     1 (100)| 00:00:01 |

|* 10 |          FIXED TABLE FULL| X$KSQEQ    |    92 |  1564 |    10 (100)| 00:00:01 |

|* 11 |       FIXED TABLE FULL   | X$KTADM    |     1 |    18 |     4 (100)| 00:00:01 |

|* 12 |       FIXED TABLE FULL   | X$KTATRFIL |     1 |    14 |     0   (0)| 00:00:01 |

|* 13 |       FIXED TABLE FULL   | X$KTATRFSL |     1 |    14 |     0   (0)| 00:00:01 |

|* 14 |       FIXED TABLE FULL   | X$KTATL    |     1 |    28 |     0   (0)| 00:00:01 |

|* 15 |       FIXED TABLE FULL   | X$KTSTUSC  |     1 |    16 |     0   (0)| 00:00:01 |

|* 16 |       FIXED TABLE FULL   | X$KTSTUSS  |     1 |    16 |     0   (0)| 00:00:01 |

|* 17 |       FIXED TABLE FULL   | X$KTSTUSG  |     1 |    22 |     0   (0)| 00:00:01 |

|* 18 |       FIXED TABLE FULL   | X$KTCXB    |     1 |    17 |     1 (100)| 00:00:01 |

|* 19 |     FIXED TABLE FULL     | X$KSUSE    |  4544 | 54528 |     1 (100)| 00:00:01 |

|  20 |    FIXED TABLE FULL      | X$KSQRS    | 25024 |   293K|     4 (100)| 00:00:01 |

---------------------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

   2 - access(TO_CHAR(USERENV('INSTANCE'))||RAWTOHEX("RADDR")=TO_CHAR("R"."INST

              _ID")||RAWTOHEX("R"."ADDR"))

   3 - access("SADDR"="S"."ADDR")

   6 - filter(USERENV('INSTANCE') IS NOT NULL)

   9 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  10 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  11 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  12 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  13 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  14 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  15 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  16 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  17 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  18 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSPAFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  19 - filter("S"."INST_ID"=USERENV('INSTANCE'))

Statistics

----------------------------------------------------------

          0  recursive calls

         25  db block gets

          0  consistent gets

          0  physical reads

          0  redo size

        527  bytes sent via SQL*Net to client

        520  bytes received via SQL*Net from client

          2  SQL*Net roundtrips to/from client

          0  sorts (memory)

          0  sorts (disk)

          1  rows processed

4,固定执行计划

 

这里发现执行计划已经对了,但是业务发起对v$lock查询后,手动查询又发现慢了,没有办法只能手动固定执行计划了

SQL> select sql_fulltext,sql_id from v$sqlarea where sql_fulltext like '%select count(*) FROM V$LOCK%';

SQL_FULLTEXT                                                                     SQL_ID

-------------------------------------------------------------------------------- ------------------

select count(*) FROM V$LOCK                                                      09sj365h256dd

SQL> @test.sql

Parameter 1:

ORIGINAL_SQL_ID (required)

Enter value for 1: c6qh23k9h3pq0

Parameter 2:

MODIFIED_SQL_ID (required)

Enter value for 2: 09sj365h256dd

         PLAN

   HASH VALUE          AVG_ET_SECS

------------- --------------------

   3730480328                 .211

Parameter 3:

PLAN_HASH_VALUE (required)

Enter value for 3: 3730480328

Values passed to coe_load_sql_profile:

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ORIGINAL_SQL_ID: "c6qh23k9h3pq0"

MODIFIED_SQL_ID: "09sj365h256dd"

PLAN_HASH_VALUE: "3730480328"

SQL>BEGIN

  2    IF :sql_text IS NULL THEN

  3      RAISE_APPLICATION_ERROR(-20100, 'SQL_TEXT for original SQL_ID &&original_sql_id. was not found in memory (gv$sqltext_with_newlines) or AWR (dba_hist_sqltext).');

  4    END IF;

  5  END;

  6  /

SQL>SET TERM OFF;

SQL>BEGIN

  2    IF :other_xml IS NULL THEN

  3      RAISE_APPLICATION_ERROR(-20101, 'PLAN for modified SQL_ID &&modified_sql_id. and PHV &&plan_hash_value. was not found in memory (gv$sql_plan) or AWR (dba_hist_sql_plan).');

  4    END IF;

  5  END;

  6  /

SQL>

SQL>SET ECHO OFF;

0001 BEGIN_OUTLINE_DATA

0002 IGNORE_OPTIM_EMBEDDED_HINTS

0003 OPTIMIZER_FEATURES_ENABLE('11.2.0.4')

0004 DB_VERSION('11.2.0.4')

0005 OPT_PARAM('_optimizer_null_aware_antijoin' 'false')

0006 OPT_PARAM('_optimizer_extended_cursor_sharing' 'none')

0007 OPT_PARAM('_optimizer_extended_cursor_sharing_rel' 'none')

0008 OPT_PARAM('_optimizer_adaptive_cursor_sharing' 'false')

0009 OPT_PARAM('_optimizer_use_feedback' 'false')

0010 ALL_ROWS

0011 OUTLINE_LEAF(@"SEL$7")

0012 OUTLINE_LEAF(@"SEL$8")

0013 OUTLINE_LEAF(@"SET$2")

0014 OUTLINE_LEAF(@"SEL$ABDE6DFF")

0015 MERGE(@"SEL$6")

0016 OUTLINE_LEAF(@"SEL$9")

0017 OUTLINE_LEAF(@"SEL$10")

0018 OUTLINE_LEAF(@"SEL$11")

0019 OUTLINE_LEAF(@"SEL$12")

0020 OUTLINE_LEAF(@"SEL$13")

0021 OUTLINE_LEAF(@"SEL$14")

0022 OUTLINE_LEAF(@"SEL$15")

0023 OUTLINE_LEAF(@"SEL$16")

0024 OUTLINE_LEAF(@"SET$1")

0025 OUTLINE_LEAF(@"SEL$88122447")

0026 MERGE(@"SEL$641071AC")

0027 OUTLINE(@"SEL$5")

0028 OUTLINE(@"SEL$6")

0029 OUTLINE(@"SEL$1")

0030 OUTLINE(@"SEL$641071AC")

0031 MERGE(@"SEL$07BDC5B4")

0032 OUTLINE(@"SEL$2")

0033 OUTLINE(@"SEL$07BDC5B4")

0034 MERGE(@"SEL$4")

0035 OUTLINE(@"SEL$3")

0036 OUTLINE(@"SEL$4")

0037 NO_ACCESS(@"SEL$88122447" "GV$_LOCK"@"SEL$4")

0038 FULL(@"SEL$88122447" "S"@"SEL$3")

0039 FULL(@"SEL$88122447" "R"@"SEL$3")

0040 LEADING(@"SEL$88122447" "GV$_LOCK"@"SEL$4" "S"@"SEL$3" "R"@"SEL$3")

0041 USE_HASH(@"SEL$88122447" "S"@"SEL$3")

0042 USE_HASH(@"SEL$88122447" "R"@"SEL$3")

0043 FULL(@"SEL$16" "X$KTCXB"@"SEL$16")

0044 FULL(@"SEL$15" "X$KTSTUSG"@"SEL$15")

0045 FULL(@"SEL$14" "X$KTSTUSS"@"SEL$14")

0046 FULL(@"SEL$13" "X$KTSTUSC"@"SEL$13")

0047 FULL(@"SEL$12" "X$KTATL"@"SEL$12")

0048 FULL(@"SEL$11" "X$KTATRFSL"@"SEL$11")

0049 FULL(@"SEL$10" "X$KTATRFIL"@"SEL$10")

0050 FULL(@"SEL$9" "X$KTADM"@"SEL$9")

0051 NO_ACCESS(@"SEL$ABDE6DFF" "GV$_LOCK1"@"SEL$6")

0052 FULL(@"SEL$8" "X$KSQEQ"@"SEL$8")

0053 FULL(@"SEL$7" "X$KDNSSF"@"SEL$7")

0054 END_OUTLINE_DATA

SQL>SELECT count(*) FROM V$LOCK;

            COUNT(*)

--------------------

                2438

Execution Plan

----------------------------------------------------------

Plan hash value: 3730480328

---------------------------------------------------------------------------------------

| Id  | Operation                | Name       | Rows  | Bytes | Cost (%CPU)| Time     |

---------------------------------------------------------------------------------------

|   0 | SELECT STATEMENT         |            |     1 |    49 |    21 (100)| 00:00:01 |

|   1 |  SORT AGGREGATE          |            |     1 |    49 |            |          |

|*  2 |   HASH JOIN              |            | 30279 |  1448K|    21 (100)| 00:00:01 |

|*  3 |    HASH JOIN             |            |   121 |  4477 |    16 (100)| 00:00:01 |

|   4 |     VIEW                 | GV$_LOCK   |   121 |  3025 |    16 (100)| 00:00:01 |

|   5 |      UNION-ALL           |            |       |       |            |          |

|*  6 |       FILTER             |            |       |       |            |          |

|   7 |        VIEW              | GV$_LOCK1  |   113 |  2825 |    11 (100)| 00:00:01 |

|   8 |         UNION-ALL        |            |       |       |            |          |

|*  9 |          FIXED TABLE FULL| X$KDNSSF   |     1 |    16 |     1 (100)| 00:00:01 |

|* 10 |          FIXED TABLE FULL| X$KSQEQ    |   112 |  1904 |    10 (100)| 00:00:01 |

|* 11 |       FIXED TABLE FULL   | X$KTADM    |     1 |    19 |     4 (100)| 00:00:01 |

|* 12 |       FIXED TABLE FULL   | X$KTATRFIL |     1 |    14 |     0   (0)| 00:00:01 |

|* 13 |       FIXED TABLE FULL   | X$KTATRFSL |     1 |    14 |     0   (0)| 00:00:01 |

|* 14 |       FIXED TABLE FULL   | X$KTATL    |     1 |    28 |     0   (0)| 00:00:01 |

|* 15 |       FIXED TABLE FULL   | X$KTSTUSC  |     1 |    16 |     0   (0)| 00:00:01 |

|* 16 |       FIXED TABLE FULL   | X$KTSTUSS  |     1 |    16 |     0   (0)| 00:00:01 |

|* 17 |       FIXED TABLE FULL   | X$KTSTUSG  |     1 |    22 |     0   (0)| 00:00:01 |

|* 18 |       FIXED TABLE FULL   | X$KTCXB    |     1 |    17 |     1 (100)| 00:00:01 |

|* 19 |     FIXED TABLE FULL     | X$KSUSE    |  4544 | 54528 |     1 (100)| 00:00:01 |

|  20 |    FIXED TABLE FULL      | X$KSQRS    | 25024 |   293K|     4 (100)| 00:00:01 |

---------------------------------------------------------------------------------------

Predicate Information (identified by operation id):

---------------------------------------------------

   2 - access(TO_CHAR(USERENV('INSTANCE'))||RAWTOHEX("RADDR")=TO_CHAR("R"."INST

              _ID")||RAWTOHEX("R"."ADDR"))

   3 - access("SADDR"="S"."ADDR")

   6 - filter(USERENV('INSTANCE') IS NOT NULL)

   9 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  10 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  11 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  12 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  13 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  14 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  15 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  16 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  17 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSOBFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  18 - filter(("KSQLKMOD"<>0 OR "KSQLKREQ"<>0) AND BITAND("KSSPAFLG",1)<>0 AND

              "INST_ID"=USERENV('INSTANCE'))

  19 - filter("S"."INST_ID"=USERENV('INSTANCE'))

Note

-----

   - SQL profile "C6QH23K9H3PQ0_3730480328" used for this statement

Statistics

----------------------------------------------------------

          0  recursive calls

         24  db block gets

          0  consistent gets

          0  physical reads

          0  redo size

        527  bytes sent via SQL*Net to client

        520  bytes received via SQL*Net from client

          2  SQL*Net roundtrips to/from client

          0  sorts (memory)

          0  sorts (disk)

本文固定链接: http://www.htz.pw/2015/09/14/%e6%9f%a5%e8%af%a2vlock%e8%a7%86%e5%9b%be%e6%85%a2.html | 认真就输

该日志由 huangtingzhong 于2015年09月14日发表在 调优 分类下, 通告目前不可用,你可以至底部留下评论。
原创文章转载请注明: 查询v$lock视图慢 | 认真就输
关键字: