Oracle批量替换数据文件路径
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081---set newname for datafi...
Oracle批量重命名数据文件、重命令临时文件
12345678910111213141516171819202122232425262728293031323334353637383940414243Linux:---修改日志文件set linesize 200 pagesize 200 select 'alter database rename file '|| ...
一、Oracle12c 数据库自带的用户名123456789101112131415161718192021222324252627282930313233343536373839404142434445464748---12.1.0.2select username from dba_users where username not in ('SCOTT', ...
检查Oracle索引是否有效
123456789col owner for a10col table_name for a30col index_name for a30col status for a15col tablespace_name for a15set linesize 300 pagesize 300select owner, table_name, tablespace...
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970[oracle@server01:/home/oracle]$crontab -lYou (oracle) are not allo...
Mysql8.0安装Xtrabackup
一、Xtrabackup简介 Innobackupex is the symlink for xtrabackup. innobackupex still supports all features and syntax as 2.2 version did, but is now deprecated and will be ...
在遇到 MySQL 8报错 “error while loading shared libraries: libcrypto.so.3” 时，通常是因为系统找不到所需的 libcrypto.so.3 库文件，libcrypto.so.3 是 OpenSSL 3.0 中的一个库文件，MySQL 8.x 版本和一些 MariaDB 版本可能依赖这个库。
一、错误提示12[root@serve...
查看Mysql数据库占用空间大小
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576---统计各个数据库数据总量SELECT table_sche...
查询Oracle在线会话
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061set linesize 500set pagesize 500col sid for 9999999col spid for a5col...
linux find命令
1.查找3天前的文件并删除12345find . -name "*.bak" -mtime +3 |xargs rm -rffind . -name "*.bak" -mtime +3 -exec rm -rf {} \;查找3天内的文件并删除:find . -name "*.bak"...
