Oracle : Tracing the session behind an ORA-54 resource busy message

select    oracle_username || ' (' || s.osuser || ')' username ,    s.sid || ',' || s.serial# sess_id ,    owner || '.' ||    object_name object ,    object_type ,    decode(    l.block     ,    0, 'Not Blocking'     ,    1, 'Blocking'     ,    2, 'Global') status ,    decode(v.locked_mode     ,    0, 'None'     ,    1, 'Null'     ,    2, 'Row-S (SS)'     ,    3, 'Row-X (SX)'     ,    4, 'Share'     ,    5, 'S/Row-X (SSX)'     ,    6, 'Exclusive', TO_CHAR(lmode)) mode_held from    v$locked_object v ,    dba_objects d ,    v$lock l ,    v$session s where     v.object_id = d.object_id and     v.object_id = l.id1 and     v.session_id = s.sid order by oracle_username ,    session_id ALTER SYSTEM KILL SESSION '109,27585'; --sess_id

Firefox 3.5 startup speedup

Remove files from the following directories which are scanned for security: C:\Documents and Settings\*user*\Local Settings\History C:\Documents and Settings\*user*\Local Settings\Temporary Internet Files C:\Documents and Settings\*user*\My Recent Documents C:\Documents and Settings\*user*\Temp\

Windows : Remote desktop - terminal server has exceeded the maximum ...

Getting a RC console session Console option for mstsc is removed from Pre vista sp1, xp sp3, server 2008 For connecting from older machines to older machines - mstsc -v:servername /f -console For connecting from new machines to older machines there is a different switch - mstsc -v:servername /f /admin For connecting from to new machines this way - cannot be done From the command line If you can get an admin connection - net use /user:[username] \\servername\share Then can query/kill sessions remote (below) Killing other non-console sessions From the command line - query session /server:servername Then reset session [ID] /server:servername

Windows : RunDll links

http://www.tburke.net/info/rundll.htm http://www.robvanderwoude.com/rundll.html http://www.mvps.org/vb/index2.html?tips/shellcpl.htm http://www.jsiinc.com/subh/tip3500/rh3562.htm

Sharepoint - Map subsite to a drive

Mapping the sharepoint wiki as a mapped drive From explorer (NOT internet explorer) choose Tools->Map Network Drive Select a free Drive: letter (e.g. Z:) In the Folder: field type the url http://sharepoint/Wiki Check reconnect at login as required Press Nb. Only sharepoint subsites can be mapped this way Adding sharepoint as a Network Place Run the add network place wizard - rundll32 netplwiz.dll,AddNetPlaceRunDll Click Next and Select “Choose another network location” click “Next”. Type the address of SharePoint site/sub site. (e.g. http://p2-Testsite/Testsubsite/) Type in the username and password. Navigate to the Document library/list and create a Shortcut. <b><b> </b></b> http://www.phase2.com/blog/?p=96

Sharepoint : Embed excel in the wiki

To add an excel spreadsheet for viewing in sharepoint Save spreadsheet to Sharepoint by selection sharepoint3/wiki/Wiki Pages/Oracle-docs/<spreadheet_name>.xlsx Choose "Site Actions" (blue lozenge top right hand side) and Edit Page Select Yellow "Add a Web Part" bar Tick All Web Parts->Business Data->Excel Web Access Select edit->Modify Shared Web Part Select Workbook field using <...> button (/wiki/Wiki Pages/Oracle-docs/<spreadheet_name>.xlsx) Amend display properties as required Nb. Autogenerate Title will override entered title Press <OK> Press Exit Edit Mode To update an excel spreadsheet stored/ussed in sharepoint Navigate to required spreadsheet in sharepoint and select Open->In Excel Select Open->In Excel Edit spreadsheet as required Overwrite using "Save As" to the original sharepoint location in (e.g. sharepoint3/wiki/Wiki Pages/Oracle-docs/<spreadheet_name>.xlsx) On the wiki page choose Update->Reload Workbook to check changes

SourceSafe : Get a release based on a label

To check out the labelled release from VSS using the GUI Open VSS repository \\lonnasc0601\Database VSS In the tree navigate and select the node $/schema/ODL_DBSERVICES Right click and select Working Folder - select a local foler to check out to and press Back on the selected tree node right click again and select Show History In the Project History Options dialog click 'Include Labels' and press In the history table select the line where the Action is Labeled 'ZPFL_20090618_ORACLE-172' and press In the Get Dialog click 'Recursive' and then 'Build Tree' and press If prompted to create a folder press To check out the labelled release from VSS using the command line Setup env set PATH=%PATH%;C:\Program Files\Microsoft Visual SourceSafe set SSDIR=\\lonnasc0601\Database VSS mkdir "C:\VSS\Database VSS7" Run get command for a label REM ss.exe get -V -R -GL -I- ss.exe get $\schemas\ODL_DBSERVICES -VZPFL_20090618_ORACLE-172 -R -GL"C:\VSS\Database VSS7" -I- To label projects (directories) in GUI Select required project, right click and select Label Enter  required label (eg. ZPFL_20090618_ORACLE-132) Label will be applied to project and recursively to all sub-projects and file To label a file in GUI Select required file, select label icon on toolbar (=clock and postit note) Enter label text (eg. ZPFL_20090618_ORACLE-132) NOTE that a new file version if created for each label entered on a distinct file To view labels in GUI Select project or file, right click and choose SHow History Check the 'Include Lables' check box Labels are included in the Action column