| Stats gather-LAST_ANALYZED column is not updated (merged) [message #566060] |
Tue, 11 September 2012 03:18  |
 |
sathik123
Messages: 37
Registered: December 2010
Location: chennai
|
Member |
|
|
Hi
Using below script i run stats gather job..But LAST_ANALYZED column is not updated for the table.. Please help me on this why it was not updated..My DB version is 11.1.0.7.0
exec DBMS_STATS.GATHER_TABLE_STATS(ownname => 'XXXX', tabname => 'XXXXXX',estimate_percent =>5, method_opt => 'FOR ALL INDEXED COLUMNS SIZE AUTO', degree => 8, granularity => 'ALL',Cascade => TRUE);
|
|
|
|
|
|
| Re: LAST_ANALYZED column is not updated [message #566062 is a reply to message #566061] |
Tue, 11 September 2012 03:39  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Use SQL*Plus and copy and paste your session, the WHOLE session.
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.
In the end, FEEDBACK to your topic, you have been posted several questions and you NEVER tell us if it helps, if you have solved your problem and how.
No feedback, means we don't know if what we post is useful, so we can assume it is useless to answer and try to help you.
Regards
Michel
[Updated on: Tue, 11 September 2012 03:39] Report message to a moderator |
|
|
|
| Stats gather-LAST_ANALYZED column is not updated [message #566089 is a reply to message #566060] |
Tue, 11 September 2012 06:31 |
|
sathik123
Messages: 37
Registered: December 2010
Location: chennai
|
Member |
|
|
Hi
Applogies for previous mistake.Using below script i ran the stats gather job for partitined table on yesterday(10sep)..But LAST_ANALYZED column is not updated in the dba_table, it shows old date in last_analyzed column But in the dba_tab_partitions last_analyzed column shows diffrent date as below
SQL> select TABLE_NAME,PARTITION_NAME,LAST_ANALYZED from dba_tab_partitions where table_name='DLM_PERFORMANCE_DATA' order by 2;
TABLE_NAME PARTITION_NAME LAST_ANALYZ
------------------------------ ------------------------------ -----------
DLM_PERFORMANCE_DATA DLM_06012012 29-FEB-2012
DLM_PERFORMANCE_DATA SYS_P2662459 15-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662479 16-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662539 17-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662560 18-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662580 18-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662600 19-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662639 21-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662660 21-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662699 23-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662739 24-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662779 25-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662819 25-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662859 26-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662899 28-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662939 29-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662979 30-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2662999 31-AUG-2012
DLM_PERFORMANCE_DATA SYS_P2663039 01-SEP-2012
DLM_PERFORMANCE_DATA SYS_P2663080 01-SEP-2012
DLM_PERFORMANCE_DATA SYS_P2663119 02-SEP-2012
DLM_PERFORMANCE_DATA SYS_P2663140 05-SEP-2012
DLM_PERFORMANCE_DATA SYS_P2663160 05-SEP-2012
DLM_PERFORMANCE_DATA SYS_P2663179 06-SEP-2012
DLM_PERFORMANCE_DATA SYS_P2663199 07-SEP-2012
DLM_PERFORMANCE_DATA SYS_P2663239 08-SEP-2012
DLM_PERFORMANCE_DATA SYS_P2663260 08-SEP-2012
DLM_PERFORMANCE_DATA SYS_P2663280 09-SEP-2012
DLM_PERFORMANCE_DATA SYS_P2663319 09-SEP-2012
DLM_PERFORMANCE_DATA SYS_P2663339
My DB version is 11.1.0.7.0
Please help me to understand why it was not updated. If you could help that will be useful..
exec DBMS_STATS.GATHER_TABLE_STATS(ownname => 'XXXX', tabname => 'XXXXXX',estimate_percent =>5, method_opt => 'FOR ALL INDEXED COLUMNS SIZE AUTO', degree => 8, granularity => 'ALL',Cascade => TRUE);
Thanks and Regards
iamsathk
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
) 1 Vote
] 
Blog
Search
Help
Members
Register
Login
Home
