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: 65155
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: ORA-12560: TNS:protocol adapter error
Next Topic: Unable to resize the datafile
Goto Forum:

Current Time: Wed Aug 23 14:41:37 CDT 2017

Total time taken to generate the page: 0.15262 seconds