msdnchina的专栏@JiNan,ShanDong

https://space.bilibili.com/28628293

Slow SYSDBA OS authentication (Doc ID 2225093.1)APPLIES TO:Oracle Database Cloud Schema Service - Version N/A and laterOracle Database Exadata Express Cloud Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and later

Persistent Memory in Exadata X8MChristian CraftSENIOR DIRECTOR, PRODUCT MANAGEMENTThe introduction of Persistent Memory (PMEM) marks the beginning of a revolution in the computing industry. There has always been a separation between system memory wh

[root@localhost dbhome_1]# cd OPatch[root@localhost OPatch]# ./OPatch version-bash: ./OPatch: No such file or directory[root@localhost OPatch]# ./opatch versionError: This Java instance does not support a 64-bit JVM.Please install the desired version.

https://docs.oracle.com/en/database/oracle/oracle-database/19/dblic/database-licensing-information-user-manual.pdf

Our technologist isolates transactions safely.By Tom KyteNovember/December 2005Isolation LevelsI've read theOracle Database Conceptsmanual, Chapter 20, "Data Concurrency and Consistency," b...

Understanding Instance Recovery<br />Instance and crash recovery are the automatic application of redo log records to Oracle data blocks after a crash or system failure. During normal operation, if an instance is shut down cleanly (as when using a SHUT

<br />日志组状态：inactive/active/current<br /> Active (Current) and Inactive Redo Log Files<br />Oracle Database uses only one redo log files at a time to store redo records written from the redo log buffer. The redo log file that LGWR is actively writi

The logical standby database is kept synchronized with the primary database though SQLApply, which transforms the data in the redo received from the primary databaseinto SQL statements and then executing the SQL statements on the standby database.

Differential Incremental BackupsIn a differential level 1 backup, RMAN backs up all blocks that have changed since the most recent incremental backup at level 1 (cumulative or differ

RMAN Backup Typeshttp://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmconc1.htm#i1007616 As explained in Table 2-1, RMAN backups can be classified in these ways:Full or

11gR2中的asm后台进程

abmr：测试自动块恢复特性

oracle linux 和外部存储系统 的关系

Oracle 集群 10gR2/ 11gR1/ 11gR2/ 12cR1 诊断信息收集指南 (Doc ID 1623352.1)

适用于: Oracle Database - Enterprise Edition - 版本 9.2.0.1 和更高版本本文档所含信息适用于所有平台Oracle Clusterware & Oracle Real Application Clusters症状概要：在Oracle的RAC环境中，数据库会收集global cache 的工作负载统计信息，并把这些信息

获取oracle sql语句中绑定变量值的方法

查询oracle sql的执行计划时，一个很重要的视图--dba_hist_sql_plan

SYS_OP_C2C 导致的全表扫描（fts）/全索引扫描

oracle db 中的用户账户被锁--查看oracle用户的尝试次数

修改被 DB Control 监控的db （10g and 11g）中 dbsnmp密码的方法

Main Note - ogg的 Supplemental Logging and TRANDATA

rman 备份时报：ORA-02396: exceeded maximum idle time

运行utlpwdmg.sql之后报ORA-28003, ORA-20001, ORA-20002, ORA-20003, ORA-20004 错误。

Applies to: Oracle Server - Enterprise Edition - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]Information in this document applies to any platform.SymptomsA read-only database is cloned fr

参考原文：Dbconsole Dbsnmp account is getting locked (Doc ID 1127123.1)本文不做翻译。仅作转载。 Applies to: Enterprise Manager for Oracle Database - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]Infor

GoldenGate进程 abend，报错为OGG-00868 ORA-02396: Exceeded Maximum Idle Time, Please Connect Again

即使resource_limit = false， password的 资源限制也会生效

对dba_users视图中，account_status列的解释

oracle密码管理策略

开启dblink的 oracle net trace/tracing --对dblink进行跟踪的方法

文档内容 目标 脚本来源 解决方案 脚本指导 脚本执行步骤 脚本变更 utlu112i_8.sql - 升级到 11.2.0.4 - 版本 8 - 2014年1月

How to Set or Switch Oracle Homes on Windows (Doc ID 969581.1)

Microsoft Windows 环境中NLS_LANG的正确设置 (Doc ID 1577370.1)

windows下，OracleServiceXXX和Oracle 实例的关系

当并行事务恢复进程在运行时，禁用并行事务恢复的方法

重建控制文件的方法

linux 下 osw随操作系统启动而自动启动的标准脚本。

在windows 2003 sp2 或者 windows 2008 rac环境中，可能会由于默认的SNP（ Scalable Networking Pack）特性会导致 实例驱逐或者节点驱逐

在Oracle software 被安装时, /dev/null0文件被创建。