<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[scliu的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/scliu</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; scliu]]></copyright><item><title><![CDATA[git常用命令]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/144528803</link><guid>https://blog.youkuaiyun.com/scliu/article/details/144528803</guid><author>scliu</author><pubDate>Tue, 17 Dec 2024 10:49:03 +0800</pubDate><description><![CDATA[git init。]]></description><category></category></item><item><title><![CDATA[centos7安装达梦数据库dm8]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/121614167</link><guid>https://blog.youkuaiyun.com/scliu/article/details/121614167</guid><author>scliu</author><pubDate>Mon, 29 Nov 2021 16:59:34 +0800</pubDate><description><![CDATA[[root@dell21 mnt]# mount -o loop dm8_20210712_x86_rh6_64_ent
dm8_20210712_x86_rh6_64_ent/     dm8_20210712_x86_rh6_64_ent.zip
[root@dell21 tmp]# mount -o loop dm8_20210712_x86_rh6_64_ent/dm8_20210712_x86_rh6_64_ent_8.1.2.38_pack1.iso /mnt
mount: /dev/loop0]]></description><category></category></item><item><title><![CDATA[greenplum6 找回删掉的数据]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/121569754</link><guid>https://blog.youkuaiyun.com/scliu/article/details/121569754</guid><author>scliu</author><pubDate>Fri, 26 Nov 2021 22:23:03 +0800</pubDate><description><![CDATA[greenplum6上delete命令误删数据可以通过pageinspect插件找回。
安装pageinspect插件：
create extension pageinspect;
安装完成后通过下面的方式找回数据

t_data是16进制的数据，需要转换成可读的数据。
greenplum6自带的pageinspect没有t_data列，改了代码可以输出t_data。

...]]></description><category></category></item><item><title><![CDATA[PL/SQL 连接 Oralce 提示 Could not initialize oci.dll]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/120907874</link><guid>https://blog.youkuaiyun.com/scliu/article/details/120907874</guid><author>scliu</author><pubDate>Fri, 22 Oct 2021 16:03:01 +0800</pubDate><description><![CDATA[在 x64 的 Win7 上重新安装了 Oralce 后，通过 PL/SQL 连接数据库时，提示如下错误信息
Could not initialize “C:\oracle\instantclient\oci.dll”
Make sure you have the 32 bits Oracle Client installed.
环境
windows10 64bit
Oracle win64 19c
PL/SQL v12.0
详细错误信息
Initialization error
Could not ini]]></description><category></category></item><item><title><![CDATA[nf_conntrack : table full, dropping packet]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/120742352</link><guid>https://blog.youkuaiyun.com/scliu/article/details/120742352</guid><author>scliu</author><pubDate>Wed, 13 Oct 2021 13:55:50 +0800</pubDate><description><![CDATA[停了docker 重启服务器 nf_conntrack 就消失了
systemctl stop docker
systemctl disable docker
lsmod | grep conntrack

]]></description><category></category></item><item><title><![CDATA[greenplum 生成执行计划慢的一种情况]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/116735289</link><guid>https://blog.youkuaiyun.com/scliu/article/details/116735289</guid><author>scliu</author><pubDate>Thu, 13 May 2021 09:06:44 +0800</pubDate><description><![CDATA[greenplum 4.3.33 版本遇到生成执行计划需要7秒左右的时间，相关信息如下：
Thread 2 (Thread 0x7f64eac77700 (LWP 31116)):
#0  0x00007f64e65acdfd in poll () from /lib64/libc.so.6
#1  0x0000000000bbb034 in rxThreadFunc (arg=) at ic_udpifc.c:6313
#2  0x00007f64e70acdc5 in start_thread () f]]></description><category></category></item><item><title><![CDATA[greenplum6查找表的relfilenode]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/105985619</link><guid>https://blog.youkuaiyun.com/scliu/article/details/105985619</guid><author>scliu</author><pubDate>Fri, 08 May 2020 00:29:26 +0800</pubDate><description><![CDATA[testdb=# select oid,pg_relation_filenode(oid),relname from pg_class where relname like 'pg_type%';
oid | pg_relation_filenode |      relname
------+----------------------+----------------------...]]></description><category></category></item><item><title><![CDATA[MySQL 停机冷备搭建主从复制]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/100008548</link><guid>https://blog.youkuaiyun.com/scliu/article/details/100008548</guid><author>scliu</author><pubDate>Thu, 22 Aug 2019 10:04:25 +0800</pubDate><description><![CDATA[1、停止主库备库
systemctl stop mysqld
2、复制主库文件到备库
a，备库切换到mysql datadir 目录,执行命令
nc -l 6666 |tar -C ./ -xf -
b，主库切换到mysql datadir 目录,执行命令
tar -cf - test1 |nc mysql2 6666   （需要同步的数据库）
tar -cf - ibdata1 |nc mysq...]]></description><category></category></item><item><title><![CDATA[Linux SCSI target framework (tgt)源码解读一]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/99701415</link><guid>https://blog.youkuaiyun.com/scliu/article/details/99701415</guid><author>scliu</author><pubDate>Sun, 18 Aug 2019 09:57:51 +0800</pubDate><description><![CDATA[测试环境执行读操作后，tgt程序的线程中有部分线程出现了pread64调用。对应线程的调用堆栈：
Thread 19 (Thread 0x7f2e6881a700 (LWP 23420)):
#0  0x000000317c40f063 in pread64 () from /lib64/libpthread.so.0
#1  0x0000000000432af7 in bs_rdwr_reque...]]></description><category></category></item><item><title><![CDATA[Postgresql startup 进程waiting问题原因分析]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/98530529</link><guid>https://blog.youkuaiyun.com/scliu/article/details/98530529</guid><author>scliu</author><pubDate>Mon, 05 Aug 2019 22:46:04 +0800</pubDate><description><![CDATA[一、问题现象：
Postgresql 11.2版本物理复制，startup 进程命令行有时会出现waiting 标识。本文分析了出现waiting 标识的原因。
二、问题分析：
通过ps -ef | grep startup 监控startup 进程。
postgres: startup process   recovering 0000000100000000000000A6
当startup ...]]></description><category></category></item><item><title><![CDATA[greenplum 4.2.7性能参数]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/82322440</link><guid>https://blog.youkuaiyun.com/scliu/article/details/82322440</guid><author>scliu</author><pubDate>Sat, 18 Jan 2014 15:41:05 +0800</pubDate><description><![CDATA[gp_resqueue_priority_cpucores_per_segment=16

gp_external_enable_exec=on

gp_segment_connect_timeout=30min

shared_buffers=256MB

gp_external_grant_privileges=on

max_fsm_pages=400000

max_fsm_relatio...]]></description><category></category></item><item><title><![CDATA[常用expdp脚本]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/82322364</link><guid>https://blog.youkuaiyun.com/scliu/article/details/82322364</guid><author>scliu</author><pubDate>Fri, 27 Dec 2013 16:37:34 +0800</pubDate><description><![CDATA[只导表结构

expdp gdsdc/gdsdc dumpfile=gdsdc1227.dmp logfile=gdsdc1227.log directory=IMPDPDATA job_name=gdsdc_job CONTENT=METADATA_ONLY SCHEMAS=gdsdc exclude=STATISTICS



导出schema部分特征表不导出

expdp gdsdc/gd...]]></description><category></category></item><item><title><![CDATA[中医治疗瘊子]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/82322429</link><guid>https://blog.youkuaiyun.com/scliu/article/details/82322429</guid><author>scliu</author><pubDate>Sun, 14 Jul 2013 09:59:25 +0800</pubDate><description><![CDATA[最简单的方法：1、到药店买一盒鸡眼贴，贴在瘊子上面，一天换一片，过几天猴子就自己脱落了。2、白面加白醋兑成浆糊样，胡在瘊子上，一天一次或者两次，短的话 3 4天多的一个礼拜就会脱水变成死皮，用指甲剪剪掉就可以了。3、用祛痣平瘊治疗4、用醋泡鸡蛋，鸡蛋洗干净后，用针在蛋壳上扎几个针眼，放在醋中浸泡24小时，把鸡蛋和醋一起煮熟吃下。连吃3天一个疗程。如果瘊子多可以再吃3天。...]]></description><category></category></item><item><title><![CDATA[cache buffers chains]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/82322298</link><guid>https://blog.youkuaiyun.com/scliu/article/details/82322298</guid><author>scliu</author><pubDate>Wed, 08 Feb 2012 11:09:42 +0800</pubDate><description><![CDATA[cache buffers chains The cache buffers chains  latches are used to protect a buffer list in the buffer cache. These  latches are used when searching for, adding, or removing a buffer from  the buffer ...]]></description><category></category></item><item><title><![CDATA[重建undo表空间]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/82322294</link><guid>https://blog.youkuaiyun.com/scliu/article/details/82322294</guid><author>scliu</author><pubDate>Mon, 06 Feb 2012 13:38:12 +0800</pubDate><description><![CDATA[1.确认文件 SQL&amp;gt; select file_name,bytes/1024/1024 from dba_data_files   2  where tablespace_name like 'UNDOTBS1';  FILE_NAME -----------------------------------------------------------------------------...]]></description><category></category></item><item><title><![CDATA[脾胃虚弱用什么中成药比较好？]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/82322027</link><guid>https://blog.youkuaiyun.com/scliu/article/details/82322027</guid><author>scliu</author><pubDate>Mon, 13 Dec 2010 13:03:29 +0800</pubDate><description><![CDATA[脾胃虚弱，可以用参苓白术散，归脾丸，补中益气丸。如果有腹泻用参苓白术散比较好。如果有失眠心悸用归脾丸比较好。如果有内脏下垂，用补中益气丸。饭后腹涨多存在一个脾胃不合，用香砂六君丸。比较合适。...]]></description><category></category></item><item><title><![CDATA[引用 oracle用nfs时mount设置]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/82322043</link><guid>https://blog.youkuaiyun.com/scliu/article/details/82322043</guid><author>scliu</author><pubDate>Fri, 10 Dec 2010 13:06:43 +0800</pubDate><description><![CDATA[ 引用simon-zzm 的 oracle用nfs时mount设置oracle归档进程写日志到NFS文件系统，与一般的在NFS文件系统上通过命令添加删除文件是不同的，要在mount NFS文件系统的时候指定一定的参数才能让归档进程正常归档。
原来是这样指定mount的：
mount -t nfs 192.168.60.110:/exitgogo /free/oracle/orarch
增加moun...]]></description><category></category></item><item><title><![CDATA[oracle支持字符集名称]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/82322021</link><guid>https://blog.youkuaiyun.com/scliu/article/details/82322021</guid><author>scliu</author><pubDate>Tue, 09 Nov 2010 15:11:59 +0800</pubDate><description><![CDATA[oracle支持字符集名称：

SQL&amp;gt; select value from V$NLS_VALID_VALUES where parameter='CHARACTERSET' order by value;
......

242 rows selected.

将名称转换成十六进制：

SQL&amp;gt; SELECT to_char(NLS_CHARSET_ID('ZHS16GBK'),'...]]></description><category></category></item><item><title><![CDATA[Oracle取表记录的长度（字节数）]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/82322111</link><guid>https://blog.youkuaiyun.com/scliu/article/details/82322111</guid><author>scliu</author><pubDate>Thu, 28 Oct 2010 09:55:32 +0800</pubDate><description><![CDATA[/* Formatted on 2010/10/28 9:25:00 (QP5 v5.163.1008.3004) */  SELECT owner,         table_name,         column_name,         data_type,         data_length,         SUM (            CASE data_type    ...]]></description><category></category></item><item><title><![CDATA[跟踪Oracle session 诊断问题]]></title><link>https://blog.youkuaiyun.com/scliu/article/details/82322109</link><guid>https://blog.youkuaiyun.com/scliu/article/details/82322109</guid><author>scliu</author><pubDate>Thu, 21 Oct 2010 16:47:09 +0800</pubDate><description><![CDATA[1、获取session相关信息
select sid,SERIAL#,USERNAME ,OSUSER,MACHINE,PROCESS,MACHINE,TERMINAL,PROGRAM,event, LOGON_TIME,sql_id from v$session where program='QLYGDataExchange.exe';
select sql_id from v$session...]]></description><category></category></item></channel></rss>