<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[j_ychen的博客]]></title><description><![CDATA[]]></description><link>https://blog.csdn.net/j_ychen</link><language>zh-cn</language><generator>https://blog.csdn.net/</generator><copyright><![CDATA[Copyright &copy; j_ychen]]></copyright><item><title><![CDATA[ORA-4031相关脚本(Doc ID 430473.1)]]></title><link>https://blog.csdn.net/j_ychen/article/details/122775661</link><guid>https://blog.csdn.net/j_ychen/article/details/122775661</guid><author>j_ychen</author><pubDate>Thu, 03 Feb 2022 14:56:19 +0800</pubDate><description><![CDATA[@SGAParameters.sql


Database Started Last
----------------------------------------
03-Feb-2022 12:50:57

1 row selected.


Setting                                                                MBytes
------------------------------------------------------]]></description><category></category></item><item><title><![CDATA[8.0: After changing innodb_undo_directory, Server Fails to Start: Plugin initialization]]></title><link>https://blog.csdn.net/j_ychen/article/details/122007910</link><guid>https://blog.csdn.net/j_ychen/article/details/122007910</guid><author>j_ychen</author><pubDate>Sat, 18 Dec 2021 02:06:08 +0800</pubDate><description><![CDATA[APPLIES TO:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

SYMPTOMS

Server fails to start, with a vague message in the log:


2020-03-08T13:32:53.741553Z 0 [System] [MY-010116] [Server] mysqld (mysqld 8.0.19-.]]></description><category></category></item><item><title><![CDATA[RMAN Active Duplicate on RAC fails with ORA-17629 and ORA-17627: ORA-12154 (Doc ID 1982003.1)]]></title><link>https://blog.csdn.net/j_ychen/article/details/118258086</link><guid>https://blog.csdn.net/j_ychen/article/details/118258086</guid><author>j_ychen</author><pubDate>Sun, 27 Jun 2021 01:23:41 +0800</pubDate><description><![CDATA[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:11
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in store]]></description><category></category></item><item><title><![CDATA[19c 新特性-2]]></title><link>https://blog.csdn.net/j_ychen/article/details/117792329</link><guid>https://blog.csdn.net/j_ychen/article/details/117792329</guid><author>j_ychen</author><pubDate>Fri, 18 Jun 2021 17:43:29 +0800</pubDate><description><![CDATA[Dynamically Change Oracle Data Guard Broker Fast-Start Failover Target

The 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 ]]></description><category></category></item><item><title><![CDATA[ora-65532 Automatic Indexing - Autonomous Database (Shared) (Doc ID 2764331.1)]]></title><link>https://blog.csdn.net/j_ychen/article/details/118018458</link><guid>https://blog.csdn.net/j_ychen/article/details/118018458</guid><author>j_ychen</author><pubDate>Fri, 18 Jun 2021 10:33:16 +0800</pubDate><description><![CDATA[APPLIES TO:

Autonomous Database on Shared Infrastructure - Version N/A to N/A
Information in this document applies to any platform.

GOAL

The automatic indexing feature in Oracle Database is enabled in Autonomous Database.The automatic indexing feature .]]></description><category></category></item><item><title><![CDATA[19c 新特性-1]]></title><link>https://blog.csdn.net/j_ychen/article/details/117756923</link><guid>https://blog.csdn.net/j_ychen/article/details/117756923</guid><author>j_ychen</author><pubDate>Thu, 10 Jun 2021 22:01:10 +0800</pubDate><description><![CDATA[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]]></description><category></category></item><item><title><![CDATA[shared pool]]></title><link>https://blog.csdn.net/j_ychen/article/details/117457544</link><guid>https://blog.csdn.net/j_ychen/article/details/117457544</guid><author>j_ychen</author><pubDate>Wed, 02 Jun 2021 10:15:24 +0800</pubDate><description><![CDATA[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为

游标...]]></description><category></category></item><item><title><![CDATA[‘library cache lock‘ Waits: Causes and Solutions (Doc ID 1952395.1)]]></title><link>https://blog.csdn.net/j_ychen/article/details/117260779</link><guid>https://blog.csdn.net/j_ychen/article/details/117260779</guid><author>j_ychen</author><pubDate>Tue, 25 May 2021 17:30:13 +0800</pubDate><description><![CDATA[Cause Identified: Unshared SQL Due to Literals


SQL 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]]></description><category></category></item><item><title><![CDATA[ORA-14130: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION]]></title><link>https://blog.csdn.net/j_ychen/article/details/117171941</link><guid>https://blog.csdn.net/j_ychen/article/details/117171941</guid><author>j_ychen</author><pubDate>Sat, 22 May 2021 21:26:36 +0800</pubDate><description><![CDATA[中间表跟归档表需要建主键or disable主键。

最好disable主键。

exchange后索引失效。需要创建索引。
]]></description><category></category></item><item><title><![CDATA[pt-archiver 删除、归档数据]]></title><link>https://blog.csdn.net/j_ychen/article/details/117093690</link><guid>https://blog.csdn.net/j_ychen/article/details/117093690</guid><author>j_ychen</author><pubDate>Thu, 20 May 2021 23:59:21 +0800</pubDate><description><![CDATA[pt-archiver Archive rows from a MySQL table into another table or a file
pt-archiver --source h=localhost,D=tt,t=sbtest1 --user=root --password=oracle --socket=/tmp/mysql.sock --no-check-charset --dest h=localhost,D=test,t=sbtest1 --file '/tmp/t1.log'...]]></description><category></category></item><item><title><![CDATA[mysql 隔离级别]]></title><link>https://blog.csdn.net/j_ychen/article/details/116903642</link><guid>https://blog.csdn.net/j_ychen/article/details/116903642</guid><author>j_ychen</author><pubDate>Sun, 16 May 2021 22:09:03 +0800</pubDate><description><![CDATA[The isolation level is used for operations on InnoDB tables.

SELECT @@GLOBAL.transaction_isolation, @@GLOBAL.transaction_read_only;
SELECT @@SESSION.transaction_isolation, @@SESSION.transaction_read_only;


SET [GLOBAL | SESSION] TRANSACTION
 transa...]]></description><category></category></item><item><title><![CDATA[19c 新特性 ----大部分来自欠子哥的测试。]]></title><link>https://blog.csdn.net/j_ychen/article/details/116845023</link><guid>https://blog.csdn.net/j_ychen/article/details/116845023</guid><author>j_ychen</author><pubDate>Sat, 15 May 2021 15:12:21 +0800</pubDate><description><![CDATA[1.Data Guard DML Redirect

alter system set adg_redirect_dml=true scope=both sid='*';

可以在备库进行 insert、update、 delete 的操作,是通过dblink从备库从主库写。

2.Partitioned Hybrid Tables

19c 创建了 hybrid_partition_table 分区表，与以往分区表不一样 的是，这个分区表，一部分分区是正常的分区，一部分分区是外部表来的。正常的分区可以 进]]></description><category></category></item><item><title><![CDATA[Elasticsearch数据写流程和读流程]]></title><link>https://blog.csdn.net/j_ychen/article/details/116709682</link><guid>https://blog.csdn.net/j_ychen/article/details/116709682</guid><author>j_ychen</author><pubDate>Wed, 12 May 2021 16:47:13 +0800</pubDate><description><![CDATA[数据写流程和读流程一、数据写流程二、数据读流程
一、数据写流程


客户端选择一个 集群任意节点 发送请求过去，这个 node 就是 coordinating node（协调节点）。
coordinating node（协调节点） 对 document 进行路由，将请求转发给对应的 node（有 primary shard）。
实际的 node 上的 primary shard 处理请求，然后将数据同步到 replica node。
coordinating node 如果发现 primary node 和]]></description><category></category></item><item><title><![CDATA[Elasticsearch 写操作]]></title><link>https://blog.csdn.net/j_ychen/article/details/116662579</link><guid>https://blog.csdn.net/j_ychen/article/details/116662579</guid><author>j_ychen</author><pubDate>Wed, 12 May 2021 11:26:19 +0800</pubDate><description><![CDATA[写操作一、写数据底层原理二、Translog三、段合并段合并性能问题其他性能四、删除和更新总结

一、写数据底层原理
当用户向一个节点提交了一个索引新文档的请求，节点会计算新文档应该加入到哪个分片（shard）中。每个节点都存储有每个分片存储在哪个节点的信息，因此协调节点会将请求发送给对应的节点。注意这个请求会发送给主分片，等主分片完成索引，会并行将请求发送到其所有副本分片，保证每个分片都持有最新数据。

新的document先写入内存buffer中，同时追加写入translog日志文件（transacti]]></description><category></category></item><item><title><![CDATA[Elasticsearch倒排索引]]></title><link>https://blog.csdn.net/j_ychen/article/details/116596438</link><guid>https://blog.csdn.net/j_ychen/article/details/116596438</guid><author>j_ychen</author><pubDate>Mon, 10 May 2021 18:21:16 +0800</pubDate><description><![CDATA[倒排索引前言一、倒排索引的内部结构1.Term index2.Term Dictionary字典数据结构3.与mysql对比二、FST（Finite State Transducer）总结

前言
Elasticsearch 使用一种称为 倒排索引 的结构，它适用于快速的全文搜索。一个倒排索引由文档中所有不重复词的列表构成，对于其中每个词，有一个包含它的文档列表。在搜索引擎中，每个文档都有一个对应的文档 ID，文档内容被表示为一系列关键词的集合。例如，文档 1 经过分词，提取了 20 个关键词，每个关键词都]]></description><category></category></item><item><title><![CDATA[11.2.0.4到19c duplicate 需要打补丁18633374]]></title><link>https://blog.csdn.net/j_ychen/article/details/116135471</link><guid>https://blog.csdn.net/j_ychen/article/details/116135471</guid><author>j_ychen</author><pubDate>Sun, 25 Apr 2021 18:30:03 +0800</pubDate><description><![CDATA[ora-17629

ora-17639

参考：2517772.1
]]></description><category></category></item><item><title><![CDATA[my.cnf查找顺序]]></title><link>https://blog.csdn.net/j_ychen/article/details/113185194</link><guid>https://blog.csdn.net/j_ychen/article/details/113185194</guid><author>j_ychen</author><pubDate>Tue, 26 Jan 2021 17:26:17 +0800</pubDate><description><![CDATA[Table4.2Option Files Read on Unix and Unix-Like Systems

File Name
			Purpose
		/etc/my.cnf
			Global options
		/etc/mysql/my.cnf
			Global options
		SYSCONFDIR/my.cnf
			Global options
		$MYSQL_HOME/my.cnf
			Server-specific options (server only)
		defa..]]></description><category></category></item><item><title><![CDATA[MYSQL 8.0 主键检查sql_require_primary_key]]></title><link>https://blog.csdn.net/j_ychen/article/details/112784160</link><guid>https://blog.csdn.net/j_ychen/article/details/112784160</guid><author>j_ychen</author><pubDate>Mon, 18 Jan 2021 16:25:41 +0800</pubDate><description><![CDATA[MySQL 8.0.13 版本引入了一个新的参数sql_require_primary_key，创建新表或更改现有表结构的语句是否强制要求表具有主键。默认是OFF。

1. 开启后影响：

启用后， sql_require_primary_key具有以下效果：



	尝试创建没有主键的新表失败并显示错误。这包括CREATE TABLE ... LIKE。它还包含CREATE TABLE ... SELECT，除非该CREATE TABLE部分包含主键定义。
	
	
	尝试从现有表中删除主键失败并显示错误，]]></description><category></category></item><item><title><![CDATA[MYSQL 8.0 MGR组复制插件体系结构]]></title><link>https://blog.csdn.net/j_ychen/article/details/112766599</link><guid>https://blog.csdn.net/j_ychen/article/details/112766599</guid><author>j_ychen</author><pubDate>Mon, 18 Jan 2021 11:15:55 +0800</pubDate><description><![CDATA[API层：包括一组用于捕获，应用和生命周期的API，这些API控制插件如何与MySQL Server交互。有一些接口可以使信息从服务器流向插件，反之亦然。这些接口将MySQL Server核心与组复制插件隔离开，并且大多数是放置在事务执行管道中的钩子。在一个方向上，从服务器到插件，会有事件通知，例如服务器启动，服务器恢复，服务器准备接受连接以及服务器即将提交事务。在另一个方向，插件指示服务器执行操作，如提交或中止正在进行的事务，或在中继日志中对事务进行排队。


组件层：Capture组件负责跟踪与正在..]]></description><category></category></item><item><title><![CDATA[MySQL中的xtrabackup的原理解析]]></title><link>https://blog.csdn.net/j_ychen/article/details/111869352</link><guid>https://blog.csdn.net/j_ychen/article/details/111869352</guid><author>j_ychen</author><pubDate>Wed, 30 Dec 2020 16:03:50 +0800</pubDate><description><![CDATA[Percona XtraBackupPercona XtraBackup如何工作Percona XtraBackup的工作方式xtrabackup与innobackupex二者区别备份原理Xtrabackup工具的备份过程原理图全库备份增量备份恢复原理Xtrabackup工具的恢复过程原理图全库恢复增量备份的恢复增量备份恢复示例创建增量备份准备增量备份
Percona XtraBackup如何工作
Xtrabackup是基于InnoDB存储引擎灾难恢复的。它复制InnoDB的数据文件,尽管数据文件在内部是非]]></description><category></category></item></channel></rss>