Bug 29613690 : CHILD CURSOR LEAK DUE TO BIND MISMATCH
2018/06/07 by Leave a Comment
Child cursors are increasing due to bind mismatch. The problematic query is following.(SQL_ID=8y78t7xj7h2fk) SELECT ... FROM WWUJT628 a628 ... LEFT JOIN (SELECT DISTINCT NR_ADV_SEQ FROM WWUJT632 WHERE NO_ISSUE_ADMIN = :B1) a632 ON (a628.NR_ADV_SEQ = a632.NR_ADV_SEQ) LEFT JOIN WWUJT080 a080b ON (a080b.ID_ROLE_ADMIN_M = a630.ID_ROLE_ADMIN_M_REQ_DEST) WHERE a628.ZZ_LOGIC_DEL_FLG = 'N' AND a628.NO_ISSUE_ADMIN = :B2 AND ((a628.DT_PUBLIC IS NOT NULL AND a628.ID_SITUA_UNDER_LIMIT <= :B3) OR (a628.DT_PUBLIC IS NULL AND a628.ID_SITUA_REGIST = :B4 AND a628.CD_COM_REGIST = :B5)) ... ORDER BY DECODE(a630.CD_EVAL_PROCESS, NULL, '1', '0'), a628.DT_PUBLIC , a628.NR_ADV_SEQ; DIAGNOSTIC ANALYSIS: -------------------- Result of selecting from V$SQL and V$SQL_SHARED_CURSOR(05_after.lst) SQL> select sql_id, child_number, plan_hash_value,IS_BIND_SENSITIVE, IS_BIND_AWARE, IS_SHAREABLE from v$sql where sql_id='8y78t7xj7h2fk'; SQL_ID CHILD_NUMBER PLAN_HASH_VALUE IS IS IS -------------------------- ------------ --------------- -- -- -- 8y78t7xj7h2fk 0 2238769467 Y Y Y 8y78t7xj7h2fk 1 2238769467 Y Y Y 8y78t7xj7h2fk 2 2238769467 Y Y Y 8y78t7xj7h2fk 3 2238769467 Y Y Y 8y78t7xj7h2fk 4 2238769467 Y Y Y 8y78t7xj7h2fk 5 2238769467 Y Y Y 8y78t7xj7h2fk 6 2238769467 Y Y Y 8y78t7xj7h2fk 7 2238769467 Y Y Y 8y78t7xj7h2fk 8 2238769467 Y Y Y 8y78t7xj7h2fk 9 2238769467 Y Y Y SQL> select BIND_EQUIV_FAILURE from V$SQL_SHARED_CURSOR where sql_id='8y78t7xj7h2fk'; BI -- N Y Y Y Y Y Y Y Y Y V$SQL_SHARED_CURSOR.REASON shows: <ChildNode><ChildNumber>8</ChildNumber><ID>39</ID><reason> Bind mismatch(33)</reason><size>1x4</size><init_ranges_in_first_pass> 3801990668</init_ranges_in_first_pass></ChildNode> One of these parameters and patch are doen't resolve the problem. - alter system set "_optimizer_use_feedback"=false ; - alter system set "_optimizer_adaptive_cursor_sharing"=false ; - alter system set "_fix_control"='23596611:OFF' ; - alter system set "_optimizer_extended_cursor_sharing" = none ; - Bug 28794230 12.2 CURSOR MUTEX X DUE TO SQL NOT SHARED BECAUSE OF BIND_EQUIV_FAILURE They can avoid the problem by setting one of these parameters. - alter system set "_optimizer_extended_cursor_sharing_rel" = none; - alter system set optimizer_adaptive_plans=false ; - Event 10053 level 1 - Event 10507 level 15652 (KKOCS_TRC_CMP3|KKOCS_TRC_BEV3|KKOCS_TRC_EXE3|KKOCS_TRC_STA1 KKOCS_TRC_TFB1|KKOCS_TRC_CFB2|KKOCS_TRC_AR1) - Cursortrace level 99172 - Library cache dump level 16 WORKAROUND: ----------- - alter system set "_optimizer_extended_cursor_sharing_rel" = SIMPLE; or - alter system set optimizer_adaptive_plans=true ;
日语学习中
2018/05/21 by Leave a Comment
ただいま
おかえり
なに 什么
よし 好 好的
10分、20分、30分、40分、50分、60分读：
じっぷん、にじっぷん、さんじっぷん、よんじっぷんごじっぷん、ろくじっぷん
11分、12分、13分、14分、15分、16分、17分、18分、19分读：
じゅういっぷん、じゅうにふん、じゅうさんぷん、じゅうよんぷん、じゅうごふん、じゅうろっぷん、じゅうななふん、じゅうはっぷん、じゅうきゅうふん
Oracle flashback query failed with ORA-01555?
2018/03/13 by Leave a Comment
if you deleted/updated data by mistake in oracle. and try to recover data from flashback query. Your query may fail with ora-01555 error:
SQL> l 1 declare 2 cursor c is select * from testt2 as of scn 5385449; 3 begin 4 for i in c loop 5 null; 6 end loop; 7* end; SQL> / declare * ERROR at line 1: ORA-01555: snapshot too old: rollback segment number with name "" too small ORA-06512: at line 4
if you have no backup , then you can not recover data in this case .
we provide a better flashback service , it can recover part of deleted data . for example .
SQL> set serveroutput on;
SQL> exec better_flashback_table_save('TEST2','TESTT2',2843925,'MYTVSAVE3');
table TEST2.TESTT2 @ scn 2843925 find 5568 rows , copied to TEST2.MYTVSAVE3
PL/SQL procedure successfully completed.
the service step :
1. first expand your undo_retention parameter :
alter system set undo_retention=86400;
expand all undo datafiles
alter database datafile ‘undofile’ resize BIGGER_SIZE;
the first step avoid undo extent reused by system
2. we will provide procedure better_flashback_table_query , check how many rows can be recovered
3. we will provide procedure better_flashback_table_save , which will recover data and stored in new table .
4. we can also take advantage prm-dul undelete function to help you recover data . pls check https://youtu.be/hIYutqNcVBI
We provide above as a service . contact service@parnassusdata.com
goldengate ogg troubleshooting guide
2018/02/21 by Leave a Comment
Oracle 11.2.0.4 LINUX WINDOWS 下载
2018/02/15 by Leave a Comment
请注意，如果你有support.oracle.com账号，那么严格从官网下载介质。如果实在没有，那么从互联网上下载介质一定要验证SHA1,避免介质被修改。
ORACLE 11.2.0.4 Windows 64bit:
链接: https://pan.baidu.com/s/1eFN0HqgHRLIg12iKZu8B2Q?pwd=7r7d
提取码: 7r7d
11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset) p13390677_112040_MSWIN-x86-64_1of7.zip 1.2 GB (1327046969 bytes) SHA-256 9C6E1235D1B0EE6C36E3F82FEBDC74160BB9766900579FC7EBBFACECD6E8F4B2 SHA-1 893475AFA9C6758FB14E8269EF05F6D485445F28 p13390677_112040_MSWIN-x86-64_2of7.zip 1.1 GB (1152431908 bytes) SHA-1 6EE067D16F80061B03CFD63603B3F5E454B6152D SHA-256 6343B2EA4F47C4E85FD4DC1B5C2EA0B86294E48FAD90DE1820C3F9DF906675F3 p13390677_112040_MSWIN-x86-64_3of7.zip 735.0 MB (770723774 bytes) SHA-256 EC47CFF4D500BD357982C57D9F84F893293A3DBB79A62FC7AE66E2144BEFFF6C SHA-1 AA69BD12E01BECBD249C71F8682D75BB2FA003DB p13390677_112040_MSWIN-x86-64_4of7.zip 600.7 MB (629885092 bytes) SHA-256 10D708F6C3FA12466486BDBB3B1FB235EEEAF1AAB39B67B86C42648F8F49FB33 SHA-1 821CD458D76672DD10A3C377196C6CE52CBB1BBF p13390677_112040_MSWIN-x86-64_5of7.zip 525.6 MB (551173867 bytes) SHA-1 E975AA77E4D79B2A22F0F341CBA97EE696B5ADD1 SHA-256 25FB15F2031C4C82EC09D001023103A9267BC2D34D0F1731E0EBFCDA0495C72E p13390677_112040_MSWIN-x86-64_6of7.zip 484.2 MB (507686306 bytes) SHA-1 C899797A782DE2A09EC90C57A1117D3490CEAA65 SHA-256 4A2EF2B9FB3656009320676B2DDFB13A81777B6F2E70ECCA37606637EF796043 p13390677_112040_MSWIN-x86-64_7of7.zip 108.3 MB (113590540 bytes) SHA-1 DCA23E6583527F7ABC19846D1FD51D56DE4C4111 SHA-256 4BF2626A281C006331846C174790EF63D744C7A0BAC309CAAB48548596476701
ORACLE 11.2.0.4 Linux 64bit:
链接: https://pan.baidu.com/s/1HYVkgu7dm6SWh6x4iJ8GQw?pwd=hbkf
提取码: hbkf
11.2.0.4.0 PATCH SET FOR ORACLE DATABASE SERVER (Patchset) p13390677_112040_Linux-x86-64_1of7.zip 1.3 GB (1395582860 bytes) SHA-256 0B399A6593804C04B4BD65F61E73575341A49F8A273ACABA0DCDA2DFEC4979E0 SHA-1 983461D6442B0833630475EC4885278588585651 p13390677_112040_Linux-x86-64_2of7.zip 1.1 GB (1151304589 bytes) SHA-1 2E628D8CAC5D1C6FFF15E728B1F227747BF2DED8 SHA-256 73E04957EE0BF6F3B3E6CFCF659BDF647800FE52A377FB8521BA7E3105CCC8DD p13390677_112040_Linux-x86-64_3of7.zip 1.1 GB (1205251894 bytes) SHA-1 8C0CD2D7BB2DD73E965A90CD053828D7A52AE7E7 SHA-256 09C08AD3E1EE03DB1707F01C6221C7E3E75EC295316D0046CC5D82A65C7B928C p13390677_112040_Linux-x86-64_4of7.zip 625.6 MB (656026876 bytes) SHA-1 1ACF8F785313D3C5CF631A0077416C22348B9DF8 SHA-256 88B4A4ABB57F7E94941FE21FA99F8481868BADF2E1E0749522BBA53450F880C2 p13390677_112040_Linux-x86-64_5of7.zip 571.4 MB (599170344 bytes) SHA-256 F9C9D077549EFA10689804B3B07E3EFD56C655A4ABA51EC307114B46B8EAFC5F SHA-1 8D68764AB38804A9B9C9E80BF5AE0F3D6C397151 p13390677_112040_Linux-x86-64_6of7.zip 465.7 MB (488372844 bytes) SHA-256 B2E08F605D7A4F8ECE2A15636A65C922933C7EF29F7AD8B8F71B23FE1ECBACA8 SHA-1 79533E2FF40664A4640616BD559903ED616F2633 p13390677_112040_Linux-x86-64_7of7.zip 114.0 MB (119521122 bytes) SHA-256 1CB47B7C0B437D7D25D497ED49719167A9FB8F97A434E93E4663CFA07590E2BA SHA-1 B23A8CED6D47664F20C116ABA9A2C77D65B2DD6D
react native css style field
2017/06/17 by Leave a Comment
ref:
https://github.com/macleanliu/learnjs/blob/master/css.ts
