tpcc压测oracle,love wife love life —Roger的Oracle/MySQL数据恢复博客

obclient> select event,state,count(1) from v$session_Wait group by event,state order by 3;

+---------------------------------+-------------------+----------+

| EVENT | STATE | COUNT(1) |

+---------------------------------+-------------------+----------+

| sync rpc | WAITED SHORT TIME | 2 |

| latch: default spin rwlock wait | WAITED SHORT TIME | 2 |

| db file data read | WAITED SHORT TIME | 4 |

| sync rpc | WAITED KNOWN TIME | 9 |

| mysql response wait client | WAITED SHORT TIME | 19 |

+---------------------------------+-------------------+----------+

5 rows in set (0.01 sec)

obclient> select sid,event,p1text,p1,p2,p2text,p3,p3text,WAIT_CLASS#,STATE,WAIT_TIME_MICRO,TIME_REMAINING_MICRO from v$session_Wait ;

+------------+---------------------------------+---------+-----------------+------------+--------+----+--------+-------------+-------------------+-----------------+----------------------+

| SID | EVENT | P1TEXT | P1 | P2 | P2TEXT | P3 | P3TEXT | WAIT_CLASS# | STATE | WAIT_TIME_MICRO | TIME_REMAINING_MICRO |

+------------+---------------------------------+---------+-----------------+------------+--------+----+--------+-------------+-------------------+-----------------+----------------------+

| 3221487745 | sync rpc | pcode | 595 | 210 | size | 0 | NULL | 7 | WAITED KNOWN TIME | 13549 | NULL |

| 3221487815 | db file data read | fd | 160 | 0 | offset | 0 | size | 8 | WAITED SHORT TIME | 271 | NULL |

| 3221488245 | db file data read | fd | 1840 | 0 | offset | 0 | size | 8 | WAITED SHORT TIME | 618 | NULL |

| 3221489377 | sync rpc | pcode | 515 | 655 | size | 0 | NULL | 7 | WAITED KNOWN TIME | 13171 | NULL |

| 3221489514 | sync rpc | pcode | 552 | 301 | size | 0 | NULL | 7 | WAITED KNOWN TIME | 12768 | NULL |

| 3221490586 | sync rpc | pcode | 515 | 1417 | size | 0 | NULL | 7 | WAITED KNOWN TIME | 46715 | NULL |

| 3221495859 | sync rpc | pcode | 1294 | 3914 | size | 0 | NULL | 7 | WAITED SHORT TIME | 775 | NULL |

| 3221497539 | sync rpc | pcode | 1294 | 6973 | size | 0 | NULL | 7 | WAITED KNOWN TIME | 35819 | NULL |

| 3221498632 | sync rpc | pcode | 515 | 2215 | size | 0 | NULL | 7 | WAITED KNOWN TIME | 112505 | NULL |

| 3221498707 | sync rpc | pcode | 516 | 203 | size | 0 | NULL | 7 | WAITED KNOWN TIME | 26327 | NULL |

| 3221498708 | latch: default spin rwlock wait | address | 140648371133768 | 1073745962 | number | 1 | tries | 4 | WAITED SHORT TIME | 2173 | NULL |

| 3221498712 | sync rpc | pcode | 515 | 2215 | size | 0 | NULL | 7 | WAITED SHORT TIME | 1102 | NULL |

| 3221498764 | sync rpc | pcode | 515 | 2215 | size | 0 | NULL | 7 | WAITED KNOWN TIME | 46322 | NULL |

| 3221498765 | latch: default spin rwlock wait | address | 140648371133768 | 1073745962 | number | 1 | tries | 4 | WAITED SHORT TIME | 986 | NULL |

| 3221498783 | sync rpc | pcode | 526 | 669 | size | 0 | NULL | 7 | WAITED KNOWN TIME | 72230 | NULL |

| 3221498989 | db file data read | fd | 4096 | 0 | offset | 0 | size | 8 | WAITED SHORT TIME | 310 | NULL |

| 3221498990 | db file data read | fd | 16384 | 0 | offset | 0 | size | 8 | WAITED SHORT TIME | 229 | NULL |

| 3221498991 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 24 | -1 |

| 3221499010 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 45 | -1 |

| 3221499011 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 436 | -1 |

| 3221499012 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 22 | -1 |

| 3221499013 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 119 | -1 |

| 3221499014 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 34 | -1 |

| 3221499015 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 145 | -1 |

| 3221499016 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 91 | -1 |

| 3221499017 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 1145 | -1 |

| 3221499098 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 44 | -1 |

| 3221499099 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 24 | -1 |

| 3221499100 | latch: default spin rwlock wait | address | 140648371133768 | 3221229610 | number | 1 | tries | 4 | WAITED SHORT TIME | 6495 | NULL |

| 3221499101 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 85 | -1 |

| 3221499102 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 35 | -1 |

| 3221499103 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 40 | -1 |

| 3221499104 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 48 | -1 |

| 3221499105 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 112 | -1 |

| 3221499106 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 35 | -1 |

| 3221499107 | mysql response wait client | NULL | 0 | 0 | NULL | 0 | NULL | 7 | WAITED SHORT TIME | 246 | -1 |

+------------+---------------------------------+---------+-----------------+------------+--------+----+--------+-------------+-------------------+-----------------+----------------------+

36 rows in set (0.01 sec)