1.配置测试环境创建数据表空间createtablespacetestloggingdatafile'/home/oracle/test.dbf'size10mautoextendonnext10mmaxsize2048mextentmanagementlocal;创建用户并指定表空间createusertestidentifiedby123456defaulttablespace
参考文档:https://docs.oracle.com/en/database/oracle/oracle-database/12.2/cwlin/index.htmlhttps://docs.oracle.com/en/database/oracle/oracle-database/12.2/ladbi/index.htmlhttps://oracle-base.com/articles/li
1. 查看所有表空间大小SQL> select tablespace_name,sum(bytes)/1024/1024 from dba_data_files group by tablespace_name;2. 已经空闲的表空间大小SQL> select tablespace_name,sum(bytes)/1024/1024 from dba_free_space group
ASM删除archivelog查询当前归档路径$export oracle_sid=his1$sqlplus / nologSQL>archive log list;asmcmd命令行删除指定archivelog$export oracle_sid=+ASM1$asmcmdasmcmd>cd +FBR/HIS1/ARCHIVELOGasmcmd>rm -fr 2016_01*从R
oracle 11G windows 2008系统 造成了监听死锁 报TNS-00505: 操作超时最后分析 发现 LISTENER.LOG日志大小超过2GB解决方案:cd$ORACLE_HOME/network/loglsnrctlset log_status offmvlistener.log listener.baklsnrctlset log_status on&n
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号