VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

11g DEFAULT_MAINTENANCE_PLAN 总结

Posted by admin on 18th June 2012

查看数据仓库的awr报告发现以下问题 顺便总结一下之前碰到的一类问题

CPU Time (s)Executions CPU per Exec (s)%TotalElapsed Time (s)%CPU%IO SQL IdSQL ModuleSQL Text
13,664.[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »

11.2.0.3 datapump got ORA-38500

Posted by admin on 23rd February 2012

从10.2.0.5的库导入一张表的增量数据到11.2.0.3 impdp报出如下错误,对比两边表结构一致,tablespace有剩余空间 报错如下:

[oracle@localhost ~]$ impdp  \'\/ as sysdba \'    directory=pump   dumpfile=so.dmp TABLE_EXISTS_ACTION=append

Import: Release 11.2.0.3.0 - Production on Thu Feb 23 09:44:49 2012

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYS"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_IMPORT_FULL_01":  "/******** AS SYSDBA" directory=pump dumpfile=so.dmp TABLE_EXISTS_ACTION=append
Processing object type TABLE_EXPORT/TABLE/TABLE
Table "USER_DATA2"."SO" exists. Data will be appended to existing table but all dependent metadata will be skipped due to table_exists_action of append
ORA-38500: Unsupported operation: Oracle XML DB not present

reference:

Data Pump Import Fails With[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »

[转] 11g Release 2 RMAN Backup Compression

Posted by admin on 16th December 2011

11g Release 2 RMAN Backup Compression
Oracle 11g Release 2 introduced compression algorithm levels which can be used for compressing table data, Data[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »

11G新特性 IO Calibration 评测

Posted by admin on 13th December 2011

11G新特性 IO Calibration可以帮我们估算出存储的读写性能,在使用这个特性之前 我们需要满足一些条件:

.在linux系统中默认是不开启异步IO的
SQL> show parameter filesystemio_options

NAME TYPE V[……]

Read more

Tags:
Posted in Oracle Experience | No Comments »

ORA-01555 on Active Physical standby and patchset issue without Central Inventory

Posted by admin on 7th December 2011

今天在生产库解决一个ORA-01555 on Active Physical standby问题:
Applies to:

Oracle Server – Enterprise Edition – Version: 11.2.0.2.0 and later [Release: 11.2[……]

Read more

Tags:
Posted in Oracle Experience | 2 Comments »