Recent content by zstringer

Our Oracle team figured out a solution. Include the following line in sqlnet.ora: DISABLE_OOB=ON That seems to have fixed the problem.

I'm using PLSD 15.04.2064 64-bit. We recently moved from an on-prem database to an AWS one, and I'm getting this error a lot. Tries to relog on a few times, and then it's successful. Note that I'm not having this trouble with Oracle's SQL Developer.

Sorry for the late reply - that fixed the problem. Thanks Marco!

I'll email you the file. This seems to be the relevant section: 00:00:45.332 TOracleQuery $10C5C5E0 Start Query.Execute SQL = select m.sql_text, dbms_sqltune.report_sql_monitor(sql_id => m.sql_id, type => 'HTML', report_level => 'ALL') AS report from v$sql_monitor m...

Please bring back the colors and icons that were in PLSD version 14. Version 15 is blah grey, the > icons are too big. Need the colors and icons! Make this a preference setting perhaps. I don't care if this is the new "web standard", it's not very user-friendly. Just saying. -Peter

Hi all, Suffering significant slowdowns of a PL/SQL process that used to be faster. Tables and indexes are analyzed on a daily basis. When I look at a problematic SQL statement in Tools > Sessions, when I click on SQL Monitor I get these errors: ORA-31011: XML parsing failed ORA-06512: at...

I have a query that took a very long time. The picture shows information from PLSD SQL Monitor. I'm not sure how to interpret it though. Thanks for your help.

Hello all, I'm copying a 6mm row dataset over a database link, and we've found using the performance using PL/SQL to be very poor. However, if we run a SQLPlus script with SET ARRAYSIZE = 1500 we get satisfactory performance. I found some references to the READBUFFER parameter; is there a way...