可以通过以下文档了解exadata软硬件的一些情况,以及troubleshooting时如何收集信息，需要收集怎么样的信息-包括了hardware,software
network,ILOM等。另外还有一些ED的远程容灾建议。
Doc ID 888828.1 Database Machin[……]
July 15, 2012 Exadata, oracle No comments Exadata
July 10, 2012 Exadata, oracle No comments Exadata
Oracle RAC RDS reference:
Oracle Real Application Clusters (RAC) allows Oracle Database to run any packaged or custom application, unchanged acro[……]
July 7, 2012 maintain, oracle No comments scripts
this scripts is used to monitor transaction rolling back progress
——————————————————————————-[……]
June 28, 2012 oracle, replication No comments dataguard
db1 –liu
SQL> select * from v$version;
BANNER
—————————————————————-
Oracle Database 10g Enterpr[……]
June 20, 2012 oracle, replication No comments dataguard
Recover physical standby database after loss of archive log(2)
上次写过一篇DG丢失归档后的处理过程，总体来说就是使用增量备份覆盖gap数据从而跳过gap的archivelog 这里再阐述另一种情况
[oracle@db6[……]
June 18, 2012 11g, oracle No comments 11g
查看数据仓库的awr报告发现以下问题 顺便总结一下之前碰到的一类问题
CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
13,664.[……]
June 14, 2012 maintain, oracle No comments scripts
this scripts is used to check user all privileges
set serveroutput on;
DECLARE
v_user VARCHAR2(30) := ‘XXX’;
v_ddl[……]
June 13, 2012 oracle, RAC No comments asm
Why ASM?
. ASM is an Oracle provided Database/Cluster filesystem and Storage Volume manager, optimized for Oracle for any kind of workload (b[……]
June 7, 2012 Internals, oracle No comments structure
对于BITMAP index的使用 一直存在一些争议 我们来看看下面几个观点：
1. Low cardinality – Some dabase vendor, like Oracle, provides very practical suggestion
If the num[……]
June 7, 2012 Internals, oracle No comments internal
今天开发因为连接数不够 强烈要求加大processes值,突然想到了processes对_cursor_db_buffers_pinned的影响,,小记之:
当会话需要pin住buffer header时它首先要获去buffer handle,实例所存在的buffer handle总数由(ea[……]