AssassinAnn

摘要： 今天去机房拷贝备份回来，发现RH5.5不支持NTFS的文件格式挂载，在网上找到一种方法还是比较好用，需安装一个叫ntfs-3g软件的第三方工具。[root@linux_v1 ~]# uname -aLinux linux_v1.com 2.6.18-194.el5 #1 SMP Tue Mar 16 21:52:39 EDT 2010 x86_64 x86_64 x86_64 GNU/Linux查看内核版本为2.6.18-194.el5，查看后去http://sourceforge.net/projects/fuse/files/fuse-2.X/2.7.0/下载fuse-2.7.0.tar. 阅读全文

摘要： 近日陆续接到项目组反馈的ORA-00020错误反馈，并且监控数据库服务器还有CPU占用较高的情况，初步判定是新上线的一个项目连接数过多导致超出最大进程数的问题，ORACLE的processes参数默认是150，通过调整该参数至400后解决ORA-00020问题，但CPU占用较高(16核均在80%左右)的问题依然存在。当天生成AWR报告观察实例性能主要参数，如图： 观察发现Excute to Parse %和Parse CPU to Parse Elapsd %的比值与目标值差距较大。 Execute to Parse %说明执行sql和解析sql之间的比例，越大越好，计算公式是100*... 阅读全文

摘要： 释放空间 阅读全文

摘要： 配置网络连通vi /etc/hosts主机创建/查看归档目录,创建备库在线日志目录mkdir /u02/oradata/ann01/archive_logmkdir /u02/oradata/ann01/standby在备机上创建相关目录(保证如下几项与主库一致)mkdir $ORACLE_BASE/adminmkdir $ORACLE_BASE/admin/ann01mkdir $ORACLE_BASE/admin/ann01/{a,b,c,u,dp}dump（此项11G有所不同）mkdir /u02/oradata/ann01mkdir /u02/oradata/ann01/archive 阅读全文

摘要： Experiment of expdp and impdp 阅读全文

摘要： Data Pump Export is a utility for unloading data and metadata into a set of operating system files called a dump file set. The dump file set can be imported only by the Data Pump Import utility. The dump file set can be imported on the same system or it can be moved to another system and loaded th.. 阅读全文

摘要： Steps in a Typical LogMiner Session:Enable Supplemental LoggingExtract a LogMiner Dictionary (unless you plan to use the online catalog)Specify Redo Log Files for AnalysisStart LogMinerQuery V$LOGMNR_CONTENTSEnd the LogMiner SessionEnable Supplemental LoggingSQL> SELECT SUPPLEMENTAL_LOG_DATA_MIN 阅读全文

摘要： Based on: All changes made to user data or to the database dictionary are recorded in the Oracle redo log files so that database recovery operations can be performed.Pinpointingwhen a logical corruption to a database, such as errors made at the application level and so on.LogMiner Benefits:Pinpoint. 阅读全文

摘要： 先通过一个实验探讨一下索引的问题创建测试环境create table test01(c1 number,c2 number);declare i number:=1;begin while i<=100000 loop insert into test01(c1,c2) select i,dbms_random.value(1,100000) from dual; if mod(i,1000)=0 then commit; end if; i:=i+1; end loop;end;create index idx_test01_c1 on test01(... 阅读全文