oracle
文章平均质量分 75
地_衣
这个作者很懒,什么都没留下…
展开
-
管理自动索引
You can use the automatic indexing feature to configure and use auto indexes in an Oracle database to improve database performance. 利用自动索引功能配置及使用来提高数据库性能About Automatic Indexing The aut...原创 2019-10-25 09:42:52 · 364 阅读 · 0 评论 -
VIPs Often Go Offline Unexpectedly and Relocate to Another Node(文档 ID 1297867.1)
In this Document Symptoms Cause SolutionAPPLIES TO:Oracle Database - Enterprise Edition - Version 10.2.0.5 and laterInformation in this原创 2017-09-27 09:43:12 · 369 阅读 · 0 评论 -
ORA-27300, ORA-27301, ORA-27302 on AIX (文档 ID 1541121.1)
ORA-27300, ORA-27301, ORA-27302 on AIX (文档 ID 1541121.1)In this DocumentSymptoms Cause Solution References原创 2017-05-09 10:21:03 · 885 阅读 · 0 评论 -
WRH$_ACTIVE_SESSION_HISTORY Does Not Get Purged Based Upon the Retention Policy (文档 ID 387914.1)
WRH$_ACTIVE_SESSION_HISTORY Does Not Get Purged Based Upon the Retention Policy (文档 ID 387914.1)转到底部In this DocumentSymptoms C原创 2017-05-09 10:15:27 · 566 阅读 · 0 评论 -
ORA-00600: internal error code, arguments: [kcblasm_1], [103], [], [], [], [], [], []
In this Document Symptoms Changes Cause Solution ReferencesAPPLIES TO:Oracle Database - Enterpri原创 2017-01-06 10:11:42 · 847 阅读 · 0 评论 -
In-Memory Column optional
The IM column store is a new static pool in the SGA. Data in the IM column store does not reside in the traditional row format but instead in a columnar format. Each column is stored as a separate s原创 2016-11-30 16:10:28 · 639 阅读 · 0 评论 -
开启和关闭force full database caching mode:
1、判断数据库是否是强制全库缓存模式(如果是返回YES):SQL> SELECT FORCE_FULL_DB_CACHING FROM V$DATABASE;FOR---NO2、开启强制全库缓存模式数据库兼容性级别必需是12.0.0或者更高;3、enabling force full database cachin原创 2016-11-30 16:08:37 · 1178 阅读 · 0 评论 -
通过alter session 切换容器
Switching to the PDB pdb3SQL> alter session set container=pdb3;Session altered. Switching to the RootSQL> alter session set container=cdb$root;Session altered. Switching to原创 2016-11-30 16:07:03 · 6999 阅读 · 0 评论 -
手工建PDB
可以通过如下方式创建PDB:通过seed创建PDB:在通过seed创建PDB时,需要指定文件存放位置,可通过如下两种方式:1、在create pluggable database 语句中设置file_name_convert参数:[oracle@ora12c ~]$ sqlplus /nolog原创 2016-11-30 16:04:39 · 1344 阅读 · 0 评论 -
Bug 16012614 - ORA-245 on RMAN controlfile backup (文档 ID 16012614.8)
Bug 16012614 ORA-245 on RMAN controlfile backup This note gives a brief overview of bug 16012614. The content was last updated on: 14-JUL-2015 Click here for details of each of the sections原创 2016-03-04 11:15:48 · 767 阅读 · 0 评论 -
Login with RMAN immediately fails with ORA-04031, ORA-06508
In this Document Symptoms Cause Solution ReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 10.2.原创 2016-02-17 12:48:14 · 1015 阅读 · 0 评论 -
ORA-600 [KFDAUDEALLOC2] AND INSTANCE CRASH EVEN WITH THE FIX OF BUG 14467061 (文档 ID 1903273.1)
In this Document Symptoms Cause Solution ReferencesThis document is being delivered to you via Oracle Support's Rapid Vi转载 2017-09-19 09:16:18 · 810 阅读 · 0 评论 -
12.2 AIX : PRVG-1901 : failed to setup CVU remote execution framework directory (文档 ID 2260330.1)
In this Document Symptoms Cause Solution ReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 12.2.0.1 and转载 2017-09-19 09:21:07 · 7857 阅读 · 0 评论 -
ORA-07445 [kksumc] And ORA-600 [17087] During Insert Into Table (文档 ID 580347.1)
In this Document Symptoms Cause Solution ReferencesAPPLIES TO:Oracle Database - Enterprise Edition - Version 10.2.0.3 to 10.转载 2017-11-20 11:54:52 · 481 阅读 · 0 评论 -
ORA-07445 or ORA-600 Errors With a Big Stack or a Corrupted Stack (文档 ID 1318825.1)
In this DocumentSymptoms Cause SolutionAPPLIES TO:Oracle Database - Enterprise Edition - Version 9.0.1.0 and laterInformation in this do转载 2017-11-20 11:52:21 · 351 阅读 · 0 评论 -
OGG ORA-01847: day of month must be between 1 and last day of month (status = 1847)
1、某客户lis库replicat进程ABENDING;2、查看ggserr.log日志信息,报如下错误: 2017-10-25 11:25:35 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repyylis.prm: REPLICAT REPYYLIS started. 2017-10原创 2017-10-26 12:22:07 · 4042 阅读 · 0 评论 -
oracle 12cR2 过滤分区维护操作
Filtered Partition Maintenance Operations in Oracle Database 12c Release 2 (12.2)Oracle Database 12c Release 2 (12.2) allows you to add a filter condition when you move, split or merge a partition原创 2017-10-17 14:16:20 · 563 阅读 · 0 评论 -
Oracle 12cR2自动列表分区
Automatic List Partitioning in Oracle Database 12c Release 2 (12.2)Automatic list partitioning was introduced in Oracle Database 12c Release 2 (12.2) to solve the problem of how to handle new dist翻译 2017-10-17 09:41:38 · 790 阅读 · 0 评论 -
oracle 12cR2 多列列表分区
Multi-Column List Partitioning in Oracle Database 12c Release 2 (12.2)Oracle Database 12c Release 2 (12.2) introduced the ability to define a list partitioned table based on multiple columns. Crea原创 2017-10-16 17:39:32 · 794 阅读 · 0 评论 -
2017年10月 oracle 关键补丁更新
注:本文出自http://www.oracle.com/technetwork/security-advisory/cpuoct2017-3236626.html 检查你的系统,是否打了最新的补丁。。。。。。。。。。。。。Oracle Critical Patch Update Advisory - October 2017DescriptionA Crit转载 2017-10-31 09:24:02 · 5300 阅读 · 0 评论 -
12cR2多租户下隔离PDB磁盘I/O
Multitenant : Disk I/O (IOPS, MBPS) Resource Management for PDBs in Oracle Database 12c Release 2 (12.2)In the previous release there was no easy way to control the amount of disk I/O used by an i翻译 2017-10-13 16:12:34 · 1014 阅读 · 0 评论 -
ORA-600 [kghstack_free2] Raised by Corrupt Datafile (文档 ID 748310.1)
In this Document Symptoms Cause Solution ReferencesThis document is being delivered to you via Oracle Support's原创 2017-10-10 10:31:41 · 305 阅读 · 0 评论 -
Managing Voting Disks
Managing Voting DisksThis section includes the following topics for managing voting disks in your cluster:Storing Voting Disks on Oracle ASMBacking Up Voting DisksRestoring Voting Disk翻译 2015-11-30 10:25:18 · 401 阅读 · 0 评论 -
ORA- 12012 : err or on aut o execu te of job ORACLE_OCM. MGMT_CONFIG_JOB_2_1 ORA-29280: inval
巡检客户的数据库,发现alert log中报如下错误:ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1"ORA-29280: invalid directory pathORA-06512: at "ORACLE_OCM.MGMT_DB_LL_METRICS", line 2436OR原创 2015-10-19 22:32:17 · 590 阅读 · 0 评论 -
Oracle11gR2 修改 VIP
在使用oracle的过程中,难免会遇到需要修改VIP的情况,下面就是oracle官方文档给出的步骤,大家在修改的过程中还是需要按照官方文档来实施:来自:http://docs.oracle.com/cd/E11882_01/rac.112/e16794/admin.htm#BGBGDHFG ---------Changing the Virtual IP原创 2013-06-09 16:24:41 · 1062 阅读 · 0 评论 -
ORA-23421: job number 25 is not a job in the job queue
今天刚上班,收到一条短信,登录服务器,发现一个job运行有问题导致,于是用DBA账户停止该JOB,报如下错误:SYS@xezf(qs-xezf-db1)> exec dbms_job.broken(25,true);BEGIN dbms_job.broken(25,true); END;*ERROR at line 1:ORA-23421: job number原创 2013-05-29 13:07:12 · 1174 阅读 · 0 评论 -
ins_emdb.mk make: *** [nmccollector] Error 2
操作系统:CentOS 6.4数据库: Oracle 10gR2链接过程报:ins_emdb.mk 错误报错日志:make[1]: *** [/data/app/oracle/product/10.2.0/db_1/sysman/lib/nmccollector] Error 1INFO: make: *** [nmccollector] Error 2INFO: End原创 2013-05-24 11:08:05 · 1883 阅读 · 0 评论 -
Latch Free(闩锁释放)
由于线上系统出现大量的Latch Free 等待事件,查询发现dbtan的写的不错,故转载;作者:dbtan 源地址:http://www.dbtan.com/2010/05/latch-free.html Latch Free(闩锁释放):Latch Free通常被称为闩锁释放,这个名称常常引起误解,实际上我们应该在前面加上一个“等待”(wait),当数据库出现这个等待时,说转载 2013-04-27 14:25:14 · 2601 阅读 · 0 评论 -
Oracle 存储过程 无法编译 解决方法
本文转自:Dave 的 http://blog.csdn.net/tianlesoftware/article/details/7412555 今天同事修改存储过程又导致2个过程无法被编译,流程规范上的东西,Dave 这里不多说,看看怎么解决问题。 1. 查看无效对象XEZF@xezf(qs-xezf-db1)> select object_name转载 2013-04-15 15:13:32 · 3153 阅读 · 0 评论 -
Oracle 11g 触发器新增功能
Oracle 11g 触发器新增功能:触发器的执行顺序组合触发器启用和禁用触发器触发器的执行顺序Oracle 允许超过一个触发器建立相同的时间点,但它从来不保证它们的执行顺序。Oracle 11g 触发器语法现在包括FOLLOWS子句保证了触发器的执行顺序在相同时间点。下面的例子创建一张表和两个在相同时间点触发的触发器CREATE TABLE trigger_follo原创 2013-04-09 13:00:18 · 731 阅读 · 0 评论 -
DDL_LOCK_TIMEOUT --Oracle 11g DDL 的 wait选项
DDL命令需要排它锁的内部结构。如果这些锁不可用,将返回一个” ORA-00054: resource busy”,当试图修改频繁访问的对象时,这可能特别让人沮丧,为了解决这个问题Oracle 11g 包含了DDL_LOCK_TIMEOUT参数,可以在实例或者会话级别分别使用alter system和 alter session命令。DDL_LOCK_TIMEOUT表示一个DDL命原创 2013-04-08 14:52:31 · 716 阅读 · 0 评论 -
临时表空间收缩--Oracle 11g 新特性
从11g开始,可以使用ALTER TABLESPACE tablespace_name SHRINK SPACE 命令收缩临时表空间,也可以使用 ALTER TABLESPACE tablespace_name SHRINK TEMPFILE命令收缩临时文件,上面命令,可使用可选的KEEP子句来指定表空间或临时文件的下限。11g新增视图:DBA_TEMP_FREE_SPACE该视图用来查看原创 2013-04-07 09:59:13 · 715 阅读 · 0 评论 -
只读表(Read-only)--Oracle 11g 新特性
在11g前的版本中,若想对表设置为只读,可以通过赋予SELECT对象权限给这些用户,但表的拥有者还是读写的。而Oracle 11g 允许表标记为只读(read-only)通过ALTER TABLE 命令。可以通过下面命令对表读写权限进行设置:ALTER TABLE table_name READ ONLY;ALTER TABLE table_name READ WRITE;简单示例原创 2013-04-07 10:03:04 · 488 阅读 · 0 评论 -
delete 分批提交删除数据表记录
由于业务需要,需要对业务表数据进行删除,所以借鉴eygle的方式,如下:create or replace procedure del_datpayment (p_TableName in varchar2,--表名p_Condition in varchar2,--条件p_Count in varchar2--每批提交的条数 )aspragma autonom原创 2013-05-31 22:10:51 · 3437 阅读 · 0 评论 -
Oracle listener静态注册和动态注册
一、什么是注册? 注册就是将数据库作为一个服务注册到监听程序。客户端不需要知道数据库名和实例名,只需要知道该数据库对外提供的服务名就可以申请连接到数据库。这个服务名可能与实例名一样,也有可能不一样。 在数据库服务器启动过程中,数据库服务器会向监听程序注册相应的服务(无论何时启动一个数据库,默认地都有两条信息注册到监听器中:数据库服务器对应的实例和服务。)相当于是这样:在转载 2013-06-05 14:09:40 · 360 阅读 · 0 评论 -
Oracle 11g 新特性 Flashback Data Archive
Using Flashback Data Archive (Oracle Total Recall)A Flashback Data Archive (Oracle Total Recall) provides the ability to track and store all transactional changes to a table over its lifetime. I翻译 2013-06-07 16:08:49 · 1062 阅读 · 0 评论 -
Scan Listener In INTERMEDIATE Mode - Not All Endpoints Registered
In this Document Symptoms Changes Cause Solution ReferencesAPPLIES TO:Oracle Database - Enterpri原创 2015-11-03 13:36:08 · 1733 阅读 · 0 评论 -
表连接 nested loop hash join sort merge
11.3 Overview of JoinsJoins are statements that retrieve data from multiple tables. A join is characterized by multiple tables in theFROM clause. The existence of a join condition in the WHERE cla原创 2014-04-22 14:48:14 · 437 阅读 · 0 评论 -
Redefining Tables Online
在数据库系统中,偶尔需要原创 2014-05-07 12:29:45 · 508 阅读 · 0 评论 -
log file sync(日志文件同步) 与 Log file parallel write 等待事件
log file sync(日志文件同步)等待事件具有一个参数:buffer#。在Oracle Database 10g中,这种等待事件位于Commit等待下面。当处理log file sync等待事件时,注意下面的思想:◎ log file sync 等待时间和事务中指(提交或回滚)相关◎ 当进程在log file sync事件上花费大量时间时,这通常表明过多的提交或短事务。转载 2014-04-30 17:22:24 · 510 阅读 · 0 评论