RAC中一次混乱的性能诊断过程2

SQL ordered by Elapsed Time

  • Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
  • % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
  • Total DB Time (s): 5,870
  • Captured SQL account for 16.7% of Total

Elapsed Time (s)

CPU Time (s)

Executions

Elap per Exec (s)

% Total DB Time

SQL Id

SQL Module

SQL Text

66

61

10

6.61

1.13

5pa6u5dtnucaq

 

SELECT * FROM ( Select RowNum ...

66

59

10

6.56

1.12

7jnkm6r7t5ams

 

SELECT COUNT(*) FROM TEST1...

58

54

1

57.80

0.98

7a9cd2xa25yab

 

SELECT * FROM ( Select RowNum ...

46

43

7

6.56

0.78

6kwkbk30jkha1

 

SELECT COUNT(*) FROM TEST1 ...

45

44

7

6.45

0.77

3ywk3pt184rtb

 

SELECT * FROM ( Select RowNum ...

37

25

3

12.24

0.63

9xwa8z12j7t70

 

select ti.serialno itemNo, ti....

33

33

5

6.56

0.56

0h7fsx5a8r3sn

 

SELECT * FROM ( Select RowNum ...

33

31

5

6.52

0.56

5qhnyr92d96sm

 

SELECT COUNT(*) FROM TEST1 ...

32

29

58

0.55

0.54

2z3p2wf0daumf

 

SELECT DISTINCT Wflog.* FROM W...

32

29

5

6.31

0.54

bq5ur4q4r6m6b

 

SELECT COUNT(*) FROM TEST1 ...

结果可以看到基本没有特别耗时的SQL,所以想通过优化单个SQL来大幅度提高性能的想法是不能实现的,然后进入查看最多逻辑读取的SQL

上一篇:湖南将建大数据交易中心 提升区域经济竞争力


下一篇:JS 的基本语法