<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[IIOOHHHSSSS的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/IIOOHHHSSSS</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; IIOOHHHSSSS]]></copyright><item><title><![CDATA[ORACLE单机PSU]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/144245195</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/144245195</guid><author>IIOOHHHSSSS</author><pubDate>Wed, 04 Dec 2024 18:26:23 +0800</pubDate><description><![CDATA[确定当前安装的任何一次性补丁是否与PSU补丁冲突。检查完成后，关闭监听和实列开始补丁。完成，该PSU为2024.7。]]></description><category></category></item><item><title><![CDATA[SQLHC使用]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/143419892</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/143419892</guid><author>IIOOHHHSSSS</author><pubDate>Thu, 31 Oct 2024 23:13:41 +0800</pubDate><description><![CDATA[SQLHC用于检查单条SQL语句运行的环境，包括基于成本的优化器（CBO）的统计数据，用户对象的元数据定义，配置参数和其它可能影响到目标SQL性能的因素。解压出来后，可以看到改语句的全部信息，这里重点关注sqlhc_20241031_1115_gc6d3jxbh57q1_10_sql_tuning_advisor这个文件，里面是调优建议，和计划对比。执行完成后SQLT和SQLHC脚本生成的报告文件都在进入SQL*Plus之前的OS的当前目录下。2.选择优化的语句的sql_id。执行sqlhc.sql脚本。]]></description><category></category></item><item><title><![CDATA[Oracle DataGuard自动启动脚本]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/129875231</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/129875231</guid><author>IIOOHHHSSSS</author><pubDate>Fri, 31 Mar 2023 11:03:43 +0800</pubDate><description><![CDATA[【代码】Oracle DataGuard自动启动脚本。]]></description><category></category></item><item><title><![CDATA[oracle单机自启动]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/129862292</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/129862292</guid><author>IIOOHHHSSSS</author><pubDate>Thu, 30 Mar 2023 17:29:18 +0800</pubDate><description><![CDATA[公司单机测试库，业务库断电后需要人工去启库和监听。每次服务器开始都会自启。]]></description><category></category></item><item><title><![CDATA[Oracle外键禁用]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/126101501</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/126101501</guid><author>IIOOHHHSSSS</author><pubDate>Mon, 01 Aug 2022 15:21:37 +0800</pubDate><description><![CDATA[Oracle 外键禁用]]></description><category></category></item><item><title><![CDATA[ORACLE监控索引使用]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/124961450</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/124961450</guid><author>IIOOHHHSSSS</author><pubDate>Wed, 25 May 2022 14:13:27 +0800</pubDate><description><![CDATA[Oracle监控索引使用]]></description><category></category></item><item><title><![CDATA[Oracle视图学习DBA_HIST_ACTIVE_SESS_HISTORY]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/124922402</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/124922402</guid><author>IIOOHHHSSSS</author><pubDate>Mon, 23 May 2022 11:08:24 +0800</pubDate><description><![CDATA[Oracle视图学习DBA_HIST_ACTIVE_SESS_HISTORY]]></description><category></category></item><item><title><![CDATA[ORACLE审计管理]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/122297027</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/122297027</guid><author>IIOOHHHSSSS</author><pubDate>Tue, 04 Jan 2022 16:00:12 +0800</pubDate><description><![CDATA[审计（audit)用于监视用户所执行的数据库操作，审计记录可存在数据字典表，存储在system表空间中的 sys.aud$表中，可通过视图dba_audit_trail查看
默认位置为$oracle_base/admin/$oracle_sid/adump/
oracle 10g 默认情况下审计是没有开启的
oracle 11g 默认情况下审计是开启的
审计的三个视图
dba_audit_trail:保存所有的audit trail，实际上它只是一个基于aud$的视图。其它的视图dba_audit_sess]]></description><category></category></item><item><title><![CDATA[Oracle的冷备+恢复]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121633007</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121633007</guid><author>IIOOHHHSSSS</author><pubDate>Wed, 08 Dec 2021 17:58:49 +0800</pubDate><description><![CDATA[冷备恢复单机-单机]]></description><category></category></item><item><title><![CDATA[Oracle等待事件查询语句整理]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121628526</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121628526</guid><author>IIOOHHHSSSS</author><pubDate>Tue, 30 Nov 2021 11:22:49 +0800</pubDate><description><![CDATA[–查询阻塞和被阻塞的session，支持RAC，按instance分组
SELECT a.INST_ID,
a.sid,
a.SERIAL#,
a.USERNAME,
a.SQL_ID,
a.PROGRAM,
a.EVENT,
a.BLOCKING_SESSION,
a.WAIT_TIME_MICRO
FROM GVSESSIONAWHERE(A.INSTID,a.SID)in(selectb.BLOCKINGINSTANCE,b.BLOCKINGSESSIONfromgvSESSION A
 WHERE ]]></description><category></category></item><item><title><![CDATA[Oracle性能管理常用命令]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121603654</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121603654</guid><author>IIOOHHHSSSS</author><pubDate>Mon, 29 Nov 2021 10:14:11 +0800</pubDate><description><![CDATA[1.1.1.SQL优化任务查看与参数设置
select * from DBA_ADVISOR_EXECUTIONS t where t.task_name like ‘%AUTO%’ order by t.execution_start desc;
select dbms_sqltune.report_tuning_task(task_name =&gt; ‘SYS_AUTO_SQL_TUNING_TASK’,execution_name =&gt; ‘EXEC_329376’) from dual;
be]]></description><category></category></item><item><title><![CDATA[自动清理Oracle归档日志，alter日志，监听日志，审计日志]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121602678</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121602678</guid><author>IIOOHHHSSSS</author><pubDate>Mon, 29 Nov 2021 09:35:38 +0800</pubDate><description><![CDATA[#crontab
30 8 * * *  /ora/u01/scripts/clean_log.sh  &gt; /dev/null 2&gt;&amp;1
#######################################################################
################archive log
#!/bin/bash
. /home/oracle/.bash_profile
--------------------
#every day arch]]></description><category></category></item><item><title><![CDATA[虚拟机安装Oracle RAC]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121535381</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121535381</guid><author>IIOOHHHSSSS</author><pubDate>Thu, 25 Nov 2021 13:24:31 +0800</pubDate><description><![CDATA[服务器信息：
节点一：192.168.10.2 dbm1
节点二：192.168.10.3 dbm2
操作系统均为红帽6.9
Ip信息
public ip
192.168.10.2 dbm1
192.168.10.3 dbm2
private ip
10.10.0.4 dbm1-priv
10.10.0.5 dbm2-priv
vip
192.168.10.4 dbm1-vip
192.168.10.5 dbm2-vip
scan
192.168.10.6 scan
需要的安装包
cvuqdisk-1.0.]]></description><category></category></item><item><title><![CDATA[Oracle灾备开机自启动到mount（DG单机目标端)]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121515183</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121515183</guid><author>IIOOHHHSSSS</author><pubDate>Wed, 24 Nov 2021 14:49:48 +0800</pubDate><description><![CDATA[脚本如下
DG备端开机自启动
#!/bin/sh
#db auto be mount status when os restart
#20221124
su - oracle -c ‘sqlplus / as sysdba’&lt;&lt;EOF
startup nomount;
alter database mount standby database;
alter database recover managed standby database using current logfile discon]]></description><category></category></item><item><title><![CDATA[利用rman备份创建standby备库]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121511077</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/121511077</guid><author>IIOOHHHSSSS</author><pubDate>Wed, 24 Nov 2021 14:25:41 +0800</pubDate><description><![CDATA[使用rman来创建standby，过程相当简单，主库无需停机。本次试验演示了利用Rman热备，然后restore来创建备库的过程。
生产库：10.158.5.186
DG备库：10.158.5.188

演示环境
[oracle@dbm apps]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 25 17:48:20 2019
Copyright © 1982, 2013, Oracle.  All righ]]></description><category></category></item><item><title><![CDATA[MySQL主从复制搭建]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/88033404</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/88033404</guid><author>IIOOHHHSSSS</author><pubDate>Thu, 28 Feb 2019 16:22:58 +0800</pubDate><description><![CDATA[Mysql主从复制

1.主从复制概述
MySQL主从复制是其最重要的功能之一。主从复制是指一台服务器充当主数据库服务器，另一台或多台服务器充当从数据库服务器，主服务器中的数据自动复制到从服务器之中。对于多级复制，数据库服务器即可充当主机，也可充当从机。MySQL主从复制的基础是主服务器对数据库修改记录二进制日志，从服务器通过主服...]]></description><category></category></item><item><title><![CDATA[nginx+tomcat+redis+mysql实现session会话共享]]></title><link>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/86700287</link><guid>https://blog.youkuaiyun.com/IIOOHHHSSSS/article/details/86700287</guid><author>IIOOHHHSSSS</author><pubDate>Wed, 30 Jan 2019 11:00:10 +0800</pubDate><description><![CDATA[         redis缓存服务器(nginx+tomcat+redis+mysql实现session会话共享)

一、redis介绍
redis是一个key-value存储系统。和Memcached类似，它支持存储的value类型相对更多，包括string(字符串)、list(链表)、set(集合)、zset(sorted set --有序集合)和hash（哈希类型）。与memcached一...]]></description><category></category></item></channel></rss>