阿西吧li

摘要： APPLIES TO: Oracle Database Cloud Service - Version N/A and laterOracle Database - Enterprise Edition - Version 11.2.0.4 and laterOracle Database Clou 阅读全文

摘要： APPLIES TO: Oracle Hospitality OPERA 5 Property Services - Version 5.4.0 and laterInformation in this document applies to any platform. GOAL The docum 阅读全文

摘要： Document Display Give Feedback... Search: ORA-20001:sTATISTIC aDVISOR Restore Pane Copyright (c) 2022, Oracle. All rights reserved. Oracle Confidentia 阅读全文

摘要： mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLESPACES WHERE SPACE = 26\G *************************** 1. row *************************** SPACE 阅读全文

摘要： MYSQL5.7以上才支持 Enable: UPDATE performance_schema.setup_instruments SET ENABLED = 'YES', TIMED = 'YES' WHERE NAME = 'wait/lock/metadata/sql/mdl'; Disabl 阅读全文

摘要： 今天业务需求需要从ORACLE数据库抽取数据库到MYSQL，自己写了个并发抽取玩一下 service层，对数据进行了切分，每50万一组 @Service public class DemoService { @Autowired private JdbcTemplate jdbcTemplate; 阅读全文

摘要： 拼接json，发送给server 钉钉实现告警 #!/bin/bash dbid=1 host_ip='测试' alterFile=/root/error.log alertLineFile=/tmp/alertLine message= if [ ! -f "$alertLineFile" ] | 阅读全文

摘要： 数据库版本为:11.2.0.4 当cursor_sharing为SIMILAR或者FORCE时候，将会导致函数索引失效； 表doc_order_header列有LASTSHIPMENTTIME得函数索引； 当时通过v$session视图发现，过滤条件to_char(h.lastshipmenttim 阅读全文

摘要： 创建新表时报错： 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 阅读全文

摘要： 执行5分钟还没执行完； explain update ind_shop t1 join (select shop_id,(case when `value`='男装' then 1 when `value`='女装' then 2 when `value`='男女装' then 3 else 0 e 阅读全文