|
New versions of LatchProf and LatchProfX for latch contention troubleshooting and tuning
-
tanelpoder.com
-
16 years ago
-
eng
The LatchProf and LatchProfX scripts allow you to be more systematic with latch contention troubleshooting and tuning. No more guesswork is needed as these scripts give you exact session IDs and in this version also SQLIDs of the troublemaking applications. You can download the new versions here: LatchProf (reads V$ views) LatchProfX (reads X$ tables, but gives better info, run as SYS) Example output (with SQLID info) is below: S....
|
|
In user-interface design, always address the user as "you" (and never "me")
-
www.databasesandlife.com
-
16 years ago
-
eng
Computers, if they are addressing the user, should address the user as "you", not as "me". Computers need, from time to time, to address the user, for example “You have updated your setting successfully”. Some programs use the word “you” to address the user, some use the word “me” on the grounds that the user is reading it, and to them, they are “me”. However, using “me” to address someone is ridiculous! That’s as logical as a human u..
|
|
I just finished reading Mountains Beyond Mountains: The Quest of Dr. Paul Farmer, a Man Who Would Cure the World . I’ve known of the book for a couple years but never quite got around to reading it, likely because I knew it would challenge me. After the Haitian earthquake about a month ago, I remembered the book, decided I must read it, and then Barnes & Noble had it on sale. So here I am. Read More
|
|
I just finished reading Mountains Beyond Mountains: The Quest of Dr. Paul Farmer, a Man Who Would Cure the World . I’ve known of the book for a couple years but never quite got around to reading it, likely because I knew it would challenge me. After the Haitian earthquake about a month ago, I remembered the book, decided I must read it, and then Barnes & Noble had it on sale. So here I am. Read More
|
|
I’ve been looking for a good solution for versioning and synchronizing my dotfiles between machines for some time. I experimented with keeping all of ~ in subversion for a while, but it never worked out well for me. I’ve finally settled on a solution that I like using git, and so this is a writeup of my workflows for working with my dotfiles in git, in the hopes that someone else might find it useful.
|
|
I’ve been looking for a good solution for versioning and synchronizing my dotfiles between machines for some time. I experimented with keeping all of ~ in subversion for a while, but it never worked out well for me. I’ve finally settled on a solution that I like using git, and so this is a writeup of my workflows for working with my dotfiles in git, in the hopes that someone else might find it useful.
|
|
Oracle Troubleshooting: How to read Oracle ERRORSTACK output?!
-
tanelpoder.com
-
16 years ago
-
eng
I have written the first article to the troubleshooting section of my new website tech.E2SN.com: It’s about a very valuable Oracle troubleshooting tool -> ERRORSTACK trace. I cover 4 frequently asked questions there: Reading the current executing SQL statement text from errorstack trace Reading the current executing PL/SQL package and PL/SQL source code line number from errorstack trace Reading the current bind variable values from er..
|
|
Oracle Troubleshooting: How to read Oracle ERRORSTACK output?!
-
tanelpoder.com
-
16 years ago
-
eng
I have written the first article to the troubleshooting section of my new website tech.E2SN.com: It’s about a very valuable Oracle troubleshooting tool -> ERRORSTACK trace. I cover 4 frequently asked questions there: Reading the current executing SQL statement text from errorstack trace Reading the current executing PL/SQL package and PL/SQL source code line number from errorstack trace Reading the current bind variable values from er..
|
|
Why in the world do some programming languages include optional syntax? To a true type A engineer, this is incomprehensible and unacceptable. For example, in Adobe's ActionScript, statements may optionally be terminated with a semicolon. Usually this is not required, except in a few situations you need it. Evil. The statement that our number one job as software engineers is to manage complexitity really resonates with me, and willy nilly al....
|
|
Why in the world do some programming languages include optional syntax? To a true type A engineer, this is incomprehensible and unacceptable. For example, in Adobe's ActionScript, statements may optionally be terminated with a semicolon. Usually this is not required, except in a few situations you need it. Evil. The statement that our number one job as software engineers is to manage complexitity really resonates with me, and willy nilly al....
|
|
Many projects reference environment variables at either build time, install time, or run time to handle configuration that can't be made to work across all of the target environments. It is better to use plain text simple configuration files for the reasons that follow. First, let's quickly review common usage of environment variables. Directory path to supporting tools and libraries (JAVA_HOME, LD_LIBRARY_PATH, CATALINA_HOME, etc) Cust....
|
|
Many projects reference environment variables at either build time, install time, or run time to handle configuration that can't be made to work across all of the target environments. It is better to use plain text simple configuration files for the reasons that follow. First, let's quickly review common usage of environment variables. Directory path to supporting tools and libraries (JAVA_HOME, LD_LIBRARY_PATH, CATALINA_HOME, etc) Cust....
|
|
ouch. just... ouch. but awesome. but I'm glad to hear that bandcamp is still going strong behind-the-scenes!
|
|
ouch. just... ouch. but awesome. but I'm glad to hear that bandcamp is still going strong behind-the-scenes!
|
|
I have an Nginx frontend to serv everything but confluence which was not happy with my SSLized conf, here is the solution ! This doc is related to confluence but will works with any java apps in a tomcat First don’t use the standalone version of confluence (which is a Tomcat 5.5), use the EAR/WAR tar gz archive. We need Tomcat 6 cause we will use a “Valve” [RemoteIPValve](http://tomcat.apa che.org/tomcat-6.0-doc/api/org/apache/catalina/valv..
|
|
Software testing is a powerful tool when creating all types of applications. That’s why it is also so important to test it in details so that a chance of an unexpected fail is minimal. We say it so: all code you write must be tested with minimum 2 types of tests: positive and negative. A positive test is a test that verifies a correct functionality, a negative test verifies that a function will fail or throw an exception. Let’s see how it w..
|
|
Using Process Memory Matrix script for calculating Oracle process memory usage on Solaris
-
tanelpoder.com
-
16 years ago
-
eng
I just published a new script and article about calculating the real Oracle process memory usage on Solaris. The problem with V$PROCESS* views (and the V$SESSTAT) is that they will tell you what Oracle thinks it’s using, not the real amount of memory used. There will be discrepancies due how memory is actually allocated in OS, libraries out of Oracle’s control, the static memory areas inside Oracle binary and of course bugs.
|
|
Using Process Memory Matrix script for calculating Oracle process memory usage on Solaris
-
tanelpoder.com
-
16 years ago
-
eng
I just published a new script and article about calculating the real Oracle process memory usage on Solaris. The problem with V$PROCESS* views (and the V$SESSTAT) is that they will tell you what Oracle thinks it’s using, not the real amount of memory used. There will be discrepancies due how memory is actually allocated in OS, libraries out of Oracle’s control, the static memory areas inside Oracle binary and of course bugs.
|
|
If you want to generate code, make sure your target language is not Java
-
www.databasesandlife.com
-
16 years ago
-
eng
I tried to write a program using Java; it all seemed to be going well but then I hit a ridiculous limit. Java cannot be used for this type of problem. I have now completely re-written it in a different programming language, and that works fine. Be aware of this limit. I was unaware of it when I started this project. But it makes Java completely unsuitable for a whole class of problem.
|
|
I am currently actively interested in new opportunities due to changing circumstances with my current role. I’ve therefore uploaded a current curriculum vitae to this site .
|
|
I am currently actively interested in new opportunities due to changing circumstances with my current role. I’ve therefore uploaded a current curriculum vitae to this site .
|
|
Kyle Hailey has started putting together a much needed Oracle wait event reference. You can access it here . By the way, Oracle documentation also has a wait event reference section, it has more events, but it’s less detailed…
|
|
Kyle Hailey has started putting together a much needed Oracle wait event reference. You can access it here . By the way, Oracle documentation also has a wait event reference section, it has more events, but it’s less detailed…
|
|
Sometimes the interfaces you need just aren’t well documented, but thanks to the internets , some websearches , and a useful dictionary , you can often decipher random web documentation jargon to help you produce useful code . You can hire James and his team at m9rx corporation . You can follow James on Mastodon for more frequent updates and other random thoughts. You can follow James on Twitter for more freque..
|
|
Sometimes the interfaces you need just aren’t well documented, but thanks to the internets , some websearches , and a useful dictionary , you can often decipher random web documentation jargon to help you produce useful code . You can hire James and his team at m9rx corporation . You can follow James on Mastodon for more frequent updates and other random thoughts. You can follow James on Twitter for more freque..
|
|
I've updated the browser plugin to finally support full online multiplayer! Go try it! I think the plugin is now stable enough that I am promoting it as the officially recommended method of playing the game. :) Of course, there are still some problems. Namely, in Internet Explorer the mouse control doesn't work. Testing so far has shown Firefox 3 and Chrome (on Windows) handle the game very well. So give it a whirl, and please post an..
|