ora2pg安装及卸载
--ora2pg安装
tar xzf ora2pg-10.x.tar.gz
or
tar xjf ora2pg-10.x.tar.bz2
cd ora2pg-10.x/
perl Makefile.PL
make && make install
--ora2pg卸载
rm -rf /usr/bin/ora2pg
rm -rf /usr/lib/perl5/site_perl/5.8.8/Ora2Pg.pm
rm -rf /usr/lib/perl5/site_perl/5.8.8/Ora2Pg/PLSQL.pm
rm -rf /usr/share/man/man3/ora2pg.3
rm -rf /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/Ora2Pg/.packlist
--安装DBD::oracle
export LD_LIBRARY_PATH=/usr/lib/oracle/11.2/client64/lib
export ORACLE_HOME=/usr/lib/oracle/11.2/client64/
perl -MCPAN -e 'install DBD::Oracle'
or
--DBI模块的安装
# tar xvzf DBI-1.617.tar.gz
# cd DBI-1.617
# vi README
# perl Makefile.PL
# make
# make test
# make install
--DBD::Oracle::模块的安装
--安装DBD::Oracle模块前要先安装oracle example
--设置环境变量
# export ORACLE_HOME=/u01/app/oracle/product/10.2.0
# export ORACLE_USERID='test/test@ora10g'
# export PATH=$ORACLE_HOME/bin:$PATH
# export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
--安装DBD::Oracle模块
# tar xzvf DBD-Oracle-1.38.tar.gz
# cd DBD-Oracle-1.38
# perl Makefile.PL
# make
# make test
# make install
----------------------------------------------------------
《高性能SQL调优精要与案例解析》
blog1:http://www.cnblogs.com/lhdz_bj
blog2:http://blog.itpub.net/8484829
blog3:http://blog.csdn.net/tuning_optmization