ORACLEsid(LOCAL=NO)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORACLEsid(LOCAL=NO)

  1. #1
    Join Date
    Jul 2001
    Posts
    93
    Hi,

    We have our Oracle 8.1.7 production instance on Solaris 2.6. When a ps -afe is done on my database server, the multiple process names are oracledbname (LOCAL=NO). What are these processes? Does they cost a lot of system resources (e.g. memory)? Is there any way to prevent them to be started?

    Thanks.


  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    They are all the processes that are getting connected to the database server from a remote client. It also means the connection between the remote client and the server is still alive. If they are inactive, yes they would cost you the resources. As you may see, they would be holding a good amount of memory. You can do the top and see, how much of memory is used and how much they are entitled for. Normally they would go off if the user gets to close the connection. other wise, you can set the max idle time on the database, and clean them up, instead of killing them one by one manually.


    Sam

    [Edited by sambavan on 02-12-2002 at 11:56 AM]
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jul 2001
    Posts
    93
    Hi,

    We are using MTS. Is there any way to find whether these connections are dedicated or shared?.

    Thanks.

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