Oracle DBA on Windows Tips and Articles

Oracle DBA monitors Oracle processes on unix using ps command. It is rumor that there is no alternate command available in windows for checking Oracle processes on Windows. This technical tip helps Oracle DBA specially to remote Oracle dba for monitoring Oracle processes on Windows using command line.Using "tasklist" command Oracle DBA can able to trace all running processes in windows including oracle,sqlplus,exp,imp and others. Means we can use this "tasklist" command on Windows because it is alternate of "ps" command of Unix in our daily Oracle DBA support work.

Read more

Oracle DBA is deleting Listener process on Windows using GUI tools of Oracle. Without those tools Oracle DBA is unable to delete Listener process because registry problem of Windows. Means we should need to delete each registry entries of Listener from registry manually. It is very difficult task for every Oracle DBA (on Windows). Otherwise we are unable to create new listener with same name because past entries exist in Windows registry and service. This technical article explains how to delete listener process without GUI tools and using command line in Windows. Using this command line trick you have no worry about registry entry and service of Listener. Even you can delete listener process without Oracle also (means in absent of Oracle software in Windows systems).

Read more

Every Oracle DBA has some confusion for tuning of network of windows database server. Network tuning of operating system is more crucial part for every Oracle DBA.Oracle database server is accepting and sending client requests using network. If we are able to boost performance of network then it will directly hit performance of client requests. For improving performance of network using TCP/IP protocol we have some tips. How to use windows tweak for tuning windows network.

Read more