OraFAQ Forum: Server Administration » Clarificatons

Home » RDBMS Server » Server Administration » Clarificatons - oracle dba concepts (oracle : 9.2.0.8.0 o/s: hp-ux 11.28 )

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

Clarificatons - oracle dba concepts [message #380911]

Wed, 14 January 2009 00:33

kesavansundaram
Messages: 183
Registered: October 2007
Location: MUMBAI

Senior Member

Dear sir,

i would like to clarify the following queries:

1 - when we kill one session,sometimes, it takes time to kill it. but the status shows KILLED in OEM.
Please confirm the mechanism of killing the sessions...
Is there any specific time to kill one session or to mark the patricular session as KILLED ?

2 - during import, undo tablespace size is getting increased..
and once completed, the size increased is automatically getting shrinked.
please confirm why undo size is getting increased during import ?

3 - can we set MAXSIZE:UNLIMITED for an undo tablespace ?

4 - During import, archive files are getting generated...why ?

thank you,
kesavan.

Report message to a moderator

Re: Clarificatons - oracle dba concepts [message #380914 is a reply to message #380911]

Wed, 14 January 2009 00:52

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

Senior Member
Account Moderator

Repost with one question per topic in the appropriate forum.
Answering to multiple not related questions will lead to a mess that noone can benefit in futur.

This topic is locked.

Regards
Michel

[Updated on: Wed, 14 January 2009 00:53]

Report message to a moderator

Previous Topic:	How to move the datafiles from one place to another?
Next Topic:	Unable to resize the datafile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 18:11:40 CST 2024