Clear Dead Oracle Processes

Hi,

We are using Oracle 9.2.0.4 on Tru64 5.1 Unix.

Processes (Oracle) which are marked Dead are not getting clear on our system.

Documentaion I read I found that in 9.2.04 there is bug relates to PMON for this.

Profile idle_time and killed sniped status session is not exactly our requirement.

Is there any alternate solution to clear dead oracle session or processes ?

Is there any init.ora parameter or configuration file I can update ?

Your guidance will be appriciated.

Regards
Jayesh

how do you know the processes are not getting cleared, how long do you wait, where do you look to make this determination?

not too sure about your problem. you want to kill
the dead session or you want to kill process?

the session is differnent from process.

if i understand your post correctly, you found out some
orphan oracle processes. that means that the session is already ended, the process is still there.

i guess the only way is to shut down database to clear those
orphan processes.

Yes Session is ended but its processes are still on system.
And wants to clear those processes.
Except shuting down database is there any other recommendations ?

Thanks
Jayesh

Quote:

---

Originally posted by Lily_Liu_2004
not too sure about your problem. you want to kill
the dead session or you want to kill process?

the session is differnent from process.

if i understand your post correctly, you found out some
orphan oracle processes. that means that the session is already ended, the process is still there.

i guess the only way is to shut down database to clear those
orphan processes.

---

all right hold the phone, are you saying to reboot the database everytime an os process does not disappear immediately?

PMON frees up the resources in Oracle, are you saying the PMON is not doing this?

jayeshdba,

Did you set up resource_manager_plan? If yes, comment it out in init.ora or set it to null in sqlplus. It seems to be that there is a bug involved in 9.2.0.4.

Login as sys, and execute
ALTER SYSTEM SET RESOURCE_MAMANGER_PLAN="";

Did you see processes in the server?

Tamil

Check if resource_limit = true exists in your init.ora file or do

SQL> alter system set resource_limit = true;

That will enable the resorce management.

Also u can setup sqlnet.expire_time = 10 in your listener.ora file.


HTH,

clio_usa - OCP 8/8i/9i DBA

Hi,

Above setting is already in effect. But still we are having dead connections detection problem.

I am thinking to set up expiration_time=60 in sqlnet.ora file.

But there are multiple databases are running on the same server and version.

I am asked to set up above parameter to specific one database.

How can I specify above to specific database(SID) in sqlnet.ora?

Any instance specific parameter we can specify in sqlnet.ora?

Thanks
Jayesh