ITPub博客

Redis3.2.6安装(CentOS 6.5)

MySQL 多表关联删除

Oracle 多表关联删除

使用TortoiseHg克隆远程目录报错"abort: Access is denied"

Oracle 11g报错ORA-12012: error on auto execute of job "ORACLE_OCM"."MGMT_CONFIG_JOB_2_1"

Percona MySQL 日志中出现大量Aborted connection (Got an error reading communication packets)

Oracle 11G安装报错"ORA-00401: the value for parameter compatible is not supported by this release

Oracle报错ORA-01034: ORACLE not availableORA-27101: shared memory realm does not existLinux-x86_64 Error: 2: No such file or directory

Oracle 11g 报错ORA-01102: cannot mount database in EXCLUSIVE mode

配置SQL Developer连接MySQL的方法

Oracle 11g 修改监听端口

Oracle 11g 查看监听日志

MySQL SELECT..INTO OUTFILE语句只能导出1000行的故障

Oracle 11g RAC表决盘和OCR盘挂载失败引发的节点故障

PowerDesiner 15 在物理模型中创建表和索引

MySQL 通过SUBSTRING_INDEX函数拆分字符串为数组单元

Percona MySQL 5.6语句加锁报错：ERROR 1665 (HY000): Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT and at least one table uses a storage engine limited to row-based logging. InnoDB is limited to row-logging when transaction isolation level is READ COMMITTED or READ UNCOMMITTED.

Oracle 连接的测试

Oracle 11g 数据库服务器CPU、IO负载高的故排除流程

在哈希分区中，如果分区字段的值是相同的，相同值的条目都会存放在相同的分区中；LIST分区则易于管理，而对于哈希分区，则不好控制各个值所存放的分区，有的分区会存放两个或多个分区字段值。