|
Adobe’s former CEO, Bruce Chizen, when asked ‘What advice do you have for new/young public companies?’, gave a response of ‘Go private’. While partially a joke he went on to elaborate something that many businesses seem to miss on. The main idea is that businesses are very nearsighted in their focus, they look at quarterly goals and in some cases yearly, but not where they want to be in 10 years. When companies become worried that head coun....
|
|
Advanced Oracle Troubleshooting Guide, Part 5: Sampling V$ stuff with WaitProf. Really fast. Using SQL!
-
tanelpoder.com
-
18 years ago
-
eng
I bet you thought I’ll be writing about direct SGA access?! ;) Nope! Direct SGA access has excellent troubleshooting potential (as long as you know the shared memory data structures), but it has one major drawback – very few companies have such tools already in place in their production systems. I have occasionally been called in to solve an urgent performance problem, happening right now and it needs solving immediately! And did ....
|
|
Advanced Oracle Troubleshooting Guide, Part 5: Sampling V$ stuff with WaitProf. Really fast. Using SQL!
-
tanelpoder.com
-
18 years ago
-
eng
I bet you thought I’ll be writing about direct SGA access?! ;) Nope! Direct SGA access has excellent troubleshooting potential (as long as you know the shared memory data structures), but it has one major drawback – very few companies have such tools already in place in their production systems. I have occasionally been called in to solve an urgent performance problem, happening right now and it needs solving immediately! And did ....
|
|
So yesterday I posted around blurring the lines around your personal and professional life. Today I’d like to discuss a bit of the opposite of when companies blur the lines. Hopefully you don’t, but at first you may think how is this possible. Well first let me highlight some of what many feel are negative pieces, such as when an HR Rep who went to the same university as you looks up your facebook profile. You thinking this is private to fr....
|
|
So yesterday I posted around blurring the lines around your personal and professional life. Today I’d like to discuss a bit of the opposite of when companies blur the lines. Hopefully you don’t, but at first you may think how is this possible. Well first let me highlight some of what many feel are negative pieces, such as when an HR Rep who went to the same university as you looks up your facebook profile. You thinking this is private to fr....
|
|
Someone recently commented on by tweeting after having given my two weeks notice to my company, that it may not have been the best idea. So as a result I’d like to post my reasoning and thought why I feel it is actually a great idea. Even a month before my giving two weeks notice many knew it was likely going to happen, and I personally hope that this allowed those that may have needed to, to better plan accordingly. This also I believe all....
|
|
Someone recently commented on by tweeting after having given my two weeks notice to my company, that it may not have been the best idea. So as a result I’d like to post my reasoning and thought why I feel it is actually a great idea. Even a month before my giving two weeks notice many knew it was likely going to happen, and I personally hope that this allowed those that may have needed to, to better plan accordingly. This also I believe all....
|
|
I’m sure that Joel on Software is well read: his views on user interfaces are certainly well worth reading. But there’s a point hidden down at the end of Chapter 7 which is well worth repeating. And that’s that using a wide fixed-width font for text entry is much better than a thin proportionally-spaced font. Recently I noticed that the invitation panel on Google Spreadsheets, allowing you to type in email addresses of people to i..
|
|
I’m pretty sure I’ve said it before, but in case I haven’t voiced it on here yet, watch out for Adobe. They look like they’re firing on all cylinders lately and don’t look to be slowing down. At Adobe MAX 2007, I saw a preview of many things that were coming up for them. Though from already having worked with Adobe Flex was a fan, at least of the Flex and AIR products. Adobe now seems to be doing as much to drive adoption of the products as....
|
|
I’m pretty sure I’ve said it before, but in case I haven’t voiced it on here yet, watch out for Adobe. They look like they’re firing on all cylinders lately and don’t look to be slowing down. At Adobe MAX 2007, I saw a preview of many things that were coming up for them. Though from already having worked with Adobe Flex was a fan, at least of the Flex and AIR products. Adobe now seems to be doing as much to drive adoption of the products as....
|
|
There’s a nice Metalink Note 438452.1 about various less known Oracle performance tuning utilities. If you haven’t heard about things like StackX, LTOM, HangFG, SQLTXPLAIN, OS_Watcher or OPDG then it’s time to check this note out! :)
|
|
There’s a nice Metalink Note 438452.1 about various less known Oracle performance tuning utilities. If you haven’t heard about things like StackX, LTOM, HangFG, SQLTXPLAIN, OS_Watcher or OPDG then it’s time to check this note out! :)
|
|
Advanced Oracle Troubleshooting Guide, Part 4: Diagnosing a long parsing issue
-
tanelpoder.com
-
18 years ago
-
eng
There was a recent thread in Oracle Forums about a session getting stuck somewhere when a specific SQL was issued. The SQL executed did not return at all unless ORDERED hint was used. Even the EXPLAIN PLAN command (which only parses the statement, doesn’t execute it) did never return. Classic tracing + tkprof techniques didn’t show much (just some recursive queries consuming insignificant amounts of time). The proven V$SESSION_WAIT sa....
|
|
Advanced Oracle Troubleshooting Guide, Part 4: Diagnosing a long parsing issue
-
tanelpoder.com
-
18 years ago
-
eng
There was a recent thread in Oracle Forums about a session getting stuck somewhere when a specific SQL was issued. The SQL executed did not return at all unless ORDERED hint was used. Even the EXPLAIN PLAN command (which only parses the statement, doesn’t execute it) did never return. Classic tracing + tkprof techniques didn’t show much (just some recursive queries consuming insignificant amounts of time). The proven V$SESSION_WAIT sa....
|
|
I have a (very) small script called sn.sql which I use as a wrapper around snapper (maybe I should’ve called it Snapper Wrapper but it’s too long name for the purpose :) The idea is to have to type less when running Snapper with default options (take 1 snapshot, output to screen and display Session tats,Wait events and Time model stats). Whenever there’s a performance issue with a session I first quickly run @sn , for example:
|
|
I have a (very) small script called sn.sql which I use as a wrapper around snapper (maybe I should’ve called it Snapper Wrapper but it’s too long name for the purpose :) The idea is to have to type less when running Snapper with default options (take 1 snapshot, output to screen and display Session tats,Wait events and Time model stats). Whenever there’s a performance issue with a session I first quickly run @sn , for example:
|
|
A recent conversation of someone that was offended when the were introduced to someone new, then was not greeted first since they were a female brought what follows to mind. The above is a train of thought that came from a 70 year old military wife. I do not believe this is common practice today and is quite rarely found as the common etiquette, but nonetheless I think what is proper etiquette in business is changing quite rapidly. Though I....
|
|
A recent conversation of someone that was offended when the were introduced to someone new, then was not greeted first since they were a female brought what follows to mind. The above is a train of thought that came from a 70 year old military wife. I do not believe this is common practice today and is quite rarely found as the common etiquette, but nonetheless I think what is proper etiquette in business is changing quite rapidly. Though I....
|
|
In my last article, I showed how to implement authentication with Ruby on Rails. But security is about more than simple login. For many applications, we want to grant permission to manipulate a resource to a set of users. In this article, I will guide you though adding functionality so that users can modify the permissions for who gets to edit an article. Before we start implementing access control, we should get our application ready by en..
|
|
Three challenges for agile projects When I join projects now, I want to challenge all the stakeholders to make three commitments: Simulate production at least monthly: The software should be run in an environment that is comparable with the target production environment with loads and data variations similar to that of production. Thus, the technical stability of the project is proved. Demo with the business side at least monthly: The resul..
|
|
Querying the current tracefile name, using SQL – with tracefile_identifier
-
tanelpoder.com
-
18 years ago
-
eng
Update: In Oracle 11g upwards you can use V$DIAG_INFO for getting your own session’s trace file name too ( diag.sql script). But on earlier versions or if you want to see the current tracefile name of another, you still need to use the V$PROCESS approach below. Note that V$PROCESS in 11g (or 11.2?) has a column TRACEFILE that shows the entire path+name of a process tracefile (however there seems to be a bug in 12.1.0.2 where the field is ..
|
|
Querying the current tracefile name, using SQL – with tracefile_identifier
-
tanelpoder.com
-
18 years ago
-
eng
Update: In Oracle 11g upwards you can use V$DIAG_INFO for getting your own session’s trace file name too ( diag.sql script). But on earlier versions or if you want to see the current tracefile name of another, you still need to use the V$PROCESS approach below. Note that V$PROCESS in 11g (or 11.2?) has a column TRACEFILE that shows the entire path+name of a process tracefile (however there seems to be a bug in 12.1.0.2 where the field is ..
|
|
Oracle Troubleshooting with Snapper – detecting who’s causing excessive redo generation
-
tanelpoder.com
-
18 years ago
-
eng
Update: As this post was written many years ago, you should check out newer Snapper articles/videos: /2013/02/18/snapper-v4-02-and-the-snapper-launch-party-video/ My friend asked today a question that how to identify why his Oracle 9.2 database has suddenly started generating loads more redo than usual. So obviously I recommended him Snapper as first thing, it’s perfect for ad-hoc analysis like that! ( I know I sound biased but if ....
|
|
Oracle Troubleshooting with Snapper – detecting who’s causing excessive redo generation
-
tanelpoder.com
-
18 years ago
-
eng
Update: As this post was written many years ago, you should check out newer Snapper articles/videos: /2013/02/18/snapper-v4-02-and-the-snapper-launch-party-video/ My friend asked today a question that how to identify why his Oracle 9.2 database has suddenly started generating loads more redo than usual. So obviously I recommended him Snapper as first thing, it’s perfect for ad-hoc analysis like that! ( I know I sound biased but if ....
|
|
I recently read an article on Techcrunch on how web 2.0 had undoubtedly made an impact, but had yet to truly make money. From my stance they is really one way to make money on the web, which is through advertising (paid subscription services are dying). This can either be done through a simple banner ad, or something that can more easily be deemed a qualified lead or referral. Ads will always be there, but if web 2.0 is to start making mone....
|
|
I recently read an article on Techcrunch on how web 2.0 had undoubtedly made an impact, but had yet to truly make money. From my stance they is really one way to make money on the web, which is through advertising (paid subscription services are dying). This can either be done through a simple banner ad, or something that can more easily be deemed a qualified lead or referral. Ads will always be there, but if web 2.0 is to start making mone....
|
|
Please make sure you understand hand signals. And don’t try and half wheel other people, it causes crashes!
Snapped chain. Bent chainring. Bent crank spider. Bruises. Damn.
|
|
Please make sure you understand hand signals. And don’t try and half wheel other people, it causes crashes!
Snapped chain. Bent chainring. Bent crank spider. Bruises. Damn.
|
|
This picture is of an IBM Model 3380 Hard Drive from 1981. Because it looks like a nuclear device or jet engine, I was able to convince my neighbour that I was generating my own nuclear power from now on, as well as the people at the Chrysler convention that it was an electric engine for a transport truck (I was passing them when going to a high school tech presentation at Bingemans where I used this as a fun prop). My pranks know no bounds..
|
|
This picture is of an IBM Model 3380 Hard Drive from 1981. Because it looks like a nuclear device or jet engine, I was able to convince my neighbour that I was generating my own nuclear power from now on, as well as the people at the Chrysler convention that it was an electric engine for a transport truck (I was passing them when going to a high school tech presentation at Bingemans where I used this as a fun prop). My pranks know no bounds..
|
|
Performance and Scalalability Improvements in Oracle 10g and 11g
-
tanelpoder.com
-
18 years ago
-
eng
I have uploaded the slides of my “Performance and Scalalability Improvements in Oracle 10g and 11g” presentation here .
|
|
Performance and Scalalability Improvements in Oracle 10g and 11g
-
tanelpoder.com
-
18 years ago
-
eng
I have uploaded the slides of my “Performance and Scalalability Improvements in Oracle 10g and 11g” presentation here .
|
|
There was a question in a recent Oracle-L thread about various uses of autonomous transactions. Autonomous transactions can be very useful for a PL/SQL application logging, but sometimes they are also abused to cope with bad application design (like avoiding mutating table errors in triggers etc). I’m not going to start on that topic here though, but instead presenting another case where autonomous transactions have helped me to work ....
|
|
There was a question in a recent Oracle-L thread about various uses of autonomous transactions. Autonomous transactions can be very useful for a PL/SQL application logging, but sometimes they are also abused to cope with bad application design (like avoiding mutating table errors in triggers etc). I’m not going to start on that topic here though, but instead presenting another case where autonomous transactions have helped me to work ....
|
|
I’m finding it a growingly interesting balance in consuming versus producing information. I also feel with the increase in availability of information, the barrier to entry in so many areas are shrinking rapidly. I think of some of the areas where the barriers to entry are typically much higher. 15 years ago we would have never seen a 23 year old as the CEO of a company valued at 15 billion dollars. While my vantage point even within the bu....
|
|
I’m finding it a growingly interesting balance in consuming versus producing information. I also feel with the increase in availability of information, the barrier to entry in so many areas are shrinking rapidly. I think of some of the areas where the barriers to entry are typically much higher. 15 years ago we would have never seen a 23 year old as the CEO of a company valued at 15 billion dollars. While my vantage point even within the bu....
|
|
As I’ve become more or less a web 2.0 whore. I’ve also had a great interest in web 3.0 and what it will fortell. Most believe natural language and the semantic web will play a large role in that. And while it will that will not be the end result of web 3.0. While web 2.0 included AJAX and Flex, that really doesn’t fully encompass what they are. Web 3.0 to sum it up most simply will be about reducing the noise of the web. While I can take ve....
|
|
As I’ve become more or less a web 2.0 whore. I’ve also had a great interest in web 3.0 and what it will fortell. Most believe natural language and the semantic web will play a large role in that. And while it will that will not be the end result of web 3.0. While web 2.0 included AJAX and Flex, that really doesn’t fully encompass what they are. Web 3.0 to sum it up most simply will be about reducing the noise of the web. While I can take ve....
|
|
Every so often I re-read a book that I read years ago to remember what it is about. Mostly, I re-read sci-fi or notable works such as Neuromancer (William Gibson) or The Hitchhiker’s Guide to the Galaxy (Douglas Adams) since those are the types of books that I kept over the years. However, I kept a book from 1989 called Life with UNIX (Don Libes & Sandy Ressler) that I remember using as a good UNIX reference a long time ago. ..
|
|
Every so often I re-read a book that I read years ago to remember what it is about. Mostly, I re-read sci-fi or notable works such as Neuromancer (William Gibson) or The Hitchhiker’s Guide to the Galaxy (Douglas Adams) since those are the types of books that I kept over the years. However, I kept a book from 1989 called Life with UNIX (Don Libes & Sandy Ressler) that I remember using as a good UNIX reference a long time ago. ..
|