Why alter table move can repair the problem awr not generated ?
From: LuoLee.me <luolee.me_at_gmail.com>
Date: Mon, 06 Jan 2014 09:57:38 +0800
Message-ID: <2197d306-328e-4103-882d-823128e8f4b2_at_getmailbird.com>
Dear list,
I meet a problem that awr snapshot didn't generate correctly last week. I attempt to truncate the table sys.WRI$_OPTSTAT_HISTHEAD_HISTORY, but it didn't take effect. The other way, I use the "alter table sys.WRI$_OPTSTAT_HISTHEAD_HISTORY move" in restricted mode, it became effect. I know the way that truncate the table could do it sometimes, but this time, it fails.
Date: Mon, 06 Jan 2014 09:57:38 +0800
Message-ID: <2197d306-328e-4103-882d-823128e8f4b2_at_getmailbird.com>
Dear list,
I meet a problem that awr snapshot didn't generate correctly last week. I attempt to truncate the table sys.WRI$_OPTSTAT_HISTHEAD_HISTORY, but it didn't take effect. The other way, I use the "alter table sys.WRI$_OPTSTAT_HISTHEAD_HISTORY move" in restricted mode, it became effect. I know the way that truncate the table could do it sometimes, but this time, it fails.
We all know that "alter table move" could lower the highest watermark, but why it can repair the awr not generated problem, and why truncate could not here. Anyone know the truth ? Thanks in advance.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 06 2014 - 02:57:38 CET