Method for collecting Oracle ARW reports in batches

The invention relates to the field of computers and discloses a method for collecting oracle ARW reports in batches. The method comprises steps of (1) entering an SQLPLUS order tool to call an AWR report batch collection scripts, and starting a collection program to collect, (2) setting collection t...

Ausführliche Beschreibung

Gespeichert in:
Bibliographische Detailangaben
Hauptverfasser: LUO CHUN, ZANG BINGLING, LI CHUN, CHEN DONG, WEI XINGHUA, XIONG ZHONGZHE, QIU DALONG, LI JIANHUI, ZHANG WENJIAN
Format: Patent
Sprache:chi ; eng
Schlagworte:
Online-Zugang:Volltext bestellen
Tags: Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
container_end_page
container_issue
container_start_page
container_title
container_volume
creator LUO CHUN
ZANG BINGLING
LI CHUN
CHEN DONG
WEI XINGHUA
XIONG ZHONGZHE
QIU DALONG
LI JIANHUI
ZHANG WENJIAN
description The invention relates to the field of computers and discloses a method for collecting oracle ARW reports in batches. The method comprises steps of (1) entering an SQLPLUS order tool to call an AWR report batch collection scripts, and starting a collection program to collect, (2) setting collection time according to a collection time requirement, and inputting a time range for collecting reports, (3) inputting a report storage path, determining space of the path, giving out an alarm for prompting to remove files if the space is inadequate, and storing the path into the report if the space is enough, and (4) operating the script and generating all AWR reports in the designated time range according to the step (2) and (3). During systemic analysis to a database by an operation and maintenance worker, work can be simplified by the SQL script, so report collection efficiency can be improved; the creativity of the invention is that AWR report batch production can be simplified; and possibility of mistakes during th
format Patent
fullrecord <record><control><sourceid>epo_EVB</sourceid><recordid>TN_cdi_epo_espacenet_CN107506276A</recordid><sourceformat>XML</sourceformat><sourcesystem>PC</sourcesystem><sourcerecordid>CN107506276A</sourcerecordid><originalsourceid>FETCH-epo_espacenet_CN107506276A3</originalsourceid><addsrcrecordid>eNrjZDD2TS3JyE9RSMsvUkjOz8lJTS7JzEtX8C9KTM5JVXAMClcoSi3ILyopVsjMU0hKLEnOSC3mYWBNS8wpTuWF0twMim6uIc4eukCV8anFBYnJqXmpJfHOfoYG5qYGZkbmZo7GxKgBALUsK8o</addsrcrecordid><sourcetype>Open Access Repository</sourcetype><iscdi>true</iscdi><recordtype>patent</recordtype></control><display><type>patent</type><title>Method for collecting Oracle ARW reports in batches</title><source>esp@cenet</source><creator>LUO CHUN ; ZANG BINGLING ; LI CHUN ; CHEN DONG ; WEI XINGHUA ; XIONG ZHONGZHE ; QIU DALONG ; LI JIANHUI ; ZHANG WENJIAN</creator><creatorcontrib>LUO CHUN ; ZANG BINGLING ; LI CHUN ; CHEN DONG ; WEI XINGHUA ; XIONG ZHONGZHE ; QIU DALONG ; LI JIANHUI ; ZHANG WENJIAN</creatorcontrib><description>The invention relates to the field of computers and discloses a method for collecting oracle ARW reports in batches. The method comprises steps of (1) entering an SQLPLUS order tool to call an AWR report batch collection scripts, and starting a collection program to collect, (2) setting collection time according to a collection time requirement, and inputting a time range for collecting reports, (3) inputting a report storage path, determining space of the path, giving out an alarm for prompting to remove files if the space is inadequate, and storing the path into the report if the space is enough, and (4) operating the script and generating all AWR reports in the designated time range according to the step (2) and (3). During systemic analysis to a database by an operation and maintenance worker, work can be simplified by the SQL script, so report collection efficiency can be improved; the creativity of the invention is that AWR report batch production can be simplified; and possibility of mistakes during th</description><language>chi ; eng</language><subject>CALCULATING ; COMPUTING ; COUNTING ; ELECTRIC DIGITAL DATA PROCESSING ; PHYSICS</subject><creationdate>2017</creationdate><oa>free_for_read</oa><woscitedreferencessubscribed>false</woscitedreferencessubscribed></display><links><openurl>$$Topenurl_article</openurl><openurlfulltext>$$Topenurlfull_article</openurlfulltext><thumbnail>$$Tsyndetics_thumb_exl</thumbnail><linktohtml>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20171222&amp;DB=EPODOC&amp;CC=CN&amp;NR=107506276A$$EHTML$$P50$$Gepo$$Hfree_for_read</linktohtml><link.rule.ids>230,308,776,881,25542,76289</link.rule.ids><linktorsrc>$$Uhttps://worldwide.espacenet.com/publicationDetails/biblio?FT=D&amp;date=20171222&amp;DB=EPODOC&amp;CC=CN&amp;NR=107506276A$$EView_record_in_European_Patent_Office$$FView_record_in_$$GEuropean_Patent_Office$$Hfree_for_read</linktorsrc></links><search><creatorcontrib>LUO CHUN</creatorcontrib><creatorcontrib>ZANG BINGLING</creatorcontrib><creatorcontrib>LI CHUN</creatorcontrib><creatorcontrib>CHEN DONG</creatorcontrib><creatorcontrib>WEI XINGHUA</creatorcontrib><creatorcontrib>XIONG ZHONGZHE</creatorcontrib><creatorcontrib>QIU DALONG</creatorcontrib><creatorcontrib>LI JIANHUI</creatorcontrib><creatorcontrib>ZHANG WENJIAN</creatorcontrib><title>Method for collecting Oracle ARW reports in batches</title><description>The invention relates to the field of computers and discloses a method for collecting oracle ARW reports in batches. The method comprises steps of (1) entering an SQLPLUS order tool to call an AWR report batch collection scripts, and starting a collection program to collect, (2) setting collection time according to a collection time requirement, and inputting a time range for collecting reports, (3) inputting a report storage path, determining space of the path, giving out an alarm for prompting to remove files if the space is inadequate, and storing the path into the report if the space is enough, and (4) operating the script and generating all AWR reports in the designated time range according to the step (2) and (3). During systemic analysis to a database by an operation and maintenance worker, work can be simplified by the SQL script, so report collection efficiency can be improved; the creativity of the invention is that AWR report batch production can be simplified; and possibility of mistakes during th</description><subject>CALCULATING</subject><subject>COMPUTING</subject><subject>COUNTING</subject><subject>ELECTRIC DIGITAL DATA PROCESSING</subject><subject>PHYSICS</subject><fulltext>true</fulltext><rsrctype>patent</rsrctype><creationdate>2017</creationdate><recordtype>patent</recordtype><sourceid>EVB</sourceid><recordid>eNrjZDD2TS3JyE9RSMsvUkjOz8lJTS7JzEtX8C9KTM5JVXAMClcoSi3ILyopVsjMU0hKLEnOSC3mYWBNS8wpTuWF0twMim6uIc4eukCV8anFBYnJqXmpJfHOfoYG5qYGZkbmZo7GxKgBALUsK8o</recordid><startdate>20171222</startdate><enddate>20171222</enddate><creator>LUO CHUN</creator><creator>ZANG BINGLING</creator><creator>LI CHUN</creator><creator>CHEN DONG</creator><creator>WEI XINGHUA</creator><creator>XIONG ZHONGZHE</creator><creator>QIU DALONG</creator><creator>LI JIANHUI</creator><creator>ZHANG WENJIAN</creator><scope>EVB</scope></search><sort><creationdate>20171222</creationdate><title>Method for collecting Oracle ARW reports in batches</title><author>LUO CHUN ; ZANG BINGLING ; LI CHUN ; CHEN DONG ; WEI XINGHUA ; XIONG ZHONGZHE ; QIU DALONG ; LI JIANHUI ; ZHANG WENJIAN</author></sort><facets><frbrtype>5</frbrtype><frbrgroupid>cdi_FETCH-epo_espacenet_CN107506276A3</frbrgroupid><rsrctype>patents</rsrctype><prefilter>patents</prefilter><language>chi ; eng</language><creationdate>2017</creationdate><topic>CALCULATING</topic><topic>COMPUTING</topic><topic>COUNTING</topic><topic>ELECTRIC DIGITAL DATA PROCESSING</topic><topic>PHYSICS</topic><toplevel>online_resources</toplevel><creatorcontrib>LUO CHUN</creatorcontrib><creatorcontrib>ZANG BINGLING</creatorcontrib><creatorcontrib>LI CHUN</creatorcontrib><creatorcontrib>CHEN DONG</creatorcontrib><creatorcontrib>WEI XINGHUA</creatorcontrib><creatorcontrib>XIONG ZHONGZHE</creatorcontrib><creatorcontrib>QIU DALONG</creatorcontrib><creatorcontrib>LI JIANHUI</creatorcontrib><creatorcontrib>ZHANG WENJIAN</creatorcontrib><collection>esp@cenet</collection></facets><delivery><delcategory>Remote Search Resource</delcategory><fulltext>fulltext_linktorsrc</fulltext></delivery><addata><au>LUO CHUN</au><au>ZANG BINGLING</au><au>LI CHUN</au><au>CHEN DONG</au><au>WEI XINGHUA</au><au>XIONG ZHONGZHE</au><au>QIU DALONG</au><au>LI JIANHUI</au><au>ZHANG WENJIAN</au><format>patent</format><genre>patent</genre><ristype>GEN</ristype><title>Method for collecting Oracle ARW reports in batches</title><date>2017-12-22</date><risdate>2017</risdate><abstract>The invention relates to the field of computers and discloses a method for collecting oracle ARW reports in batches. The method comprises steps of (1) entering an SQLPLUS order tool to call an AWR report batch collection scripts, and starting a collection program to collect, (2) setting collection time according to a collection time requirement, and inputting a time range for collecting reports, (3) inputting a report storage path, determining space of the path, giving out an alarm for prompting to remove files if the space is inadequate, and storing the path into the report if the space is enough, and (4) operating the script and generating all AWR reports in the designated time range according to the step (2) and (3). During systemic analysis to a database by an operation and maintenance worker, work can be simplified by the SQL script, so report collection efficiency can be improved; the creativity of the invention is that AWR report batch production can be simplified; and possibility of mistakes during th</abstract><oa>free_for_read</oa></addata></record>
fulltext fulltext_linktorsrc
identifier
ispartof
issn
language chi ; eng
recordid cdi_epo_espacenet_CN107506276A
source esp@cenet
subjects CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
title Method for collecting Oracle ARW reports in batches
url https://sfx.bib-bvb.de/sfx_tum?ctx_ver=Z39.88-2004&ctx_enc=info:ofi/enc:UTF-8&ctx_tim=2025-02-08T16%3A10%3A25IST&url_ver=Z39.88-2004&url_ctx_fmt=infofi/fmt:kev:mtx:ctx&rfr_id=info:sid/primo.exlibrisgroup.com:primo3-Article-epo_EVB&rft_val_fmt=info:ofi/fmt:kev:mtx:patent&rft.genre=patent&rft.au=LUO%20CHUN&rft.date=2017-12-22&rft_id=info:doi/&rft_dat=%3Cepo_EVB%3ECN107506276A%3C/epo_EVB%3E%3Curl%3E%3C/url%3E&disable_directlink=true&sfx.directlink=off&sfx.report_link=0&rft_id=info:oai/&rft_id=info:pmid/&rfr_iscdi=true