Using the following steps one can setup vim/gvim to run on windows. 1) Add the following new variable VIM on your system. Example: VIM=C:\apps\vim\vim73 (Where C:\apps\vim\vim73 is where vim/gvim is installed) 2) Copy the file %VIM%\vimrc_example.vim as _vimrc in %VIM% folder 3) Add the following 2 lines at the end in %VIM%\_vimrc so it sets … Continue reading How to set vim/gvim on windows?
Tag: windows
Create a database manually on windows in 11g?
-- Step 1) set up environment variables needed (ORACLE_HOME, ORACLE_SID and add ORACLE_HOME\bin to PATH) set ORACLE_HOME=e:\oracle\11g\product\11.2.0.1 set PATH=%ORACLE_HOME%\bin;%PATH% set ORACLE_SID=TESTDB -- Step 2) Sample pfile (parameter file) for the instance and place it in %ORCALE_HOME%\dbs db_name='TESTDB' memory_target=500m processes=150 audit_file_dest='E:\oracle\DB\TESTDB\admin\adump' audit_trail ='db' db_block_size=8192 db_domain='' diagnostic_dest=E:\oracle\DB\TESTDB\diagnostic_dest dispatchers='(PROTOCOL=TCP) (SERVICE=TESTDBXDB)' open_cursors=300 remote_login_passwordfile='EXCLUSIVE' undo_tablespace='UNDOTBS1' control_files = ("E:\oracle\DB\TESTDB\oradata\control1.ora", "E:\oracle\DB\TESTDB\oradata\control2.ora") compatible … Continue reading Create a database manually on windows in 11g?
How to monitor CPU of oracle processes on Windows?
Using QSlice one can monitor CPU usage for individual thread on a windows box. Qslice can be downloaded from the following url http://www.microsoft.com/downloads/en/details.aspx?familyid=6247BB76-13C5-4E0E-B800-53DC1B84A94C&displaylang=en By clicking on the oracle.exe in Qslice it displays all threads and CPU usage for each thread, so using the following SQL you can match the corresponding SID. SQL> select to_char(p.spid, 'xxxxxxxx') … Continue reading How to monitor CPU of oracle processes on Windows?
How to configure Windows to display a message when users log on?
Window tools
Here are some of the windows tools that can be used when working on window internals. Autoruns (autoruns.exe) - http://technet.microsoft.com/en-us/sysinternals/bb963902.aspx Access Chk - http://technet.microsoft.com/en-us/sysinternals/bb664922.aspx Dependency walker - http://dependencywalker.com/ List DLLs - http://technet.microsoft.com/en-us/sysinternals/bb896656.aspx Handle Viewer - http://technet.microsoft.com/en-us/sysinternals/bb896655.aspx Logon Sessions - http://technet.microsoft.com/en-us/sysinternals/bb896769.aspx Process Explorer - http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx Object viewer - http://technet.microsoft.com/en-us/sysinternals/bb896657.aspx Service control - sc.exe (built-in tool) Task … Continue reading Window tools
Set title of a window
Using the script one can set the title of a window, one of the reason for doing would be distinguish a window from another. The following example was tried on AIX. $ cat settitle.ksh TITLEBAR="33]0;${1} 07" echo $TITLEBAR # in this example the title of the window will change to "Hi" $ ./settitle.ksh Hi
How to tell uptime on windows?
Using one of the following commands one can tell the uptime on windows i.e. the time since the last reboot occurred. REM on WinXP C:> net statistics workstation | find /I "Statistics since" Statistics since 12/28/2008 10:35 AM REM on WinXP, Windows 2000 C:\>systeminfo | find /I "System Up Time" System Up Time: 1 Days, … Continue reading How to tell uptime on windows?
Killing an Oracle thread on Windows
On Windows for each instance all oracle sessions are thread based and are part of one Oracle process (oracle.exe), so killing oracle.exe would crash your entire instance. Therefore using the utility orakill.exe one can kill user's session. Using the following SQL one can find the thread id of the oracle process. SQL> SELECT a.username, a.osuser, … Continue reading Killing an Oracle thread on Windows
alexlima.com 