|
Sqlplus is my second home, part 3: Colored selections in Windows XP command prompt
-
tanelpoder.com
-
18 years ago
-
eng
Whenever delivering some Oracle training or running a demo at a conference, I’ve always liked to use the Windows command prompt version of sqlplus. One reason of course is its easy command line history navigation capability ( press F7 in cmd.exe after entering few commands to see why ). Another reason is that whenever I want to highlight some part of sqlplus output, I can just drag a selection rectangle around that text. In other words ..
|
|
Sqlplus is my second home, part 2: Running SQL scripts from remote locations using HTTP
-
tanelpoder.com
-
18 years ago
-
eng
As you probably already know, the Session Snapper has been designed to be a very easy-to-use performance tool. It is especially useful in database environments where there are no decent performance tools pre-installed and available. Snapper doesn’t require any setup, all you need is to log on to the database using sqlplus and download snapper.sql script to your computer. Well, actually the second part is not required, as Oracle sqlplu....
|
|
Sqlplus is my second home, part 2: Running SQL scripts from remote locations using HTTP
-
tanelpoder.com
-
18 years ago
-
eng
As you probably already know, the Session Snapper has been designed to be a very easy-to-use performance tool. It is especially useful in database environments where there are no decent performance tools pre-installed and available. Snapper doesn’t require any setup, all you need is to log on to the database using sqlplus and download snapper.sql script to your computer. Well, actually the second part is not required, as Oracle sqlplu....
|
|
There was a discussion about whether Oracle really allocates all memory for SGA immediately on instance startup or not. And further, whether Oracle allocates memory beyond the SGA_TARET if SGA_MAX_SIZE is larger than it. It’s worth reading this thread first: http://forums.oracle.com/forums/thread.jspa?threadID=535400&tstart=0 I will paste an edited version of my reply to here as well:
|
|
There was a discussion about whether Oracle really allocates all memory for SGA immediately on instance startup or not. And further, whether Oracle allocates memory beyond the SGA_TARET if SGA_MAX_SIZE is larger than it. It’s worth reading this thread first: http://forums.oracle.com/forums/thread.jspa?threadID=535400&tstart=0 I will paste an edited version of my reply to here as well:
|
|
Advanced Oracle Troubleshooting Guide, Part 2: No magic is needed, systematic approach will do
-
tanelpoder.com
-
18 years ago
-
eng
There are two ways for diagnosing problems: Checking for the usual suspects and hoping to find a matching one Following a systematic approach Checking for the usual suspects and hoping to find a matching one The first approach relies on previous experience (both in particular subject area/technology and about the context/environment the problem occurs). For example if a patient comes to doctor complaining about pain in chest, then for d..
|
|
Advanced Oracle Troubleshooting Guide, Part 2: No magic is needed, systematic approach will do
-
tanelpoder.com
-
18 years ago
-
eng
There are two ways for diagnosing problems: Checking for the usual suspects and hoping to find a matching one Following a systematic approach Checking for the usual suspects and hoping to find a matching one The first approach relies on previous experience (both in particular subject area/technology and about the context/environment the problem occurs). For example if a patient comes to doctor complaining about pain in chest, then for d..
|
|
The main design goal of Session Snapper was that it should not require any changes to be made into database. And to achieve this goal, I was even willing to sacrifice some functionality. So, for example there is no sorting capability in Snapper output. It would have been easy to create an SQL Type to database, use that as session statistics storage and query results out using an order by on statistics delta column – giving you (probably....
|
|
The main design goal of Session Snapper was that it should not require any changes to be made into database. And to achieve this goal, I was even willing to sacrifice some functionality. So, for example there is no sorting capability in Snapper output. It would have been easy to create an SQL Type to database, use that as session statistics storage and query results out using an order by on statistics delta column – giving you (probably....
|
|
This is my attempt for getting cheap popularity out of recent Oracle 11g release. This is not going to be another Oracle 11g new features list, I’ll be just posting any of my research findings here, in a semi-organized way. The first post is is about Automatic Memory Management. AMM manages all SGA + PGA memory together, allowing it to shift memory from SGA to PGAs and vice versa. You only need to set a MEMORY_TARGET (and if you like, MEM....
|
|
This is my attempt for getting cheap popularity out of recent Oracle 11g release. This is not going to be another Oracle 11g new features list, I’ll be just posting any of my research findings here, in a semi-organized way. The first post is is about Automatic Memory Management. AMM manages all SGA + PGA memory together, allowing it to shift memory from SGA to PGAs and vice versa. You only need to set a MEMORY_TARGET (and if you like, MEM....
|
|
Oracle Session Snapper – real-time session-level performance stats for DBAs
-
tanelpoder.com
-
18 years ago
-
eng
A post by Jonathan Lewis inspired me to finally complete my version of the Oracle session performance snapper script, which main characteristics are it reports Oracle session level performance counter and wait information in real time it does NOT require any database objects to be created If you are a DBA or consultant working on ad-hoc performance issues, you will like it! Are you familiar with following situation? (Monday mo....
|
|
Oracle Session Snapper – real-time session-level performance stats for DBAs
-
tanelpoder.com
-
18 years ago
-
eng
A post by Jonathan Lewis inspired me to finally complete my version of the Oracle session performance snapper script, which main characteristics are it reports Oracle session level performance counter and wait information in real time it does NOT require any database objects to be created If you are a DBA or consultant working on ad-hoc performance issues, you will like it! Are you familiar with following situation? (Monday mo....
|
|
I consider myself to be a very patient person (all things considered) - but one thing that causes me to lose my patience is when I hear of proprietary computer companies that spread FUD (Fear, Uncertainty and Doubt) in order to keep their customers from considering other (and usually much better) technologies. While Microsoft has been the main purveyor of FUD since the early 1990s, SCO used FUD in an attempt to downplay the Linux operatin..
|
|
I consider myself to be a very patient person (all things considered) - but one thing that causes me to lose my patience is when I hear of proprietary computer companies that spread FUD (Fear, Uncertainty and Doubt) in order to keep their customers from considering other (and usually much better) technologies. While Microsoft has been the main purveyor of FUD since the early 1990s, SCO used FUD in an attempt to downplay the Linux operatin..
|
|
For the past 2 years, I have had a Buddha Shrine in the server closet in my office. I carefully researched proper Buddha Shrine requirements and styles on Google before I chose the above arrangement (Buddha must be elevated and surrounded by objects that represent tokens of life). Why did I do this? Simple. To speed up our current Internet access and reduce the number of times that we need to reboot/reset classroom routers (when caches..
|
|
For the past 2 years, I have had a Buddha Shrine in the server closet in my office. I carefully researched proper Buddha Shrine requirements and styles on Google before I chose the above arrangement (Buddha must be elevated and surrounded by objects that represent tokens of life). Why did I do this? Simple. To speed up our current Internet access and reduce the number of times that we need to reboot/reset classroom routers (when caches..
|
|
My good friend Skoll recently wrote of the motorcycling life : One of me favourite bands Manowar one sang "Riding horses made of steel". What kind of mental image does that provoke? Riding a Harley Davidson to sunset on an empty hightway, a beautiful young girl on your back seat? What a load of bullcrap! Motorcycling is about rain, it's about being soaking wet and freezing your ass off. It's about losing your friends in the traffic bec....
|
|
Sometimes, a quick and easy programming language like Ruby might not be so quick and easy. Sometimes, C may be easier. Sometimes, you might complete a task faster with C than with your favorite scripting language. I’ve long been a proponent of scripting languages. In particular, I’ve enjoyed learning and using Ruby. So when I was inspired to program a boggle solver as a code kata, I naturally reached for this nice shining tool in my toolche..
|
|
Sqlplus is my second home, Part 1: HTMLizing your sqlplus output
-
tanelpoder.com
-
18 years ago
-
eng
I have not managed to post anything for a while, but I intend to make it up by starting this series of posts made specially for Oracle enthusiasts, geeks and maniacs among us. Here I plan to post the coolest Oracle stuff I’ve just found out and some of it may actually be useful to you! Lets start. This post is about removing the last major problem with sqlplus in everyday database and application administration work. I would say the com....
|
|
Sqlplus is my second home, Part 1: HTMLizing your sqlplus output
-
tanelpoder.com
-
18 years ago
-
eng
I have not managed to post anything for a while, but I intend to make it up by starting this series of posts made specially for Oracle enthusiasts, geeks and maniacs among us. Here I plan to post the coolest Oracle stuff I’ve just found out and some of it may actually be useful to you! Lets start. This post is about removing the last major problem with sqlplus in everyday database and application administration work. I would say the com....
|
|
Useless default documentation dilutes both code and actual documentation
-
www.databasesandlife.com
-
18 years ago
-
eng
IDEs can create default code, including default documentation, such as: /** * Insert class or interface description here. */ It would be great if people would actually write documentation. Even a single sentence to describe what the class is modeling would be helpful if it’s not obvious from the name. Or object invariants (e.g. boughtCount <= offeredCount). To find a class without documentation is annoying. But to see such an IDE-gen..
|
|
I’m sitting in the airport in Las Vegas on the way back from DEF CON 15. It’s the first time I’ve been at the con, and it wasn’t really what I expected. Frankly, I walked away feeling kinda underwhelmed. Very few of the talks were as technical as I was hoping – they were almost universally broad overviews of an area, with lots of introduction, and relatively little, to my eye, technical meat.
|
|
I’m sitting in the airport in Las Vegas on the way back from DEF CON 15. It’s the first time I’ve been at the con, and it wasn’t really what I expected. Frankly, I walked away feeling kinda underwhelmed. Very few of the talks were as technical as I was hoping – they were almost universally broad overviews of an area, with lots of introduction, and relatively little, to my eye, technical meat.
|
|
On July 6th, Richard Stallman gave a talk at the University of Waterloo regarding copyright and its evils. Although slow at the beginning (perhaps because Richard was still finishing his Pepsi and introducing the features of copyright), it turned out to be a powerful and enlightening educational experience. I decided not to write a blog about it until I was able to view it again on video after my vacation and make specific notes. You ca..
|
|
On July 6th, Richard Stallman gave a talk at the University of Waterloo regarding copyright and its evils. Although slow at the beginning (perhaps because Richard was still finishing his Pepsi and introducing the features of copyright), it turned out to be a powerful and enlightening educational experience. I decided not to write a blog about it until I was able to view it again on video after my vacation and make specific notes. You ca..
|
|
I saw this book a short while ago at Chapters (book store chain in Canada). What caught my eye was the humour on the front cover! This book is on how to secure your PC using Computer Associates Internet Security software (with a Windows Vista update!). However, the laptop that the lady on the cover is using is a MacBook! Currently, there are no known viruses or spyware for Macs! But I definitely agree with the subliminal advertising ..
|
|
I saw this book a short while ago at Chapters (book store chain in Canada). What caught my eye was the humour on the front cover! This book is on how to secure your PC using Computer Associates Internet Security software (with a Windows Vista update!). However, the laptop that the lady on the cover is using is a MacBook! Currently, there are no known viruses or spyware for Macs! But I definitely agree with the subliminal advertising ..
|
|
Copying the contents of one directory into another on Linux: not as easy at it looks!
-
www.databasesandlife.com
-
18 years ago
-
eng
Task: You want to copy the contents of one directory into another existing directory. On Linux. I.e. if the source directory is “x” and the destination directory is the already-existing directory “y”, if there are files “x/1” and “x/2” then files “y/1” and “y/2” should be created. If “x” is an empty directory then no files in “y” should be created. Now, this is not as easy as it sounds.
|
|
Anders Nordås shows how to throw a checked exception without declaring a throws clause. The method uses some inherently evil mechanisms (the name of the class “sun.misc.Unsafe” should be a tip of), and like Anders says, this should probably never be used in production. Basically, calling sun.misc.Unsafe.throwException will throw a checked exception without alerting the compiler. The exception is not wrapped, but it cannot be caught by its c..
|
|
Sometimes, you just do things that bring out the geek within……well……today is one of those days. Guess what you can do with the front bezel of an Apple eMac? Make a family photo frame! Simply find a piece of glass that is 14”x11” and place it on the inside of the bezel. Next, place your picture on the glass (preferably with a nice thick matting to add depth) and screw a 15”x12” piece of pressboard into the existing screw holes on the in..
|
|
Sometimes, you just do things that bring out the geek within……well……today is one of those days. Guess what you can do with the front bezel of an Apple eMac? Make a family photo frame! Simply find a piece of glass that is 14”x11” and place it on the inside of the bezel. Next, place your picture on the glass (preferably with a nice thick matting to add depth) and screw a 15”x12” piece of pressboard into the existing screw holes on the in..
|
|
This is probably old news to most, but since I usually fly SAS my flight yesterday to Manchester for the State of the Map and GUADEC conferences was the first time I ran into Finnair’s check-in SMS service . I was sitting in a meeting about three hours before the flight and suddenly got a message to my cell phone: FINNAIR check-in: AY937 Helsinki-Manchester 17.07.2007 departure 16:00 seat 15A window. Confirm by replying A. ....
|
|
This is a good term for a commonplace management error: http://www.answers.com/topic/concorde-fallacy
|
|
Sony rang on Friday. They wanted to know the guarantee number (the number that I don’t have, which should have been on the invoice; the invoice which originated from them, and I’ve sent them back twice already). I took the opportunity to ask how the repair was going (as their website where you can track the repairs doesn’t work). They told me the battery was broken and they had to send off for a new one, which hadn’t arrived yet. There ar..
|
|
Why can Scrum deliver surprising results already in the first month of adoption? Because it helps the team focus on what’s really important. We had Jeff Sutherland visit Oslo XP meetup a few weeks back. Jeff is co-creator of the Scrum method (with Ken Schwaber) and CTO of PatientKeeper, a US health information company. His presentation focused on the effects of Scrum on distributed teams, and on the effects of adopting Scrum in projects.
|
|
Yup - it’s vacation time again! And this next week I plan to do nothing but relax, get a tan, drink “Muskoka Dry Pale Ginger Ale” and read a few books that I haven’t had the time to open yet. And yes, my daughter is going to swim all week long - that is her in the water with the kids from the cottage next door. Now you are probably wondering why I am blogging on my vacation……shouldn’t a vacation be devoid of TV/phones/Internet/computers..
|
|
Yup - it’s vacation time again! And this next week I plan to do nothing but relax, get a tan, drink “Muskoka Dry Pale Ginger Ale” and read a few books that I haven’t had the time to open yet. And yes, my daughter is going to swim all week long - that is her in the water with the kids from the cottage next door. Now you are probably wondering why I am blogging on my vacation……shouldn’t a vacation be devoid of TV/phones/Internet/computers..
|
|
There's a problem persisting boolean fields using Hibernate 3.2.2 to MySQL 5.0, if you allow Hibernate to generate your schema, and you leave Hibernate to generate the schema in the default way. It works fine on MySQL 4.1 and it doesn't matter if you use boolean (primitive) or Boolean (object) types for the fields. With a class such as: public class MyObject { protected boolean myField; public boolean getMyField() { return myField; } ..
|