I knows how to use the "ps -ef" command
in UNIX to see my Oracle background processes but I don't know how to see
the background processes in Windows. When I view Oracle processes on
Windows, all I see is one background process called oracle.exe
How do you see details on the Oracle background processes on Windows?Answer:
In Windows, the "thread" model is used, and Oracle dispatches his own
background tasks within the domain of the single process, oracle.exe.
Hence, you cannot see any background processes from the Windows OS
(but you can see listener process and parallel query slaves). To see
detauls about the background processes in Windows, you need to run a
dictionary query against the v$bgprocess v
iew to see what the
background processes are doing in Windows:
set lines 200
Please note that this inability to see the Oracle background processes in
Windows is actually a benefit because Oracle leverages on the thread model
in Windows, In UNIX, the OS dispatches and manages the background
tasks, but within Oracle on Windows, Oracle is able to manage the background
task activity directly.
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.