大约有 44,000 项符合查询结果（耗时：0.0434秒） [XML]
How to check Oracle database for long running queries
...SQL that is currently "ACTIVE":-
select S.USERNAME, s.sid, s.osuser, t.sql_id, sql_text
from v$sqltext_with_newlines t,V$SESSION s
where t.address =s.sql_address
and t.hash_value = s.sql_hash_value
and s.status = 'ACTIVE'
and s.username <> 'SYSTEM'
order by s.sid,t.piece
/
This shows locks....
How can I perform a `git pull` without re-entering my SSH password?
...reate a file called ~/.ssh/config and add the line:
IdentityFile ~/.ssh/my_key2_rsa
where ~/.ssh/my_key2_rsa is my key.
share
|
improve this answer
|
follow
...
Servlet for serving static content
...tiple url-pattern tags inside servlet-mapping
– vivid_voidgroup
May 22 '12 at 12:59
Just be careful with index files (...
How to determine MIME type of file in android?
...ring mimeType = null;
if (uri.getScheme().equals(ContentResolver.SCHEME_CONTENT)) {
ContentResolver cr = getAppContext().getContentResolver();
mimeType = cr.getType(uri);
} else {
String fileExtension = MimeTypeMap.getFileExtensionFromUrl(uri
.toString...
Return index of greatest value in an array
...
If you are utilizing underscore, you can use this nice short one-liner:
_.indexOf(arr, _.max(arr))
It will first find the value of the largest item in the array, in this case 22. Then it will return the index of where 22 is within the array, in this case 2.
...
How to convert an address into a Google Maps Link (NOT MAP)
...ps.google.com/maps?q=" + encodeURIComponent( $(this).text() ) + "' target='_blank'>" + $(this).text() + "</a>";
$(this).html(link);
});
});
Bonus:
I also came across a situation that called for generating embedded maps from the links, and though I'd share with future travelers:
...
How to print a string in fixed width?
...specific case a possible implementation could look like:
>>> dict_ = {'a': 1, 'ab': 1, 'abc': 1}
>>> for item in dict_.items():
... print 'value %3s - num of occurances = %d' % item # %d is the token of integers
...
value a - num of occurances = 1
value ab - num of occuran...
Fastest way to check if a string matches a regexp in ruby?
...y
require 'benchmark'
str = "aacaabc"
re = Regexp.new('a+b').freeze
N = 4_000_000
Benchmark.bm do |b|
b.report("str.match re\t") { N.times { str.match re } }
b.report("str =~ re\t") { N.times { str =~ re } }
b.report("str[re] \t") { N.times { str[re] } }
b.report("re =~ str...
Test if string is a number in Ruby on Rails
...
Create is_number? Method.
Create a helper method:
def is_number? string
true if Float(string) rescue false
end
And then call it like this:
my_string = '12.34'
is_number?( my_string )
# => true
Extend String Class.
If yo...
Given two directory trees, how can I find out which files differ by content?
...-dereference --new-file --no-ignore-file-name-case /dir1 /dir2 > dirdiff_1.txt
rsync --recursive --delete --links --checksum --verbose --dry-run /dir1/ /dir2/ > dirdiff_2.txt
The choice between them depends on the location of dir1 and dir2:
When the directories reside on two seperate drive...