Oracle DBA on Windows Tips and Articles
In this section you can find out the Oracle DBA on Windows Tips,techniques,technical papers and howto. This is absolutely free download section. There are lot of hidden techniques you can find out for managing and administrating Oracle on windows platform which is very useful for Remote DBA & Remote DBA Services.
Recent Articles List:
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.
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).
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.