• 博客访问: 145146
  • 博文数量: 68
  • 用 户 组: 普通用户
  • 注册时间: 2008-05-04 11:19
个人简介

暂无介绍

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类
文章存档

2010年(35)

2009年(32)

2008年(1)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题

发布时间:2010-01-27 11:22:50

10.2 Data Guard Physical Standby Switchover [ID 751600.1] 修改时间 15-DEC-2009 类型 REFERENCE 状态 PUBLISHED In this Document Purpose 10.2 Data Guard Physical Standby Switchover 1.0 Prerequisites / Preparation 2.0 Pre-Switchover Checks 3.0 Switchover 4.0 Post-Switchover Steps 5.0 Create a Guaranteed Restore Point on Each Switchover Database 6. ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4Information in this document ap......【阅读全文】

阅读(3007) | 评论(0) | 转发(0)

发布时间:2010-01-21 11:31:53

OCR / Vote disk Maintenance Operations: (ADD/REMOVE/REPLACE/MOVE), including moving from RAW Devices to Block Devices. [ID 428681.1] 修改时间 16-NOV-2009 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution ReferencesApplies to: Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.1.0.6Information in this document applies to any platform.Oracle Server Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 GoalThe goal of this note is to provide steps to add, remove, replace o......【阅读全文】

阅读(1970) | 评论(0) | 转发(0)

发布时间:2010-01-19 16:19:34

参考ID 62143.11:理解Literal SQL2:Literal SQL versus Shared SQL当条件谓词是数字时,使用Literal 可以根据histogram statistics产生更精确的执行计划 ,在DDS中 parse time is small percentage of the exection time.3:Eliminating Literal SQL SELECT substr(sql_text,1,40) "SQL", count(*) , sum(executions) "TotExecs" FROM v$sqlarea WHERE executions < 5 GROUP BY substr(sql_text,1,40) HAVING count(*) > 30 ORDER BY 2;4:SESSION_CACHED_CURSORS parameter......【阅读全文】

阅读(669) | 评论(0) | 转发(0)

发布时间:2010-01-18 10:26:20

Just about every DBA has had to deal with ora-1000 errors, "Maximum open cursors exceeded." This article will discuss initialization parameters that affect open cursors, the difference between open and cached cursors, closing cursors, and monitoring open and cached cursors.Open cursorsOpen cursors take up space in the shared pool, in the library cache. To keep a renegade session from filling up the library cache, or clogging the CPU with millions of parse requests, we set the parameter......【阅读全文】

阅读(933) | 评论(0) | 转发(0)

发布时间:2010-01-18 10:08:19

http://jobs.zhaopin.com/P8/CC1207/8097/J902/501/CC120780976J90250113000.htm?f=ss&DYWE=1263778744153.428191.1263778744.1263778744.1http://jobs.zhaopin.com/P2/CC2652/0251/J902/500/CC265202518J90250000000.htm?f=ss&DYWE=1263778744153.428191.1263778744.1263778744.1[@more@]......【阅读全文】

阅读(444) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册