Clear Dead Oracle Processes
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Clear Dead Oracle Processes

  1. #1
    Join Date
    Nov 2000
    Posts
    34

    Lightbulb 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

  2. #2
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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

  3. #3
    Join Date
    Mar 2004
    Location
    IA USA
    Posts
    257
    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.

  4. #4
    Join Date
    Nov 2000
    Posts
    34
    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

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    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

  6. #6
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    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

  7. #7
    Join Date
    May 2002
    Location
    California, USA
    Posts
    175
    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

  8. #8
    Join Date
    Nov 2000
    Posts
    34
    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
  •  



Click Here to Expand Forum to Full Width