Oracle Data Query is always in the running status.

Solve the problem that oracle queries data and is always in the execution status. Description: www.2cto.com is very strange, that is, the data before the date Condition 6 in the Table query can be found, the execution status is displayed after the 7th start. if the number is greater than 6 or before 6, you can check the number after 7 or after 7. (It may not be clearly described. You can set it up.) solution: oracle usually analyzes the table at a fixed time. The analysis time on my side may be no. 6, therefore, you cannot find it after the query. we can manually analyze the table and execute the command: analyze table cmip_accountbook compute statistics; the execution time may be a bit long.