listen_addresses = '*'然后重启生效

我认为AI的发展对DBA利大于弊，dba可以利用ai的功能，更高效快捷的查询命令、写脚本、知识问答等，减少dba查资料的时间。

mycat版本报错日志2022-03-29 11:01:27.492 INFO [$_NIOREACTOR-10-RW] (io.mycat.net.handler.FrontendAuthenticator.success(FrontendAuthenticator.java:226)) - [thread=$_NIOREACTOR-10-RW,class=ManagerConnection,i

AnyConnect VPN 客户端

主库：备库：standby_file_management=‘AUTO’为什么会这样

oracle 字符集SIMPLIFIED CHINESE_CHINA.AL32UTF8 支持保存emoji表情吗

awr报告call dbms_space.auto_space_advisor_job_proc ( );create table “A_UBO”.DBMS_TABCOMP_TEMP_UNCMP tablespace “A_BO_TAB” nologging as select /*+ FULL(“A_UBO”.“FILES_APPLE”) */ * from “A_UBO”.“FILES_APP

10:17:10 UTC - mysqld got signal 11 ;Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware.Thread pointer: 0x7f99fc0a45c0Attempting backtrace. You can use the f

本地自建 mysql 8 版本修改隔离级别show global variables like ‘%iso%’;set global transaction isolation level read committed;为什么过段时间会变成REPEATABLE-READ，很奇怪

日志内容

delivery_time和start_warehouse和do_id都有单独的索引执行计划如图

看后台发现console-kit-daemon进程占很多虚拟内存

oracle 10.2.0.5.0 shrink 表后，alert 日志出现WARNING: received KRVX_OPER_CANNOT_SUPPORTKDOG Missing from redoknlldmm: gdbnm=TMSDBknlldmm: objn=54111knlldmm: objv=0knlldmm: scn=186393213165knlldmm: opnum=255

v

*** 2021-03-01 15:27:20.724Process diagnostic dump for ORACLE.EXE (ARC0), OS id=6708,pid: 39, proc_ser: 17, sid: 673, sess_ser: 203current sql: Current Wait Stack:0: waiting for ‘rdbms ipc message’tim

这是oracle 查询语句，查出来需要200s，返回行数100，表都不到100w，不加sum很快，加了sum很慢，sql如下：select sum(qty) tag_qty, rc_idfrom (select ser_id,func_get_pdr_count(service_tag, dispatch_time) as qty,rc_idfrom (select s.ser_id,p.rc_i