Oracle批量建表空间数据文件脚本
一、单机批量创建数据文件1234567891011121314151617181920212223242526272829303132333435363738#!/bin/bashdatetime=$(date +%Y-%m-%d_%H%M)export ORACLE_SID=aidbexport ORACLE_HOME=/u01/app/oracl...
批量修改文件名，批量修改名称，批量修改文件名前缀
12345678910111213141516171819202122232425262728(1) Linux批量改文件名:for txt in *.txt; do mv "$txt" "new_${dir%*/}";donefor txt in `ls Full-*`;...
授权只读访问某个用户下的数据
一、创建角色1create role select_all_qxphis_table;
二、将qxphis用户的表授权给角色12345678910111213141516171819202122232425declare cursor c_tabname is select table_name from dba_tables where owner...
https://www.truenas.com/docs/scale/scaletutorials/shares/smb/https://www.truenas.com/docs/scale/scaletutorials/shares/addingnfsshares/
一、创建用户和组
Credentials—Local Groups—Add
二、添加物理磁盘(esxi)...
查询Oracle等待事件
一、查看当前某个SQL_ID会话情况123456789101112131415set linesize 500set pagesize 500col sid format 9999col spid for a5col serial# format 999999col event format a23col p123 format a15col wait_time...
Oracle查询会话，Oracle批量杀会话，Oracle根据SQL_ID杀会话，Oracle根据SQL_ID杀会话杀进程，按SQL_ID批量杀会话
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646...
调整Linux系统 /home分区和swap分区大小
一、备份数据1234567891011121314151617181920212223# ll /home/admin/总用量 0drwxr-xr-x. 2 admin admin 6 4月 1 14:30 公共drwxr-xr-x. 2 admin admin 6 4月 1 14:30 模板drwxr-xr-x. ...
Oracle批量导入数据，批量创建数据文件脚本
12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758#!/bin/bashdatetime=$(date +%Y-%m-%d_%H%M)export ORACLE_SID=aidb...
一、现象给数据库扩容表空间的时候，遭遇ORA-00059: maximum number of DB_FILES exceeded错误
123456SQL> SQL> create tablespace st_hie_data datafile '/data/oracle/aidb/st_hie_data01.dbf' size 10g autoextend ...
