CN108829876A - The solution and device that the pl/sql client request time-out of Oracle does not respond - Google Patents
The solution and device that the pl/sql client request time-out of Oracle does not respond Download PDFInfo
- Publication number
- CN108829876A CN108829876A CN201810668598.XA CN201810668598A CN108829876A CN 108829876 A CN108829876 A CN 108829876A CN 201810668598 A CN201810668598 A CN 201810668598A CN 108829876 A CN108829876 A CN 108829876A
- Authority
- CN
- China
- Prior art keywords
- oracle
- respond
- sql
- sentence
- sql client
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The solution and device not responded the invention discloses the pl/sql client request time-out of Oracle a kind of, belong to field of computer technology.The solution that the pl/sql client request time-out of Oracle of the invention does not respond, after pl/sql connection database, the performance indicator of network is obtained by built-in script, and show current network transfer speeds, when network throughput is less than threshold values, the Oracle sentence being currently executing is saved, when pl/sql is not responded, execution journal is directly transferred, the current Last status for executing sentence is returned.The reason of solution that the pl/sql client request time-out of the Oracle of the invention does not respond can make user of service not respond generation judges, the probability that time-out does not respond occurs to reduce, improves working efficiency, has good application value.
Description
Technical field
The present invention relates to field of computer technology, and the pl/sql client request time-out for specifically providing a kind of Oracle is not rung
The solution and device answered.
Background technique
With the development of information technology, oracle database technology promotes the use of every field more and more widely.When
When pl/sql executes oracle database sentence or script, it may appear that the case where request timed out does not respond, in the prior art, out
Now the settling mode after such case is：One, its response is waited；Two, pl/sql is closed by force, and pl/sql can be under temp directory
The file for retaining the opening state of current window is generated, can show window to be restored when starting pl/sql next time, this file
It is stored in TEMP/PLS-Recovery.But in the case where waiting it to respond, needing the time indefinite, user may be out of patience.
In the case where directly closing, by restoring file come the work before returning to, the script that often holiday is finished writing.Both
Situation can all influence the working condition of user of service, reduce working efficiency.
The return situation of data packet when packet capturing comparison connects different oracle databases is carried out by wireshark tool,
It was found that the data packet of connection oracle database always occurs to retransmit data packet, data packet acquisition abnormal phenomenon, and data pass
Will lead to pl/sql after defeated exception cannot respond to, analysis it is very big the reason is that pl/sql connection database network problem, but mesh
It is preceding without the extraordinary treatment mechanism to network problem.
Summary of the invention
Technical assignment of the invention is that in view of the above problems, providing one kind can make user of service not ring generation
The reason of answering is judged, the probability that time-out does not respond occurs to reduce, and improves the pl/sql visitor of the Oracle of working efficiency
The solution that family end request timed out does not respond.
What the pl/sql client request time-out that the further technical assignment of the present invention is to provide a kind of Oracle did not responded
Solving device.
To achieve the above object, the present invention provides following technical solutions：
A kind of solution that the pl/sql client request time-out of Oracle does not respond, the solution is in pl/sql connection
After oracle database, the performance indicator of network is obtained by built-in script, and shows current network transfer speeds, works as network
When handling capacity is less than threshold values, the Oracle sentence being currently executing is saved, when pl/sql client does not respond, directly
It connects and transfers execution journal, return to the Last status of currently performed Oracle sentence.
The script is the script of any one detectable network speed in the prior art.
The threshold values is 100 ms.When network throughput be less than threshold values when, to the Oracle sentence being currently executing into
The case where row saves, and prevents after not responding closing by force, part Oracle sentence is caused to be lost.Improve the effect of work
Rate, user of service can also judge the reason of generation, reduce and the probability that time-out does not respond occurs.
Preferably, the solution specifically includes following steps：
S1：Pl/sql connection oracle database executes sentence；
S2：Current network transmission speed is judged, if network throughput is less than threshold values, step S3 is executed, otherwise executes step
Rapid S4；
S3：Save the Oracle sentence being currently executing；
S4：It continues to execute；
S5：When pl/sql client does not respond, the Oracle sentence of a upper execution is returned.
Preferably, in step S2, the performance indicator of network is obtained by built-in script, to current network transmission speed into
Row judgement.
Preferably, pl/sql client calculates the size for executing table, required for calculating during step S4 is continued to execute
Time prevent execution table excessive the time required to display, calculation amount is excessive, and pl/sql client caused by executing for a long time is not
Response.
Preferably, directly transferring the execution journal of preservation when pl/sql client does not respond in step S5, upper one is returned
The Oracle sentence of a execution.
The solving device that the pl/sql client request time-out of Oracle does not respond, the device include：
Link block：Sentence is executed for pl/sql client connection oracle database；
Judgment module：For judging current network transmission speed；
Comparison module：For current network transmission speed to be made comparisons with threshold values；
Preserving module：For saving the Oracle sentence being currently executing；
Return module：For when pl/sql client does not respond, returning to the Oracle sentence of a upper execution.
Preferably, the judgment module, the performance indicator of network is obtained by built-in script, speed is transmitted to current network
Degree is judged.
Preferably, the preserving module saves the Oracle sentence being currently executing, during continuing to execute, pl/
Sql client calculates the size for executing table, and the time required for calculating prevents execution table excessive, calculation amount the time required to display
Excessive, pl/sql caused by executing for a long time is not responded.
Preferably, the return module directly transfers the execution journal of preservation, the Oracle language of a upper execution is returned
Sentence.
Compared with prior art, the solution tool that the pl/sql client request time-out of Oracle of the invention does not respond
There is beneficial effect following prominent：The solution that the pl/sql client request time-out of the Oracle does not respond, Ke Yirang
User sees whether that request timed out, which can occur, not to be responded in real time, and may determine that the reason of generation time-out does not respond, when
When generation time-out does not respond, it can be restored to the Oracle sentence of a upper execution from the execution journal of preservation, prevent from passing through
The case where closing by force to restart client, influencing the working condition of user of service has good to improve working efficiency
Good application value.
Detailed description of the invention
Fig. 1 is the flow chart for the solution that the pl/sql client request time-out of Oracle of the present invention does not respond；
Fig. 2 is the schematic diagram for the solving device that the pl/sql client request time-out of Oracle of the present invention does not respond.
Specific embodiment
Below in conjunction with drawings and examples, the pl/sql client request time-out of Oracle of the invention is not responded
Solution and device are described in further detail.
Embodiment
As shown in Figure 1, the solution that the pl/sql client request time-out of Oracle of the invention does not respond, in pl/
After sql connection oracle database, the performance indicator of network is obtained by built-in script, and shows current network transmission speed
Degree saves the Oracle sentence being currently executing, when network throughput is less than threshold values when pl/sql is not responded
When, execution journal is directly transferred, the current Last status for executing Oracle sentence is returned.
The solution that the pl/sql client request time-out of the Oracle does not respond specifically includes following steps：
S1：Pl/sql connection oracle database executes sentence.
S2：Current network transmission speed is judged, if network throughput is less than threshold values, step S3 is executed, otherwise holds
Row step S4.
The performance indicator that network is obtained by built-in script, judges current network transmission speed.
S3：Save the Oracle sentence being currently executing.
S4：It continues to execute.
During continuing to execute, pl/sql client calculates the size for executing table, the time required for calculating, needed for display
Time prevents execution table excessive, and calculation amount is excessive, and pl/sql client caused by executing for a long time does not respond.
S5：When pl/sql client does not respond, the Oracle sentence of a upper execution is returned.
When pl/sql client does not respond, the execution journal of preservation is directly transferred, returns to the Oracle language of a upper execution
Sentence.
As shown in Fig. 2, the solving device that the pl/sql client request time-out of Oracle of the invention does not respond, the device
Including：
Link block：Sentence is executed for pl/sql client connection database.
Judgment module：For judging current network transmission speed.The performance indicator that network is obtained by built-in script, to working as
Preceding network transfer speeds are judged.
Comparison module：For current network transmission speed to be made comparisons with threshold values.
Preserving module：For saving the Oracle sentence being currently executing, during continuing to execute, pl/sql client
The size for executing table is calculated, the time required for calculating prevents execution table excessive, calculation amount is excessive, when long the time required to display
Between execute caused by pl/sql do not respond.
Return module：For when pl/sql client does not respond, returning to the Oracle sentence of a upper execution.
Return module directly transfers the execution journal of preservation, returns to the Oracle sentence of a upper execution.
Embodiment described above, the only present invention more preferably specific embodiment, those skilled in the art is at this
The usual variations and alternatives carried out within the scope of inventive technique scheme should be all included within the scope of the present invention.
Claims (9)
- The solution that the pl/sql client request time-out of 1.Oracle does not respond, it is characterised in that：The solution exists After pl/sql connection oracle database, the performance indicator of network is obtained by built-in script, and shows current network transmission Speed saves the Oracle sentence being currently executing, when network throughput is less than threshold values when pl/sql client When not responding, execution journal is directly transferred, returns to the Last status of currently performed Oracle sentence.
- 2. the solution that the pl/sql client request time-out of Oracle according to claim 1 does not respond, feature It is：Specifically include following steps：S1：Pl/sql connection oracle database executes sentence；S2：Current network transmission speed is judged, if network throughput is less than threshold values, step S3 is executed, otherwise executes step Rapid S4；S3：Save the Oracle sentence being currently executing；S4：It continues to execute；S5：When pl/sql client does not respond, the Oracle sentence of a upper execution is returned.
- 3. the solution that the pl/sql client request time-out of Oracle according to claim 2 does not respond, feature It is：In step S2, the performance indicator of network is obtained by built-in script, current network transmission speed is judged.
- 4. the solution that the pl/sql client request time-out of Oracle according to claim 3 does not respond, feature It is：During step S4 is continued to execute, pl/sql client calculates the size for executing table, the time required for calculating, display Required time prevents execution table excessive, and calculation amount is excessive, and pl/sql client caused by executing for a long time does not respond.
- 5. the solution that the pl/sql client request time-out of Oracle according to claim 4 does not respond, feature It is：When pl/sql client does not respond in step S5, the execution journal of preservation is directly transferred, returns to a upper execution Oracle sentence.
- The solving device that the pl/sql client request time-out of 6.Oracle does not respond, it is characterised in that：The device includes：Link block：Sentence is executed for pl/sql client connection oracle database；Judgment module：For judging current network transmission speed；Comparison module：For current network transmission speed to be made comparisons with threshold values；Preserving module：For saving the Oracle sentence being currently executing；Return module：For when pl/sql client does not respond, returning to the Oracle sentence of a upper execution.
- 7. the solving device that the pl/sql client request time-out of Oracle according to claim 6 does not respond, feature It is：The judgment module is obtained the performance indicator of network by built-in script, judged current network transmission speed.
- 8. the solving device that the pl/sql client request time-out of Oracle according to claim 6 or 7 does not respond, special Sign is：The preserving module saves the Oracle sentence being currently executing, during continuing to execute, pl/sql client meter The size for executing table is calculated, the time required for calculating prevents execution table excessive the time required to display, and calculation amount is excessive, for a long time Pl/sql caused by executing is not responded.
- 9. the solving device that the pl/sql client request time-out of Oracle according to claim 8 does not respond, feature It is：The return module directly transfers the execution journal of preservation, returns to the Oracle sentence of a upper execution.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810668598.XA CN108829876A (en) | 2018-06-26 | 2018-06-26 | The solution and device that the pl/sql client request time-out of Oracle does not respond |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201810668598.XA CN108829876A (en) | 2018-06-26 | 2018-06-26 | The solution and device that the pl/sql client request time-out of Oracle does not respond |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108829876A true CN108829876A (en) | 2018-11-16 |
Family
ID=64138875
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201810668598.XA Pending CN108829876A (en) | 2018-06-26 | 2018-06-26 | The solution and device that the pl/sql client request time-out of Oracle does not respond |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108829876A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112783739A (en) * | 2021-01-05 | 2021-05-11 | 广州品唯软件有限公司 | Timeout time display method, device, system, computer equipment and storage medium |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103873276A (en) * | 2012-12-12 | 2014-06-18 | 中国移动通信集团浙江有限公司 | Business processing method under J2EE framework and system thereof |
| CN104243438A (en) * | 2013-06-24 | 2014-12-24 | 阿里巴巴集团控股有限公司 | Database transaction processing method and server |
| CN104793988A (en) * | 2014-01-20 | 2015-07-22 | 阿里巴巴集团控股有限公司 | Cross-database distributed transaction implementation method and device |
| CN105117441A (en) * | 2015-08-11 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Data work order processing method and system |
| CN105159929A (en) * | 2015-08-05 | 2015-12-16 | 北京思特奇信息技术股份有限公司 | Memory database communication method and system |
| CN105608086A (en) * | 2014-11-17 | 2016-05-25 | 中兴通讯股份有限公司 | Transaction processing method and device of distributed database system |
| CN106557514A (en) * | 2015-09-29 | 2017-04-05 | 中兴通讯股份有限公司 | A kind of distributed transaction rollback method and device |
-
2018
- 2018-06-26 CN CN201810668598.XA patent/CN108829876A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103873276A (en) * | 2012-12-12 | 2014-06-18 | 中国移动通信集团浙江有限公司 | Business processing method under J2EE framework and system thereof |
| CN104243438A (en) * | 2013-06-24 | 2014-12-24 | 阿里巴巴集团控股有限公司 | Database transaction processing method and server |
| CN104793988A (en) * | 2014-01-20 | 2015-07-22 | 阿里巴巴集团控股有限公司 | Cross-database distributed transaction implementation method and device |
| CN105608086A (en) * | 2014-11-17 | 2016-05-25 | 中兴通讯股份有限公司 | Transaction processing method and device of distributed database system |
| CN105159929A (en) * | 2015-08-05 | 2015-12-16 | 北京思特奇信息技术股份有限公司 | Memory database communication method and system |
| CN105117441A (en) * | 2015-08-11 | 2015-12-02 | 北京思特奇信息技术股份有限公司 | Data work order processing method and system |
| CN106557514A (en) * | 2015-09-29 | 2017-04-05 | 中兴通讯股份有限公司 | A kind of distributed transaction rollback method and device |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112783739A (en) * | 2021-01-05 | 2021-05-11 | 广州品唯软件有限公司 | Timeout time display method, device, system, computer equipment and storage medium |
| CN112783739B (en) * | 2021-01-05 | 2022-08-19 | 广州品唯软件有限公司 | Timeout time display method, device, system, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9722900B2 (en) | Methods and computer program products for transaction analysis of network traffic in a network device | |
| US20130343213A1 (en) | Methods and Computer Program Products for Correlation Analysis of Network Traffic in a Network Device | |
| US8645532B2 (en) | Methods and computer program products for monitoring the contents of network traffic in a network device | |
| CN103546467B (en) | The method applying Modbus rtu protocol on TCP/IP network | |
| CN106485141A (en) | The detection of abnormal traffic thread and processing method under JAVA environment | |
| CN106936896B (en) | Kafka cluster data transmission method and device | |
| CN105874773B (en) | Task processing device, intelligent equipment, task processing method and baseband processor | |
| WO2021218063A1 (en) | Method and apparatus for assigning parameter with value on the basis of name mapping, and computer device | |
| CN103475657B (en) | The treating method and apparatus of anti-SYN extensive aggression | |
| CN108829876A (en) | The solution and device that the pl/sql client request time-out of Oracle does not respond | |
| CN108901035A (en) | The recognition methods of internet-of-things terminal and device | |
| CN105025063A (en) | Online data transmission method for large-scale terminal equipment | |
| WO2020119400A1 (en) | Failure processing method and apparatus, and storage medium | |
| CN104410687A (en) | Method for transmitting data among multiple groups of courses on basis of pipe | |
| CN109144666A (en) | A kind of method for processing resource and system across cloud platform | |
| CN108306815A (en) | A kind of method, apparatus, equipment and computer readable storage medium obtaining message | |
| CN115865734B (en) | Fault detection method, data generation method, device, equipment and medium | |
| CN111935782A (en) | Optimization method of client retry mechanism and storage medium | |
| CN104519062A (en) | Method and system for creating connection of multiple pairs of socket ports | |
| CN116390043A (en) | Calling method, multimode terminal and storage medium | |
| CN103178981B (en) | Connection management method and system | |
| US20180285270A1 (en) | Real-time cache repair tool | |
| CN114637777A (en) | Method and system for real-time exchange processing of foreground and background system data | |
| CN111090513B (en) | Method for detecting link health state of Internet of vehicles platform terminal and storage medium | |
| CN115037803B (en) | Service calling method, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20190709 Address after: 214029 No. 999 Gaolang East Road, Binhu District, Wuxi City, Jiangsu Province (Software Development Building) 707 Applicant after: Chaozhou Zhuoshu Big Data Industry Development Co.,Ltd. Address before: 250100 S06 Floor, No. 1036 Tidal Road, Jinan High-tech Zone, Shandong Province Applicant before: SHANDONG HUIMAO ELECTRONIC PORT Co.,Ltd. |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20181116 |