- 博客(10)
- 资源 (3)
- 收藏
- 关注
原创 pexpect-2.3安装方法
[root@pc197 tools]# wget http://pexpect.sourceforge.net/pexpect-2.3.tar.gz--2014-02-28 11:14:25-- http://pexpect.sourceforge.net/pexpect-2.3.tar.gzResolving pexpect.sourceforge.net... 216.34.181.
2014-02-28 11:26:45 5933
原创 cache lookup failed for attribute
报错信息:ERROR: XX000: cache lookup failed for attribute 1 of relation 81453940 (lsyscache.c:359) (seg5 sdw1:40017 pid=13531) (cdbdisp.c:1476)ERROR: XX000: cache lookup failed for attribute 1 of rela
2014-02-27 16:07:44 4168
原创 AWR 导出 导入 生成
wget ftp://root:xxxxxx@179.100.253.179/home/oracle/223808.log
2014-02-24 11:11:08 1422
原创 gp常用命令
[gpadmin@mdw ~]$ gpconfig --show max_connectionsValues on all segments are consistentGUC : max_connectionsMaster value: 250Segment value: 750[gpadmin@mdw ~]$ psql -c 'SHOW ALL;' -d
2014-02-11 12:37:38 3841 1
转载 postgresql 的进程监控&管理
转自:http://breakdayzhou.blog.163.com/blog/static/1825846312011419102526725/首先,在postgresql.conf中把stats_command_string = true打开,使PostgreSQL的stats collector process监控每个session的sql语句。第一个脚本 viewsql.
2014-02-10 15:35:52 3860
原创 gpcheckcat命令
使用gpcheckcat命令检验你的系统目录的完整性检查数据库:nohup $GPHOME/bin/lib/gpcheckcat -p 5432 -v dbname| tee -a /tmp/checkcat.txt &执行命令:"$GPHOME/bin/lib/gpcheckcat -A"查看日志:cd /home/gpadmin/gpAdminLogs
2014-02-08 17:26:09 3152
转载 15 Advanced PostgreSQL Commands with Examples
转自:http://www.thegeekstuff.com/2009/04/15-practical-postgresql-database-adminstration-commands/1. 如何找到postgreSQL数据库中占空间最大的表?$ /usr/local/pgsql/bin/psql testWelcome to psql 8.3.7, the Postgr
2014-02-08 13:56:21 761
原创 ORA-04021: timeout occurred while waiting to lock object
ORA-04021: timeout occurred while waiting to lock object
2014-02-02 11:29:20 1337
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人