ITPub博客

-----------------------------------create table testflow(userid number,flowup number,flowdown number)insert into testflow values (1,1,2);insert into testflow values (1,1,2);insert into testflow value...

http://ishare.iask.sina.com.cn/search.php?key=%B4%F3%BB%B0rac&from=index&format=

oracle 动态性能(V$)视图http://dolphin-ygj.iteye.com/blog/361933 如何比较两个 Schema 的异同http://www.dbanotes.net/database/oracle_schema_compare.htmlSriv -- Thanks for the question regarding ...

REMREM compare_schemas.sqlREM ===================REMREM This script. is provided by Database Specialists, Inc. REM (http://www.dbspecialists.com) for individual use and not for sale. REM Database Spec...

--------------------------------------------------------------------------------------------------------1、查询数据库等待事件top10,关注前前几个等待事件，关注前三个等待事件是否有因果或关联关系select t2...

http://space.itpub.net/15415488/viewspace-666270 Improving performance with Data PumpThere are some considerations the user should pay attention, in order to take full advantage of this tool. W...

large pool 调整 http://space.itpub.net/25243263/viewspace-696204  ！！重要

 上一篇 / 下一篇  2011-04-27 17:28:14 查看( 87 ) / 评论( 1 ) / 评分( 0 / 0 ) 1)、检查集群状态： 　　[grid@rac02 ~]$ crsctl check clusterITPUB个人空间"s8{ Y(\ Y V-j　　CRS-4537: Cluster ...

ORACLE 10G RAC巡检脚本！2011-01-21 17:36===========================SRVCTL============================1.列出配置的所有数据库srvctl config database2.显示指定集群数据库的所有服务srvctl config se...

http://blogs.oracle.com/db/entry/master_note_for_data_pump_doc_id_12647151 Common IssuesBug 7362589 indicates with 11g performance can be very slow when exporting a small proportion of object...

情况1： 保养数据库及操作系统，服务器，需要关闭DB(所有实例)，OS 及Server 。a. 首先停止Oracle10g 环境$ lsnrctl stop (每个节点上停止监听，也可以用srvctl 来操作，每个节点上执行)$ emctl stop dbconsole ...

 情况1： 保养数据库及操作系统，服务器，需要关闭DB(所有实例)，OS及Server 。a. 首先停止Oracle10g 环境$ lsnrctl stop (每个节点上停止监听，也可以用srvctl来操作)$ emctl stop dbconsole (每个节点停...

http://blog.csdn.net/tianlesoftware/archive/2011/04/03/6300295.aspx  之前整理过一篇Oracle Patch 的文章，参考：       Oracle 补丁体系 及 opatch 工具 介绍&nbs...

hp-ux环境的rac打patch的过程记录--打patch之前需要停止所有的oracle应用，包括数据库、asm实例、监听程序、如果是rac环境还包括nodeapps和crs；--我们这里的环境是rac环境--将opatch命令的路径包含在PATH变量中...

Checklist for Slow Performance of Export Data Pump (expdp) and Import DataPump (impdp) [ID 453895.1]  Modified 24-JUN-2010     Type BULLETIN  &...

Poor Data Export Performance(revised)By admin, on November 2nd, 2010这是一个十分简单的单表导出作业，表上大约有200万条数据；但实际exp导出时dump文件每秒增长不足1MB，速度十分缓慢。123456...

sql

http://www.idevelopment.info/data/Oracle/DBA_tips/Tuning/TUNING_17.shtmlGather Statistics with DBMS_STATS by Jeff Hunter, Sr. Database Administrator Contents Overview Missing statistics Anal...