Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Studio Beta 12.5 IDE interaction much slower than 12.4

zootleDec 10 2015 — edited Jan 16 2016

I've noticed even with a single project loaded, the IDE response times to button clicks (such as editing project properties) has an almost unusable lag.  I don't see this with 12.4 on the same host.

Comments

Pierre Yotti

I tested it on 19c Version

test.png

i have the errors in all case

save.png

Holger.Lehmann

If you change it to

DECLARE

   l_clob   CLOB

      := '{"longString": "This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long.This entire string is 5031 characters long."}';

BEGIN

   --5031/4=1257.75

   DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (5031) ERROR ON ERROR)));

   BEGIN

      DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (5031) ERROR ON ERROR)));

   EXCEPTION

      WHEN OTHERS THEN

         DBMS_OUTPUT.put_line (SQLERRM);

   END;

   l_clob   :=

      '{"longString": "This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long.This entire string is 10032 characters long."}';

   --10032/4=2508

   DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (10032) ERROR ON ERROR)));

   BEGIN

      DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (10032) ERROR ON ERROR)));

   EXCEPTION

      WHEN OTHERS THEN

         DBMS_OUTPUT.put_line (SQLERRM);

   END;

   l_clob   := '{"longString": "8       "}';

   DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (8) ERROR ON ERROR)));

   BEGIN

      DBMS_OUTPUT.put_line (LENGTH (json_value (l_clob, '$.longString' RETURNING VARCHAR2 (8) ERROR ON ERROR)));

   EXCEPTION

      WHEN OTHERS THEN

         DBMS_OUTPUT.put_line (SQLERRM);

   END;

END;

/

it will work.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 13 2016
Added on Dec 10 2015
2 comments
1,026 views