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

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
579

So, it's normal :-)