When I am giving the following command,
ps -elf|grep LOCAL=NO| wc -l
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?
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.
On a DB server with 9 databases:
SQL> !ps -elf|grep LOCAL=NO| wc -l
So, it's normal :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g