OraFAQ Forum: Server Administration » Re: archive log list doesn't work as sysdba

Home » RDBMS Server » Server Administration » Re: archive log list doesn't work as sysdba

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

Re: archive log list doesn't work as sysdba [message #55597]

Mon, 03 February 2003 11:07

Somesh Dhawas
Messages: 9
Registered: January 2003

Junior Member

Mahesh,

Thanks for your email You've been real helpful. I shall try this. In the meatime I've a question for you on Oracle 8.1.7.4 (8i) on Unix.

Can I kill a session in Oracle whose Unix process-id donesn't exist anymore.

Would ater system kill session work in this situation ?
Should I try to kill it thorough DBA studio and kill do a post transaction kill ?

I would doubt that Oracle will be able to kill this session of mine if the unix process_id is gone. Actually a row is locked by this hung session and some other process is trying to acces the same record.

Can you help ?

Thanks
-Somesh

Report message to a moderator

Previous Topic:	space to run oracle
Next Topic:	Didicated Server and Shared Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 07:28:44 CDT 2024