shihuan830619的专栏

./pg_ctl -D /usr/local/pgdb/pgdata -l shihuan.log -o "-d 5 -p 8432" start其中-d参数有5个级别，分别是1、2、3、4、5，第5个级别是最高的，即：最详细的日志输出。下面是以debug模式启动一个单机PostgreSQL服务的日志输出信息样例:2022-05-13 17:02:36.588 CST [14394] DEBUG: postgres: PostmasterMain: initial environment .

https://explain.depesz.com/https://explain.dalibo.com/说明: 把数据库的执行计划explain粘贴到上面两个网址中的一个里面，让分析explain内容更清晰明了。

官方网址:https://www.percona.com/doc/percona-toolkit/3.0/index.htmlPercona Toolkkit软件下载地址:https://www.percona.com/downloads/percona-toolkit/LATEST/

[oracle@pamiddle ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 15 10:33:08 2015Copyright (c) 1982, 2013, Oracle. All rights reserved.Connected to:Oracle Da...

[oracle@pacollector ~]$ lsnrctl status[oracle@pacollector ~]$ lsnrctl start[oracle@pacollector ~]$ lsnrctl stop[oracle@pacollector ~]$ sqlplus /nologSQL> conn /as sysdbaSQL> startup ...

[root@pacollector ~]# vi /etc/hosts这里要把本机IP和主机名加入hosts文件中VMWare设置CD/DVD处勾选已连接并指定RedHat6的ISO安装包 [root@pacollector ~]#mkdir /mnt/cdrom [root@pacollector ~]#mount -o loop /dev/cdrom /mnt/cdrom ...

本例Oracle的实例名字为[color=blue]parep[/color]。原始的listener.ora文件内容如下:[code="java"]# listener.ora Network Configuration File: C:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora# Generated ...

[root@foglight ~]# vi /etc/hosts这里要把本机IP和主机名加入hosts文件中VMWare设置CD/DVD处勾选[color=blue]已连接[/color]并指定RedHat6的ISO安装包[root@foglight ~]#mkdir /mnt/cdrom[root@foglight ~]#mount -o loop /dev/cdrom /m...

一、MySQL与Oracle数据库如何处理Clob，Blob数据类型(1)不通数据库中对应clob,blob的类型如下： MySQL中：clob对应text，blob对应blob DB2/Oracle中：clob对应clob，blob对应blob(2)domain中对应的类型： clob对应String，blob对应byte[] clob对应j...

[url]http://www.cnblogs.com/coohoo/archive/2011/01/16/1936888.html[/url][url]http://blog.youkuaiyun.com/tianlesoftware/article/details/4677378[/url] (Flash Recovery Area 的备份命令是backup recovery area ，该命令...

附件里Oracle学习资料。

[url=http://worlddownloads.quest.com.edgesuite.net/Repository/support.quest.com/Toad%20for%20Oracle/10.5/Software/Toad%20Development%20Suite%20for%20Oracle%2010.5%20Commercial.exe]Toad Development Sui...

create or replace function str_list2( key_name in varchar2, key in varchar2, coname in varchar2, tname in varchar2 ) return varcha...

create or replace procedure PC_TB_HTTPTASK_RESULT_TMP ISv_http_targetalias varchar2(300);v_http_dns_avgrtt number;v_http_avgrtt number;v_http_firstbyte_avgrtt number;v_http_body_avgrtt numbe...

依赖ojdbc14.jar包OraclePooled.java代码：[code="java"]import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import javax.sql.PooledConnection;import oracle....