| oracle process [message #51040] |
Mon, 22 April 2002 20:42  |
Sanjay Nag Ray
Messages: 3
Registered: October 2001
|
Junior Member |
|
|
1> how i will find how many process is going on in oracle background except default oracle process.
ii> how i will know how much resource is busy on oracle memory and how much is free
|
|
|
|
| Re: oracle process [message #51041 is a reply to message #51040] |
Mon, 22 April 2002 21:18  |
saleem
Messages: 65
Registered: January 2002
|
Member |
|
|
1 - select osuser, username, program, sid, serial#
from v$session;
2 - select * from v$sgastat where name like '%free%';
cheers
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
