DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Shadow process

  1. #1
    Join Date
    Jan 2003
    Location
    Bahrain
    Posts
    109

    Shadow process

    hi,

    When I am giving the following command,
    ps -elf|grep LOCAL=NO| wc -l

    272

    I read in some artiles that LOCAL=No menas clients are trying to connect using NET 8. Is this a shadow process?

    Is this affect my performance? Because I have 6GB RAB. But I have only 3M Free. And also my performance is dam slow.

    Can anyone tell me how to tune it?

    Seelan

  2. #2
    Join Date
    Oct 2002
    Posts
    807
    Yes, LOCAL=NO is a shadow process.

    As for your performance concern, there isn't enough data to conclude anything. How many active sessions do you have? What's running on the database? What's the load? What's the SGA? Run statspack. One could go on and on.

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    On a DB server with 9 databases:

    SQL> !ps -elf|grep LOCAL=NO| wc -l
    579

    So, it's normal :-)
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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