Site uses cookies to provide basic functionality.
Javascript rendering is set to off by default when visiting the site via .onion and .i2p domains. It can be enabled back again in user's settings section. Javascript rendering set to off means, that you can disable javascript in your browser now and the site will remain functional.
There is also IRC server now available via native IRC clients or non javascript web based one.
Fonts can be adjusted in user's settings section as well.
Check FAQ for more.

OK

Networks
Languages
1 2 3 4 7 10 14 20 29 42 61 87 125 180 257 326 368 527 554 713 755 824 901 956 994 1020 1039 1052 1060 1061 1062 1063 1064 1067 1071 1074 1077 1078 1079 1080 1081 ▲ ▼
Warning: This article requires a lot of editing love before it is very useful. It might be somewhat incoherent. Read at your own risk. ;-) Silo (software): A silo system cannot easily integrate with any other system. In software, the term “silo” is used to refer to a system that is constructed as one unit from the front end to the data storage. Everything is tied together to work with the rest of the silo, but not with other elements.
Get ready for some more adventures in Oracle process stack! Before proceeding though, please read this post about safety of different stack sampling approaches. I have had few non-trivial Oracle troubleshooting cases, related to query hangs and bad performance, where I’ve wanted to know where exactly in execution plan the current execution is. Remember, Oracle is just another program executing instructions clustered in functions on ..
Get ready for some more adventures in Oracle process stack! Before proceeding though, please read this post about safety of different stack sampling approaches. I have had few non-trivial Oracle troubleshooting cases, related to query hangs and bad performance, where I’ve wanted to know where exactly in execution plan the current execution is. Remember, Oracle is just another program executing instructions clustered in functions on ..
Debugger dangers - tanelpoder.com - 17 years ago - eng
Whenever I deliver training or conference presentations on advanced troubleshooting topics, I usually spend some time demonstrating how to get and interpret Oracle server process stack traces. As I’ve mentioned before, stack traces are the ultimate indicators showing where in Oracle kernel (or whatever application) code the execution currently is (or where it was when a crash occurred). This is the reason Oracle Support asks for stack tra....
Debugger dangers - tanelpoder.com - 17 years ago - eng
Whenever I deliver training or conference presentations on advanced troubleshooting topics, I usually spend some time demonstrating how to get and interpret Oracle server process stack traces. As I’ve mentioned before, stack traces are the ultimate indicators showing where in Oracle kernel (or whatever application) code the execution currently is (or where it was when a crash occurred). This is the reason Oracle Support asks for stack tra....
There’s been a lot of buzz in the valley lately around this very small startup, that has a few pretty heavy hitters. Between the four founders they have worked on nearly all of the Google products so many know and love, with the exception of search. Paul Bucheit, is even responsible for Google’s current motto, “don’t be evil”. These four guys not only are visionaries within the web space, they also know how to deliver a product, having help....
There’s been a lot of buzz in the valley lately around this very small startup, that has a few pretty heavy hitters. Between the four founders they have worked on nearly all of the Google products so many know and love, with the exception of search. Paul Bucheit, is even responsible for Google’s current motto, “don’t be evil”. These four guys not only are visionaries within the web space, they also know how to deliver a product, having help....
If you’re writing software using a database system such as MySQL, your code doesn’t have access to all the data at any point in time, you SELECT just the data you need to operate on. If you want to do some database-wide operation, you need to ask the database to do it, because you don’t have all the rows. When you want to enforce uniqueness, for example across a whole table (for example a document name needs to be unique), or across a p..
The only way to enforce unique constraints on a database table is by asking the database to do it . Create the table, create the unique constraint, do an insert, and parse the error message if the insert failed, to see if it was a unique constraint violation. Any kind of SELECT COUNT(*) before an insert will not work. This is now available automatically from WebTek. If the underlying table has any unique constraints, if they are violat..
I received a question on what’s the point of the use of Mutexes for Oracle cursors in library cache. For short intro, I’m pasting one of my fairly recent answers in Oracle forums about Oracle mutexes here: In Oracle, latches and mutexes are different things and managed using different modules. KSL* modules for latches and KGX* for mutexes. General mutex operatins require less CPU instructions than latch operations (as they aren’t as sop..
I received a question on what’s the point of the use of Mutexes for Oracle cursors in library cache. For short intro, I’m pasting one of my fairly recent answers in Oracle forums about Oracle mutexes here: In Oracle, latches and mutexes are different things and managed using different modules. KSL* modules for latches and KGX* for mutexes. General mutex operatins require less CPU instructions than latch operations (as they aren’t as sop..
Oracle has an unusual feature, which attracts it a lot of criticism. If you try to insert the empty string into a column marked "not null", you get an error. The empty string is treated the same as "null" by Oracle. This is different to programming languages (and indeed other databases, at least MySQL), which means one has to be careful not to make a mistake when using a programming language to talk to the database. That it’s different fr..
So this week they announced what many expected was coming the iPhone 3g. However off the shelf it’s still not web  2.0, while a great device its not a web 2.0 device yet. Apple without a doubt understands user experience, but they do not fully grasp web 2.0 yet. Microsoft seems to even have a better understanding with the products they are looking to role out with Mesh and their enterprise social/collaboration tools. Lot’s of great applica....
So this week they announced what many expected was coming the iPhone 3g. However off the shelf it’s still not web  2.0, while a great device its not a web 2.0 device yet. Apple without a doubt understands user experience, but they do not fully grasp web 2.0 yet. Microsoft seems to even have a better understanding with the products they are looking to role out with Mesh and their enterprise social/collaboration tools. Lot’s of great applica....
While I may or may not know how to be successful in silicon valley, I feel pretty confident that I can point out a few ways to not be successful in valley terms. What follows is my thoughts on how you can best limit yourself to own, run, or be involved in the entrepreneurial spirit of the valley. The first is keeping yourself in a bubble, by not diving into the new technologies, new services, and new age of the web there’s little possibil....
While I may or may not know how to be successful in silicon valley, I feel pretty confident that I can point out a few ways to not be successful in valley terms. What follows is my thoughts on how you can best limit yourself to own, run, or be involved in the entrepreneurial spirit of the valley. The first is keeping yourself in a bubble, by not diving into the new technologies, new services, and new age of the web there’s little possibil....
Over the years we at Nemein have been experimenting with various ways of keeping our operations managed. Now with some personnel changes including Joe's departure it was a good time to change the way we work again. I had some goals: Keeping status of different projects up-to-date with more accuracy Ensuring our sales and project management knows if some project is being blocked by missing materials Enabling a more distributed, we....
There was a recent post over at ReadWriteWeb about how content is becoming a commodity. I don’t believe many people would argue with this. While at first this wasn’t something I viewed in a positive light the more I think over it the more I see some value in it. As content does become more and more of a commodity the value in who is publishing or producing that content goes up. Five years ago if someone would have talked about some trade-se....
There was a recent post over at ReadWriteWeb about how content is becoming a commodity. I don’t believe many people would argue with this. While at first this wasn’t something I viewed in a positive light the more I think over it the more I see some value in it. As content does become more and more of a commodity the value in who is publishing or producing that content goes up. Five years ago if someone would have talked about some trade-se....
Every now and then I need to generate a large number of rows into some table. Not that I have any personal urge to do so, but you know, this is needed for some test cases and so on ;-) It’s quite well known that it’s possible to generate lots of rows using CONNECT BY LEVEL <= #rows syntax. However as the CONNECT BY LEVEL syntax is recursive by nature, it will consume more memory the more rows you query in one shot ( I think it was Mar..
Every now and then I need to generate a large number of rows into some table. Not that I have any personal urge to do so, but you know, this is needed for some test cases and so on ;-) It’s quite well known that it’s possible to generate lots of rows using CONNECT BY LEVEL <= #rows syntax. However as the CONNECT BY LEVEL syntax is recursive by nature, it will consume more memory the more rows you query in one shot ( I think it was Mar..
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....
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....
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 ....
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! :)
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....
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....
Snapper shortcut - tanelpoder.com - 18 years ago - eng
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:
Snapper shortcut - tanelpoder.com - 18 years ago - eng
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..
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 ..
1 2 3 4 7 10 14 20 29 42 61 87 125 180 257 326 368 527 554 713 755 824 901 956 994 1020 1039 1052 1060 1061 1062 1063 1064 1067 1071 1074 1077 1078 1079 1080 1081 ▲ ▼
3 visitors online