Oracle
关注
分享
扫一扫
文章平均质量分 67
jx_jy
这个作者很懒，什么都没留下…
展开
-
ORA-4031相关脚本(Doc ID 430473.1)
@SGAParameters.sqlDatabase Started Last----------------------------------------03-Feb-2022 12:50:571 row selected.Setting MBytes------------------------------------------------------转载 2022-02-03 14:56:19 · 419 阅读 · 0 评论 -
RMAN Active Duplicate on RAC fails with ORA-17629 and ORA-17627: ORA-12154 (Doc ID 1982003.1)
RMAN active duplication of RAC database fails on restart operation with the following error messages:RMAN-03002: failure of Duplicate Db command at 02/17/2015 15:12:11RMAN-05501: aborting duplication of target databaseRMAN-03015: error occurred in store转载 2021-06-27 01:23:41 · 481 阅读 · 0 评论 -
19c 新特性-2
Dynamically Change Oracle Data Guard Broker Fast-Start Failover TargetThe fast-start failover target standby database can be changed dynamically, to another standby database in the target list, without disabling fast-start failover.In earlier releases原创 2021-06-18 17:43:29 · 484 阅读 · 0 评论 -
ora-65532 Automatic Indexing - Autonomous Database (Shared) (Doc ID 2764331.1)
APPLIES TO:Autonomous Database on Shared Infrastructure - Version N/A to N/AInformation in this document applies to any platform.GOALThe automatic indexing feature in Oracle Database is enabled in Autonomous Database.The automatic indexing feature .转载 2021-06-18 10:33:16 · 287 阅读 · 0 评论 -
19c 新特性-1
Application Express（APEX组件）Application Continuity for Java Application Continuity向应用屏蔽了数据库中断，好处是应用不会因为数据库问题导致执行失败。Note: You must use Transaction Guard for using this feature.Application Continuity is a feature of the Oracle JDBC Thin driver and is no原创 2021-06-10 22:01:10 · 765 阅读 · 2 评论 -
shared pool
v$sgastat ；row cache: The dictionary cache -cached rows fro data dictionary used to build more complex sql and library cache objects;v$db_object_cache(v$sql或者v$sqlarea) 建议用v$sqlstats。降低数据库性能影响堆的数量取决于对象的类型：一个sql游标有两个heads。一个小的heap是库缓存结果，大的heap为游标...转载 2021-06-02 10:15:24 · 203 阅读 · 0 评论 -
‘library cache lock‘ Waits: Causes and Solutions (Doc ID 1952395.1)
Cause Identified: Unshared SQL Due to LiteralsSQL statements are using literal values where a bind value could have been used. The literal values cause the statement to be unshared and will force a hard parse.Cause Identified: Shared SQL being aged ou转载 2021-05-25 17:30:13 · 240 阅读 · 0 评论 -
ORA-14130: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION
中间表跟归档表需要建主键or disable主键。最好disable主键。exchange后索引失效。需要创建索引。原创 2021-05-22 21:26:36 · 654 阅读 · 0 评论 -
19c 新特性 ----大部分来自欠子哥的测试。
1.Data Guard DML Redirectalter system set adg_redirect_dml=true scope=both sid='*';可以在备库进行 insert、update、 delete 的操作,是通过dblink从备库从主库写。2.Partitioned Hybrid Tables19c 创建了 hybrid_partition_table 分区表，与以往分区表不一样 的是，这个分区表，一部分分区是正常的分区，一部分分区是外部表来的。正常的分区可以 进转载 2021-05-15 15:12:21 · 328 阅读 · 0 评论 -
11.2.0.4到19c duplicate 需要打补丁18633374
ora-17629ora-17639参考：2517772.1原创 2021-04-25 18:30:03 · 208 阅读 · 0 评论 -
OMS Install/Upgrade Fails During BIP Configuration
在安装OEM13.4版本遇到如下错误，一查是遇到了BUGAPPLIES TO:Enterprise Manager Base Platform - Version 13.4.0.0.0 and laterInformation in this document applies to any platform.SYMPTOMSInstalling/Upgrading to OMS 13.4 fails during the BIP Configuration without much e原创 2020-12-10 15:05:53 · 213 阅读 · 0 评论 -
ORA-06598: insufficient INHERIT PRIVILEGES privilege (Doc ID 2690051.1)
Issue is from OEM data masking .Database using account pdbadmin , which has sysdba grant .But during Application data modeling job below error is coming.Processing application: TEST_MASK(TEST_MASK)User does not have sufficient privileges to complete..转载 2020-11-26 14:18:53 · 1581 阅读 · 0 评论 -
init.orachkscheduler
ngineered Systems Utilities - Version 12.1.2.8.1 and laterLinux x86-64GOALOn : 12.1.2.8.1 version, Trace File AnalyzerYou may encounter below messages in the OS message log-------------------------- snip -------------------------Feb 5 01:02:13 <转载 2020-11-25 15:13:42 · 344 阅读 · 0 评论 -
11g Grid Agent Monitoring RAC Databases Consumes High CPU And Causes Bad Performance (Doc ID 1129243
11g Grid Agent Monitoring RAC Databases Consumes High CPU And Causes Bad Performance (Doc ID 1129243.1)APPLIES TO:Enterprise Manager Base Platform - Version 11.1.0.1 to 11.1.0.1 [Release 11.1]Information in this document applies to any platform.SYMP转载 2020-08-25 10:49:17 · 169 阅读 · 0 评论 -
Changing Database Name With Standby Database In Place Using NID Utility (Doc ID 790406.1)
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.0 [Release 9.2 to 11.2]Oracle Database - Enterprise Edition - Version 11.2.0.3 to 12.1.0.2 [Release 11.2 to 12.1]Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Ve翻译 2020-08-21 12:23:07 · 166 阅读 · 0 评论 -
IMPDP Fails with ORA-39083 and ORA-06502 for PASSWORD_HISTORY (Doc ID 1551778.1)
APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation in this document applies to any platform.SYMPTOMSMigrating Oracle database release 10.2.0.4.0 to 11.2.0.3...转载 2020-05-06 15:12:57 · 620 阅读 · 0 评论 -
ora-19554 ora-27211 failed to load media management library
su - oraclecd /usr/openv/netbackup/bin./oracle_link原创 2020-04-26 08:59:23 · 1288 阅读 · 0 评论 -
How to enable Large Page Feature on AIX-Based Systems (Doc ID 372157.1)
Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.1 [Release 9.2 to 11.2]Oracle Database - Enterprise Edition - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]Oracle Database Cloud Schema...转载 2020-03-01 21:43:53 · 488 阅读 · 0 评论 -
ORACLE 12.2新特性-在线将非分区表转换成分区表
通过在ALTER table SQL语句中添加MODIFY子句，可以将非分区表转换为分区表。此外，还可以指定关键字ONLINE，在转换过程中启用并发DML操作。语法如下：ALTERTABLEtable_nameMODIFYtable_partitioning_clauses[filter_condition][ONLINE][UPDATEINDE...转载 2019-11-29 10:43:40 · 575 阅读 · 0 评论 -
ORACLE 12.2新特性-在线重定义新增功能
1.监视表在线重定义进度 可以查询V$ONLINE_REDEF视图以监视联机表重定义操作的进度。 select * fromV$ONLINE_REDEF; 该V$ONLINE_REDEF视图为该PROGRESS列中的操作提供了百分比完成值。该视图在该OPERATION列中显示完成该操作所需的步骤总数。例如，如果操作中有10个步骤，则此列可能显示Step 6 out of...翻译 2019-11-28 14:41:31 · 548 阅读 · 0 评论 -
Manually Purge the Optimizer Statistics & AWR Snapshots to Reduce Space Usage of SYSAUX Tablespace
APPLIES TO:Oracle Database - Enterprise Edition - Version 11.1.0.7 and laterOracle Applications DBA - Version 12.1.3 to 12.1.3 [Release 12.1]Oracle Database Exadata Cloud Machine - Version N/A and...转载 2019-11-21 15:54:54 · 450 阅读 · 0 评论 -
Datapump Expdp Or Impdp Slowdown Due To Frequent Waits On ”Streams AQ: Enqueue Blocked On Low Memory
APPLIES TO:Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database - Standard Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.SY...转载 2019-11-14 11:08:08 · 870 阅读 · 0 评论 -
Oracle 12.2 PDB的内存资源管理
原文链接：https://oracle-base.com/articles/12c/multitenant-memory-resource-management-for-pdbs-12cr2在12.2之前的版本，我们根本没有办法控制一个单独的PDB能使用的内存总量。导致的结果就是“一个糟糕的邻居”可能占用大量内存从而导致同一个实例下其他PDB的性能下降。在Oracle 12.2中，你可以控制某单个...转载 2018-05-29 15:43:02 · 1720 阅读 · 1 评论 -
oracle根据分隔符一行转多行
REGEXP_SUBSTR函数格式如下：REGEXP_SUBSTR(source_char, pattern [, position [, occurrence [, match_param [, subexpr ...转载 2019-05-30 11:12:15 · 2850 阅读 · 0 评论 -
打补丁到11.2.0.3.15遇到的报错
How to Create an OCM Response file to Apply a Patch in Silent Mode - opatch silent (文档 ID 966023.1) 转到底部 In this Document Goal Solution 1) Download...转载 2019-05-17 23:11:06 · 411 阅读 · 0 评论 -
Example: SQL Tuning Task Options (文档 ID 2461848.1)
Applies to:Oracle Life Sciences Data Hub - Version 2.4.6 and laterInformation in this document applies to any platform.GoalThis is an example in how to apply a SQL profile.SolutionIn this e...转载 2019-05-13 17:25:59 · 319 阅读 · 0 评论 -
Directing Plans with Baselines/Profiles Using coe_load_sql_baseline.sql / coe_load_sql_profile.sql
(shipped with SQLT) (文档 ID 1400903.1)APPLIES TO:Oracle Database - Enterprise Edition - Version 10.1.0.2 and laterInformation in this document applies to any platform.GOALThis document expl...转载 2019-05-16 16:17:32 · 550 阅读 · 0 评论 -
ora-01122 ora-01110 ora-01207
ORA-01122: database file 1 failed verification checkORA-01110: data file 1:'/backup/copy/coNmn'ORA-01207: file is more recent than control file - old control fileUse the current control file or...转载 2019-05-19 21:49:55 · 833 阅读 · 0 评论 -
ORACLE 11GR2 查询v$lock缓慢并且direct path write temp等待
今查询v$lock视图发现查询缓慢，要1分钟查有结果，并且出现direct path write temp等待实际返回结构就100条左右记录，v$lock总共才600条，视图查询不应该这么慢，也不能HASH造成大量的临时空间的使用，从上面的执行计划可以看出可能是MERGE JOIN CARTESIAN，这表示笛卡尔连接，如果表X$KSUSE，X$KSQRS行数不小的话的确会造成临时...原创 2019-05-30 14:50:26 · 643 阅读 · 0 评论 -
禁用透明大页Transparent HugePages
默认情况下，Red Hat Enterprise Linux 6，SUSE Linux Enterprise Server 11和Oracle Linux 6以及早期版本的Oracle Linux Unbreakable Enterprise Kernel 2（UEK2）内核启用了透明HugePages内存。在Oracle Linux UEK2内核的更高版本中禁用透明HugePages内存。透...翻译 2019-05-30 15:25:25 · 2018 阅读 · 0 评论 -
Extract abends with "ERROR OGG-01028 partial record at sequence 。。, block 。。block byte 0, rba 。。"
(文档 ID 2159577.1)APPLIES TO:Oracle GoldenGate - Version 11.2.1.0.32 and laterInformation in this document applies to any platform.SYMPTOMSClassic Extract abends with following erroreg.,...转载 2019-06-19 10:10:17 · 1409 阅读 · 0 评论 -
oracle字段拼接过程中以0开头的小数，开头的0消失
1.出现问题 在做字段拼接的过程，查询结果出现以0开头的小数，开头的0消失2.问题解决为何小数点前0会省略，是因为oracle数据库中存在一个隐形类型转换，在拼接的过程中小数自动转成字符类型，相当于调用了to_char函数，所以丢失小数点前面的0这里操作就是把数值类型转换为字符型，即加上to_char(字段,’fm9999999999999990.00’) ，（查看表结构...原创 2019-06-10 09:15:11 · 8947 阅读 · 0 评论 -
Ora-600 [4193] When Opening Or Shutting Down A Database (文档 ID 452662.1)
Errors in alert.log:TueJul1713:38:132007Errorsinfile/home/oracle/oracle/product/10.2.0/yms/rdbms/log/yms_smon_8337.trc:ORA-00607:Internalerroroccurredwhilemakingachangetoadatab...转载 2019-06-18 11:13:56 · 333 阅读 · 0 评论 -
ORACLE 12.2c 新特性-Restarting Redefinition From Failure
如果联机表重新定义失败，则可以检查DBA_REDEFINITION_STATUS视图来查看错误信息和可重新启动的信息。如果RESTARTABLE是Y，则可以更正错误并重新启动上次停止的在线重新定义过程。如果RESTARTABLE是N，则必须中止重定义操作。在某些情况下，可以在失败后重新启动表的在线重新定义。重新启动操作意味着在线重新定义过程从故障停止的地方开始，并且不会丢失任何工作。例如，...原创 2019-07-19 16:42:38 · 337 阅读 · 0 评论 -
ORACLE 12.2新特性-索引监控
本文内容摘自Oracle 12.2 中的索引监控功能 (Doc ID 2469640.1)目标本文档介绍了Oracle 12.2中索引监控的新功能。解决方案Oracle 12.2中的索引监控有了很大改进。在以前的版本中，我们可以如下监视索引使用情况。1.为索引启用MONITORING。SQL> alter index <Index_Name> moni...转载 2019-07-22 09:51:48 · 638 阅读 · 0 评论 -
How to Monitor and tune Open and Cached Cursors (Doc ID 1430255.1)
OPEN_CURSORS指定会话一次可以拥有的最大打开游标数（私有SQL区域的句柄）。您可以使用此参数来防止会话打开过多的游标。例如，如果OPEN_CURSORS设置为100，则每个会话最多可以同时打开100个光标。如果单个会话打开了100个（open_cursors值）游标，则在尝试再打开一个游标时会出现ora-1000错误。OPEN_CURSORS的默认值为50，但Oracle建议您...翻译 2019-09-18 17:07:19 · 202 阅读 · 0 评论 -
CRS-2674 Clusterware Network Resource ora.net1.network Could not Start
(文档 ID 1270186.1)Oracle Database - Enterprise Edition - Version 11.2.0.1 and laterInformation in this document applies to any platform.Symptoms2 node RAC on 11.2.0.1, after the network switch u...转载 2019-05-07 11:59:07 · 945 阅读 · 0 评论 -
datapatch fails with Error:"ORA-03114" ,"ORA-03113" due to "ORA-07445" (文档 ID 2422799.1)
Applies to:Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.Symptomsdatapatch fails with error : ' ORA-03114: not connected...转载 2019-05-19 12:47:54 · 621 阅读 · 0 评论 -
AIX export 报 ORA-27054: mount盘
ID 1518979.1ID 781349.1 SymptomsYou are transferring your database/installation to a NetApps NFS mount point.The following error occurs on database startup:ORA-01503: CREATE CONTROLFILE fa...转载 2018-09-07 21:50:12 · 785 阅读 · 0 评论 -
ogg 一对多 --datapump进程没传送
INFO OGG-01052 No recovery is required for target file /ggs/dirdat/rs000000, at RBA 0 (file not opened). 解决方法：info ... 查看状态。alter extract pump.., extseqno .., extrba 0 附上官方文档https://d...原创 2018-08-20 23:03:50 · 3336 阅读 · 0 评论