Home » RDBMS Server » Server Administration » Stats gather-LAST_ANALYZED column is not updated (merged) (11.1.0.7.0)  () 1 Vote
Stats gather-LAST_ANALYZED column is not updated (merged) [message #566060] Tue, 11 September 2012 03:18 Go to next message
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 #566061 is a reply to message #566060] Tue, 11 September 2012 03:21 Go to previous messageGo to next message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
I gathering stats for the partitioned table.
Re: LAST_ANALYZED column is not updated [message #566062 is a reply to message #566061] Tue, 11 September 2012 03:39 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: Stats gather-LAST_ANALYZED column is not updated [message #566094 is a reply to message #566089] Tue, 11 September 2012 06:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do NOT create a new topic but continue on the previous and FORMAT your posts. I am tired to move and merge your topics.

We are still waiting for a feedback on your on your previous topics.

Regards
Michel

[Updated on: Tue, 11 September 2012 06:35]

Report message to a moderator

Re: Stats gather-LAST_ANALYZED column is not updated [message #566100 is a reply to message #566094] Tue, 11 September 2012 06:48 Go to previous messageGo to next message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
I do not know how to give a feed back..Pls navigate me to go give feed back..
Re: Stats gather-LAST_ANALYZED column is not updated [message #566104 is a reply to message #566100] Tue, 11 September 2012 06:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Go to your topics (click on your name and then on "show all messages by iamsathk") and put a feedback that is a text, an answer, the solution you got, some thanks just like you posted this message.

Regards
Michel

[Updated on: Tue, 11 September 2012 06:53]

Report message to a moderator

Re: Stats gather-LAST_ANALYZED column is not updated [message #566118 is a reply to message #566104] Tue, 11 September 2012 07:20 Go to previous messageGo to next message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
please help me to get the answer for this..
Re: Stats gather-LAST_ANALYZED column is not updated (merged) [message #566135 is a reply to message #566060] Tue, 11 September 2012 08:09 Go to previous messageGo to next message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
I have given feedback..still do i need to do anything.
Re: Stats gather-LAST_ANALYZED column is not updated (merged) [message #566140 is a reply to message #566135] Tue, 11 September 2012 08:19 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does 'XXXXXX' = 'DLM_PERFORMANCE_DATA'?

Regards
Michel
Re: Stats gather-LAST_ANALYZED column is not updated (merged) [message #566157 is a reply to message #566140] Tue, 11 September 2012 09:33 Go to previous messageGo to next message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
Yes..
Re: Stats gather-LAST_ANALYZED column is not updated (merged) [message #566531 is a reply to message #566060] Mon, 17 September 2012 02:11 Go to previous message
sathik123
Messages: 37
Registered: December 2010
Location: chennai
Member
Here the proble is gather stats was not run successfully. we ran the in backround. it failed due to temp tablespace. It is out mistake not seeing the nohup log. Thanks for the your valuable time.
Previous Topic: Unable to extend extent (2 Merged)
Next Topic: su: (to orauser) root on none
Goto Forum:
  


Current Time: Fri Mar 29 00:24:36 CDT 2024