- 博客(63)
- 收藏
- 关注
RSS订阅原创 MySQL重写插件
Mysql支持查询重写插件1、是服务端插件2、支持的语句： Mysql 8.0.12: Select 、Insert、Replace、Update、Delete; Mysql 8.0.12:仅支持Select3、涉及的数据库：query_rewrite 表：rewrite_rules 存储过程：flush_rewrite_rules 函数：loa...
2022-04-18 16:37:55
479
原创 管理自动索引
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
337
转载 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
455
转载 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
329
转载 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
5113
原创 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
3943
原创 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
540
翻译 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
736
原创 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
761
翻译 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
981
原创 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
285
原创 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
353
转载 dia0 High Memory Usage (文档 ID 1376981.1)
In this Document Symptoms Cause Solution ReferencesThis document is being delivered to you via Oracle Support's Rapid Visi
2017-09-19 09:29:42
1155
转载 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
7699
转载 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
733
原创 Can OGG Version 11 Be Used to Pump/Move Trails Generated from Version 9 or 10? (文档 ID 1297283.1)
In this DocumentGoal SolutionAPPLIES TO:Oracle GoldenGate - Version 11.1.1.0.0 and laterInformation in this document applies to any platform.GOA
2017-05-10 17:15:20
338
原创 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
863
原创 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
551
原创 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
824
转载 五种方式将数据从MongoDB同步到ElasticSearch
Elastic search(ES) is a pop-star for recording and analyzing data, andMongodb is a famous NoSQL database for storing and querying data. With our web infrastructure improving, how can we export dat
2016-12-30 10:31:27
7268
原创 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
617
原创 开启和关闭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
1145
原创 通过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
6874
原创 手工建PDB
可以通过如下方式创建PDB：通过seed创建PDB：在通过seed创建PDB时，需要指定文件存放位置，可通过如下两种方式：1、在create pluggable database 语句中设置file_name_convert参数：[oracle@ora12c ~]$ sqlplus /nolog
2016-11-30 16:04:39
1308
原创 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
747
原创 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
989
翻译 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
386
原创 SQL Server常用查询
--1.查看数据库版本信息 select @@version as 'Database Version'--2.查看所有数据库名称及大小 exec sp_helpdb --3.查看数据库所在机器的操作系统参数 exec master..xp_msver --4.查看数据库启动的参数 exec sp_configure
2015-11-24 16:27:14
1110
原创 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
1701
原创 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
553
原创 Postgresql备份之pg_dump
[postgre@pg-1 postgresql-9.4.4]$ pg_dump --helppg_dump dumps a database as a text file or to other formats.Usage: pg_dump [OPTION]... [DBNAME]General options: -f,
2015-10-15 15:08:31
5617
1
原创 PG常用管理命令
查看服务进程： select pid,usename,client_addr,client_port from pg_stat_activity;查看当前数据库实例的版本： select version(); 查看数据库的启动时间：select pg_postmaster_start_time();查看最后load配置文件的时间：
2015-10-15 15:02:59
3203
原创 pg_basebackup 命令行参数
pg_basebackup是postgresql提供的一个方便基础备份的工具（9.1开始提供），这个工具会把整个数据库实例的数据都拷贝出来，而不只是把实例中的部分（如某个数据库或表）单独备份出来，该工具使用replication协议连接到数据库实例上，所以主数据库中的pg_hba.conf必须允许replication连接，类似如下：local replication post
2015-10-15 15:01:46
10854
原创 VirtualBox 克隆的虚拟机网卡起不来
克隆的虚拟机，网卡起不来，报：device eth0 does not seem to be present, delaying initialization1、将ifcfg-eth0中的mac地址删掉，重启故障依旧；2、/etc/udev/rules.d/70-persistent-net.rules这个文件绑定了网卡和mac地址，需要做对应的修改或者删除这个文件，然后重
2015-10-15 14:29:49
754
原创 Percona Toolkit
1、简介：percona-toolkit是一组高级命令行工具的集合，用来执行各种通过手工执行非常复杂和麻烦的mysql和系统任务，这些任务包括：检查master和slave数据的一致性有效地对记录进行归档查找重复的索引对服务器信息进行汇总分析来自日志和tcpdump的查询当系统出问题的时候收集重要的系统信息2、软件下载:地址：https://www.percon
2015-10-15 14:24:32
601
原创 postgresql同步流复制的Hot Standby
Postgresql的流复制是异步的，异步的缺点是Standby上的数据落后于主库上的数据，如果使用Hot Standby做读写分离，就会存在数据一致性的问题，对于一些一致性高的应用来说是不可接受的。所以PG从9.1之后提供了同步流复制的架构。同步复制要求在数据写入Standby数据后，事务的commit才返回，所以Standby库出现问题时，会导致主库被Hang住。解决这个问题的方法是启动两个s
2015-10-15 14:14:13
8725
原创 postgresql异步流复制Hot Standby
1、配置环境： 示例环境主机名ＩＰ地址角色系统版本数据目录pg版本pg-110.0.2.60主库RedHat6.4/us
2015-10-15 14:12:52
1006
原创 Atlas Sharding 安装、配置及简单测试
1、软件下载地址：https://github.com/Qihoo360/Atlas/releases2、Atlas Sharding简介Sharding的基本思想就是把一个数据表中的数据切分成多个部分, 存放到不同的主机上去(切分的策略有多种), 从而缓解单台机器的性能跟容量的问题. sharding是一种水平切分, 适用于单表数据庞大
2015-10-15 14:02:17
3668
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人