가자

JSP 요청이 믾고 잣으며 상주 시간은 요청을 하는 순간 뿐이며 세션을 사용하지 않는 상황

JAVA_OPTS="-XX:-UseAdaptiveSizePolicy -XX:NewSize=1g -XX:MaxNewSize=1g -XX:SurvivorRatio=4 -XX:TargetSurvivorRatio=90 -XX:MaxTenuringThreshold=64"

초기 구동 상태 (메모리 크기 참고)

http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/controlstatements.htm#LNPLS004

• Conditional selection statements, which run different statements for different data values.

  The conditional selection statements are IF and and CASE.

• Loop statements, which run the same statements with a series of different data values.

  The loop statements are the basic LOOP, FOR LOOP, and WHILE LOOP.

  The EXIT statement transfers control to the end of a loop. The CONTINUE statement exits the current iteration of a loop and transfers control to the next iteration. Both EXIT and CONTINUE have an optional WHEN clause, where you can specify a condition.

• Sequential control statements, which are not crucial to PL/SQL programming.

  The sequential control statements are GOTO, which goes to a specified statement, and NULL, which does nothing.

-- TEST NUMBERING SEQUENCE

create sequence SEQ_TEST_STBID start with 1 increment by 1;

drop sequence SEQ_TEST_STBID;

select SEQ_TEST_STBID.nextval from dual;

select SEQ_TEST_STBID.currval from dual;

-- stbid, charid

select '{ABC'||to_char(SEQ_TEST_STBID.currval ,'FM09999')||'-BBBB-11E2-B616-5D7CAF36E0E5}' from dual;

-- pid

select to_char(SEQ_TEST_STBID.nextval + 30000) from dual;

-- ClientID

select '111222333-'||to_char(SEQ_TEST_STBID.currval, 'FM09999') from dual;

-- Readable_ClientID

select '01999'||to_char(SEQ_TEST_STBID.currval, 'FM099999') from dual;

-- userid

select 'tester'||to_char(SEQ_TEST_STBID.currval, 'FM09999') from dual;

-- date

select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual;

-- add pairing

insert into t_nps_pairing(PID, STBID, CHARID, CLIENTID, CLIENTTYPE, READABLE_CLIENTID, STATUS, REGDATE, USERID, REP_FLAG)

  values(

  SEQ_TEST_STBID.nextval + 30000, 

  '{ABC'||to_char(SEQ_TEST_STBID.currval ,'FM09999')||'-BBBB-11E2-B616-5D7CAF36E0E5}', 

  '{ABC'||to_char(SEQ_TEST_STBID.currval ,'FM09999')||'-BBBB-11E2-B616-5D7CAF36E0E5}',

  '111222333'||to_char(SEQ_TEST_STBID.currval, 'FM09999'),

  'ME',

  '01999'||to_char(SEQ_TEST_STBID.currval, 'FM099999'),

  1,

  sysdate,

  'tester'||to_char(SEQ_TEST_STBID.currval, 'FM09999'),

  1);

--      PID, STBID, CHARID, CLIENTID, CLIENTTYPE, READABLE_CLIENTID, STATUS, REGDATE, USERID, REP_FLAG

begin

for i in 1..5000 loop

  insert into t_nps_pairing(PID, STBID, CHARID, CLIENTID, CLIENTTYPE, READABLE_CLIENTID, STATUS, REGDATE, USERID, REP_FLAG)

  values(

  SEQ_TEST_STBID.nextval + 30000, 

  '{ABC'||to_char(SEQ_TEST_STBID.currval ,'FM09999')||'-BBBB-11E2-B616-5D7CAF36E0E5}', 

  '{ABC'||to_char(SEQ_TEST_STBID.currval ,'FM09999')||'-BBBB-11E2-B616-5D7CAF36E0E5}',

  'CID-'||to_char(SEQ_TEST_STBID.currval, 'FM09999'),

  'ME',

  '01999'||to_char(SEQ_TEST_STBID.currval, 'FM099999'),

  1,

  sysdate,

  'tester'||to_char(SEQ_TEST_STBID.currval, 'FM09999'),

  1);

end loop;

end;

-- Check table. t_nps_pairing

select * from t_nps_pairing where stbid like '{ABC%-BBBB-11E2-B616-5D7CAF36E0E5}';

select count(*) from t_nps_pairing where stbid like '{ABC%-BBBB-11E2-B616-5D7CAF36E0E5}';

-- Delete pairing data

delete from t_nps_pairing where stbid like '{ABC%-BBBB-11E2-B616-5D7CAF36E0E5}';