Oracle Management
文章平均质量分 71
Alley_Li
兴趣是最大的老师!
展开
专栏收录文章
- 默认排序
- 最新发布
- 最早发布
- 最多阅读
- 最少阅读
-
Retrieve Oracle password from Toad for Oracle
http://damir-vadas.blogspot.co.uk/2013/06/retrive-oracle-password-from-toad-for.html?_sm_au_=i2VrD5qDJHHtH50LOne of the oldest feature Dell Toad has is saving login passwords. This is accomplish转载 2015-11-17 18:06:44 · 1175 阅读 · 0 评论 -
The Best Way to Save/Import Toad Settings
https://www.toadworld.com/products/toad-for-oracle/w/toad_for_oracle_wiki/186.the-best-way-to-saveimport-toad-settingsOn the Toad list, a poster asked what is the best way to save or import转载 2015-11-17 18:07:59 · 590 阅读 · 0 评论 -
sqlnet.ora needs to add some parameters for toad
sqlnet.ora# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be原创 2015-11-18 11:53:47 · 473 阅读 · 0 评论 -
sqlnet.ora configuration for toad
sqlnet.ora# This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be abl原创 2015-11-18 12:17:34 · 522 阅读 · 0 评论 -
Oracle redo log 大小及组数的设置(在线修改日志组数目及组成员个数)
Oracle redo log 大小及组数的设置(在线修改日志组数目及组成员个数) 1.查看当前系统现有的redo log状况(组数/大小/名称/状态)desc">SYS@ORCL>desc v$log Name Null? Type ----------------------------转载 2016-03-02 18:15:45 · 4371 阅读 · 0 评论 -
查看Oracle的redo日志切换频率
两个sql,原理是一样的,第二个用到了统计函数。 时间单位:分钟 select * from v$log where a.THREAD# = 1 select b.SEQUENCE#, b.FIRST_TIME, a.SEQUENCE#, a.FIRST_TIME, round(((a.FIRST_TIME-b.FIRST_TIME)*2转载 2016-03-02 18:17:10 · 7323 阅读 · 0 评论 -
DRM 简介
首先,我们对和DRM 相关的一些概念进行介绍。Buffer: 对于RAC 数据库,当一个数据块被读入到buffer cache后,我们就称其为buffer , cache fusion 会将这个buffer作为resource来管理。Master:在RAC 数据库的世界里,每一个resource都会有一个master实例,这个master实例会在shared pool转载 2016-03-29 14:18:04 · 564 阅读 · 0 评论 -
oracle nologging用法
http://www.cnblogs.com/zmlctt/p/3747443.html一、oracle日志模式分为(logging,force logging,nologging)默认情况是logging,就是会记录到redo日志中,force logging是强制记录日志,nologging是尽量减少日志。FORCE LOGGING可以在数据库级别、表空间级别进行设定、而L转载 2016-07-12 14:46:04 · 3669 阅读 · 0 评论
分享