CN107506276A - A kind of method for realizing batch collection Oracle AWR reports - Google Patents
A kind of method for realizing batch collection Oracle AWR reports Download PDFInfo
- Publication number
- CN107506276A CN107506276A CN201710494085.7A CN201710494085A CN107506276A CN 107506276 A CN107506276 A CN 107506276A CN 201710494085 A CN201710494085 A CN 201710494085A CN 107506276 A CN107506276 A CN 107506276A
- Authority
- CN
- China
- Prior art keywords
- report
- awr
- path
- oracle
- reports
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Quality & Reliability (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention relates to computer realm, discloses a kind of method for realizing batch collection Oracle AWR reports, comprises the following steps：(1) enter SQLPLUS command tools, call AWR report batch capture scripts, start capture program and be acquired；(2) according to acquisition time demand, acquisition time is set, input will collect the time range of report；(3) path of input storage report, judges space under the path, such as insufficient space, then sends alarm sounds cleaning file；As space is enough, report is stored in the path；(4) AWR all in the range of the specified time that script runs and specified according to step (2) and step (3) generation is reported.These work are greatly simplified when operation maintenance personnel does Systematic Analysis to database, improve the collection efficiency of report by the present invention by SQL scripts.The step of creativeness of the present invention is to simplify Mass production AWR reports, reduce the probability to be malfunctioned in generation reporting process.
Description
Technical field
The present invention relates to field of computer technology, more particularly to a kind of side for realizing batch collection Oracle AWR report
Method.
Background technology
Core of the oracle database as many enterprise's key service systems, failure and performance issue need to pay close attention to
Emphasis.AWR (Automatic Workload Repository) reports provide comprehensive detailed as oracle database itself
Database analysis audit report, cover the every aspect of database self information.Operation maintenance personnel can pass through Oracle's
Carry script and generate this report portionwise, but it is cumbersome when needing Mass production report for a period of time.
The content of the invention
The shortcomings that present invention for spending the time more, cumbersome in the prior art, there is provided one kind realizes batch collection
The method of Oracle AWR reports.
In order to solve the above-mentioned technical problem, the present invention is addressed by following technical proposals.
A kind of method for realizing batch collection Oracle AWR reports, comprises the following steps：
(1) enter SQLPLUS command tools, call AWR report batch capture scripts, start capture program and be acquired；
(2) according to acquisition time demand, acquisition time is set, input will collect the time range of report；
(3) path of input storage report, judges space under the path, such as insufficient space, then sends alarm and carry
Show cleaning file；As space is enough, report is stored in the path；
(4) AWR reports all in the range of the specified time that script operation and generation step (2) and step (3) generation are specified
Accuse.
Preferably, in step (2), time range is 5-8 hour.
The present invention has significant technique effect as a result of above technical scheme：The present invention is in operation maintenance personnel logarithm
, it is necessary to which the database AWR in a period of time of acquisition is reported when doing Systematic Analysis according to storehouse.Pass through Oracle's itself
Awrrpt.sql scripts generate one by one wastes time and energy, and greatly simplifies these work by SQL scripts, improves the collection of report
Efficiency.The step of creativeness of the present invention is to simplify Mass production AWR reports, reduce what is malfunctioned in generation reporting process
Probability.
Brief description of the drawings
Fig. 1 is a kind of operating diagram for the method for realizing batch collection Oracle AWR reports of the present invention.
Embodiment
The present invention is described in further detail with embodiment below in conjunction with the accompanying drawings.
As shown in figure 1, a kind of method for realizing batch collection Oracle AWR reports, comprises the following steps：
(1) enter SQLPLUS command tools, call AWR report batch capture scripts, start capture program and be acquired；
(2) according to acquisition time demand, acquisition time is set, input will collect the time range of report；
(3) path of input storage report, judges space under the path, such as insufficient space, then sends alarm and carry
Show cleaning file；As space is enough, report is stored in the path；
(4) AWR reports all in the range of the specified time that script operation and generation step (2) and step (3) generation are specified
Accuse.
The present invention is when operation maintenance personnel does Systematic Analysis to database, it is necessary to database AWR in a period of time of acquisition
Report.Being generated one by one by Oracle itself awrrpt.sql scripts wastes time and energy, by SQL scripts by these work significantly
Simplify, improve the collection efficiency of report.The step of creativeness of the present invention is to simplify Mass production AWR reports, reduce
The probability to be malfunctioned in generation reporting process.
Embodiment 1
Certain project needs to collect 30 days 9 March in 2017：00 to 14：00 whole AWR reports, then it is defeated in capture program
Enter initial time for 20170330.09：00, the end time 20170330.14：00, it is 10 to obtain reporting quantities, then：
(1) enter SQLPLUS command tools, call AWR report batch capture scripts, start capture program, in (2)
Specified time scope, corresponding analysis report is generated using AWR snapshots；
(2) input will collect the time range of report, collect 30 days 9 March in 2017：00 to 14：00 whole AWR reports
Accuse, then can input initial time 20,170,330 09：00, the end time 20,170,330 14：00；
(3) path of input storage report, judges space under the path, insufficient space, then needs to clear up useless
File vacates corresponding space or changes other paths；The size of 1 part of AWR report is hundreds of KB to 1MB or so, therefore accordingly
Parking space to reserve 1MB × 10=10MB.
(4) AWR all in the range of the specified time that script runs and specified according to step (2) and step (3) generation is reported
Accuse.
In a word, presently preferred embodiments of the present invention, all equalizations made according to scope of the present invention patent be the foregoing is only
Change and modification, it should all belong to the covering scope of patent of the present invention.
Claims (2)
- A kind of 1. method for realizing batch collection Oracle AWR reports, it is characterised in that comprise the following steps：(1) enter SQLPLUS command tools, call AWR report batch capture scripts, start capture program and be acquired；(2) according to acquisition time demand, acquisition time is set, input will collect the time range of report；(3) path of input storage report, judges space under the path, such as insufficient space, then it is clear to send alarm sounds Manage file；As space is enough, report is stored in the path；(4) AWR all in the range of the specified time that script runs and specified according to step (2) and step (3) generation is reported.
- A kind of 2. method for realizing batch collection Oracle AWR reports according to claim 1, it is characterised in that：Step (2) in, time range is 5-8 hour.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710494085.7A CN107506276A (en) | 2017-06-26 | 2017-06-26 | A kind of method for realizing batch collection Oracle AWR reports |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710494085.7A CN107506276A (en) | 2017-06-26 | 2017-06-26 | A kind of method for realizing batch collection Oracle AWR reports |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107506276A true CN107506276A (en) | 2017-12-22 |
Family
ID=60679360
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710494085.7A Pending CN107506276A (en) | 2017-06-26 | 2017-06-26 | A kind of method for realizing batch collection Oracle AWR reports |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107506276A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110580247A (en) * | 2019-09-11 | 2019-12-17 | 普元信息技术股份有限公司 | System and method for realizing database operation efficiency optimization function aiming at data sharing platform |
| CN110807017A (en) * | 2019-10-16 | 2020-02-18 | 杭州美创科技有限公司 | AWR report analysis method based on Beautiful Soup analysis technology |
| CN111130987A (en) * | 2019-11-01 | 2020-05-08 | 平安科技（深圳）有限公司 | Automatic acquisition method and device for AWR report, electronic equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473643A (en) * | 2013-09-10 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Product management data auditing method and system for BOSS system |
| CN104133915A (en) * | 2014-08-13 | 2014-11-05 | 北京华夏威科软件技术有限公司 | Monitoring method and system for operation and maintenance behavior of database administrator |
| CN105512002A (en) * | 2015-11-23 | 2016-04-20 | 上海汽车集团股份有限公司 | Equipment monitoring method and monitoring server |
-
2017
- 2017-06-26 CN CN201710494085.7A patent/CN107506276A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103473643A (en) * | 2013-09-10 | 2013-12-25 | 北京思特奇信息技术股份有限公司 | Product management data auditing method and system for BOSS system |
| CN104133915A (en) * | 2014-08-13 | 2014-11-05 | 北京华夏威科软件技术有限公司 | Monitoring method and system for operation and maintenance behavior of database administrator |
| CN105512002A (en) * | 2015-11-23 | 2016-04-20 | 上海汽车集团股份有限公司 | Equipment monitoring method and monitoring server |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110580247A (en) * | 2019-09-11 | 2019-12-17 | 普元信息技术股份有限公司 | System and method for realizing database operation efficiency optimization function aiming at data sharing platform |
| CN110807017A (en) * | 2019-10-16 | 2020-02-18 | 杭州美创科技有限公司 | AWR report analysis method based on Beautiful Soup analysis technology |
| CN111130987A (en) * | 2019-11-01 | 2020-05-08 | 平安科技（深圳）有限公司 | Automatic acquisition method and device for AWR report, electronic equipment and storage medium |
| WO2021082484A1 (en) * | 2019-11-01 | 2021-05-06 | 平安科技（深圳）有限公司 | Awr report automatic acquisition method and apparatus, electronic device, and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN1959717B (en) | System and method for preprocessing mass remote sensing data collection driven by order form | |
| CN108512689A (en) | Micro services business monitoring method and server | |
| CN100375038C (en) | Finally agent optimization method and system of source in reorder two-stage refering | |
| CN107506276A (en) | A kind of method for realizing batch collection Oracle AWR reports | |
| US9747585B2 (en) | Method of retrieving and uniformalizing elevator maintenance and callback data and code events | |
| CN103699967A (en) | Panoramic information platform based on electric network regulation and control integration | |
| CN104615617A (en) | Dispatch monitoring information processing system for substation equipment | |
| CN103077019B (en) | A kind of graphical parameter batch maintenance method and device | |
| CN113849483A (en) | Real-time database system architecture for intelligent factory | |
| CN107656858A (en) | A kind of method and system of automatic O＆M monitoring oracle database | |
| CN102999524A (en) | Method and system for searching document association | |
| CN108062387A (en) | A kind of real time data cleaning and conversion method towards TAS systems | |
| CN104199819A (en) | WEB system error processing method and device | |
| CN105653322A (en) | Operation and maintenance server and server event processing method | |
| WO2020028459A1 (en) | Method and system for implementing an automated data validation tool | |
| CN110599018B (en) | Production task configuration system and method based on MES system | |
| CN104063468A (en) | Data report automatic generating and extracting method and device | |
| CN102571413A (en) | Method for resource management under cluster environment | |
| CN103440302B (en) | The method and system of Real Data Exchangs | |
| CN110555583A (en) | method for uniformly processing wide-area operation data of intelligent power grid dispatching control system | |
| CN201371834Y (en) | Railway transportation multi-functional alarm display | |
| CN101339506A (en) | Device for implementing software products resource and version management | |
| CN105933396B (en) | A kind of each canalization interface of collaboration realizes the method and system of long flow | |
| CN112506927A (en) | Performance data storage method under cloud environment | |
| CN112446619B (en) | Power distribution network rush-repair processing method and device |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171222 |