Onsite failure-data volume exceeding Plsql developer result set results in application no data phenomenon

Scenario Recurrence:

Maintenance people want to use the Plsql Developer tool to view data from a table a year ago, with data in the table about 30W, because there is no business at this time, and the maintainer closes the application. When the query selects all the data is listed, the results are displayed to more than 3W, pop-up such as the following information prompt, display "result set exceeds the maximum length", at this time the maintenance personnel ignore, click OK after the database continues to query, about 6 minutes after the end of the query. At this point, the maintainer restarts the application and finds that the data display bar does not query any data for the table, and the application does not have any error prompts.

Resolution:

Through the remote image, let maintenance personnel set the Plsql developer tool in the length of the result set to 0 (that is, do not limit the maximum length), and then query again, restart the application, the table data can be seen, problem resolution.

Summarize:

The visual reflection of this behavior is to change the relevant scope settings, recalling that the previous result set should be 0, the test is that a maintenance personnel re-installed the tool software, let the settings back to the default value, but does not affect the application of the query, do not know whether the application or database reasons. Because in the field, have the opportunity to go back and then to the scene to view. Fortunately, the problem is to conquer.

The references are as follows: