Configure for NLOG
摘要：for detail async configure, queueLimit - Limit on the number of requests in the lazy writer thread request queue. Integer Defaul...
阅读全文
posted @
2013-12-06 15:40
子虚乌有
阅读(494)
推荐(0) 编辑
Add new datafile or tempfile to space
摘要：ALTER DATABASE TEMPFILE 'D:\DATA\ORACLE\xxx_HOME\ORADATA\MIG_TEMP01.DBF' OFFLINE; select file#,status,name from v$tempfile; select file#,status,name from v$datafile; alter tablespace MIG_TEMP drop ...
阅读全文
posted @
2013-12-04 10:56
子虚乌有
阅读(342)
推荐(0) 编辑
select columns to string
摘要：set serveroutput on DECLARE l_next_id integer; l_total integer; l_dml varchar2(1000); l_string varchar2(2000); l_column varchar2(100); begin l_string :=''; select count(1) into l_total from all_...
阅读全文
posted @
2013-12-02 14:47
子虚乌有
阅读(323)
推荐(0) 编辑
