![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Oracle
明天不会下雨
这个作者很懒,什么都没留下…
展开
-
Oracle在线重定义修改字段脚本_在线修改字段类型_dbms_redefinition
-- 创建测试数据 -- 创建一张临时表 create table tbl_yy as select rownum as id, to_char(sysdate + rownum/24/3600, 'yyyy-mm-dd hh24:mi:ss') as inc_datetime, trunc(dbms_random.value(0...原创 2020-01-14 15:35:01 · 695 阅读 · 0 评论 -
CRS-2406 Bug 10400667
Bug 10400667 CRS-2406 from ctssd process appears continuously in CRS alert.log This note gives a brief overview of bug 10400667. The content was last updated on: 02-DEC-2011 Click here for转载 2014-01-13 15:29:03 · 1704 阅读 · 0 评论 -
11g Data Guard 维护手顺
#--duplicate数据库 rman target / auxiliary sys/sys@phydb duplicate target database for standby; duplicate target database for standby from active database; duplicate target database for standby NOFIL原创 2014-01-13 16:14:26 · 1075 阅读 · 0 评论 -
redo 日志切换频率查旬
select THREAD#, trunc(first_time) "Date", to_char(first_time, 'Dy') "Day", substr(count(1), 1, 5) as "Total", substr(SUM(decode(to_char(first_time, 'hh24'), '00', 1, 0)), 1, 3) as "h00", substr(SUM(de原创 2014-01-13 16:19:00 · 1029 阅读 · 0 评论