- 博客(335)
- 资源 (2)
- 收藏
- 关注
原创 [每日一题] 11gOCP 1z0-053 :2013-10-11 Flashback Data Archive属性.........................43
[每日一题] 11gOCP 1z0-053 :2013-10-11 Flashback Data Archive属性
2013-10-12 20:58:01 3348 1
原创 [每日一题] 11gOCP 1z0-053 :2013-10-10 materialized view---- online redefinition ...................35
[每日一题] 11gOCP 1z0-053 :2013-10-10 materialized view---- online redefinition
2013-10-12 19:28:29 4031 1
原创 [每日一题] 11gOCP 1z0-053 :2013-10-9 backup with the KEEP option....................................33
[每日一题] 11gOCP 1z0-053 :2013-10-9 backup with the KEEP option
2013-10-09 17:32:44 4957
原创 [每日一题] 11gOCP 1z0-053 :2013-10-8 attribute for an individual disk group.....................73
[每日一题] 11gOCP 1z0-053 :2013-10-8 attribute for an individual disk group
2013-10-09 15:22:07 3719
原创 [每日一题] 11gOCP 1z0-053 :2013-10-7 the backup of MULT_DATA................................32
[每日一题] 11gOCP 1z0-053 :2013-10-7 the backup of MULT_DATA
2013-10-09 12:34:27 4833 1
原创 [每日一题] 11gOCP 1z0-053 :2013-10-6 significance of the CHANGE FAILURE ..................25
[每日一题] 11gOCP 1z0-053 :2013-10-6 significance of the CHANGE FAILURE
2013-10-06 23:33:13 3999 2
原创 [每日一题] 11gOCP 1z0-053 :2013-10-5 SQL Access Advisor.........................................23
[每日一题] 11gOCP 1z0-053 :2013-10-5 SQL Access Advisor
2013-10-05 17:07:17 3183
转载 Buffer busy waits我的看法
转载地址:http://www.itpub.net/thread-1801066-1-1.html最近看到论坛里好几篇帖子在讨论buffer busy waits,在这里谈谈我的看法。先说说这个等待怎么来的。buffer busy waits 的由来。当n个进程想以不兼容的模式持有内存块上的buffer pin的时候,就会产生buffer busy waits等待。什么?内存块上有buffer p
2013-10-05 00:00:02 6874 1
转载 深入Oracle Log Buffer 发展史
转载地址:http://www.itpub.net/thread-1803010-1-1.htmllog buffer在Oracle的各个版本里一共发生过2次重大的改变:1)多log buffer(redo strands)的出现(9I)2)private redo和in memory undo的出现(10g)你可能会补充说,还应该包括12c的多lgwr,是的,这也是一次革命性的改变,但是目前还没
2013-10-04 23:54:02 1892
转载 漫谈LOG FILE SYNC
转载地址:http://www.itpub.net/thread-1807437-1-1.htmlLOG FILE SYNC概述来新公司工作,很大的一段时间都在调优日志写,提升系统的TPS,在这方面也积累了一些理论知识和实践经验,之前零零散散在微博上也发了很多关于logfile sync的帖子,篇幅都很短,有些是自己优化系统过程中的一个心得,有些是看书过程中的一点感悟,这次把他们汇集起来,变得也更
2013-10-04 23:43:23 3294
转载 深入分析direct path read(11G)
转载地址:http://www.itpub.net/thread-1807437-1-1.html 传统读取数据的方式是服务器进程通过读取磁盘,然后把数据加载到共享内存中,这样后面的进程就可以通过共享内存访问这些数据,不用再通过缓慢的磁盘读取来完成。direct path read读取数据块方式,是指服务器进程直接读取数据文件,不经过buffer cache,这种方式读取的数据块会
2013-10-04 23:13:08 4335
原创 [每日一题] 11gOCP 1z0-053 :2013-10-4 Database Replay feature..................................17
[每日一题] 11gOCP 1z0-053 :2013-10-4 Database Replay feature
2013-10-04 20:41:14 3431
原创 [每日一题] 11gOCP 1z0-053 :2013-10-3 large ASM files--- variable extent size....................15
[每日一题] 11gOCP 1z0-053 :2013-10-3 large ASM files--- variable extent size
2013-10-03 21:32:49 4027
原创 [每日一题] 11gOCP 1z0-053 :2013-10-2 virtual private catalogs.......................................13
[每日一题] 11gOCP 1z0-053 :2013-10-2 virtual private catalogs
2013-10-02 23:43:47 3878
原创 [每日一题] 11gOCP 1z0-053 :2013-10-1 persistent lightweight jobs...........................11
[每日一题] 11gOCP 1z0-053 :2013-10-1 persistent lightweight jobs
2013-10-01 21:16:39 4259
原创 [每日一题] 11gOCP 1z0-053 :2013-09-30 ASMCMD.......................................................8
[每日一题] 11gOCP 1z0-053 :2013-09-30 ASMCMD
2013-09-30 20:39:28 3211
原创 [每日一题] 11gOCP 1z0-053 :2013-09-29 Flashback Data Archive ...................................6
[每日一题] 11gOCP 1z0-053 :2013-09-29 Flashback Data Archive
2013-09-30 19:18:26 3381
原创 [每日一题] 11gOCP 1z0-052 :2013-09-28 ORA-01555: snapshot too old......................C52
[每日一题] 11gOCP 1z0-052 :2013-09-28 ORA-01555: snapshot too old
2013-09-30 18:25:26 3772
原创 [每日一题] 11gOCP 1z0-052 :2013-09-27 bitmap index.................................................C37
[每日一题] 11gOCP 1z0-052 :2013-09-27 bitmap index
2013-09-27 17:57:19 4424 3
原创 [每日一题] 11gOCP 1z0-052 :2013-09-26 Listener.....................................................C29
[每日一题] 11gOCP 1z0-052 :2013-09-26 Listener
2013-09-27 07:47:47 2746
原创 [每日一题] 11gOCP 1z0-052 :2013-09-25 Lock ――for update.................................C23
[每日一题] 11gOCP 1z0-052 :2013-09-25 Lock ――for update
2013-09-25 17:18:27 2894
原创 [每日一题] 11gOCP 1z0-052 :2013-09-24 temporary tables.........................................C11
[每日一题] 11gOCP 1z0-052 :2013-09-24 temporary tables
2013-09-24 21:38:43 2698
原创 [每日一题] 11gOCP 1z0-052 :2013-09-23 Oracle11g 内存参数设置...................................C7
11gOCP 1z0-052 :2013-09-23 Oracle11g 内存参数设置
2013-09-23 12:12:36 3537
原创 [每日一题] 11gOCP 1z0-052 :2013-09-22 STATISTICS.................................................B65
[每日一题] 11gOCP 1z0-052 :2013-09-20 STATISTICS
2013-09-22 21:54:59 3149
原创 [每日一题] 11gOCP 1z0-052 :2013-09-21 automatic maintenance window..........................B53
[每日一题] 11gOCP 1z0-052 :2013-09-21 automatic maintenance window
2013-09-22 13:37:56 3232
原创 [每日一题] 11gOCP 1z0-052 :2013-09-20 BIGFILE | SMALLFILE TABLESPACE.....................B43
[每日一题] 11gOCP 1z0-052 :2013-09-20 BIGFILE | SMALLFILE TABLESPACE
2013-09-20 17:02:07 3088
原创 [每日一题] 11gOCP 1z0-052 :2013-09-19 创建用户...................................................B41
[每日一题] 11gOCP 1z0-052 :2013-09-19 创建用户.
2013-09-19 22:34:10 2707
原创 [每日一题] 11gOCP 1z0-052 :2013-09-18 理解EXPDP/IMPDP.......................................B36
[每日一题] 11gOCP 1z0-052 :2013-09-18 理解EXPDP/IMPDP
2013-09-18 19:29:02 3337
原创 [每日一题] 11gOCP 1z0-052 :2013-09-17 DRA--Data Recovery Advisor.............................B31
[每日一题] 11gOCP 1z0-052 :2013-09-17 DRA--Data Recovery Advisor
2013-09-18 18:14:12 2946
原创 [每日一题] 11gOCP 1z0-052 :2013-09-16 shared server mode........................................B21
[每日一题] 11gOCP 1z0-052 :2013-09-16 shared server mode
2013-09-16 21:39:10 2765
原创 [每日一题] 11gOCP 1z0-052 :2013-09-15 Enterprise Manager Support Workbench..................B9
[每日一题] 11gOCP 1z0-052 :2013-09-15 Enterprise Manager Support Workbench
2013-09-15 22:50:31 3818
原创 [每日一题] 11gOCP 1z0-052 :2013-09-14 repeated parsing activity.................................A70
[每日一题] 11gOCP 1z0-052 :2013-09-14 repeated parsing activity
2013-09-15 06:48:42 2747
原创 [每日一题] 11gOCP 1z0-052 :2013-09-13 FAST_START_MTTR_TARGET.........................................A69
11gOCP 1z0-052 :2013-09-13 FAST_START_MTTR_TARGET
2013-09-13 23:53:49 3699 1
原创 [每日一题] 11gOCP 1z0-052 :2013-09-12 SELECT_CATALOG_ROLE角色....................................A68
11gOCP 1z0-052 :2013-09-12 SELECT_CATALOG_ROLE角色.
2013-09-13 23:20:20 3688
原创 [每日一题]11gOCP 1z0-052 :2013-09-11 MGR_ROLE role..........................................A66
11gOCP 1z0-052 :2013-09-11 MGR_ROLE role
2013-09-12 00:00:54 3279
原创 [每日一题] 11gOCP 1z0-052 :2013-09-10 ABOUT ALERTS...............................................A50
[每日一题] 11gOCP 1z0-052 :2013-09-10 ABOUT ALERTS
2013-09-11 00:24:22 3402 1
原创 [每日一题] 11gOCP 1z0-052 :2013-09-9 PL/SQL package body...........................................A46
[每日一题] 11gOCP 1z0-052 :2013-09-9 PL/SQL package body
2013-09-09 17:03:01 2720
原创 [每日一题] 11gOCP 1z0-052 :2013-09-8 用户管理下的热备报错:ORA-01123.................................A45
[每日一题] 11gOCP 1z0-052 :2013-09-8 用户管理下的热备报错:ORA-01123
2013-09-08 23:50:46 2351
原创 [每日一题] 11gOCP 1z0-052 :2013-09-7 The usage of the SQL*LOAD utility...........................A38
[每日一题] 11gOCP 1z0-052 :2013-09-7 The usage of the SQL*LOAD utility
2013-09-07 23:15:10 2495
原创 [每日一题] 11gOCP 1z0-052 :2013-09-6 DBMS_STATS.SET_TABLE_PREFS()使用...............................A37
[每日一题] 11gOCP 1z0-052 :2013-09-6 DBMS_STATS.SET_TABLE_PREFS()使用
2013-09-07 23:14:19 8157
Oracle Core_ Essential Internals for DBA - Lewis_Jonathan
2013-02-27
LINUX与UNIX SHELL编程指南
2013-02-27
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人