find all columns in oracle named as district_id

I had a problem today. it was about changing all district_id in a whole database. so I need to find who used district_id as column name in tables in oracle.

here is how I find it.
Select COLUMN_NAME,table_name from user_tab_columns where table_name in ( select object_name from user_objects where object_type='TABLE' ) and COLUMN_NAME ='DISTRICT_ID' and I changed all values from found tables.

test your disks in linux

I have a linux server which has 2 disks on it. one of them is SSD and other is SATA disk. I wondered how fast is ssd is here is the output :) root@mascix.com: ~ # hdparm -t /dev/sdc /dev/sdc: Timing buffered disk reads: 598 MB in 3.00 seconds = 199.03 MB/sec root@mascix.com: ~ # hdparm -t /dev/sda /dev/sda: Timing buffered disk reads: 266 MB in 3.00 seconds = 88.55 MB/sec I should say this test done when server has load on it. pretty nice

EndoSession

one of my dead project which was about endoscopic data capture and saving in mp4 format. which was using blackmagic card to capture all data and it was working in linux with power of QT and ffmpeg.

I was thinking I may publish in google code svn repo. but there is no development plan on it so no need to have any repo. people who need to capture data from blackmagic capture card and save it in video file may find this as helpfull example.