AI 助理
备案控制台
开发者社区 开发与运维 文章 正文

数据库运维相关脚本(持续交作业)

2022-03-08 235
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介： 数据库运维相关脚本(持续交作业)

数据库运维相关脚本

1、采用shell脚本调用SQLPLUS执行SQL语句

#!/bin/bash

TAB=emp

sqlplus -s scott/tiger <<EOF | awk 'NR != 1 && $2 ~ /S.*T/{print $2,$6}'

set head off

set feed off

select * from $TAB;

select * from dept;

exit;

EOF


2、批量禁用/启用触发器

SELECT 'alter trigger ' || TRIGGER_NAME || ' enable;' FROM USER_TRIGGERS;

SELECT 'alter trigger ' || TRIGGER_NAME || ' disable;' FROM USER_TRIGGERS;


3、查询索引占碎片比例

selectname,del_lf_rows,lf_rows,

round(del_lf_rows/decode(lf_rows,0,1,lf_rows)*100,0)||'%' frag_pct

from index_stats

where round(del_lf_rows/decode(lf_rows,0,1,lf_rows)*100,0)>30


4、根据 sid 查 spid 或根据 spid 查 sid

selects.sid,s.serial#,s.LOGON_TIME,s.machine,p.spid,p.terminal

from v$session s,v$process p

where  s.paddr=p.addr and s.sid=SS or p.spid=BB

根据 sid 查sql 语句

selectusername,sql_text,machine,osuser from v$session a,v$sqltext_with_newlinesb  

where DECODE(a.sql_hash_value, 0, prev_hash_value, sql_hash_value)=b.hash_value

and a.sid=&sid order by piece


5、查询会话和进程消耗的平均内存大小

selectround(sum(pga_used_mem)/1024/1024,0) total_used_M,

round(sum(pga_used_mem)/count(1)/1024/1024,0) avg_used_M,

round(sum(pga_alloc_mem)/1024/1024,0) total_alloc_M,

round(sum(pga_alloc_mem)/count(1)/1024/1024,0) avg_alloc_M

from v$process


6、高CPU占用查询


select*from (select CPU_TIME/1000000,username,PARSING_USER_ID,sql_id,ELAPSED_TIME/1000000,sql_text    

from v$sql,dba_users

where user_id=PARSING_USER_ID

order by CPU_TIME/1000000 desc)where rownum <=3


7、一个巡检脚本

#!/bin/bashmkdir-p /home/oracle/script 
read -p"Enter Instance Name: " Name
logfile=/home/oracle/script/db_log.log
echo" ###### 2.1 Section #######" > $logfileexportORACLE_SID=$Name$ORACLE_HOME/bin/sqlplus -S / as sysdba >>$logfile <<END
set heading off
set feedback off;
set pagesize 0;
set linesize 120;
set trimout on;
set trimspool on;
set verify off;
select 'database_name: '||value from v\$parameter where name='db_name';
select 'instance_name: '||value from gv\$parameter where name='instance_name';
select 'RDBMS Relase: '||version  from product_component_version where product like 'Oracle Database%';
select 'All Datafiles Total Size: '||round(sum(total_size)/1024/1024/1024,2)||'GB' from (
select sum(bytes) total_size from dba_data_files
union all
select sum(bytes) total_size from dba_temp_files
);
select  'SGA_MAX_SIZE: '||value from v\$parameter where name='sga_max_size';
select 'SGA_TARGET: '||value from v\$parameter where name='sga_target';
select 'BLOCK_SIZE: '||value from v\$parameter where name='db_block_size';
select 'TABLESPACE TOTAL: '||count(*) from dba_tablespaces;
select 'DataFiles: '||count(*) from dba_data_files;
select 'Controlfiles: '||count(*) from v\$controlfile;
select 'Every RedoLog Size: '||bytes/1024/1024||'MB' from v\$log where rownum=1;
select 'Every RedoLog Group has Members: '||members from v\$log where rownum=1;
select 'Archive Mode: '||log_mode from v\$database;
select 'Max Process(History): '||max_utilization from v\$resource_limit where resource_name='processes';
exit;
END
echo"######## 5 Section ########" >>$logfile#echo -n "Enter All HostNames In RAC: "#read HostNamegridpath=`ps -ef|grep crsd.bin|grep -v grep|awk '{print $8}'`for i in`${gridpath%/*}/olsnodes`doecho$i >>$logfilessh$i df -h >>$logfileecho"" >>$logfileecho$i >>$logfilessh$icat /etc/sysctl.conf|grep -v ^#|grep -v grep|sort|uniq>>$logfileecho$i >>$logfileecho"HugePage Set " >>$logfilessh$igrep-i hugepage /proc/meminfo >>$logfileecho"#### 3.1 ######" >>$logfileecho$i >>$logfileecho"Local Disk Size" >>$logfilessh$i df -h|sed '1d'|awk 'sub("G","",$2){total+=$2}END{print total"G"}' >>$logfileecho$i >>$logfileecho"Network Card " >>$logfilessh$i ethtool eth0|grep Speed >>$logfileecho$i >>$logfileecho"Phyical Memory Total" >>$logfilessh$igrep MemTotal /proc/meminfo >>$logfileecho"" >>$logfileecho" Physical CPUS" >>$logfilessh$icat /proc/cpuinfo |grep "physical id"|uniq|wc -l >>$logfileecho"#### 3.1 over #####" >>$logfileecho$i >>$logfileecho"Vmstat stat " >>$logfilessh$i vmstat 210 >>$logfileecho"" >>$logfileecho$i >>$logfileecho"ifconfig stat" >>$logfilessh$i /sbin/ifconfig >>$logfiledoneecho"" >>$logfileecho"######### 6.2 Section #########" >>$logfileecho"Oracle user vairal" >>$logfilecat /home/oracle/.bash_profile >>$logfileecho"" >>$logfileecho"######### 6.3 Section #########" >>$logfileecho"Oracle Patch " >>$logfile$ORACLE_HOME/OPatch/opatch lspatches >>$logfileecho"######### 6.4 Section #########" >>$logfileecho${gridpath%/*} >>$logfilecd${gridpath%/*} >>$logfileecho"olsnodes stats" >>$logfile./olsnodes >>$logfileecho"ocrcheck stats" >>$logfile./ocrcheck >>$logfileecho"ocrconfig -showbackup stats" >>$logfile./ocrconfig -showbackup >>$logfileecho"crsctl check crs stats" >>$logfile./crsctl check crs >>$logfileecho"crsctl stat res -t " >>$logfile./crsctl stat res -t >>$logfileecho"crsctl stat res -t -init ">>$logfile./crsctl stat res -t-init >>$logfileecho"crsctl query css votedisk " >>$logfile./crsctl query css votedisk >>$logfileecho"oifcfg getif ">>$logfile./oifcfg getif >>$logfileecho"######## 6.7 Section ###########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120set pagesize 0col parameter for a40
col value for a10
prompt "Oracle install Options"select * from v\$option;
exit;
EOF
echo"######### 6.8 Section #########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 200set pagesize 0col name for a40
col value for a80
select inst_id,name,value from gv\$parameter where isdefault='FALSE';
prompt "######## 6.9 Section #######"select value$ from props\$ where name='NLS_CHARACTERSET';
exit;
EOF
echo"######### 6.13 Section ########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120col name for a60
select name,status from v\$controlfile;
exit;
EOF
echo"########## 6.14 Section ########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120select group#,thread#,sequence#,bytes/1024/1024,members,archived,status from v\$log;prompt "####### 6.15 #### redo switch frequency"set linesize 200col Day for a5
col H00 FOR '999'COL H01 FOR '999'COL H02 FOR '999'col H03 FOR '999'COL H04 FOR '999'COL H05 FOR '999'col H06 FOR '999'COL H07 FOR '999'COL H08 FOR '999'COL H09 FOR '999'COL H10 FOR '999'col H11 FOR '999'COL H12 FOR '999'COL H13 FOR '999'col H14 FOR '999'COL H15 FOR '999'COL H16 FOR '999'COL H17 FOR '999'COL H18 FOR '999'col H19 FOR '999'COL H20 FOR '999'COL H21 FOR '999'col H22 FOR '999'COL H23 FOR '999'SELECT SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) Day,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'00',1,0)) H00,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'01',1,0)) H01, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'02',1,0)) H02,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'03',1,0)) H03,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'04',1,0)) H04,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'05',1,0)) H05,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'06',1,0)) H06,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'07',1,0)) H07,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'08',1,0)) H08,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'09',1,0)) H09,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'10',1,0)) H10,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'11',1,0)) H11, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'12',1,0)) H12,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'13',1,0)) H13, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'14',1,0)) H14,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'15',1,0)) H15, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'16',1,0)) H16, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'17',1,0)) H17, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'18',1,0)) H18, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'19',1,0)) H19, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'20',1,0)) H20, 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'21',1,0)) H21,
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'22',1,0)) H22 , 
      SUM(DECODE(SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH24:MI:SS'),10,2),'23',1,0)) H23, 
      COUNT(*) TOTAL 
FROM v\$log_history  a
  where first_time>=to_char(sysdate-11)
GROUP BY SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) 
ORDER BY SUBSTR(TO_CHAR(first_time, 'MM/DD/RR HH:MI:SS'),1,5) DESC;
exit;
EOF
echo"########### 6.16 Section #########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 120col name for a40
col value for a40
show parameter db_recovery;
select inst_id,name,value from gv\$parameter where name like '%archive%' order by 1;
exit;
EOF
echo"########### 6.17 Section ###########" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 150col tablespace_name for a20
col file_name for a60
set pagesize 0select tablespace_name,file_name,bytes/1024/1024,status,autoextensible from dba_data_files;
exit;
EOF
echo"########## 6.18 Section ############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 200col tablespace_name for a20
set pagesize 0select tablespace_name,block_size,initial_extent,next_extent,status,contents,force_logging,extent_management,allocation_type,SEGMENT_SPACE_MANAGEMENT,BIGFILE,COMPRESS_FOR from dba_tablespaces;
prompt "####### tablespace_used % #######"SELECT total.tablespace_name,
      Round(total.MB, 2)          AS Total_MB,
      Round(total.MB - free.MB, 2) AS Used_MB,
      Round(( 1- free.MB / total.MB ) * 100, 2)
      || '%'                      AS Used_Pct
FROM  (SELECT tablespace_name,
              Sum(bytes) / 1024 / 1024 AS MB
        FROM  dba_free_space
        GROUP  BY tablespace_name) free,
      (SELECT tablespace_name,
              Sum(bytes) / 1024 / 1024 AS MB
        FROM  dba_data_files
        GROUP  BY tablespace_name) total
WHERE  free.tablespace_name = total.tablespace_name;
prompt "######6.19 Temporary Tablespace Usage % ######"SET PAGESIZE 60SET LINESIZE 100col tablespace_name for a20 
SELECT 
  A.tablespace_name tablespace, 
  D.mb_total,
  SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_used,
  D.mb_total - SUM (A.used_blocks * D.block_size) / 1024 / 1024 mb_free
FROM 
  v\$sort_segment A,
(
SELECT 
  B.name, 
  C.block_size, 
  SUM (C.bytes) / 1024 / 1024 mb_total
FROM 
  v\$tablespace B, 
  v\$tempfile C
WHERE 
  B.ts#= C.ts#GROUP BY 
  B.name, 
  C.block_size
) D
WHERE 
  A.tablespace_name = D.name
GROUP by 
  A.tablespace_name, 
  D.mb_total
/
prompt "######### 6.20 Section ###########"col segment_name for a30
set linesize 100set pagesize 0set heading on
select status,sum(bytes)/1024/1024 from dba_undo_extents group by status;
exit;
EOF
echo"######### 7 Section #############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileprompt "Use default password "col username for a20
set linesize 100select username from dba_users_with_defpwd where username in ('SYS','SYSTEM');
prompt "granted sysdba role "select username,sysdba from v\$pwfile_users;
PROMPT "GRANTED DBA ROLE "col grantee for a20
col granted_role for a20
select grantee,granted_role from dba_role_privs where granted_role='DBA';
prompt "password management "set linesize 200col profile for a20
col RESOURCE_NAME for a30
col limit for a15
select profile,resource_name,limit from dba_profiles where resource_name='PASSWORD_VERIFY_FUNCTION';
exit;
EOF
echo"######### 9.6 Section #############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfileset linesize 200set pagesize 0col resource_name for a30
col INITIAL_ALLOCATION for a20
col LIMIT_VALUE for a20
select * from v\$resource_limit;
exit;
EOF
echo"######## 10.1 Section ############" >>$logfilesqlplus -S / as sysdba <<EOF >>$logfilecol segment_name for a30
set linesize 150col owner for a20
set pagesize 0select owner,segment_name,sum(bytes)/1024 from dba_segments 
where (segment_name like '%TMP%'  or segment_name like '%HIS%'  or segment_name like '%BAK%'  or segment_name like '%TEST%'  or segment_name like '%201%'  or segment_name like 'BIN%')
  and owner not in ('SYS','SYSTEM','SYSMAN','APEX_030200','MGMT_VIEW','DBSNMP')
  and segment_type like 'TABLE%'group by owner,segment_name;
prompt "######## 10.2 ###### Redundant index"column redundant_index format a45
column sufficient_index format a45
select
  o1.name||'.'||n1.name  redundant_index,
  o2.name||'.'||n2.name  sufficient_index
from
  sys.icol\$  ic1,
  sys.icol\$  ic2,
  sys.ind\$  i1,
  sys.obj\$  n1,
  sys.obj\$  n2,
  sys.user\$  o1,
  sys.user\$  o2
where
  ic1.pos# = 1 and  ic2.bo# = ic1.bo# and  ic2.obj# != ic1.obj# and  ic2.pos# = 1 and  ic2.intcol# = ic1.intcol# and  i1.obj# = ic1.obj# and  bitand(i1.property, 1) =0 and
  ( select
      max(pos#) * (max(pos#) + 1) / 2    from
      sys.icol\$
    where
      obj# = ic1.obj#  ) =  ( select
      sum(xc1.pos#)    from
      sys.icol\$ xc1,
      sys.icol\$ xc2
    where
      xc1.obj# = ic1.obj# and      xc2.obj# = ic2.obj# and      xc1.pos# = xc2.pos# and      xc1.intcol# = xc2.intcol#  ) and
  n1.obj# = ic1.obj# and  n2.obj# = ic2.obj# and  o1.user# = n1.owner# and  o2.user# = n2.owner#  and o1.name not in ('SYS','SYSTEM','APEX_030200','SYSMAN','MDSYS','ORDDATA','XDB')
/
PROMPT "####### 10.3 ####### Invalid object "col object_name for a30
set linesize 120col owner for a15
col object_type for a30
set pagesize 0select owner,object_name ,object_type from dba_objects where status='INVALID';
prompt "######### 10.4 ########UNUSABLE INDEX"select owner,index_name from dba_indexes where status='UNUSABLE';
prompt "######### 10.5 ###########Order by sql "set pagesize 0select sql_id from v\$sqlarea where sql_text like '%order by %';
prompt "######### 10.6 ###########No bound variables are used for SQL"set numw 20select FORCE_MATCHING_SIGNATURE, count(1)
  from v\$sql
where FORCE_MATCHING_SIGNATURE > 0  and FORCE_MATCHING_SIGNATURE != EXACT_MATCHING_SIGNATURE
group by FORCE_MATCHING_SIGNATURE
having count(1) > 100order by 2;
prompt "####### 10.7 ####### In SYSTEM/SYSAUX tablespace "col segment_name for a30
set linesize 200col owner for a20
select owner,segment_name,segment_type,tablespace_name from dba_segments
where tablespace_name in ('SYSTEM','SYSAUX')
and owner not in ('SYS','SYSTEM','OUTLN','APEX_030200','SYSMAN','MDSYS','OLAPSYS','ORDDATA','ORDSYS','EXFSYS','XDB','CTXSYS','EXFSYS','WMSYS','DBSNMP');
prompt "######## 10.7 #####Table Fragment"col table_name for a30
select table_name,round(BLOCKS*8192/1024/1024,2) total_size_MB,
round(num_rows*AVG_ROW_LEN/1024/1024,2) used_size_MB,
round(((BLOCKS*8192/1024/1024)-(num_rows*AVG_ROW_LEN/1024/1024)),2)  wasted_size_MB,
round(round(((BLOCKS*8192/1024/1024)-(num_rows*AVG_ROW_LEN/1024/1024)),2)/
round(BLOCKS*8192/1024/1024,2),2)*100||'%' wasted_percent
from dba_tables where owner not in ('SYS','SYSTEM','OUTLN')
and round(BLOCKS*8192/1024/1024,2) <>0
and round(((BLOCKS*8192/1024/1024)-(num_rows*AVG_ROW_LEN/1024/1024)),2)>100
order by 2;
PROMPT "##### 10.9 ###### TABLESPACE FRAGMENT "set linesize 150        column tablespace_name format a20 heading 'Tablespace'    column sumb format 999,999,999
    column extents format 9999    column bytes format 999,999,999,999
    column largest format 999,999,999,999
    column Tot_Size format 999,999 Heading 'Total| Size(Mb)'    column Tot_Free format 999,999,999 heading 'Total Free(MB)'    column Pct_Free format 999.99 heading '% Free'    column Chunks_Free format 9999 heading 'No Of Ext.'    column Max_Free format 999,999,999 heading 'Max Free(Kb)'setecho off
    PROMPT  FREE SPACE AVAILABLE IN TABLESPACES
    select a.tablespace_name,sum(a.tots/1048576) Tot_Size,
    sum(a.sumb/1048576) Tot_Free,
    sum(a.sumb)*100/sum(a.tots) Pct_Free,
    sum(a.largest/1024) Max_Free,sum(a.chunks) Chunks_Free
    from
    (
    select tablespace_name,0 tots,sum(bytes) sumb,
    max(bytes) largest,count(*) chunks
    from dba_free_space a
    group by tablespace_name
    union
    select tablespace_name,sum(bytes) tots,0,0,0 from
      dba_data_files
    group by tablespace_name) a
    group by a.tablespace_name
order by pct_free;
prompt "######### 10.10 parallel object #######"set pagesize 0col owner for a15
col index_name for a30
col table_name for a30
prompt "parallel tables"select owner,table_name,degree  from dba_indexes where ltrim(degree)>'1' order by 1;
prompt "parallel index"select owner,index_name,degree from dba_indexes where ltrim(degree)>'1' order by 1;
exit;
EOF
文章标签：
Perl
Shell
SQL
索引
运维
数据库
关键词：
运维数据库
数据库运维
数据库脚本
运维脚本
运维作业
1285620146464872
目录
相关文章
Echo_Wish
|
1月前
|
存储 人工智能 运维
别再靠脚本“救火”了！让智能数据治理接管你的运维世界
别再靠脚本“救火”了！让智能数据治理接管你的运维世界
Echo_Wish
194 14
阿里云开发者
|
4月前
|
运维 监控 关系型数据库
AI 时代的 MySQL 数据库运维解决方案
本文探讨了大模型与MySQL数据库运维结合所带来的变革，介绍了构建结构化运维知识库、选择合适的大模型、设计Prompt调用策略、开发MCP Server以及建立监控优化闭环等关键步骤。通过将自然语言处理能力与数据库运维相结合，实现了故障智能诊断、SQL自动优化等功能，显著提升了MySQL运维效率和准确性。
阿里云开发者
454 18
Echo_Wish
|
4月前
|
机器学习/深度学习 消息中间件 人工智能
别只会写脚本了！看看机器学习是怎么帮运维“摸鱼”的
别只会写脚本了！看看机器学习是怎么帮运维“摸鱼”的
Echo_Wish
126 13
大数据文摘
|
5月前
|
人工智能 运维 关系型数据库
数据库运维：mysql 数据库迁移方法-mysqldump
本文介绍了MySQL数据库迁移的方法与技巧，重点探讨了数据量大小对迁移方式的影响。对于10GB以下的小型数据库，推荐使用mysqldump进行逻辑导出和source导入；10GB以上可考虑mydumper与myloader工具；100GB以上则建议物理迁移。文中还提供了统计数据库及表空间大小的SQL语句，并讲解了如何使用mysqldump导出存储过程、函数和数据结构。通过结合实际应用场景选择合适的工具与方法，可实现高效的数据迁移。
大数据文摘
1015 1
游客6kyzki537plg4
|
7月前
|
运维 监控 数据可视化
一文拆解 YashanDB Cloud Manager，数据库运维原来还能这么“智能”！
传统数据库运维依赖人工，耗时耗力还易出错。YashanDB Cloud Manager（YCM）作为“智能运维管家”，实现主动、智能、可视化的运维体验。它提供实时资源监控、智能告警系统、自动巡检机制、高可用架构支持和强大的权限管理功能，帮助用户统一管理多实例与集群，减少人工干预，构建现代化数据库运维体系，让企业高效又安心地运行数据库服务。
游客6kyzki537plg4
231 20
阿里云瑶池数据库_
|
7月前
|
人工智能 运维 关系型数据库
现已开源｜阿里云RDS发布MCP Server能力，解锁数据库“对话即运维”新体验
RDS MCP Server：数据库运维的“智能管家”
阿里云瑶池数据库_
1210 2
哈你真皮
|
7月前
|
前端开发 数据库
会议室管理系统源码（含数据库脚本）
会议室管理系统源码（含数据库脚本）
哈你真皮
127 0
Echo_Wish
|
4月前
|
机器学习/深度学习 SQL 运维
数据库出问题还靠猜？教你一招用机器学习优化运维，稳得一批！
数据库出问题还靠猜？教你一招用机器学习优化运维，稳得一批！
Echo_Wish
161 4
mysia
|
5月前
|
运维 监控 关系型数据库
AI 时代的 MySQL 数据库运维解决方案
本方案将大模型与MySQL运维深度融合，构建智能诊断、SQL优化与知识更新的自动化系统。通过知识库建设、大模型调用策略、MCP Server开发及监控闭环设计，全面提升数据库运维效率与准确性，实现从人工经验到智能决策的跃迁。
mysia
687 27
学习数据库的小张
|
3月前
|
运维 NoSQL 容灾
告别运维噩梦：手把手教你将自建 MongoDB 平滑迁移至云数据库
程序员为何逃离自建MongoDB？扩容困难、运维复杂、高可用性差成痛点。阿里云MongoDB提供分钟级扩容、自动诊断与高可用保障，助力企业高效运维、降本增效，实现数据库“无感运维”。
学习数据库的小张
227 0

热门文章

最新文章

  • 1
    除了JDBC，还有哪些常见的数据库访问技术？
  • 2
    AI运维不再是玄学：教你用AI提前预测系统故障，少熬几次夜！
  • 3
    云栖大会｜AI时代关系型数据库创新突破：软硬协同赋能企业数智化转型
  • 4
    云栖大会｜AI时代的数据库变革升级与实践：Data+AI驱动企业智能新范式
  • 5
    阿里云RDS云数据库全解析：产品功能、收费标准与活动参考
  • 6
    AI大模型应用实践 八：如何通过RAG数据库实现大模型的私有化定制与优化
  • 7
    云栖重磅｜瑶池数据库：从云原生数据底座向“AI就绪”的多模态数据底座演进
  • 8
    通义灵码产品演示： 数据库设计与数据分析
  • 9
    云栖大会｜AI浪潮下的NoSQL演进：下一代数据库的破局之道
  • 10
    Python SQLAlchemy模块：从入门到实战的数据库操作指南
  • 1
    AI运维不再是玄学：教你用AI提前预测系统故障，少熬几次夜！
    199
  • 2
    别再熬夜救火了！自动化运维正在重塑企业IT管理的底层逻辑
    125
  • 3
    别再靠“拍脑袋”修系统了——聊聊大数据如何让运维更聪明
    117
  • 4
    别再靠“救火”过日子了：智能运维，正在重塑IT服务的未来
    253
  • 5
    AI来了，运维不慌：教你用人工智能把团队管理提速三倍！
    275
  • 6
    别让运维只会“救火”——用数据点燃业务增长的引擎
    125
  • 7
    别再“亡羊补牢”了！——聊聊如何优化企业的IT运维监控架构
    102
  • 8
    别再靠脚本“救火”了！让智能数据治理接管你的运维世界
    194
  • 9
    当AI遇上自动化：运维测试终于不“加班”了
    326
  • 10
    拔俗AI巡检系统：让设备“会说话”，让隐患“早发现”，打造更安全高效的智能运维
    256

    • 相关课程

    更多
  • 企业运维之弹性计算原理与实践
  • 企业运维之云上网络原理与实践课程
  • 企业级运维之云原生与Kubernetes实战课程
  • 面向运维的 python 脚本速成-1024程序员节创造营公益课
  • Linux企业运维实战 - 入门及常用命令
  • 玩转云上智能运维

    • 相关电子书

    更多
  • 企业运维之云原生和Kubernetes 实战
  • 可视化架构运维实践
  • 2021云上架构与运维峰会演讲合集
    • 下一篇
    oss云网关配置