Home » Infrastructure » Unix » Undo tablespace can't shrink and time in v$undostat is wronge
icon6.gif  Undo tablespace can't shrink and time in v$undostat is wronge [message #166963] Mon, 10 April 2006 09:13
Sanad
Messages: 2
Registered: April 2006
Location: Yemen
Junior Member
On 2006-03-21 11:00 P.M.,I have changed the time of server of AIX unix in my system to adjust the time, I delay four minutes and I didn't shutdown the database but I have stopped only the applications in my system. Now the time in OS is right.
But I saw two things :
1- The undo tablespace can't shrink and it always increase in size as explain in below:
I have log history:
On 2006-03-22 6:00 a.m.: Undo tablespace was 4.49%
On 2006-03-23 6:00 a.m.: Undo tablespace was 28.25%
On 2006-03-24 6:00 a.m.: Undo tablespace was 51.58%
On 2006-03-25 6:00 a.m.: Undo tablespace was 67.22%
On 2006-03-26 6:00 a.m.: Undo tablespace was 95%
After I resolved by:
create undo tablespace myundo2 datafile '/opt/oracle/MYUNDO2.dbf' size 50M;
alter system set undo_tablespace=myundo2 scope=both;
drop tablespace undotbs1 including contents;
create undo tablespace undotbs1 datafile '/dev/rsmora_undotbs1';
alter system set undo_tablespace=undotbs1 scope=both;
drop tablespace myundo2 including contents;
Again:
On 2006-03-27 06:00 a.m.: Undo tablespace was 19.05%
On 2006-03-28 06:00 a.m.: undo tablespace was 44.54%
On 2006-03-29 06:00 a.m.: Undo tablespace was 67.19%
On 2006-03-30 06:00 a.m.: Undo tablespace was 92.97%
Now undo tablespace was 100% and it reused expired extents for undo transactions.

2- The Begin_time and End_time in v$undostat is not right , it gave as 3/22/2031 3:49:31 AM and same time I have executed this sql: select sysdate from dual , it gave as 4/10/2006 4:42:06 PM

Then, do you think the operation of change time effect on the undo tablespace?
I wait your reply..

Report message to a moderator

Previous Topic: I am using a Scounix server with oracle.
Next Topic: comparing two .dat files
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jan 14 03:44:19 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.