摘要: 估算时间为S ktuxesiz取10S差值 ,计算出每秒恢复的量,剩余总量除以每秒恢复的量 select s.username, t.xidusn, t.xidslot, t.xidsqn, x.ktuxesiz from sys.x$ktuxe x, sys.v_$transaction t, s 阅读全文
posted @ 2021-03-26 10:28 菲阳公社 阅读(639) 评论(0) 推荐(0)
摘要: For 8.1.7 to 9.2: SELECT a.username, a.sid, a.serial#, a.osuser, b.tablespace, b.blocks, c.sql_text FROM v$session a, v$sort_usage b, v$sqlarea c WHER 阅读全文
posted @ 2021-03-18 10:00 菲阳公社 阅读(69) 评论(0) 推荐(0)
摘要: 强制类型转换 -#include<stdio.h> int main(void) { int mice; mice=(int)1.6+(int)1.7; printf("Mice=%d\n",mice); return 0; } 带参数函数 -#include<stdio.h> void pound 阅读全文
posted @ 2021-03-18 09:34 菲阳公社 阅读(94) 评论(0) 推荐(0)
摘要: 单行 多行 文档 public class HelloWorld { public static void main (String [] args) { //output hello world /* output hello world */ /** * @description hellowo 阅读全文
posted @ 2021-03-17 19:46 菲阳公社 阅读(33) 评论(0) 推荐(0)
摘要: 1.Stop Instance srvctl stop instance -d dbname -i instance1,instance2 -o immediate 2.Start database to nomount srvctl start database -d dbname -o nomo 阅读全文
posted @ 2021-03-16 16:41 菲阳公社 阅读(86) 评论(0) 推荐(0)
摘要: Check lob status Cause The cause of these errors could be a LOB corruption. Maintaining the LOBs will solve the problem with Exp/Expdp. Copyright (c) 阅读全文
posted @ 2021-03-16 11:05 菲阳公社 阅读(770) 评论(0) 推荐(0)
摘要: OCR and VOTEDISK as root user, 1.ocrconfig -add newdiskgroup ocrconfig -delete olddiskgroup as grid user, 2.crsctl replace votedisk newdiskgroup as ro 阅读全文
posted @ 2021-03-15 17:09 菲阳公社 阅读(225) 评论(0) 推荐(0)
摘要: * -#include<stdio.h> int main(void) { unsigned int width; int num=256; printf("What filed width?\n"); scanf("%d",&width); printf("The number is %*d\n" 阅读全文
posted @ 2021-03-12 15:16 菲阳公社 阅读(89) 评论(0) 推荐(0)
摘要: 输入 -#include<stdio.h> int main(void) { int age; printf("Please enter your age: \n"); scanf("%d",&age);//读取第一个非空数字,到下一个空字符截止 printf("your age is %d\n", 阅读全文
posted @ 2021-03-12 13:40 菲阳公社 阅读(136) 评论(0) 推荐(0)
摘要: ## expdp需要添加 version参数 version=11.2.0.4.0(低版本号) 阅读全文
posted @ 2021-03-09 16:18 菲阳公社 阅读(110) 评论(0) 推荐(0)