Of all inventive minds, the religious mind must be the most inventive.
It can justify a massacre by refering to a book that essentially says “Thou shall not kill”.
Of all inventive minds, the religious mind must be the most inventive.
It can justify a massacre by refering to a book that essentially says “Thou shall not kill”.
… maybe the title should be “Two Stupidities A Week”, but since both stupid actions had to do with measurement, or rather the lack thereof, let’s stick with the proverb.
SELECT
'ALTER SYSTEM KILL SESSION ''' || sid || ',' || serial# || '''; --',
s.sid,
s.serial#,
s.osuser,
s.username,
s.program,
status
FROM v$session s
WHERE status = 'INACTIVE';
You will get a list of statements you need to execute (just copy-pase) to kill the inactive sessions. Don’t listen to the guys telling you to do intricate System Administrator stuff on a command prompt, just use any JDBC tool.
EDIT: Single query which also lists the kill command if the “alter system kill session” trick did not work:
SELECT
'ALTER SYSTEM KILL SESSION ''' || s.sid || ',' || s.serial# ||
'''; -- kill -9 ' || p.spid,
s.sid,
s.serial#,
p.spid,
s.username,
s.program,
s.status
FROM v$session s, v$process p
WHERE s.paddr = p.addr
and (s.state='INACTIVE' or s.state='KILLED');
Thanks Bas en Jeroen!
Last week I tried to pull the rotor by using a rotor puller, and a socket (from a socket wrench set) to block it. The socket burried it’s way into the first thread of the crankshaft. After realising this, I tried to fit the rotor bolt, and it wouldn’t go in. Since only the first thread was damaged, I carefully drilled it out (only needed to go 2 mm deep), and now the rotor bolt fits nicely again.
For some reason I’ve been selected my the google company to have the new interface of gmail, where you can use google talk without even installing it! Yes you’ve read that right. When I log in to Google, I immediately see a quick contacts list of people who are online (on googletalk), and I can chat with them as if I was using the actual application! Only voice is missing, but I don’t use that anyway (Skype fan), so I am really happy.Now I can google-talk with my friends on *any* computer without having to install plugins, upgrading MSN otherwise contaminating the host’s computer. I am really impressed and amazed (for the past 3 hours or so). Go Google! I feel like buying a t-shirt now 🙂
Oh yeah, and it works in both FireFox and Microsoft Internet Explorer. And I am not kidding.
Auch, and I just missed the scoop on Slashdot… I could have been a succesful submitter. so close, so close.
Read More “Tapestry/OGNL: Could not find an adaptor for class XYZ” »
For some strange reason, my brother’s Kawasaki KLR Tengai dead-stopped. After starting it again, it made some strange noises. It also had lost a lot of oil somewhere along the way, so we decided to not run it again before we found the cause of the trouble. A few weeks ago we encountered a funny problem, we couldn’t loosen the rotor-bolt. In the Kawasaki KLR workshop manual is a picture of a strange wrench to hold the rotor. Ofcourse we’re cheap, so we wouldn’t spring for a nifty and probably expensive Kawasaki specialty tool for a very old bike which not worth more than the petrol that’s in the tank (okay, okay, but you get the point).
The rotor bolt is tightened to 195Nm. That’s a lot of force there, so it’s not surprising we couldn’t loosen it by holding the flywheeel with our hands. So we set out to create a tool of our own. We even ended up trying to bend an old 32mm Chrome-Vanadium wrench, which resulted in an empty gas can, a very hot workbench and nice colors on the wrench, without it bending even the slightest. We we barely able to heat it to the point it got red-hot, because the metal just conducts the heat away from the point you want to heat.
So I started mailing with Vincent, a good friend of mine which happens to be “quite handy” with motorbikes . He pointed out that you could also stop the rotor from turning by holding the piston. Because we wanted to measure the play in the bigend bearing we needed to remove the sleeve anyway, so I immediately went back to the workshop to do this. After removing the sleeve, I could easily make some wood pegs to block the piston. The wood would have to have a big surface and be strong enough to hould the piston, without damaging the piston or the engine casing.
It turned out to work great! I needed to attach a long bar to the socket wrench to be able to apply enough force to the bolt, but in the end I got it! In the picture on the left you can see a detail of how the wood blocks are resting on the engine casing. After loosening the bolt, there was absolutely no visible damage to the piston or the engine. Even greater news is that there is also virtually no play on the bigend bearing, so we don’t have to disasemble the crank.
When looking at the bolt, the results of applying so much force to the faces of the socket wrench become visible. We know for a fact that this bolt has been removed once before, so these wearmarks are from tightening and loosening the bolt just two times. I think we can tighten it one more time, but after that it needs to be replaced.
If you are looking for a nice alternative for Acrobat Reader, I can recommend Foxit PDF Reader. It is a very small program, free, and starts up in about 1/10th of the time Acrobat Reader takes to display just the splash screen (and subsequently, the annoying update manager). It can do anything I usually need when reading and printing PDF files, and the fullscreen mode is even richer than Adobe’s.
Adobe seems to have gone overboard with their userinterface. People just want to read the PDF, and not be bothered with complicated questions which very often result in downloading and installing megabytes of unwanted software on their machines. I will recommend alternatives to Acrobat Reader from now on, and I think the world will become a slightly better place 😉
Found out about this link by accidentally browsing accros Ian Lewis’s blog. You can find out what your movie rating is. It seems I’m not for “all ages”. 🙂
Examples: Batman, Naked Gun 33 1/3
For those that can read Dutch. This is a nice example of Dutch gasstation owners wanting to be compensated for the fact that gasoline (or any other fluid you can sell) schrinks when cooled.