<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[startay的专栏]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/startay</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; startay]]></copyright><item><title><![CDATA[ROLE&TABLE PRIVELEGE]]></title><link>https://blog.youkuaiyun.com/startay/article/details/89495481</link><guid>https://blog.youkuaiyun.com/startay/article/details/89495481</guid><author>startay</author><pubDate>Wed, 24 Apr 2019 15:56:41 +0800</pubDate><description><![CDATA[ROLE/USER privilege

select * from pg_roles;
   rolname    | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin | rolreplication | rolconnlimit | rolpassword | rolvaliduntil...]]></description><category></category></item><item><title><![CDATA[PostgreSQL调优参数]]></title><link>https://blog.youkuaiyun.com/startay/article/details/89203196</link><guid>https://blog.youkuaiyun.com/startay/article/details/89203196</guid><author>startay</author><pubDate>Thu, 11 Apr 2019 09:44:30 +0800</pubDate><description><![CDATA[主要选项

选项
			默认值
			说明
			是否优化
			原因
		max_connections
			100
			允许客户端连接的最大数目
			否
			因为在测试的过程中，100个连接已经足够
		fsync
			on
			强制把数据同步更新到磁盘
			是
			因为系统的IO压力很大，为了更好的测试其他配置的影响，把改参数改为off
		shared_buffers...]]></description><category></category></item><item><title><![CDATA[4. postgresql数据库配置]]></title><link>https://blog.youkuaiyun.com/startay/article/details/88911609</link><guid>https://blog.youkuaiyun.com/startay/article/details/88911609</guid><author>startay</author><pubDate>Sat, 30 Mar 2019 14:09:08 +0800</pubDate><description><![CDATA[PostgreSQL有两个重要的全局配置文件，都位于初始化数据目录中

 postgresql.conf ：负责配置文件位置、资源限制、集群复制等

 pg_hba.conf ：负责客户端的连接和认证



[root@instance-795y2mib data]# ls -l /pgdata/10/data |grep conf
-rw------- 1 postgres pos...]]></description><category></category></item><item><title><![CDATA[3. postgresql 启停数据库、开机启动]]></title><link>https://blog.youkuaiyun.com/startay/article/details/88911532</link><guid>https://blog.youkuaiyun.com/startay/article/details/88911532</guid><author>startay</author><pubDate>Sat, 30 Mar 2019 14:00:28 +0800</pubDate><description><![CDATA[1. 数据库启动

su - postgres

vi .bash_profile
PGDATA=/pgdata/10/data
export PGDATA
PATH=$PATH:/usr/pgsql-10/bin
export PATH



-bash-4.2$ pg_ctl start

or       pg_ctl -D $PGDATA start

waiting f...]]></description><category></category></item><item><title><![CDATA[2. postgresql创建数据库实例]]></title><link>https://blog.youkuaiyun.com/startay/article/details/88911466</link><guid>https://blog.youkuaiyun.com/startay/article/details/88911466</guid><author>startay</author><pubDate>Sat, 30 Mar 2019 13:56:04 +0800</pubDate><description><![CDATA[1. create user

yum安装，会自动创建postgres用户，但是，建议安装前，先创建用户

[root@pghost1 ~]$ groupadd -g 1000 postgres

[root@pghost1 ~]$ useradd -g 1000 -u 1000 postgres

[root@pghost1 ~]$ id postgres

uid=1000(postgres)...]]></description><category></category></item><item><title><![CDATA[1. postgreSQL install]]></title><link>https://blog.youkuaiyun.com/startay/article/details/88911422</link><guid>https://blog.youkuaiyun.com/startay/article/details/88911422</guid><author>startay</author><pubDate>Sat, 30 Mar 2019 13:50:52 +0800</pubDate><description><![CDATA[下载页https://www.postgresql.org/download





a) yum install-yhttps://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-x86_64/pgdg-centos10-10-2.noarch.rpm

b) check postgresql yum

ls -l /et...]]></description><category></category></item><item><title><![CDATA[Mongodb Shell]]></title><link>https://blog.youkuaiyun.com/startay/article/details/88850622</link><guid>https://blog.youkuaiyun.com/startay/article/details/88850622</guid><author>startay</author><pubDate>Wed, 27 Mar 2019 17:28:30 +0800</pubDate><description><![CDATA[2.5 Mongodb Shell （javescript标准）

运行shell：

[root@instance-795y2mib oradata]# mongo

MongoDB shell version v4.0.6

connecting to: mongodb://127.0.0.1:27017/?gssapiServiceName=mongodb

Implicit session...]]></description><category></category></item><item><title><![CDATA[mongodb 安装启动]]></title><link>https://blog.youkuaiyun.com/startay/article/details/88850593</link><guid>https://blog.youkuaiyun.com/startay/article/details/88850593</guid><author>startay</author><pubDate>Wed, 27 Mar 2019 17:27:49 +0800</pubDate><description><![CDATA[mongodb 面向文档数据库，非关系型数据库



功能：索引，聚合，特殊集合，文件存储



2. 多文档组成集合 -&gt; 多集合组成数据库

一个mongo实例可承载多个数据库



2.1 文档：键值对的有序集合，值可以多种不同类型（键可以任意UTF8字符，但\0, . , $ 不能使用）

不能有重复键值，区分大小写



2.2 集合:一组文档

集合命名:1.不能是...]]></description><category></category></item><item><title><![CDATA[linux redhat安装，开启telnet服务]]></title><link>https://blog.youkuaiyun.com/startay/article/details/50233679</link><guid>https://blog.youkuaiyun.com/startay/article/details/50233679</guid><author>startay</author><pubDate>Wed, 09 Dec 2015 11:08:48 +0800</pubDate><description><![CDATA[1. 安装RPM包
光盘中的Packages文件夹下安装xinetd-2.3.14-33.el6.i686.rpm包
rpm -ivh xinetd-2.3.14-33.el6.i686.rpm ;

还要安装telnet服务包 telnet-server-0.17-47.el6.i686.rpm 
rpm -ivh telnet-server-0.17-47.el6.i686.rpm ]]></description><category></category></item><item><title><![CDATA[Oracle 11g 的 VKTM 进程 - virtual keeper of time]]></title><link>https://blog.youkuaiyun.com/startay/article/details/49692057</link><guid>https://blog.youkuaiyun.com/startay/article/details/49692057</guid><author>startay</author><pubDate>Sat, 07 Nov 2015 00:18:01 +0800</pubDate><description><![CDATA[在Oracle11g中，我们可以发现一个新的基础后台进程叫做VKTM （virtual keeper of time），这个进程是必须存在的。


在数据库启动时候的告警日志中可以看到：
VKTM started with pid=3, OS id=2256 at elevated priority
VKTM running at (20)ms precision


在数据字典中]]></description><category></category></item><item><title><![CDATA[Oracle的主要进程简要]]></title><link>https://blog.youkuaiyun.com/startay/article/details/49691269</link><guid>https://blog.youkuaiyun.com/startay/article/details/49691269</guid><author>startay</author><pubDate>Fri, 06 Nov 2015 23:52:54 +0800</pubDate><description><![CDATA[Oracle的主要进程简要说明摘录如下：






Name


Expanded Name


Short Description


Long Description


External Properties






ABMR


Auto BMR Background Process                      ]]></description><category></category></item><item><title><![CDATA[(BUG) AWR下DB TIME非常高 bug案例]]></title><link>https://blog.youkuaiyun.com/startay/article/details/49689287</link><guid>https://blog.youkuaiyun.com/startay/article/details/49689287</guid><author>startay</author><pubDate>Fri, 06 Nov 2015 22:57:00 +0800</pubDate><description><![CDATA[今天巡检发现AWR的 DB TIME 非常高，明显存在不符合现实。




MOS发现 该问题中了 Bug 17963187 : INCORRECT CPU USAGE IN 11.2.0.4

 

PROBLEM:
--------
very high CPU time reported


DIAGNOSTIC ANALYSIS:
---------------]]></description><category></category></item><item><title><![CDATA[ORACLE 未提交事务与语句查询]]></title><link>https://blog.youkuaiyun.com/startay/article/details/49589677</link><guid>https://blog.youkuaiyun.com/startay/article/details/49589677</guid><author>startay</author><pubDate>Mon, 02 Nov 2015 17:36:32 +0800</pubDate><description><![CDATA[插入一条记录，不提交


sys@EDIPD> select sid from v$mystat where rownum

       SID
----------
       771



sys@EDIPD> insert into edi.master_trackingno_table(ID,CARRIER_ID,TRACKING_NO,STATUS) value]]></description><category></category></item><item><title><![CDATA[一例DELETE频繁引发TX锁故障分析(ORA-02049)]]></title><link>https://blog.youkuaiyun.com/startay/article/details/49547861</link><guid>https://blog.youkuaiyun.com/startay/article/details/49547861</guid><author>startay</author><pubDate>Sun, 01 Nov 2015 02:38:46 +0800</pubDate><description><![CDATA[晚上收到服务器报错信息：


2015-10-31 19:47:33 CST  AMWAY_EXPRESS.deliverWaybill_RP.adapter:updatePpcklst  [ADA.1.316] Cannot execute the SQL statement "UPDATE EDI.PPCKLST SET FEEWGHT=1.0 where SHPNUM='SIE0002]]></description><category></category></item><item><title><![CDATA[ORACLE RAC ASM环境下DATAGUARD搭建步骤]]></title><link>https://blog.youkuaiyun.com/startay/article/details/49446851</link><guid>https://blog.youkuaiyun.com/startay/article/details/49446851</guid><author>startay</author><pubDate>Tue, 27 Oct 2015 13:03:23 +0800</pubDate><description><![CDATA[1、准备工作
Host IP          DB_NAME     DB_UNIQUE_NAME    Net Service Name
主库xxxxxxxxx    wechatqa      wechatqa        wechatqa , wechatqa1, wechatqa2
备库xxxxxxxxx    wechatqa      wchtqadg        wcht]]></description><category></category></item></channel></rss>