Home » RDBMS Server » Server Administration » oracle process
oracle process [message #51040] Mon, 22 April 2002 20:42 Go to next message
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 Go to previous message
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
Previous Topic: Temporary Data Files
Next Topic: how to enable feature for function-based indexes
Goto Forum:
  


Current Time: Wed Dec 25 09:21:17 CST 2024