<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cmbpr28628的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cmbpr28628</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cmbpr28628]]></copyright><item><title><![CDATA[配置pycharm连接linux]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298692</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298692</guid><author>cmbpr28628</author><pubDate>Sat, 31 Aug 2019 20:23:56 +0800</pubDate><description><![CDATA[选择








寻找解释器路径


然后配置文件存储路径：
















看另一个选项配置



...]]></description><category></category></item><item><title><![CDATA[datagrip安装]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298684</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298684</guid><author>cmbpr28628</author><pubDate>Sat, 31 Aug 2019 14:26:37 +0800</pubDate><description><![CDATA[今天开发帅哥推荐使用了，索性就找教程安装下，软件介质在下面

链接：https://pan.baidu.com/s/1CVa1_UcKaCGDYcpCoVsKKw

提取码：cyxy


安装之后呢，首先修改h...]]></description><category></category></item><item><title><![CDATA[linux简易 Oracle客户端安装]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298681</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298681</guid><author>cmbpr28628</author><pubDate>Wed, 10 Jul 2019 10:40:45 +0800</pubDate><description><![CDATA[需求是这样的，大数据环境要安装Oracle客户端，





oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm


oracle-instant...]]></description><category></category></item><item><title><![CDATA[java.lang.IllegalArgumentException:There is no column named SYS_NC00010$]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298683</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298683</guid><author>cmbpr28628</author><pubDate>Fri, 21 Jun 2019 14:46:40 +0800</pubDate><description><![CDATA[业务要求建立唯一索引，并且这个唯一索引还带有逻辑判断的，(⊙﹏⊙)，那么对于程序自身也可能带来点小问题(⊙﹏⊙)





createuniqueindexDMP_CORE_BASE.u_project_...]]></description><category></category></item><item><title><![CDATA[Oracle和MySQL md5加密]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298678</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298678</guid><author>cmbpr28628</author><pubDate>Mon, 17 Jun 2019 14:53:39 +0800</pubDate><description><![CDATA[mysql&gt;selectMD5(15201061106);
+----------------------------------+
|MD5(15201061106)|
...]]></description><category></category></item><item><title><![CDATA[Oracle blob类型数据转换成 base64编码]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298689</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298689</guid><author>cmbpr28628</author><pubDate>Sat, 15 Jun 2019 12:05:51 +0800</pubDate><description><![CDATA[需求大概是这样的


base64编码列表的Json格式字符串，图片文件格式是jpg,形如：


"[{"employ_files":"/9j/4AAQSkZJRgABAQEAYABgAAD"},{"emplo...]]></description><category></category></item><item><title><![CDATA[12c pdb基本操作]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298682</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298682</guid><author>cmbpr28628</author><pubDate>Tue, 04 Jun 2019 11:09:27 +0800</pubDate><description><![CDATA[pdb级别都有自己的directory



altersessionsetcontainer=zdtydb;
createdirectoryexpdp_dataas'/data2/dumpdat...]]></description><category></category></item><item><title><![CDATA[审计表 aud$ 清理]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298685</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298685</guid><author>cmbpr28628</author><pubDate>Mon, 04 Mar 2019 09:39:12 +0800</pubDate><description><![CDATA[SELECTD.TABLESPACE_NAME,
SPACE||'M'"SUM_SPACE(M)",
BLOCKS"SUM_BLOCKS",
SPACE-NVL...]]></description><category></category></item><item><title><![CDATA[MySQL double write]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298696</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298696</guid><author>cmbpr28628</author><pubDate>Fri, 14 Dec 2018 15:20:16 +0800</pubDate><description><![CDATA[double write



技术的引入就是为了提高数据写入的可靠性。当写入部分数据的时候，比如：512bytes。




为什么Oracle没有解决这个问题，而MySQL通过double wr...]]></description><category></category></item><item><title><![CDATA[MySQL socket文件被删除]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298697</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298697</guid><author>cmbpr28628</author><pubDate>Fri, 14 Dec 2018 12:53:40 +0800</pubDate><description><![CDATA[今天 登陆数据库发现



















首先说明： 这个文件不能不重启给恢复出来。


其次：

该文件是unix_domain通信使用文件，如果你不是通...]]></description><category></category></item><item><title><![CDATA[Oracle 脚本 线上哪些索引从来没有被使用过]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298676</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298676</guid><author>cmbpr28628</author><pubDate>Fri, 14 Dec 2018 11:14:23 +0800</pubDate><description><![CDATA[数据库经过N手后，索引乱建，下面的SQL就找出一点时间范围内哪些索引从来没被使用过，亲测好用，注意一点，生成的SQL你要是执行了，就会从脚本中消失了，





SELECTX.OWNER,
X...]]></description><category></category></item><item><title><![CDATA[应用改字符集小记]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298680</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298680</guid><author>cmbpr28628</author><pubDate>Sun, 02 Dec 2018 17:04:24 +0800</pubDate><description><![CDATA[由于公司业务需求，需要将数据库的字符集16GBK改成UTF8





ORA-02374: conversion error loading table "CONFIG"."CFG_CN_CHAR_DICT"...]]></description><category></category></item><item><title><![CDATA[rac上的sequence]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298695</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298695</guid><author>cmbpr28628</author><pubDate>Fri, 30 Nov 2018 20:18:11 +0800</pubDate><description><![CDATA[昨天和网友探讨，RAC中的SEQUENCE，awr报告如下，摘取关键部分：

















在RAC环境中，序列的Cache问题可能会对性能有着决定性的影响，缺省的序列C...]]></description><category></category></item><item><title><![CDATA[linux vdo验证 oracle asm diskgroup sector_size 4096 udev asmlib]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298667</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298667</guid><author>cmbpr28628</author><pubDate>Sat, 27 Oct 2018 14:29:12 +0800</pubDate><description><![CDATA[关于VDO


VOD的技术来源于收购的Permabit公司，一个专门从事重删技术的公司，所以技术可靠性是没有问题的


VDO是一个内核模块，目的是通过重删减少磁盘的空间占用，以及减少复制带宽，VDO是基于块设...]]></description><category></category></item><item><title><![CDATA[ERROR 1114 (HY000)  The table '' is full]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298526</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298526</guid><author>cmbpr28628</author><pubDate>Sun, 21 Oct 2018 15:16:04 +0800</pubDate><description><![CDATA[客户的5.1的mysql迁移到5.7，tb_mk_revisit_id是innodb表





$mysql -u root -p webparty &lt; /data2/woqu/tbover6.sql ...]]></description><category></category></item><item><title><![CDATA[Oracle 18C新特性之PDB snapshot(快照) Carousel]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298528</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298528</guid><author>cmbpr28628</author><pubDate>Fri, 12 Oct 2018 16:24:02 +0800</pubDate><description><![CDATA[|关于PDB快照Carousel






Oracle18c新特新 pdb snapshot Carousel提供了在pdb级别下手工或者自动生成快照的功能，为开发测试用例提供了便捷。CDB为...]]></description><category></category></item><item><title><![CDATA[SQL优化案例-分区索引之无前缀索引（六）]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298556</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298556</guid><author>cmbpr28628</author><pubDate>Tue, 21 Aug 2018 10:49:05 +0800</pubDate><description><![CDATA[SQL文本如下，跨分区查询，分区字段post_date（为保证客户隐私，已经将注释和文字部分去掉）：




跨30个分区执行了6分钟。



SELECT/*+index(IIND_DATE_CO...]]></description><category></category></item><item><title><![CDATA[alter table nologging   /*+APPEND PARALLEL(n)*/]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298524</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298524</guid><author>cmbpr28628</author><pubDate>Thu, 31 May 2018 19:57:53 +0800</pubDate><description><![CDATA[最近系统中关键任务做了如下操作，

alter table table_name nologging;

alter session enable parallel dml;
...]]></description><category></category></item><item><title><![CDATA[sql中select列有自定义函数 dblink]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298568</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298568</guid><author>cmbpr28628</author><pubDate>Sat, 26 May 2018 11:44:53 +0800</pubDate><description><![CDATA[原来抽取的方式是b库oci打包数据后将数据放到中间件本地磁盘，然后通过sqlldr方式加载到a库。sql如下：

select column_name1,function_name(column_name2) from ...]]></description><category></category></item><item><title><![CDATA[Oracle 12c系列(四)｜资源隔离之IO、内存、CPU]]></title><link>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298522</link><guid>https://blog.youkuaiyun.com/cmbpr28628/article/details/100298522</guid><author>cmbpr28628</author><pubDate>Sat, 28 Apr 2018 20:30:29 +0800</pubDate><description><![CDATA[沃趣科技数据库技术专家 姚崇










 


	一、IO 资源隔离



 



12cR2中，引入了两个参数MAX_IOPS和MAX_MBPS来限制PDB的物...]]></description><category></category></item></channel></rss>