- 博客(4)
- 收藏
- 关注
原创 表上有事务,online 创建索引会等待?
表上有事务,创建索引: [oracle@yyjk ~]$ sqlplus tlcbuser/tlcbuser SQL*Plus: Release 11.2.0.4.0 Production on 星期三 8月 22 08:27:41 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Ora...
2018-08-22 08:50:12 204
原创 一个表上有事务,直接创建索引?
表上有事务,创建索引: [oracle@yyjk ~]$ sqlplus tlcbuser/tlcbuser SQL*Plus: Release 11.2.0.4.0 Production on 星期三 8月 22 08:27:41 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Ora...
2018-08-22 08:47:08 259
原创 online创建索引 引发行锁等待
[oracle@yyjk ~]$ sqlplus tlcbuser/tlcbuser SQL*Plus: Release 11.2.0.4.0 Production on 星期二 8月 21 11:11:33 2018 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database...
2018-08-21 11:34:42 508
原创 oracle 收集直方图不走索引
1 Plan hash value: 1138811981 2 3 ---------------------------------------------------------------------------------------------- 4 | Id | Operation | Name | Rows |...
2018-08-10 16:53:32 555
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人