Oracle – Identify Locked Objects
Identify Locked Database Objects – Oracle
Oracle – 18c XE Flashback Pluggable Database Session
18c XE Flashback Pluggable Database Session
iPhone Heart Data – Export and Import into SQL Server for analysis
Export the data from iphone to an XML file – email to yourself – Open Heart App – Tap icon at top right of screen – Tap “Export Health Data at bottom of screen” –…
SQL Server – Add Powershell dbatools module
Add Powershell dbatools module Execute an elevated powershell session (Execute as administrator) and run the command: Import-Module dbatools Windows PowerShell Copyright (C) 2016 Microsoft Corporation. All rights reserved. Loading personal and system profiles took 756ms.…
Oracle – Install Clusterware – Test udp multicast on Private Interconnect (and get maximum MTU)
Test Multicast on Private Interconnect (and get maximum MTU) There are several ways to test multicast communication using udp. I was debugging an oracle Clusterware installation – the clusterware on the second node would not…
Windows – Start DOS prompt from Windows Explorer. Start Windows Explorer from DOS prompt
Start DOS prompt from Windows Explorer DOS prompt (cmd) can be launched from Wondows Explorer directly by typing cmd in the address bar. The result is a DOS prompt located at the same directory as…
Oracle – Monitor TEMP Tablespace
Monitor TEMP Tablespace with a DBMS_SCHEDULER job I was faced with a situation in which a process (Oracle pl/sql procedure within a package, scheduled outside Oracle in the evenings) was exhausting the TEMP tablespace. In…