oracle DECODE

select cd,decode(
cd,
'LCD','11',
'MB','22',
'fff'
)
from cm_code
order by 1

相當於case when

select cd,
case when cd ='LCD' then '11'
when cd ='MB' then '22'
else 'fff'
end as CD2
from cm_code
order by 1

oracle 增加 session

alter system set processes=200 scope=spfile;

BEA-000627 >> Reached maximum capacity of pool "My Connection Pool", making "0" new resource instances instead of "1".

Web console => testPortal> JDBC Connection Pools> My Connection Pool
Configuration => Connections => click Advanced Options [ Show ]

Login Delay: 創建物理連接延遲
Allow Shrinking :允許收縮，當已創建連接不用時，收縮到最初創建的連接數或正在使用的連接數
Shrink Frequency: 收縮時間
Enable Connection Leak Profiling:收集連接洩漏信息
Connection Reserve Timeout: 連接超時保留時間
Connection Creation Retry Frequency: 重新創建數據庫連接頻率
Inactive Connection Timeout: 非活動連接超時時間
Maximum Waiting for Connection: 最大請求連接數
Maximum Connections Made Unavailable:連接池不被應用程序使用最大連接數

2008/1/15 (Testing setting)
Enable Connection Profiling => enable
Shrink Frequency:900 => 300 second
Inactive Connection Timeout: 0 => 100 second

ORA-02264

ORA-02264: name already used by an existing constraint
ORA-06512: at "DS_USER.CMA070M", line 46

EXECUTE IMMEDIATE
'DROP TABLE '||TABLENAME||' cascade constraints';

改成
'DROP TABLE '||TABLENAME||' cascade constraints purge';