Skip to content

Instantly share code, notes, and snippets.

org.springframework.transaction: TRACE
@mixomat
mixomat / gist:07cde90d3e66caa26da87619f8e15944
Created November 30, 2018 19:55
show upnp rules on edgeOS
show upnp2 rules
@mixomat
mixomat / setup alkoport
Last active January 1, 2017 17:16
install eventmachine gem with brew openssl
brew install postgresql
gem install eventmachine -v '1.0.3' -- --with-ldflags=-L/usr/local/opt/openssl/lib --with-cppflags=-I/usr/local/opt/openssl/include
ffmpeg -i input.mkv -c:v copy -c:a libfdk_aac -b:a 480k output.mk
@mixomat
mixomat / gist:4ceed10f291c5cfae0a14f1eb898a7b0
Created June 2, 2016 08:26
show merged remote branches
git branch -r --merged
@mixomat
mixomat / tablespace.sql
Last active August 29, 2015 14:26
oracle tablespace size
# used size
select tablespace_name, 'MB'||' '||round(sum(bytes/1024/1024)) "Used_Size" from dba_data_files group by tablespace_name;
# free size
select tablespace_name, 'MB'||' '||round(sum(bytes/1024/1024)) "Free_Size" from dba_free_space group by tablespace_name;
# extend tablespace size
alter database datafile <tablespace_name> autoextend on next 128m maxsize 8192m;
@mixomat
mixomat / gist:7e874c4dd13d8a461307
Created November 28, 2014 12:48
run on main thread without deadlock
void runOnMainQueueWithoutDeadlocking(void (^block)(void))
{
if ([NSThread isMainThread])
{
block();
}
else
{
dispatch_sync(dispatch_get_main_queue(), block);
}
@mixomat
mixomat / gist:62fa92e75d7ddf641766
Created November 26, 2014 21:42
run xcode unit test
xcodebuild -workspace xxx.xcworkspace -scheme xxx -sdk /Applications/Xcode.app/Contents/Developer/Platforms/iPhoneSimulator.platform/Developer/SDKs/iPhoneSimulator7.1.sdk build test
@mixomat
mixomat / reset_passwd.sh
Created October 27, 2014 09:45
reset oracle xe sys passwords
sqlplus / as sysdba
alter user "user" identified by "passwd";
sudo tmutil delete /Volumes/drive_name/Backups.backupdb/mac_name/YYYY-MM-DD-hhmmss