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.




Reply With Quote