<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/pengtalent</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; pengtalent]]></copyright><item><title><![CDATA[oracle patch step]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/133340192</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/133340192</guid><author>pengtalent</author><pubDate>Wed, 27 Sep 2023 09:36:47 +0800</pubDate><description><![CDATA[-patchstartupquit--utlrputlrp.sql。]]></description><category></category></item><item><title><![CDATA[Install oracle 19C on Redhat8]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/128530053</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/128530053</guid><author>pengtalent</author><pubDate>Thu, 24 Aug 2023 16:30:08 +0800</pubDate><description><![CDATA[接下来又到了重中之重，在软件选择（Software Selection）中，强烈建议非高玩选择Server with GUI，并在右侧附加选项里，勾选Performance Tools、Legacy UNIX Compatibility、Development Tools、Graphical Administration Tools和System Tools，尤其是Legacy UNIX Compatibility、Development Tools这两项，可以让你在后面安装Oracle时省事很多；]]></description><category></category></item><item><title><![CDATA[python 图片提取文字]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/130439209</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/130439209</guid><author>pengtalent</author><pubDate>Sat, 29 Apr 2023 13:30:55 +0800</pubDate><description><![CDATA[将tessdata目录的上级目录所在路径：(默认为tesseract-ocr安装目录)添加至TESSDATA_PREFIX环境变量中。2，安装完成tesseract-ocr后，需要做一下配置。安装pytesseract。重新启动pycharm。]]></description><category></category></item><item><title><![CDATA[oracle常用函数]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/130438258</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/130438258</guid><author>pengtalent</author><pubDate>Sat, 29 Apr 2023 09:35:11 +0800</pubDate><description><![CDATA[]]></description><category></category></item><item><title><![CDATA[RMAN Restore]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/129781601</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/129781601</guid><author>pengtalent</author><pubDate>Sun, 26 Mar 2023 17:25:45 +0800</pubDate><description><![CDATA[1、restore 还原2、recover。]]></description><category></category></item><item><title><![CDATA[RMAN backup]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/129781503</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/129781503</guid><author>pengtalent</author><pubDate>Sun, 26 Mar 2023 17:07:57 +0800</pubDate><description><![CDATA[删除备份片丢失的备份不提示。#备份完后，将原来的归档删除。增量备的基础是0级备，就是说要做增量备的话，必须先做一个0级备(实际是全备)#dbv是一个操作系统工具，在操作系统提示符下运行的，而非RMAN。rman 本质上是一个客户端的应用程序，用来建立到目标数据库之的间连接，10G，为了加快增量备的速度，引入了一个文件，用来记录自上一次备份。]]></description><category></category></item><item><title><![CDATA[oracle cold backup]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/129769781</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/129769781</guid><author>pengtalent</author><pubDate>Sat, 25 Mar 2023 17:40:59 +0800</pubDate><description><![CDATA[C /usr/oabak/ temp  后边备份文件夹要空格隔开。获取控制文件/数据文件/日志文件/参数文件/口令文件脚本。参数z , 压缩脚本可以用unzip解压。保存为getbackupsql.sql。-P 参数表示使用绝对路径。-C 表示只取后边文件夹。-c 表示创建压缩文件。]]></description><category></category></item><item><title><![CDATA[oracle 常见等待事件汇总]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/129769496</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/129769496</guid><author>pengtalent</author><pubDate>Sat, 25 Mar 2023 17:12:35 +0800</pubDate><description><![CDATA[空闲事件可以通过stats$idle_event 表查询得到。一般来说，空闲等待是指系统因为无事可做的等待。可能表示在多表连接中，表的连接顺序存在问题。等待事件表明系统正在等待内存中的可用空间。DBWR 写出速度太慢或者IO 存在问题。控制文件的物理磁盘I/O 是否存在瓶颈。I/O 操作最为频繁的数据文件。没有很好的是用绑定变量(磁盘I/O 存在瓶颈。]]></description><category></category></item><item><title><![CDATA[Oracle 性能报告 AWR]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/129769466</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/129769466</guid><author>pengtalent</author><pubDate>Sat, 25 Mar 2023 17:08:39 +0800</pubDate><description><![CDATA[AWR报告内容非常全面，主要包括：WAIT EVENT, SQL, IO, MTTR ADVIRSORY, PGA MEMORY ADVISORY, SHARED POOL ADVISORY, SGA ADVISORY, UNDO, LATCH, SEGMENT。自动工作负载资料库(automatic workload repository)(\AWR(从ORACLE 10G后预安装到ORACLE中)2、查看AWR的快照ID。]]></description><category></category></item><item><title><![CDATA[oradebug hanganalyze test]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/129767671</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/129767671</guid><author>pengtalent</author><pubDate>Sat, 25 Mar 2023 16:52:55 +0800</pubDate><description><![CDATA[基本用法hanganalyze有两种使用方法：会话级别，单实例和rac都可以使用。]]></description><category></category></item><item><title><![CDATA[oracle 19c statspack test]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/129767521</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/129767521</guid><author>pengtalent</author><pubDate>Sat, 25 Mar 2023 15:20:54 +0800</pubDate><description><![CDATA[3. install。]]></description><category></category></item><item><title><![CDATA[Oracle DG 手动备库应用缺失日志]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/129644764</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/129644764</guid><author>pengtalent</author><pubDate>Sat, 18 Mar 2023 23:13:45 +0800</pubDate><description><![CDATA['/u01/app/oracle/oradata/flash_recovery_area/ORCLST/archivelog/2023_03_18/o1_mf_1_17_l1cmd1wk_.arc'^C已经应用ID----------100200200300。]]></description><category></category></item><item><title><![CDATA[sql server shrink many databases‘s logfile by log file size]]></title><link>https://blog.youkuaiyun.com/pengtalent/article/details/128483676</link><guid>https://blog.youkuaiyun.com/pengtalent/article/details/128483676</guid><author>pengtalent</author><pubDate>Thu, 29 Dec 2022 16:22:40 +0800</pubDate><description><![CDATA[sql server shrink many databases's logfile by log file size]]></description><category></category></item></channel></rss>