CN107066625A - A kind of oracle database table statistical information collection method and system - Google Patents
A kind of oracle database table statistical information collection method and system Download PDFInfo
- Publication number
- CN107066625A CN107066625A CN201710338614.4A CN201710338614A CN107066625A CN 107066625 A CN107066625 A CN 107066625A CN 201710338614 A CN201710338614 A CN 201710338614A CN 107066625 A CN107066625 A CN 107066625A
- Authority
- CN
- China
- Prior art keywords
- target capacity
- capacity size
- variable quantity
- statistical information
- size
- 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
- 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
- G06F16/23—Updating
- G06F16/2358—Change logging, detection, and notification
-
- 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
- G06F16/21—Design, administration or maintenance of databases
-
- 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
- G06F16/22—Indexing; Data structures therefor; Storage structures
-
- 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
- G06F16/23—Updating
- G06F16/2393—Updating materialised views
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application discloses a kind of oracle database table statistical information collection method and system, this method includes:Determine the variable quantity of object table in oracle database;Judge whether variable quantity is less than default variable quantity threshold value, if it is, forbidding collecting the statistical information of object table, if it is not, then the statistical information to object table is collected.The application is before the statistical information of object table is collected in oracle database, first determine the variable quantity of object table, then judge whether the variable quantity is more than default variable quantity threshold value, the application is in the case where above-mentioned variable quantity is more than default variable quantity threshold value, side is collected to the statistical information of object table, otherwise just forbid being collected object table, so as to carry out statistical information collection processing to object table in the case of avoiding variable quantity less, it is possible thereby to avoid consuming excessive system resource.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of oracle database table statistical information collection method and
System.
Background technology
At present, when user safeguards the oracle database for possessing tens sets of operation systems, it is frequently encountered because data
Performance issue caused by the statistical information renewal not in time of storehouse table, it has had a strong impact on the experience of terminal user.In order to realize
Statistical information to database table is updated, it is necessary to which first the statistical information to database table is collected.However, a set of at present
Complicated oracle database generally has a thousands of tables, and table size by several G to hundreds of G, for 7*24
The operation system of hour, how to collect statistical information is very cumbersome thing.In the prior art, a plan is typically defined to appoint
Business, the collection of Unified Policy is carried out to all tables, is caused many less tables of change also to be collected, is ultimately resulted in system
Resource serious waste, it is impossible to collection task is completed in stipulated time window.
In summary as can be seen that how to avoid consumption excessive when being collected to oracle database table statistical information
System resource be the problem of having to be solved at present.
The content of the invention
In view of this, it is an object of the invention to provide a kind of oracle database table statistical information collection method and it is
System, realizes the purpose for avoiding consuming excessive system resource when being collected to oracle database table statistical information.Its
Concrete scheme is as follows:
A kind of oracle database table statistical information collection method, including:
Determine the variable quantity of object table in oracle database;
Judge whether the variable quantity is less than default variable quantity threshold value, if it is, forbidding collecting the system of the object table
Information is counted, if it is not, then the statistical information to the object table is collected.
Optionally, the process for determining the variable quantity of object table in oracle database, including:
Dba_tab_modifications views are refreshed;
Obtain the data variation of the object table recorded in the dba_tab_modifications views after refreshing
Record strip number;
Using the data variation record strip number, the variable quantity of the object table is determined.
Optionally, the process that the statistical information to the object table is collected, including:
The amount of capacity of the object table is determined, target capacity size is obtained;
According to the first default mapping relations, oversampling ratio corresponding with the target capacity size is determined, target is obtained
Oversampling ratio;Wherein, negatively correlated relation between amount of capacity and the size of oversampling ratio;
According to the second default mapping relations, concurrent process number corresponding with the target capacity size is determined, mesh is obtained
Mark into number of passes;Wherein, correlation between amount of capacity and the size of concurrent process number;
According to the destination sample ratio, the statistical information to the object table carries out corresponding sampling processing, and is this
Secondary sampling process opens N number of Parallel Service process;Wherein, N values are consistent with the size of the target process number.
Optionally, first mapping relations, including:
If the target capacity size is less than 1G, oversampling ratio corresponding with the target capacity size is 100%;
If the target capacity size is more than or equal to 1G, and less than 10G, then it is corresponding with the target capacity size
Oversampling ratio is 50%;
If the target capacity size is more than or equal to 10G, and less than 50G, then it is corresponding with the target capacity size
Oversampling ratio be 30%;
If the target capacity size is more than or equal to 50, oversampling ratio corresponding with the target capacity size is
20%.
Optionally, second mapping relations, including:
If the target capacity size is less than 1G, concurrent process number corresponding with the target capacity size is 0;
If the target capacity size is more than or equal to 1G, and less than 10G, then it is corresponding with the target capacity size
Concurrent process number is 4;
If the target capacity size is more than or equal to 10G, and less than 50G, then it is corresponding with the target capacity size
Concurrent process number be 8;
If the target capacity size is more than or equal to 50, concurrent process number corresponding with the target capacity size is
12。
The present invention further correspondingly discloses a kind of oracle database table statistical information collection system, including:
Variable quantity determining module, the variable quantity for determining object table in oracle database;
Judge module, for judging whether the variable quantity is less than default variable quantity threshold value;
Disabled module, for judging that the variable quantity is less than the default variable quantity threshold value when the judge module, then prohibits
Only collect the statistical information of the object table;
Collection module, for judging that the variable quantity is more than or equal to the default variable quantity threshold when the judge module
Value, then the statistical information to the object table is collected.
Optionally, the variable quantity determining module, including:
View refresh unit, for refreshing to dba_tab_modifications views;
Change information acquiring unit, is recorded for obtaining in the dba_tab_modifications views after refreshing
The object table data variation record strip number;
Variable quantity determining unit, for utilizing the data variation record strip number, determines the variable quantity of the object table.
Optionally, the collection module, including:
Size determining unit, the amount of capacity for determining the object table, obtains target capacity size;
Ratio-dependent unit, for according to the first default mapping relations, determining corresponding with the target capacity size
Oversampling ratio, obtains destination sample ratio;Wherein, negatively correlated relation between amount of capacity and the size of oversampling ratio;
Enter number of passes determining unit, for according to the second default mapping relations, determining corresponding with the target capacity size
Concurrent process number, obtain target process number;Wherein, correlation between amount of capacity and the size of concurrent process number;
Intelligence sample unit, according to the destination sample ratio, the statistical information to the object table is adopted accordingly
Sample processing, and open N number of Parallel Service process for this sampling process;Wherein, N values and the size phase one of the target process number
Cause.
Optionally, first mapping relations, including:
If the target capacity size is less than 1G, oversampling ratio corresponding with the target capacity size is 100%;
If the target capacity size is more than or equal to 1G, and less than 10G, then it is corresponding with the target capacity size
Oversampling ratio is 50%;
If the target capacity size is more than or equal to 10G, and less than 50G, then it is corresponding with the target capacity size
Oversampling ratio be 30%;
If the target capacity size is more than or equal to 50, oversampling ratio corresponding with the target capacity size is
20%.
Optionally, second mapping relations, including:
If the target capacity size is less than 1G, concurrent process number corresponding with the target capacity size is 0;
If the target capacity size is more than or equal to 1G, and less than 10G, then it is corresponding with the target capacity size
Concurrent process number is 4;
If the target capacity size is more than or equal to 10G, and less than 50G, then it is corresponding with the target capacity size
Concurrent process number be 8;
If the target capacity size is more than or equal to 50, concurrent process number corresponding with the target capacity size is
12。
In the present invention, oracle database table statistical information collection method, including:Determine target in oracle database
The variable quantity of table;Judge whether variable quantity is less than default variable quantity threshold value, if it is, forbidding collecting the statistics letter of object table
Breath, if it is not, then the statistical information to object table is collected.
It can be seen that, the present invention first determines mesh before the statistical information of object table is collected in oracle database
The variable quantity of table is marked, then judges whether the variable quantity is more than default variable quantity threshold value, the present invention is more than pre- in above-mentioned variable quantity
If in the case of variable quantity threshold value, side is collected to the statistical information of object table, otherwise just forbids being collected object table,
So as to carry out statistical information collection processing to object table in the case of avoiding variable quantity less, it is possible thereby to avoid consuming
Many system resource.Therefore, the present invention is realized to be avoided disappearing when being collected oracle database table statistical information
The purpose of the excessive system resource of consumption.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the accompanying drawing used required in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
The embodiment of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can also basis
The accompanying drawing of offer obtains other accompanying drawings.
Fig. 1 is a kind of oracle database table statistical information collection method flow chart disclosed in the embodiment of the present invention;
Fig. 2 is the flow chart that a kind of statistical information to object table disclosed in the embodiment of the present invention is collected;
Fig. 3 is a kind of oracle database table statistical information collection system structural representation disclosed in the embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation is described, it is clear that described embodiment is only a part of embodiment of the invention, rather than whole embodiments.It is based on
Embodiment in the present invention, it is every other that those of ordinary skill in the art are obtained under the premise of creative work is not made
Embodiment, belongs to the scope of protection of the invention.
The embodiment of the invention discloses a kind of oracle database table statistical information collection method, shown in Figure 1, the party
Method includes:
Step S11:Determine the variable quantity of object table in oracle database.
It should be noted that above-mentioned object table can be any table in oracle database.
Step S12:Judge whether variable quantity is less than default variable quantity threshold value, if it is, into step S13, if not,
Then enter step S14.
Step S13:Forbid collecting the statistical information of object table.
Step S14:Statistical information to object table is collected.
It can be seen that, the embodiment of the present invention is before the statistical information of object table is collected in oracle database, first really
The variable quantity of object table is made, then judges whether the variable quantity is more than default variable quantity threshold value, the embodiment of the present invention is above-mentioned
In the case that variable quantity is more than default variable quantity threshold value, side is collected to the statistical information of object table, is otherwise just forbidden to mesh
Mark table is collected, so as to carry out statistical information collection processing to object table in the case of avoiding variable quantity less, thus
It can avoid consuming excessive system resource.Therefore, the embodiment of the present invention is realized to be counted to oracle database table
Avoid consuming the purpose of excessive system resource when information is collected.
The embodiment of the invention discloses a kind of specific oracle database table statistical information collection method, specifically include down
Face step S21 to S26:
Step S21:Dba_tab_modifications views are refreshed.
Step S22:Obtain the data variation of the object table recorded in the dba_tab_modifications views after refreshing
Record strip number.
Step S23:Using data variation record strip number, the variable quantity of object table is determined.
Step S24:Judge whether variable quantity is less than default variable quantity threshold value, if it is, into step S25, if not,
Then enter step S26.
Step S25:Forbid collecting the statistical information of object table.
Step S26:Statistical information to object table is collected.
Shown in Figure 2, in the present embodiment, the process that the above-mentioned statistical information to object table is collected specifically can be with
Including below step S261 to S264:
Step S261:The amount of capacity of object table is determined, target capacity size is obtained.
Step S262:According to the first default mapping relations, oversampling ratio corresponding with target capacity size is determined, is obtained
Destination sample ratio;Wherein, negatively correlated relation between amount of capacity and the size of oversampling ratio.
Specifically, above-mentioned first mapping relations, can include:
If target capacity size is less than 1G, oversampling ratio corresponding with target capacity size is 100%;If target capacity
Size is more than or equal to 1G, and less than 10G, then oversampling ratio corresponding with target capacity size is 50%;If target capacity
Size is more than or equal to 10G, and less than 50G, then oversampling ratio corresponding with target capacity size is 30%;If target capacity
Size is more than or equal to 50, then oversampling ratio corresponding with target capacity size is 20%.
Step S263:According to the second default mapping relations, concurrent process number corresponding with target capacity size is determined, is obtained
To target process number;Wherein, correlation between amount of capacity and the size of concurrent process number.
Specifically, above-mentioned second mapping relations, can include:
If target capacity size is less than 1G, concurrent process number corresponding with target capacity size is 0;If target capacity is big
It is small to be more than or equal to 1G, and less than 10G, then concurrent process number corresponding with target capacity size is 4;If target capacity size
More than or equal to 10G, and less than 50G, then concurrent process number corresponding with target capacity size is 8;If target capacity size
More than or equal to 50, then concurrent process number corresponding with target capacity size is 12.
Step S264:According to destination sample ratio, the statistical information to object table carries out corresponding sampling processing, and is this
Secondary sampling process opens N number of Parallel Service process;Wherein, N values are consistent with the size of target process number.
Further, the embodiment of the present invention further correspondingly discloses a kind of oracle database table statistical information collection system,
Shown in Figure 3, the system includes:
Variable quantity determining module 11, the variable quantity for determining object table in oracle database;
Judge module 12, for judging whether variable quantity is less than default variable quantity threshold value;
Disabled module 13, for judging that variable quantity is less than default variable quantity threshold value when judge module 12, then forbids collecting mesh
Mark the statistical information of table;
Collection module 14, for judging that variable quantity is more than or equal to default variable quantity threshold value when judge module 12, then to mesh
The statistical information of mark table is collected.
In the present embodiment, above-mentioned variable quantity determining module can specifically include view refresh unit, change information and obtain single
Member and variable quantity determining unit;Wherein,
View refresh unit, for refreshing to dba_tab_modifications views;
Change information acquiring unit, for obtaining the mesh recorded in the dba_tab_modifications views after refreshing
Mark the data variation record strip number of table;
Variable quantity determining unit, for utilizing data variation record strip number, determines the variable quantity of object table.
In addition, above-mentioned collection module, can specifically include size determining unit, ratio-dependent unit, enter number of passes determination list
Member and intelligence sample unit;Wherein,
Size determining unit, the amount of capacity for determining object table, obtains target capacity size;
Ratio-dependent unit, for according to the first default mapping relations, determining sampling corresponding with target capacity size
Ratio, obtains destination sample ratio;Wherein, negatively correlated relation between amount of capacity and the size of oversampling ratio;
Enter number of passes determining unit, for according to the second default mapping relations, determine it is corresponding with target capacity size simultaneously
Traveling number of passes, obtains target process number;Wherein, correlation between amount of capacity and the size of concurrent process number;
Intelligence sample unit, according to destination sample ratio, the statistical information to object table carries out corresponding sampling processing, and
N number of Parallel Service process is opened for this sampling process;Wherein, N values are consistent with the size of target process number.
Wherein, above-mentioned first mapping relations, can specifically include:
If target capacity size is less than 1G, oversampling ratio corresponding with target capacity size is 100%;If target capacity
Size is more than or equal to 1G, and less than 10G, then oversampling ratio corresponding with target capacity size is 50%;If target capacity
Size is more than or equal to 10G, and less than 50G, then oversampling ratio corresponding with target capacity size is 30%;If target capacity
Size is more than or equal to 50, then oversampling ratio corresponding with target capacity size is 20%.
Further, above-mentioned second mapping relations, can specifically include:
If target capacity size is less than 1G, concurrent process number corresponding with target capacity size is 0;If target capacity is big
It is small to be more than or equal to 1G, and less than 10G, then concurrent process number corresponding with target capacity size is 4;If target capacity size
More than or equal to 10G, and less than 50G, then concurrent process number corresponding with target capacity size is 8;If target capacity size
More than or equal to 50, then concurrent process number corresponding with target capacity size is 12.
It can be seen that, the embodiment of the present invention is before the statistical information of object table is collected in oracle database, first really
The variable quantity of object table is made, then judges whether the variable quantity is more than default variable quantity threshold value, the embodiment of the present invention is above-mentioned
In the case that variable quantity is more than default variable quantity threshold value, side is collected to the statistical information of object table, is otherwise just forbidden to mesh
Mark table is collected, so as to carry out statistical information collection processing to object table in the case of avoiding variable quantity less, thus
It can avoid consuming excessive system resource.Therefore, the embodiment of the present invention is realized to be counted to oracle database table
Avoid consuming the purpose of excessive system resource when information is collected.
Finally, in addition it is also necessary to explanation, herein, such as first and second or the like relational terms be used merely to by
One entity or operation make a distinction with another entity or operation, and not necessarily require or imply these entities or operation
Between there is any this actual relation or order.Moreover, term " comprising ", "comprising" or its any other variant meaning
Covering including for nonexcludability, so that process, method, article or equipment including a series of key elements not only include that
A little key elements, but also other key elements including being not expressly set out, or also include be this process, method, article or
The intrinsic key element of equipment.In the absence of more restrictions, the key element limited by sentence "including a ...", is not arranged
Except also there is other identical element in the process including the key element, method, article or equipment.
A kind of oracle database table statistical information collection method and system provided by the present invention have been carried out in detail above
Thin to introduce, specific case used herein is set forth to the principle and embodiment of the present invention, and above example is said
The bright method and its core concept for being only intended to help to understand the present invention;Simultaneously for those of ordinary skill in the art, foundation
The thought of the present invention, will change, in summary, this specification content is not in specific embodiments and applications
It is interpreted as limitation of the present invention.
Claims (10)
1. a kind of oracle database table statistical information collection method, it is characterised in that including:
Determine the variable quantity of object table in oracle database;
Judge whether the variable quantity is less than default variable quantity threshold value, if it is, forbidding collecting the statistics letter of the object table
Breath, if it is not, then the statistical information to the object table is collected.
2. oracle database table statistical information collection method according to claim 1, it is characterised in that described to determine
The process of the variable quantity of object table in oracle database, including:
Dba_tab_modifications views are refreshed;
Obtain the data variation record of the object table recorded in the dba_tab_modifications views after refreshing
Bar number;
Using the data variation record strip number, the variable quantity of the object table is determined.
3. oracle database table statistical information collection method according to claim 1 or 2, it is characterised in that described right
The process that the statistical information of the object table is collected, including:
The amount of capacity of the object table is determined, target capacity size is obtained;
According to the first default mapping relations, oversampling ratio corresponding with the target capacity size is determined, destination sample is obtained
Ratio;Wherein, negatively correlated relation between amount of capacity and the size of oversampling ratio;
According to the second default mapping relations, concurrent process number corresponding with the target capacity size is determined, target is obtained and enters
Number of passes;Wherein, correlation between amount of capacity and the size of concurrent process number;
According to the destination sample ratio, the statistical information to the object table carries out corresponding sampling processing, and is adopted for this
Sample process opens N number of Parallel Service process;Wherein, N values are consistent with the size of the target process number.
4. oracle database table statistical information collection method according to claim 3, it is characterised in that described first reflects
Relation is penetrated, including:
If the target capacity size is less than 1G, oversampling ratio corresponding with the target capacity size is 100%;
If the target capacity size is more than or equal to 1G, and less than 10G, then sampling corresponding with the target capacity size
Ratio is 50%;
If the target capacity size is more than or equal to 10G, and less than 50G, then it is corresponding with the target capacity size to adopt
Sample ratio is 30%;
If the target capacity size is more than or equal to 50, oversampling ratio corresponding with the target capacity size is 20%.
5. oracle database table statistical information collection method according to claim 3, it is characterised in that described second reflects
Relation is penetrated, including:
If the target capacity size is less than 1G, concurrent process number corresponding with the target capacity size is 0;
If the target capacity size is more than or equal to 1G, and less than 10G, then it is corresponding with the target capacity size parallel
It is 4 to enter number of passes;
If the target capacity size is more than or equal to 10G, and less than 50G, then it is corresponding simultaneously with the target capacity size
Traveling number of passes is 8;
If the target capacity size is more than or equal to 50, concurrent process number corresponding with the target capacity size is 12.
6. a kind of oracle database table statistical information collection system, it is characterised in that including:
Variable quantity determining module, the variable quantity for determining object table in oracle database;
Judge module, for judging whether the variable quantity is less than default variable quantity threshold value;
Disabled module, for judging that the variable quantity is less than the default variable quantity threshold value when the judge module, then forbids receiving
Collect the statistical information of the object table;
Collection module, for judging that the variable quantity is more than or equal to the default variable quantity threshold value when the judge module, then
Statistical information to the object table is collected.
7. oracle database table statistical information collection system according to claim 6, it is characterised in that the variable quantity
Determining module, including:
View refresh unit, for refreshing to dba_tab_modifications views;
Change information acquiring unit, for obtaining the institute recorded in the dba_tab_modifications views after refreshing
State the data variation record strip number of object table;
Variable quantity determining unit, for utilizing the data variation record strip number, determines the variable quantity of the object table.
8. the oracle database table statistical information collection system according to claim 6 or 7, it is characterised in that the receipts
Collect module, including:
Size determining unit, the amount of capacity for determining the object table, obtains target capacity size;
Ratio-dependent unit, for according to the first default mapping relations, determining sampling corresponding with the target capacity size
Ratio, obtains destination sample ratio;Wherein, negatively correlated relation between amount of capacity and the size of oversampling ratio;
Enter number of passes determining unit, for according to the second default mapping relations, determining corresponding simultaneously with the target capacity size
Traveling number of passes, obtains target process number;Wherein, correlation between amount of capacity and the size of concurrent process number;
Intelligence sample unit, according to the destination sample ratio, the statistical information to the object table is carried out at corresponding sampling
Reason, and open N number of Parallel Service process for this sampling process;Wherein, N values are consistent with the size of the target process number.
9. oracle database table statistical information collection system according to claim 8, it is characterised in that described first reflects
Relation is penetrated, including:
If the target capacity size is less than 1G, oversampling ratio corresponding with the target capacity size is 100%;
If the target capacity size is more than or equal to 1G, and less than 10G, then sampling corresponding with the target capacity size
Ratio is 50%;
If the target capacity size is more than or equal to 10G, and less than 50G, then it is corresponding with the target capacity size to adopt
Sample ratio is 30%;
If the target capacity size is more than or equal to 50, oversampling ratio corresponding with the target capacity size is 20%.
10. oracle database table statistical information collection system according to claim 8, it is characterised in that described second
Mapping relations, including:
If the target capacity size is less than 1G, concurrent process number corresponding with the target capacity size is 0;
If the target capacity size is more than or equal to 1G, and less than 10G, then it is corresponding with the target capacity size parallel
It is 4 to enter number of passes;
If the target capacity size is more than or equal to 10G, and less than 50G, then it is corresponding simultaneously with the target capacity size
Traveling number of passes is 8;
If the target capacity size is more than or equal to 50, concurrent process number corresponding with the target capacity size is 12.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710338614.4A CN107066625A (en) | 2017-05-12 | 2017-05-12 | A kind of oracle database table statistical information collection method and system |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710338614.4A CN107066625A (en) | 2017-05-12 | 2017-05-12 | A kind of oracle database table statistical information collection method and system |
Publications (1)
Publication Number | Publication Date |
---|---|
CN107066625A true CN107066625A (en) | 2017-08-18 |
Family
ID=59597782
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710338614.4A Pending CN107066625A (en) | 2017-05-12 | 2017-05-12 | A kind of oracle database table statistical information collection method and system |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107066625A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107862042A (en) * | 2017-11-06 | 2018-03-30 | 中国银行股份有限公司 | A kind of control method and device of data base concurrency degree |
CN108829768A (en) * | 2018-05-29 | 2018-11-16 | 中国银行股份有限公司 | A kind of collection method and device of statistical information |
CN110515963A (en) * | 2019-08-30 | 2019-11-29 | 北京东软望海科技有限公司 | Collect method, apparatus, electronic equipment and the readable storage medium storing program for executing of statistical information |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20040243555A1 (en) * | 2003-05-30 | 2004-12-02 | Oracle International Corp. | Methods and systems for optimizing queries through dynamic and autonomous database schema analysis |
CN102063449A (en) * | 2009-11-12 | 2011-05-18 | 中国移动通信集团浙江有限公司 | Method and device for improving reliability of statistic information of data object in database |
CN103412911A (en) * | 2013-08-02 | 2013-11-27 | 中国工商银行股份有限公司 | Method and device for monitoring performance of database system |
-
2017
- 2017-05-12 CN CN201710338614.4A patent/CN107066625A/en active Pending
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20040243555A1 (en) * | 2003-05-30 | 2004-12-02 | Oracle International Corp. | Methods and systems for optimizing queries through dynamic and autonomous database schema analysis |
CN102063449A (en) * | 2009-11-12 | 2011-05-18 | 中国移动通信集团浙江有限公司 | Method and device for improving reliability of statistic information of data object in database |
CN103412911A (en) * | 2013-08-02 | 2013-11-27 | 中国工商银行股份有限公司 | Method and device for monitoring performance of database system |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN107862042A (en) * | 2017-11-06 | 2018-03-30 | 中国银行股份有限公司 | A kind of control method and device of data base concurrency degree |
CN108829768A (en) * | 2018-05-29 | 2018-11-16 | 中国银行股份有限公司 | A kind of collection method and device of statistical information |
CN110515963A (en) * | 2019-08-30 | 2019-11-29 | 北京东软望海科技有限公司 | Collect method, apparatus, electronic equipment and the readable storage medium storing program for executing of statistical information |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN105956669A (en) | Vehicle maintenance strategy pushing method and device | |
CN100589418C (en) | The generation method and the generation system of alarm correlation rule | |
CN107066625A (en) | A kind of oracle database table statistical information collection method and system | |
CN106209862A (en) | A kind of steal-number defence implementation method and device | |
CN104317628A (en) | Mobile terminal and storage space cleaning method thereof | |
CN110084561A (en) | Breakpoint follow-up method, electronic device and readable storage medium storing program for executing | |
CN107730375B (en) | Tax map management method, system and terminal equipment | |
CN103714004A (en) | JVM online memory leak analysis method and system | |
CN105117107A (en) | Application program icon managing method and application program icon managing system | |
CN102006198B (en) | Method and device for acquiring network failure association rule | |
CN104636240A (en) | Method for acquiring information report and terminal | |
CN105955876A (en) | Data monitoring processing method and apparatus | |
CN102801548A (en) | Intelligent early warning method, device and information system | |
CN104574141A (en) | Service influence degree analysis method | |
Nicolis et al. | Extreme events in deterministic dynamical systems | |
Laguna et al. | Science parks approaches to address sustainability: A qualitative case study of the science parks in Spain | |
CN108775914A (en) | A kind of transit equipment detection method and detection device | |
CN102945254A (en) | Method for detecting abnormal data among TB-level mass audit data | |
CN107943912A (en) | A kind of response type Resource TOC data visualization management method, terminal and device | |
CN105429792A (en) | User behavior flow obtaining method and device and user behavior analysis method and system | |
CN107843779A (en) | A kind of Power System Fault Record classifying and analyzing method and system based on fuzzy clustering | |
CN104346337A (en) | Method and device for intercepting junk information | |
CN106127331A (en) | Civil aviaton based on rough set theory radio interference Forecasting Methodology | |
CN110457133A (en) | A kind of processing method and system of operating-system resources exception | |
CN103530297A (en) | Method and device capable of automatically carrying out website analysis |
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: 20170818 |