zt_何为条带化stripe
http://www.uplinux.com/shizi/wenxian/4368.html http://space.itpub.net/?uid-35489-action-viewspace-itemid-667835 http://space.itpub.net/?uid-7199859-action-viewspace-itemid...
oracle virtual box下载链接
https://www.virtualbox.org/wiki/Linux_Downloads
hp_hp_unix资源链接
http://www.ixpub.net/forum.php?mod=viewthread&tid=611217&extra=page%3D1%26filter%3Ddigest%26digest%3D1%26digest%3D1
zt_checkpoint相关知识
http://rainbowbridg.itpub.net/post/23663/526560
fast_start_parallel_rollback与v$fast_start_servers和v$fast_start_transactions
oracle并行事务回滚1,目的:提升smon在instance recovery的回滚速度2,根据回滚的数据块大小,oracle smon自动决定启用多个个并行度进行回滚/******相关参数****/fast_start_parallel_rollback 1,取值有3种:fal...
oracle各个启动阶段_nomount_mount_open_dump_trace命令的可运行性
/*******测试目的:dump命令是否在数据库各个启动阶段都可使用*******/SQL> select segment_name,header_file,header_block from dba_segments where segment_name='_SYSSMU1_2533871115$';SEGMENT_NAME  ...
oracle RECOVERY_PARALLELISM与instance recovery和medium recovery的关系小记
/*********oracle并行恢复的概念*************/ 1,通过io并行化减少恢复时间2,对于数据文件存储在多个磁盘作用显著3,用于实例和介质恢复/**********oracle并行恢复相关的参数*...
oracle lock系列一
/***********v$lock官方**************/http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_2027.htm#REFRN30121oracle lock------------------------------------------------------------------/*...
dump转储undo segment header block回滚段头块小方法
/*******产生一个事务*********/SQL> insert into t_ts values(1);1 row created./*******查询上述事务对应的回滚段头及文件******/SQL> select segment_name,header_file,header_block from dba_segments where s...
oracle11g之v$libcache_locks处理library cache lock及library cache pin
/****oracle11g之v$libcache_locks解决library cache lock及library cache pin的等待者及持锁者*******//******持锁会话*************/SQL> create or replace procedure proc_lib 2 authid current_us...
plsql_提取一个表多个列之和
select replace(wm_concat('rps.'||nvl(dt.column_name,0)),',',' + ') from dba_tab_columns dt, dba_col_comments dc where dt.table_name = 'REPORT_E_CHANNEL_SETTLEMENT' and dt.TABLE_...
dsi401_block structure之(二)
dsi401_block structure之(二)什么是坏损坏1,oracle读写块(buffer or disk),肯定会进行一致性检查2,一致性检查内容: 1,block version --refer to block dump 2,...
zt_buffer busy wait
http://dba-oracle.com/art_builder_bbw.htm
zt_Failed Logon Attempts
http://hoopercharles.wordpress.com/2012/04/04/failed-logon-attempts/
window或linux平台oracle非真正导出exp小记
/**window平台可以用nul实现非真正导出dmp***linux or unix为/dev/null****/C:\Users\123>exp system/system@orcl file=nul full=yExport: Release 11.2.0.1.0 - Production on Wed Apr 3 17:19:14 2013Copyright ...
dsi401_block structure(一)
/***oracle dsi 401 block结构****/1,data block分成3部分: cache layer transaction layer data layer 2,rowi...
pressure test压力测试
/****oracle压力测试工具orion*****/http://blog.csdn.net/tianlesoftware/article/details/5965331http://www.2cto.com/database/201207/138315.html/***oracle rac测试******/http://wenku.baidu.com/view/46c92...
oracle archive归档初步
/***oracle archive一些视图****/--查看归档信息archive log listv$databasev$archived_log or rc_archived_log(if use recovery catalog)v$archive_destv$archive_processes --归档日志备份信息v$backup_redol...
oracle11g flashback archive feature新特性
/******flashback archive*****/http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_1008.htm#SQLRF20009http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_5010.htm#BABIAECC/*...
backup tool nbu
/***nbu配置案例******/http://wenku.baidu.com/view/a8640c2058fb770bf78a552b.html/********Nbu7.5安装_虚拟带库安装连接_备份测试********/http://wenku.baidu.com/view/74c6558c6529647d272852d6.html...