No question at this time
DBA Top 10
1 M. Cadot 19800
2 A. Kavsek 13000
3 M. Hidayathullah ... 11400
4 B. Vroman 8500
5 P. Wisse 5900
6 T. Boles 5400
7 J. Schnackenberg 4500
8 P. Knibbs 2200
8 K. Pagadala 2200
10 G. Lambregts 2100
10 K. Van Nieuwenhov... 2100
About
DBA-Village
Download PLATO
The free tool for auditing and tuning your database
Version 55 now available
Sep 02, 2016
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users47979
Total active users1861
Act. users last 24h12
Act. users last hour1
Registered user hits last week625
Registered user hits last month1533
Go up

Refresh Statistik
Next thread: Get Query timing
Prev thread: pluggeable database compatiability

Message Score Author Date
Hello, a Big-Customer-Table getting everyday ne...... U U Jan 10, 2017, 15:45
You could check the incremental statistics update ...... Rob Pattyn Jan 10, 2017, 17:16
Dear, Please go throw following link and mos no...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Mirza Hidayathullah Baig Jan 11, 2017, 07:32
Unfortanetly the link will open completly when I h...... U U Jan 17, 2017, 01:35

Follow up by mail Click here


Subject: Refresh Statistik
Author: U U, Germany
Date: Jan 10, 2017, 15:45, 167 days ago
Oracle info: 11
Message: Hello,

a Big-Customer-Table getting everyday new date-partitions.
Is it possible to refresh ONLY the new added partiton in a table?

If the dba_stats goes for all partitons, it takes hours to go through all partitons and subpartitons.

Im using this command for refreshing the stat's:

dbms_stats.gather_table_stats('USER',TABLE_NAME);

THX
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Refresh Statistik
Author: Rob Pattyn, Belgium
Date: Jan 10, 2017, 17:16, 167 days ago
Message: You could check the incremental statistics update feature mentioned in
https://blogs.oracle.com/optimizer/entry/maintaining_statistics_on_large_partitioned_tables
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Refresh Statistik
Author: Mirza Hidayathullah Baig, United Kingdom
Date: Jan 11, 2017, 07:32, 167 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Dear,

Please go throw following link and mos note.

https://support.oracle.com/epmos/faces/CommunityDisplay?resultUrl=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F2857048&_afrLoop=319242237009430&resultTitle=Gathering+statistics+on+partitioned+and+non-partitioned+tables&commId=2857048&displayIndex=1&_afrWindowMode=0&_adf.ctrl-state=6waabiuwc_274

https://support.oracle.com/epmos/faces/CommunityDisplay?resultUrl=https%3A%2F%2Fcommunity.oracle.com%2Fthread%2F3732540&_afrLoop=319253776756660&resultTitle=best+way+to+gather+statistics+on+partitioned+tables+and+indexes&commId=3732540&displayIndex=2&_afrWindowMode=0&_adf.ctrl-state=6waabiuwc_291

How To Collect Statistics On Partitioned Table (Doc ID 1417133.1)

Regards
Mirza
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Refresh Statistik
Author: U U, Germany
Date: Jan 17, 2017, 01:35, 161 days ago
Message: Unfortanetly the link will open completly when I have A valid Support Identifier.
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here