创建并设置新的undo表空间
create undo tablespace undotbs02datafile '/home/oradata/mydb/undotbs201.dbf' size 1500M reuse AUTOEXTEND ON;
alter system set undo_tablespace=undotbs02;
select usn,xacts,status,rssize/1024/1024/1024,hwmsize/1024/1024/1024,shrinks from v$rollstat order by rssize;
删除原UNDO表空间
alter tablespace undotbs01 offline
drop tablespace undotbs1 including contents and datafiles;
表空间增加数据文件方法
ALTER TABLESPACE undotbs02 ADD DATAFILE '/home/oradata/mydb/undotbs202.dbf'...
浏览器控制台报404错误，有些人建议屏蔽Disabling Source Mapping，这个并不解决真正的问题。
需要分析问题核心：报错是因为浏览器对于压缩文件，要查找原始文件行号，需要提供未压缩的原始文件，这个压缩文件的位置放在了压缩文件的结尾。
强迫症不想看到报错可以打开对应的去掉.map的文件css或者js文件，删除结尾的sourceMappingURL，不提供map文件就可以了。
例如，删除文件结尾的 /*# sourceMappingURL=bootstrap.css.map */ 或者找到原始包下载这个.map文件，但原文件一般很大，不建议放置。
查询11g表空间使用率：
12345678910111213141516171819202122232425262728293031
set linesize 200 pagesize 999 col tablespace_name for a30 col file_name for a65 select name inst_name, b.tablespace_name , ROUND(b.total/1024/1024/1024 ,4) total_GB , ROUND(b.maxtotal/1024/1024/1024,4) maxtotal_GB, ROUND(a.free/1024/1024/1024,4) free_GB, ROUND(...
都是垃圾采集就别整那么多活，从百度和bing的搜索结果中屏蔽csdn
adblock->选项->自定义->编辑，输入如下内容，保存，从此清爽了。
1234
www.baidu.com#?#:-abp-has(> .t a:-abp-contains(CSDN))www.baidu.com#?#:-abp-has(> .t ~ div a:-abp-contains(CSDN))cn.bing.com#?#:-abp-has(> .b_title a:-abp-contains(CSDN))cn.bing.com#?#:-abp-has(> .b_title ~ div a:-abp-contains(CSDN))
123456789101112131415
create or replace trigger logon_ip_controlAFTER logon on databasedeclare ip STRING(30); prod_owner STRING(30);BEGIN SELECT SYS_CONTEXT('USERENV','SESSION_USER') into prod_owner from dual; SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') into ip from dual; if prod_owner='PROD_C' or prod_owner='PROD_S' ...
1234567891011121314151617181920212223242526272829303132
drop trigger BLOCK_TOOLS_LOGON; CREATE OR REPLACE TRIGGER BLOCK_TOOLS_LOGON AFTER LOGON ON DATABASEDECLARE my_forced_exception EXCEPTION; PRAGMA EXCEPTION_INIT(MY_FORCED_EXCEPTION, -20101);BEGIN IF (sys_context('USERENV', 'SESSION_USER') IN ('TRY_LOGON_BY_TOOLS')) -- add your username here THEN &n...
123456789101112131415161718192021222324252627282930313233343536373839404142
set verify offcol value format a20column file_name format a50 word_wrappedcolumn smallest format 999,990 heading "Smallest|Size|Poss."column currsize format 999,990 heading "Current|Size"column savings format 999,990 heading "Poss.|Savings"break on reportcompute sum of savings on report column value new_val blksizeselect value from v$parameter where name ...
@echo off
reg add HKLM\SOFTWARE\Policies\Google\Chrome\ /v RendererCodeIntegrityEnabled /t REG_DWORD /d 0
Recovery Writer (RVWR) is stuck until more space
is available in the recovery area.
Unable to write Flashback database log data because the
recovery area is full, presence of a guaranteed
restore point and no reusable flashback logs.
1. 查看闪回日志目录
1
show parameter recover
2. 查看闪回目录的使用状态
1
select * from v$flash_recovery_area_usage;
...
racle 出现未释放锁 查询出 sid 与 serial 杀死进程事务 1185
123
SELECT T2.USERNAME,T2.SID,T2.SERIAL#,T2.LOGON_TIMEFROM V$LOCKED_OBJECT T1,V$SESSION T2WHERE T1.SESSION_ID=T2.SID ORDER BY T2.LOGON_TIME
根据 sid 查询出sql sql 不重要 这步可跳过
123
SELECT SQL_TEXT FROM V$SESSION A,V$SQLTEXT_WITH_NEWLINES BWHERE DECODE(A.SQL_HASH_VALUE, 0, PREV_HASH_VALUE, SQ...
