-
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 :-)
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|