Raspberry PI – Notes
raspberry pi 4 4g model b (cortex-a72) USB Keyboard & Mouse power supply for raspberry pi (and potentially a plastic case) micro sd card (64G), with adapter so that it can be connected to laptop…
Oracle – SQL – demo deadlock
create table t (processed_flag varchar(1)); create bitmap index t_idx on t(processed_flag); From Tom Kyte “Expert Oracle Database Architecture – 3rd Edition” insert into t values (‘N’); declare pragma autonomous_transaction; begin insert into t values (‘N’);…
Oracle OVM – How to create a local Unbreakable Linux Network mirror
Assumptions: a ULN subscription – Oracle Support for oracle Linux – i.e a valid CSI use the link: How to create a local Unbreakable Linux Network mirror
Oracle – Using ASH to Monitor Temporary Tablespace Usage
Using ASH to Monitor Temporary Tablespace Usage To use ASH (Active Session History) to monitor temporary tablespace usage use SQL similar to the query below. Detect the space used by queries.
Mini Keepass – Database File from iPhone to PC
Move keepass Database File from iPhone to PC tap Share icon (square/arrow) at bottom centre select “copy to (Google) Drive” save it somewhere on the drive In Google Drive, find the file and tap three…
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” –…
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…
Oracle – opatch examples
lspatches – list patches -all_nodes – RAC system