摘要:
Oracle GoldenGate Best Practices: Oracle GoldenGate Conflict Management (Doc ID 1348990.1) 阅读全文
摘要:
There will be a script "prvtlmpg.plb" under gg home directory [oracle@OGGR2-1 ogg]$ ls -lrt prvtlmpg.plb -rw-r 1 oracle oinstall 9487 May 27 2015 prvt 阅读全文
摘要:
Integrated Extract for ADG standby database (Doc ID 2186503.1) You can not use Integrated Extract for ADG standby database. It's only Classic Extract. 阅读全文
摘要:
报错信息 ERROR at line 1: ORA-01119: error in creating database file '+data/oracle11g/hrz.dbf' ORA-17502: ksfdcre:4 Failed to create file +data/oracle11g/ 阅读全文
摘要:
pdb最大iops使用率监控指标获取 通过字典DBA_HIST_RSRC_PDB_METRIC 分析 具体字段为IOPS_THROTTLE_EXEMPT、IOMBPS_THROTTLE_EXEMPT 一般最大值超过5就要告警了 参数 iops_throttle_exempt Indicates ho 阅读全文
摘要:
oracle 并行度查看通过v$resource_limit 中的parallel_max_servers 参数来设置初始值 官方对于parallel_max_servers 参数设置 parallel_max_servers = PARALLEL_THREADS_PER_CPU * CPU_COU 阅读全文
摘要:
数据泵在导入时候出现时间格式报错主要是ora-1858 解决办法就是在操作系统层面设置变量 例如失败sql Failing sql is: CREATE TABLE <USERNAME>.<TABLE_NAME>( <COLUMN_1> NUMBER(10,0) NOT NULL ENABLE, < 阅读全文
摘要:
SQL> drop table t_tmp_user_lhr; SQL> create table t_tmp_user_lhr( id number, username varchar2(50), exec_sql varchar2(4000),create_type varchar2(20)); 阅读全文
摘要:
19.x:datapatch failed with 'ORA-13516: AWR Operation failed: CATPROC not valid ' (Doc ID 2922690.1) 阅读全文
摘要:
How To Force Direct Path Read for SQL Statements (Doc ID 2426051.1) There are ways to disable direct path read for SQL statements as follows: 1. event 阅读全文