CN101539878A - Method for accelerating oracle process to monitor recycled resources under operating system - Google Patents
Method for accelerating oracle process to monitor recycled resources under operating system Download PDFInfo
- Publication number
- CN101539878A CN101539878A CN200810034780A CN200810034780A CN101539878A CN 101539878 A CN101539878 A CN 101539878A CN 200810034780 A CN200810034780 A CN 200810034780A CN 200810034780 A CN200810034780 A CN 200810034780A CN 101539878 A CN101539878 A CN 101539878A
- Authority
- CN
- China
- Prior art keywords
- oracle
- operating system
- database
- accelerating
- regularly
- 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
Images
Abstract
The invention discloses a method for accelerating an oracle process to monitor recycled resources under an operating system, which comprises the following steps: periodically capturing sessions executed for exceeding certain time by an oracle in a database thereof and closing the sessions automatically; periodically capturing inactive sessions by the oracle in the database thereof and closing the sessions automatically; setting a timed executive program under the operating system to achieve that the oracle periodically captures processes which cannot be associated with a session any more in the database thereof and closes the processes automatically under the operating system; and monitoring the recycling of resources released by closing the processes in a period of time by the processes. By the method for accelerating the oracle process to monitor the recycled resources under the operating system, the process can be accelerated to monitor the recycling of the resources released by closing useless processes so as to keep away the happening that connection exceeds the process amount defined in the database of the oracle in advance.
Description
[technical field]
The relevant a kind of method that the oracle process monitoring reclaims resource of accelerating of the present invention is meant a kind of method that the oracle process monitoring reclaims resource of accelerating especially under operating system.
[background technology]
The background process PMON of oracle (Process Monitor, process monitoring) is responsible for carrying out process and recovers when consumer process breaks down, be responsible for cleaning memory block and the employed resource of this process of release.
But the time of the recovery resource of PMON is irregular, sometimes can not reclaim resource in several days, cause the dedicate process (proprietary process) that connects to discharge, each session all is a process, finally reach the process number of oracle lane database definition, thereby cause the user can't connect database, cause the phenomenon of database paralysis.
And,, the problem that does not have normal closing database to connect is arranged if find for some old systems, but become personnel originally owing to can not find, and also do not have complete document, can't make amendment now at all, the phenomenon that just causes the user often can't connect database takes place.
The disposal route of generally taking is to reset database, but this way is very disagreeableness to the user, does not play good preventive effect.
In view of this, be necessary to provide a kind of method that the oracle process monitoring reclaims resource of under operating system, accelerating in fact, utilize this method, can accelerate the process monitoring recovery and close the useless resource that process discharged, accomplish to take precautions against in advance the situation that connects the process number that surpasses the definition of oracle lane database and take place.
[summary of the invention]
Therefore, the object of the present invention is to provide a kind of method that the oracle process monitoring reclaims resource of under operating system, accelerating, utilize this method, can accelerate the process monitoring recovery and close the useless resource that process discharged, accomplish to take precautions against in advance the situation that connects the process number that surpasses the definition of oracle lane database and take place.
For reaching above-mentioned purpose, of the present inventionly under operating system, accelerate the method that the oracle process monitoring reclaims resource, this method comprises the following steps:
Oracle regularly grasps in its database and carries out the session that surpasses certain hour, and closes these sessions automatically;
Oracle regularly grasps inactive session in its database, and closes these sessions automatically;
By setting regularly executive routine under the operating system, realize oracle in its database, regularly grasp can't be related with session process, under operating system, close these processes automatically;
Process monitoring reclaims the resource that rev down process rev discharged in a period of time.
Compared to prior art, utilize the method that the oracle process monitoring reclaims resource of under operating system, accelerating of the present invention, can accelerate the process monitoring recovery and close the useless resource that process discharged, accomplish to take precautions against in advance the situation that connects the process number that surpasses the definition of oracle lane database and take place.
For purpose of the present invention, structural attitude and function thereof are had further understanding, conjunction with figs. is described in detail as follows now:
[description of drawings]
Fig. 1 illustrates the method flow diagram that the oracle process monitoring reclaims the method for resource of accelerating of the present invention under operating system.
[embodiment]
See also Fig. 1, Fig. 1 illustrates the method flow diagram that the oracle process monitoring reclaims the method for resource of accelerating of the present invention under operating system.
For reaching above-mentioned purpose, of the present inventionly under operating system, accelerate the method that the oracle process monitoring reclaims resource, this method comprises the following steps:
Oracle regularly grasps in its database and carries out the session that surpasses certain hour, and closes these sessions (step 100) automatically;
Oracle regularly grasps inactive session in its database, and closes these sessions (step 101) automatically;
By setting regularly executive routine under the operating system, realize oracle in its database, regularly grasp can't be related with session process, under operating system, close these processes (step 102) automatically;
Process monitoring reclaims the resource (step 103) that rev down process rev discharged in a period of time.
Especially, regularly grasp in the above-mentioned steps 100 for extracting every day once, and certain hour wherein is a twenty four hours.
Especially, the timing extracting was grasped once for per four hours in the above-mentioned steps 101.
Wherein, above-mentioned steps 100 and step 101 are by the oracle timed task with write the oracle program and realize.
Wherein, above-mentioned steps 102 realizes by the script of writing the corresponding operating system and the timing program tasks that the corresponding operating system is set.
Especially, the aforesaid operations system is solaris, and then above-mentioned script is the SH script, and above-mentioned timing executive routine then is the timed task actuator on the solaris.
Compared to prior art, utilize the method that the oracle process monitoring reclaims resource of under operating system, accelerating of the present invention, the time point that solves previous oracle recovery resource is at random, unforeseen situation, under the situation that can't predict oracle collection process time point, by above operation, impel and accelerate process monitoring and reclaim automatically at the time point that needs arbitrarily, reduce work load, close the useless resource that process discharged thereby can accelerate the process monitoring recovery, accomplish to take precautions against in advance the situation that connects the process number that surpasses the definition of oracle lane database and take place.
Claims (8)
1, a kind of method of accelerating oracle process monitoring recovery resource under operating system is characterized in that this method comprises the following steps:
Oracle regularly grasps in its database and carries out the session that surpasses certain hour, and closes these sessions automatically;
Oracle regularly grasps inactive session in its database, and closes these sessions automatically;
By setting regularly executive routine under the operating system, realize oracle in its database, regularly grasp can't be related with session process, under operating system, close these processes automatically;
Process monitoring reclaims the resource that rev down process rev discharged in a period of time.
2, the method for accelerating oracle process monitoring recovery resource under operating system as claimed in claim 1 is characterized in that above-mentioned steps: oracle regularly grasps in its database and carries out the session that surpasses certain hour, and closes these sessions automatically; Wherein, regularly grasp for extracting every day once, and certain hour wherein is a twenty four hours.
3, the method for accelerating oracle process monitoring recovery resource under operating system as claimed in claim 1 is characterized in that, especially, above-mentioned steps: oracle regularly grasps inactive session in its database, and closes these sessions automatically; Wherein, this regularly grasps to per four hours and grasps once.
4, the method for accelerating oracle process monitoring recovery resource under operating system as claimed in claim 1 is characterized in that above-mentioned steps: oracle regularly grasps in its database and carries out the session that surpasses certain hour, and closes these sessions automatically; This step is by the oracle timed task and write the realization of oracle program.
5, the method for under operating system, accelerating oracle process monitoring recovery resource as claimed in claim 1, it is characterized in that above-mentioned steps: oracle regularly grasps inactive session in its database, and closes these sessions automatically; This step is by the oracle timed task and write the realization of oracle program.
6, the method for under operating system, accelerating oracle process monitoring recovery resource as claimed in claim 1, it is characterized in that, above-mentioned steps: by setting regularly executive routine under the operating system, realize oracle in its database, regularly grasp can't be related with session process, under operating system, close these processes automatically; This step realizes by the script of writing the corresponding operating system and the timing program tasks that the corresponding operating system is set.
7, the method for accelerating oracle process monitoring recovery resource under operating system as claimed in claim 6 is characterized in that the aforesaid operations system is so1aris.
8, the method for accelerating oracle process monitoring recovery resource under operating system as claimed in claim 7 is characterized in that then the above-mentioned steps script is the SH script, and above-mentioned timing executive routine then is the timed task actuator on the solaris.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200810034780A CN101539878A (en) | 2008-03-18 | 2008-03-18 | Method for accelerating oracle process to monitor recycled resources under operating system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200810034780A CN101539878A (en) | 2008-03-18 | 2008-03-18 | Method for accelerating oracle process to monitor recycled resources under operating system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101539878A true CN101539878A (en) | 2009-09-23 |
Family
ID=41123077
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200810034780A Pending CN101539878A (en) | 2008-03-18 | 2008-03-18 | Method for accelerating oracle process to monitor recycled resources under operating system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101539878A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102253863A (en) * | 2011-06-15 | 2011-11-23 | 奇智软件（北京）有限公司 | Method for closing processes |
| CN104699615A (en) * | 2012-03-31 | 2015-06-10 | 北京奇虎科技有限公司 | System failure processing method and device |
| WO2015131679A1 (en) * | 2014-08-28 | 2015-09-11 | 中兴通讯股份有限公司 | Task process processing method and device |
| CN105574195A (en) * | 2015-12-25 | 2016-05-11 | 北京奇虎科技有限公司 | Method and device for judging whether to perform offline recycling on database or not |
| WO2019061407A1 (en) * | 2017-09-30 | 2019-04-04 | 华为技术有限公司 | Method and device for handling timeout of system service |
-
2008
- 2008-03-18 CN CN200810034780A patent/CN101539878A/en active Pending
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102253863A (en) * | 2011-06-15 | 2011-11-23 | 奇智软件（北京）有限公司 | Method for closing processes |
| CN104699615A (en) * | 2012-03-31 | 2015-06-10 | 北京奇虎科技有限公司 | System failure processing method and device |
| CN104699615B (en) * | 2012-03-31 | 2017-09-22 | 北京奇虎科技有限公司 | A kind for the treatment of method and apparatus of the system failure |
| WO2015131679A1 (en) * | 2014-08-28 | 2015-09-11 | 中兴通讯股份有限公司 | Task process processing method and device |
| CN105574195A (en) * | 2015-12-25 | 2016-05-11 | 北京奇虎科技有限公司 | Method and device for judging whether to perform offline recycling on database or not |
| WO2019061407A1 (en) * | 2017-09-30 | 2019-04-04 | 华为技术有限公司 | Method and device for handling timeout of system service |
| US11693701B2 (en) | 2017-09-30 | 2023-07-04 | Huawei Technologies Co., Ltd. | System service timeout processing method, and apparatus |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101539878A (en) | Method for accelerating oracle process to monitor recycled resources under operating system | |
| CN101149636B (en) | Repositioning system and method | |
| CN101387971A (en) | Task regulation method and apparatus for embedded software | |
| CN107203552B (en) | Garbage recovery method and device | |
| CN103744723A (en) | Thread pool managing method and system | |
| WO2008126221A1 (en) | Software modification management program, software modification management device, and software modification management method | |
| CN103617098B (en) | Intelligent backup method and intelligent backup system based on data variation | |
| EP1837771A3 (en) | Monitoring of computer events | |
| CN1987792A (en) | Application system for high grade multiple line distance management | |
| WO2006089208A3 (en) | Processing information management in a plasma processing tool | |
| EP1860604A3 (en) | Method and apparatus for automated resource assignment | |
| CN103927305B (en) | It is a kind of that the method and apparatus being controlled is overflowed to internal memory | |
| CN106597245B (en) | A kind of monitoring device and method of IGBT failure | |
| CN101408852B (en) | Method, apparatus and system for scheduling task | |
| CN104636232A (en) | Performance monitoring device and method of distributed service system | |
| CN101436146A (en) | Method and system for dynamically regulating priority of remote device management progress | |
| CN101887539A (en) | Technology for recording staff attendance based on period | |
| CN106227672B (en) | A kind of built-in application program failure captures and processing method | |
| CN105159820A (en) | Transmission method and device of system log data | |
| CN109067619B (en) | Elastic capacity scheduling method for micro-service management and processing terminal | |
| CN101295271B (en) | Software watchdog self-restoring method | |
| CN102455932A (en) | Serial execution method, device and system for task instances | |
| CN100530110C (en) | System for automatically monitoring memory leakage and memory out-of-range in inlaid system | |
| CN102722521A (en) | Method and system for monitoring data comparison | |
| CN102170292B (en) | Data processing method, data processing system and related equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20090923 |