Home » RDBMS Server » Server Administration » Clarificatons - oracle dba concepts (oracle : o/s: hp-ux 11.28 )
Clarificatons - oracle dba concepts [message #380911] Wed, 14 January 2009 00:33 Go to next message
Messages: 181
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,
Re: Clarificatons - oracle dba concepts [message #380914 is a reply to message #380911] Wed, 14 January 2009 00:52 Go to previous message
Michel Cadot
Messages: 64954
Registered: March 2007
Location: Nanterre, France, http://...
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.


[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:

Current Time: Mon Jun 26 02:18:54 CDT 2017

Total time taken to generate the page: 0.10500 seconds