It is damn! easy to see the running oracle services/processes status. But the same when comes to Windows its some thing different and tricky due to architectural differences.
we can see pmon,smon ..processes in UNIX as follows
ps -eaf | grep ora | grep -v grep | grep -v LOCAL
so obvious question that is there any way to see same kind of out put in windows command prompt too ...
Answer : In a windows environment for oracle, each detached precess runs as a concurrently running thread with single executable called Oracle.exe (Depends on version of oracle this exe file name vary slightly) . Using this executable with several threads , the threads all share the same code, memory space and other structures.
Now go to Task manager (use ctl + alt + del ) and go to processes tab.And in the list of processes also you will find only the main Oracle process but not the threads separately.
So in windows individual thread names (pmon ,smon etc) of oracle process ar not visible neither from Task manager nor from Services window.
We can find some information about them in the alert log when ever the database started.
snippet from the log looks like the below
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
How to see this log :
go to run -> cmd ->
Note : Assuming DB installed is oracle 10g.
Name vary accordingly.
We can also obtain the list threads and their assignment through SQL*Plus via the following query
select b.name bkpr , s.Username spid p.Pid from V$BGPROCESS b, V$SESSION s, V$PROCESS p, where p.Addr = b.Paddr(+) and p.Addr = s.Paddr
Note : The listener and dispatcher threads do not show up in this list.
In this way we can identify which process is associated with each thread.
Reference : Processes Vs Threads
1 comments to "where can I find pmon, smon ...oracle services in windows ?"
Powered by WidgetsForFree
- ► 2013 (19)
- ► 2011 (18)
- ► 2010 (35)
- ► 2009 (73)
- Mayhem in Mumbai - Nov 26, 2008 to Nov 29, 2008
- where is ldd installed in HP unix?
- Customs in work ..found in eenadu daily
- How to replace esacape(\n \t) charecters and ' cha...
- Facing error like this ? : bad interpreter: No suc...
- Educational blog Award ... For making everyone aro...
- Acts can win the hearts ...Friend
- where can I find pmon, smon ...oracle services in ...
- If love becomes marriage ?? ( ప్రెమే పెళ్ళయుతే ?? ...
- Harivarasanam ... song meaning and Mp3 downlaod
- How to see hardware details like name and type of ...
- Solaris 10 Zones Vs Solaris 10 physical server
- Ayyappa Deeksha - Required things - Total ayyappa ...
- యువతా!!! బ్లాగ్ అంటె?( Youth!!! blog means? ) - In...
- ▼ November (14)
My Blog List
- Airtel and vodafone GPRS settings for pocket PC phones
- Andhra 2 America
- Ayyappa Deeksha required things
- Blogs I watch !
- Captions for your bike
- DB2 FAQs
- Deepavali Vs The Goddes of sleep
- ETV - Dhee D2 D3
- Evolution of smoking in India Women
- How to make credit card payments?
- Java-J2EE interview preparation
- My SQL FAQs
- My Travelogues
- Old is blod - New is italic
- Online pay methids for credit cards
- Oracle FAQs
- Smoking in Indian Women
- Technology Vs Humans
- Twitter feeds for all Telugu stars on single page.
- Unix FAQs
- Unix best practices
- init 0, init 1, init 2 ..
- mCheck Application jar or jad download