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 · 748 阅读 · 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 · 1730 阅读 · 0 评论 -
11g Data Guard 维护手顺
#--duplicate数据库rman target / auxiliary sys/sys@phydbduplicate target database for standby;duplicate target database for standby from active database;duplicate target database for standby NOFIL原创 2014-01-13 16:14:26 · 1099 阅读 · 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 · 1066 阅读 · 0 评论