-
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?
I'm stmontgo and I approve of this message
-
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
-
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?
I'm stmontgo and I approve of this message
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|