上一页 1 2 3 4 5 6 ··· 12 下一页
摘要: In this Document Symptoms Cause Solution References APPLIES TO: Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this d 阅读全文
posted @ 2022-12-01 09:25 阿西吧li 阅读(135) 评论(0) 推荐(0) 编辑
摘要: APPLIES TO: Oracle Database Cloud Service - Version N/A and laterOracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Clou 阅读全文
posted @ 2022-06-28 09:13 阿西吧li 阅读(78) 评论(0) 推荐(0) 编辑
摘要: APPLIES TO: Oracle Hospitality OPERA 5 Property Services - Version 5.4.0 and laterInformation in this document applies to any platform. GOAL The docum 阅读全文
posted @ 2022-06-20 13:46 阿西吧li 阅读(203) 评论(0) 推荐(0) 编辑
摘要: Document Display Give Feedback... Search: ORA-20001:sTATISTIC aDVISOR Restore Pane Copyright (c) 2022, Oracle. All rights reserved. Oracle Confidentia 阅读全文
posted @ 2022-05-20 17:19 阿西吧li 阅读(309) 评论(0) 推荐(0) 编辑
摘要: mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE = 26\G *************************** 1. row *************************** SPACE 阅读全文
posted @ 2022-03-23 11:18 阿西吧li 阅读(417) 评论(0) 推荐(0) 编辑
摘要: MYSQL5.7以上才支持 Enable: UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME = 'wait/lock/metadata/sql/mdl'; Disabl 阅读全文
posted @ 2022-03-22 15:01 阿西吧li 阅读(94) 评论(0) 推荐(0) 编辑
摘要: 今天业务需求需要从ORACLE数据库抽取数据库到MYSQL,自己写了个并发抽取玩一下 service层,对数据进行了切分,每50万一组 @Service public class DemoService { @Autowired private JdbcTemplate jdbcTemplate; 阅读全文
posted @ 2022-03-02 14:04 阿西吧li 阅读(271) 评论(0) 推荐(0) 编辑
摘要: 拼接json,发送给server 钉钉实现告警 #!/bin/bash dbid=1 host_ip='测试' alterFile=/root/error.log alertLineFile=/tmp/alertLine message= if [ ! -f "$alertLineFile" ] | 阅读全文
posted @ 2022-02-17 11:28 阿西吧li 阅读(97) 评论(0) 推荐(0) 编辑
摘要: 数据库版本为:11.2.0.4 当cursor_sharing为SIMILAR或者FORCE时候,将会导致函数索引失效; 表doc_order_header列有LASTSHIPMENTTIME得函数索引; 当时通过v$session视图发现,过滤条件to_char(h.lastshipmenttim 阅读全文
posted @ 2021-12-03 13:30 阿西吧li 阅读(116) 评论(0) 推荐(0) 编辑
摘要: 创建新表时报错: ERROR 1118 (42000): Row size too large (> 4030). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 byte 阅读全文
posted @ 2021-11-10 17:48 阿西吧li 阅读(395) 评论(0) 推荐(0) 编辑
上一页 1 2 3 4 5 6 ··· 12 下一页