JAUAR

keep walking

  • 博客访问: 259332
  • 博文数量: 79
  • 用 户 组: 普通用户
  • 注册时间: 2015-10-25 12:54
  • 认证徽章:
个人简介

Man proposes, God disposes!

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类

全部博文(79)

文章存档

2017年(4)

2016年(75)

微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

发布时间:2016-03-24 23:12:32

session1:SQL> update test set name='skjf' where id=1;1 row updated.未提交SQL>session2SQL> update test set name='sj' where id=1;光标卡住,意味着被阻塞session3查询阻塞信息SQL> select sid,event,blocking_session from v$session;    .........【阅读全文】

阅读(1240) | 评论(0) | 转发(0)

发布时间:2016-04-04 16:34:57

官方文档:If you specify DELETE INPUT (without ALL), then RMAN deletes only the specific files that it backs up. If you specify ALL INPUT, then RMAN deletes all copies of the files recorded in the RMAN repository. delete input是指备份后.........【阅读全文】

阅读(1417) | 评论(0) | 转发(0)

发布时间:2016-04-05 01:17:26

官方文档:To avoid recovering offline normal or read-only tablespaces, edit them out of the CREATE CONTROLFILE statement. When you open the database with the re-created control file, the database marks these omitted files as MISSING. You can run an ALTER DATABASE RENAME FILE statement to.........【阅读全文】

阅读(1401) | 评论(0) | 转发(0)

发布时间:2016-04-06 20:05:51

实验测试:环境11.2.0.4先做个备份:RMAN> backup database plus archivelog delete all input;Starting backup at 06-APR-16current log archivedusing channel ORA_DISK_1channel ORA_DISK_1: starting archived log backup setchannel ORA_DISK_1: specifying archived log(s).........【阅读全文】

阅读(1337) | 评论(0) | 转发(0)

发布时间:2016-04-10 15:40:05

加深对sqlprofile的理解,动手测试建一个表:SQL> create table t1(n number);Table created.SQL> declare  2  begin  3  for i in 1 .. 10000  4  loop  5  insert into t1 values(i);  6  commit;  7 .........【阅读全文】

阅读(1412) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册