OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » undo management (10.2.0.3,OEL)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

undo management [message #507845]

Wed, 18 May 2011 04:26

venkatgargeyagmailcom
Messages: 20
Registered: October 2010
Location: hyderabad

Junior Member

hi all,

In one of the interview,interviewer asked me as

if you have an undo tablespace which has autoextend on

feature.after a timegap your undo tablespace presently is 100GB

here as a DBA what you will do?

please send replies

thanks in advance

Report message to a moderator

Re: undo management [message #507847 is a reply to message #507845]

Wed, 18 May 2011 04:33

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Nothing unless this is a problem.
The first question should be "why the tablespace (or rather its files) is in autoextend mode?

Regards
Michel

Report message to a moderator

Re: undo management [message #507852 is a reply to message #507847]

Wed, 18 May 2011 04:43

venkatgargeyagmailcom
Messages: 20
Registered: October 2010
Location: hyderabad

Junior Member

Hi,

thanks for reply

undo tablespace's datafile is in auto extend mode

if size reaches 100GB what should as a DBA should do

Report message to a moderator

Re: undo management [message #507859 is a reply to message #507852]

Wed, 18 May 2011 05:23

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Wed, 18 May 2011 11:33

Nothing unless this is a problem.
The first question should be "why the tablespace (or rather its files) is in autoextend mode?

Regards
Michel

Report message to a moderator

Previous Topic:	Kill zombie
Next Topic:	Applying patch (10.2.0.1.0 to 10.2.0.4.0)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 12:24:24 CST 2024