ITPub博客

用冷备份+归档日志执行不完全恢复一例本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息及本声明http://blog.itpub.net/post/11/3523用冷备份+归档日志执行不完全恢复一例 windows 2000or...

Oracle 10g : rman恢复时候数据文件的自动创建 select name,status from v$datafile;select * from v$recover_file;drop tablespace test including contents and datafiles;drop user test cascade;create tab...

如果主体定义站点down机需要重建复制环境在其他站点上以sys用户清除相应的视图信息即可.conn / as sysdbadelete DBA_REPSITES;delete DBA_REPGROUP;delete DEFTRANDEST;delete DEFERROR;delete DEFSCHEDULE;truncate...

建立指定数目数据库连接的脚本.本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息及本声明http://blog.itpub.net/post/11/3357created by husthxd-- 1.kill session方式-- 用于记录连接信息的...

环境:windows 2000 serveroracle 10.1.0.2 1.>

在数据库nomount状态下,不能用rman连接目标数据库.D:oracleproduct10.1.0BIN>rman target sys/manager@test10g catalog rman/rman@simis10g 恢复管理器: 版本10.1.0.2.0 - Production Copyright (c) 1995,...

sth about hard parses & latches.2004-10-18过多的hard parses会引起消耗系统资源,降低查询响应时间/latches争用/会引起shared_pool的碎片以下查询用于监测执行过多hard parses的程序column program format a20sele...

enjoy it.[@more@]比如一个查询select t1.*,t2.*,t3.*from t1,t2,t3where t1.c1 = t2.c1 and t1.c1 = t3.c1/可以分别建立三个表t1,t2,t3快速刷新的物化视图mv_t1,mv_t2,mv_t3,然后建立视图create view test asselect mv_t1.*,mv_t2.*,mv_t3.*from mv_t1,mv_t2,mv_t3where mv_t1.c1 = mv_t2.c1 and mv_t1.c1 = mv_t3.c1/该视图性能上与上述查询的物化视图会有不少差距,就看用户能否接受了.

enjoy it.比如一个查询select t1.*,t2.*,t3.*from t1,t2,t3where t1.c1 = t2.c1 and t1.c1 = t3.c1/可以分别建立三个表t1,t2,t3快速刷新的物化视图mv_t1,mv_t2,mv_t3,然后建立视图create view test asselect mv_t1.*...

trying...Oracle DBA Interview Questions By B G1. How many memory layers are in the shared pool?2. How do you find out from the RMAN catalog if a particular archive log has been backed-up?3. How can yo...

1.SERVICE_NAMES与LISTENER本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息及本声明http://blog.itpub.net/post/11/3085彻底理解初始化参数SERVICE_NAMES和客户端TNS中SERVICE_NAME Aut...

 SERVICE_NAMES与客户端的TNS配置       本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息及本声明      http://blog.itpub.ne...

Oracle Database 10g High Availability with RAC, Flashback & Data GuardI will paste the book's note later.btw：It's tired to read English book.Oracle Database 10g-High Availability with RAC, Flash...

关于10gRAC的VIP一些关于vip的文档：1.each node will have not only its own statically assigned IP address, but also a virtual IP address that is assigned to the node. The listener on each node will actu...

关于sort/hash区域大小的设置--  The following query against v$sesstat will show information about sorts across the entire database.SELECT name, value  FROM v$sysstat  WHERE name like 'so...

由于磁盘空间不够,只能够首先删除归档日志/以前的备份集再做备份.存在风险，慎用。本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息及本声明http://blog.itpub.net/post/11/3001-- rman脚本RM...

使用以下语句验证索引[@more@]-- 使用以下语句验证索引-- 注意pct_used,如果小于used_space/btree_space-pct_free,考虑rebuild索引-- An index can deteriorate over time due to sparseness, not due to "unbalancing". analyze index <index_name> validate structure/select btree_space, used_space, pct_used, blocks, lf_blks, br_blks from index_stats/ALTER INDEX <index_name> COALESCE COMPUTE STATISTICS/

OTN上一些sql脚本------------------------------------------------------------------------------------1-- 1.Here's a function to calculate the number of seconds elapsed in a given period of time. create...

使用以下语句验证索引-- 使用以下语句验证索引-- 注意pct_used,如果小于used_space/btree_space-pct_free,考虑rebuild索引-- An index can deteriorate over time due to sparseness, not due to "unbalancing". ana...

今天做测试。-- Date : 2004-10-10 09:09插入的时候出错，检查后发现建立复制的触发器时不成功，删除了复制主体对象而没有删除触发器而导致，跟高级复制无关。需要小心注意。继续测试.-- Date : 2004-10-10 12:39下...