发布时间：2014-11-20 16:14:18

DBMS_XPLAN学习https://docs.oracle.com/cd/B28359_01/appdev.111/b28419/d_xplan.htm#CACFJGHG DBMS_XPLAN 有五个功能:DISPLAY - to format and display the contents of a plan table. DISPLAY_AWR - to format and display the contents of the execution plan of a stored SQL statement in the AWR. DISPLAY.........【阅读全文】

发布时间：2014-10-31 15:33:56

脚本安装 zabbix-agent#!/bin/bash# install zabbix-agent# a.fanliao@gmail.com# Jun 20 10:37:40 CST 2013. /etc/profilea=0while [ $a -lt 1 ];do     rpm -Uhv http://repo.zabbix.com/zabbix/2.0/rhel/6/x86_64/zabbix-release-2.0-1.el6.noarch.rpm && (( a++ ))   &nbs.........【阅读全文】

发布时间：2014-10-30 17:53:57

hp-ux 11.23安装 zabbix agent bash-4.1# ls -ltotal 6320-rw-r--r--   1 root       sys        3230902 Oct 30 16:18 zabbix_agents_2.4.0.hpux11_23.ia64.tar.gzbash-4.1#bash-4.1# /usr/contrib/bin/gunzip zabbix_agents_2.4.0.hpux11_23.ia64.tar.gz bash-4.1.........【阅读全文】

发布时间：2014-09-10 18:01:03

Oracle 查看统计信息SCRIPT - Select to show Optimizer Statistics for CBO (Doc ID 31412.1)https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=1638430201757426&id=31412.1&_adf.ctrl-state=17ud5ixo9v_65 [oracle@my2950 admin]$ cd /u01/app/oracle/product/11.2.4/db_1/rdbms/admin[oracle@my2950 ad.........【阅读全文】

发布时间：2014-09-10 15:00:38

使用DBMS_XPLAN查看执行计划SQL> show user;USER is "SCOTT"SQL>SQL> select count(*) from dba_objects;  COUNT(*)----------     87091SQL> create table t2 as select * from dba_objects;Table created.SQL>SQL> create index idx_t2 on t2(OBJECT_ID);Index created.SQL> SQL> exec dbms_sta.........【阅读全文】