<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[听雪楼主]]></title><description><![CDATA[致力于Oracle、MySQL、PG、SQL Server等数据库相关的技术分享]]></description><link>https://blog.youkuaiyun.com/DBDeep</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; DBDeep]]></copyright><item><title><![CDATA[一个BUG导致的Oracle数据库实例重启：ORA-00600 [kjmchkiseq:!seq]]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/170130422</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/170130422</guid><author>DBDeep</author><pubDate>Thu, 05 Nov 2026 11:01:43 +0800</pubDate><description><![CDATA[一个BUG导致的Oracle数据库实例重启：ORA-00600 [kjmchkiseq:!seq]]]></description><category></category></item><item><title><![CDATA[某金融客户核心业务系统SQL优化案例（一）]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/159132579</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/159132579</guid><author>DBDeep</author><pubDate>Mon, 16 Mar 2026 23:56:56 +0800</pubDate><description><![CDATA[某金融客户核心业务系统SQL优化案例]]></description><category></category></item><item><title><![CDATA[某客户数据库系统节点1 CPU使用率过高问题分析处理]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/158939003</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/158939003</guid><author>DBDeep</author><pubDate>Thu, 12 Mar 2026 00:16:03 +0800</pubDate><description><![CDATA[某客户节点1 CPU使用率过高问题分析处理]]></description><category></category></item><item><title><![CDATA[某客户系统Oracle数据运行慢分析]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/158937641</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/158937641</guid><author>DBDeep</author><pubDate>Thu, 12 Mar 2026 00:08:52 +0800</pubDate><description><![CDATA[某客户系统Oracle数据运行慢分析]]></description><category></category></item><item><title><![CDATA[某客户核心业务系统报ORA-600错误分析处理]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/158936804</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/158936804</guid><author>DBDeep</author><pubDate>Thu, 12 Mar 2026 00:03:51 +0800</pubDate><description><![CDATA[某客户核心业务系统报ORA-600错误分析处理]]></description><category></category></item><item><title><![CDATA[Oracle ADG出现Gap（归档间隙）的完整处理方案]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/158916157</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/158916157</guid><author>DBDeep</author><pubDate>Wed, 11 Mar 2026 03:21:45 +0800</pubDate><description><![CDATA[当Gap范围较大（缺失日志超过10个），或主库归档日志被删除、损坏，无法通过拷贝日志修复时，需通过主库增量备份+备库恢复的方式修复，核心原理是基于备库当前SCN，从主库生成增量备份，同步缺失的数据块，适用于Oracle 11g及以上版本，是生产环境中处理大型Gap的常用方法。]]></description><category></category></item><item><title><![CDATA[一起Oracle 19c bug 导致的业务系统超时问题分析]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/150469688</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/150469688</guid><author>DBDeep</author><pubDate>Sun, 17 Aug 2025 17:31:53 +0800</pubDate><description><![CDATA[在某些数据库高负载运行的情况下，数据库核心进程DBWR（Database Writer，负责将数据库内存中被修改的数据块批量写入磁盘数据文件）在进行数据写入时，由于内部序列（sequence）错误不能获取相应的权限（write permission），导致内存中的缓存数据（Dirty Buffer）无法及时写入磁盘，进而引发数据库缓冲区（Buffer Cache）中的脏数据（Dirty Data）堆积。数据库会话以降低连接数。2、08:22 ，现场数据库运维人员收到数据库实例2 DOWN告警短信。]]></description><category></category></item><item><title><![CDATA[Oracle Undo Tablespace 使用率暴涨案例分析]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/150469048</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/150469048</guid><author>DBDeep</author><pubDate>Sun, 17 Aug 2025 16:44:37 +0800</pubDate><description><![CDATA[本案例因为对物化视图执行delete操作导致的undo tablespace表空间使用率暴涨的问题，以重建物化视图解决，重建物化视图后，物化视图的刷新恢复正常，delete操作事务亦可以快速commit，事务的undo block不再长期占用undo tablespace。客户XXX数据库是4节点Oracle RAC架构,节点1监控undo tablespace使用率超过阈值告警，并且还在快速增长，经检查发现，一事务在对物化视图执行delete时，长时间未完成，导致undo表空间被占用，使用率快速增长。]]></description><category></category></item><item><title><![CDATA[Oracle查看历史会话信息视图介绍]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/150467533</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/150467533</guid><author>DBDeep</author><pubDate>Sun, 17 Aug 2025 15:11:45 +0800</pubDate><description><![CDATA[在Oracle数据库中，查看历史会话信息主要依赖于以下动态性能视图（Dynamic Performance Views）和自动工作负载存储库（AWR）相关视图。本文列举了一些关键视图及说明。]]></description><category></category></item><item><title><![CDATA[Oracle adg环境下调整redo日志组以及standby日志组大小]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/147907082</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/147907082</guid><author>DBDeep</author><pubDate>Mon, 12 May 2025 23:29:15 +0800</pubDate><description><![CDATA[Oracle adg环境下调整redo日志组以及standby日志组大小]]></description><category></category></item><item><title><![CDATA[Oracle 19c 使用OGG同步数据到kafka端报错分析处理]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/147622033</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/147622033</guid><author>DBDeep</author><pubDate>Wed, 30 Apr 2025 00:44:17 +0800</pubDate><description><![CDATA[通过排查参数配置，源端已配置目录名，至此怀疑是目录名配置错误，通过和客户确认，源端环境为多租户数据库，租户数据库名为：Uat。查看源端、目标端同步进程都是running状态。*.*不能是通配符，因为没有为目标表*指定目录名或非通配符目录名。今天收到一个客户反馈，新创建的ogg同步出现了问题，进程启动后无法进行同步。联系业务在源端进行数据库插入操作，目标端（kafka端）已成功获取同步数据。修改完后，启动源、目标端进程，可以正常启动，日志无报错信息。至此，整改故障分析处理结束。报错提示源端没有目录名。]]></description><category></category></item><item><title><![CDATA[Oracle 12.1.0.2补丁安装全流程]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/147315619</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/147315619</guid><author>DBDeep</author><pubDate>Thu, 17 Apr 2025 23:00:20 +0800</pubDate><description><![CDATA[The complete process of installing Oracle 12.1.0.2 patches
]]></description><category></category></item><item><title><![CDATA[Oracle补丁安装工具opatch更新报错处理]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/147315243</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/147315243</guid><author>DBDeep</author><pubDate>Thu, 17 Apr 2025 22:32:52 +0800</pubDate><description><![CDATA[Oracle补丁安装工具opatch更新报错处理]]></description><category></category></item><item><title><![CDATA[某客户ORA-600 导致数据库反复重启问题分析]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/147314976</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/147314976</guid><author>DBDeep</author><pubDate>Thu, 17 Apr 2025 22:12:47 +0800</pubDate><description><![CDATA[某客户ORA-600 导致数据库反复重启问题分析]]></description><category></category></item><item><title><![CDATA[一次统计信息收集导致的Oracle数据库查询慢分析]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/145235001</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/145235001</guid><author>DBDeep</author><pubDate>Sun, 19 Jan 2025 00:14:43 +0800</pubDate><description><![CDATA[通过统计信息时间以及数据量信息发现，这个分区表分布不均匀，且在反应慢的时段内进行了统计信息收集。查看awr报告，发现在18:30-19:00时，大量会话查询此分区表最后一个大分区，即max分区，所以造成大量会话阻塞，导致数据库查询慢。统计信息收集完，数据库查询恢复正常。根据客户提出的信息，查看对应时段的awr报告，发现在此时段内，对表XXX_XXXX_SCAN存在着大量的查询操作。最后，已和客户建议在非业务时段或者业务负载低的时段进行表的统计信息收集，同时尽量不要在业务时段进行任何备份操作。]]></description><category></category></item><item><title><![CDATA[Oracle进行exp导出密码中有特殊字符报EXP-00056和ORA-12154错处理]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/144396513</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/144396513</guid><author>DBDeep</author><pubDate>Wed, 11 Dec 2024 11:43:48 +0800</pubDate><description><![CDATA[Oracle进行exp导出密码中有特殊字符报EXP-00056和ORA-12154错处理]]></description><category></category></item><item><title><![CDATA[Oracle 19c修改pga报ORA-00093、ORA-01078错进行分析处理]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/143895632</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/143895632</guid><author>DBDeep</author><pubDate>Tue, 19 Nov 2024 21:16:54 +0800</pubDate><description><![CDATA[Oracle 19c修改pga报ORA-00093、ORA-01078错进行分析处理]]></description><category></category></item><item><title><![CDATA[Oracle 19c PDB克隆后出现Warning: PDB altered with errors受限模式处理]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/143745218</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/143745218</guid><author>DBDeep</author><pubDate>Wed, 13 Nov 2024 16:04:01 +0800</pubDate><description><![CDATA[Oracle 19c PDB克隆后出现Warning: PDB altered with errors受限模式处理]]></description><category></category></item><item><title><![CDATA[关于一次由根目录权限问题导致的Oracle集群无法启动问题分析处理]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/143206528</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/143206528</guid><author>DBDeep</author><pubDate>Thu, 24 Oct 2024 13:36:06 +0800</pubDate><description><![CDATA[关于一次由根目录权限问题导致的Oracle集群无法启动问题分析处理]]></description><category></category></item><item><title><![CDATA[MySQL8.0主从同步报ERROR 13121错误解决方法]]></title><link>https://blog.youkuaiyun.com/DBDeep/article/details/142977697</link><guid>https://blog.youkuaiyun.com/DBDeep/article/details/142977697</guid><author>DBDeep</author><pubDate>Wed, 16 Oct 2024 11:46:36 +0800</pubDate><description><![CDATA[MySQL8.0主从同步报ERROR 13121错误解决方法]]></description><category></category></item></channel></rss>