Wednesday, November 08, 2006

Playing in the Sand

Just got back from a week in Kuwait upgrading our database down there from 9i to 10g and upgrading our ESRI from 9.0 to 9.1.

I must say upgrading Oracle9i to 10g on a Sun Solaris 10 OS is the most easiest and painless install I’ve ever done. I found out on our Dev box that trying to put 10g on Solaris 8 was like trying to put a square peg in a round hole. Luckily, I got our UNIX admin on board with upgrading all of our servers to Solaris 10 before I started my production upgrade festivities.

When I got down there we had one database serving up maps and vehicle tracking data. All the tracking data is OLTP oriented and the maps are nothing but a bunch of blobs. The user has the ability to see maps by themselves and vehicle information (text) by itself. The user also has the ability to see maps and the vehicle data at the same time.

The server has plenty of horsepower and space so I decided to break the database into two. I created another database and put the maps on it. I configured it for bulk stuff .One other thing I did was, we have a particular map that automatically loads up when a user first accesses the webpage, I threw that in to the keep pool. Performance is very nice. It’s so refreshing when you have a database configured correctly for the environment it supports.

8 comments:

John Hurley said...

Just call me confused because I thought that in another posting you said that your company is migrating all your solaris oracle databases to linux?

Jeff Hunter said...

John Hurley said...

Just call me confused because I thought that in another posting you said that your company is migrating all your solaris oracle databases to linux?

OK, confused, this is the way it is. This is the "So What Co-operative" where self-proclaimed experts from around the globe chime in on all matters IT. While I may be running away from Solaris, that doesn't mean everybody in the world has seen the light yet. ;)

OracleDoc said...

Hey Man I never professed to be an "expert". I'm far from it. Ones actions or inactions speak for their ability.

That just irks me all kinds of ways when someone professes to be an "expert" on something. But that's another subject that has been beaten like [insert colorful simile here].

Jeff Hunter said...

OK, make that "Jeff Proclaimed experts"....

Noons said...

oradoc dude:
is that system in iraq in any way related to tbmcs or atccis?

OracleDoc said...

Hey Noons,
I don't have a system in Iraq, it's in Kuwait and I have no idea what those acronyms stand for :(

Noons said...

sorry, I meant Kuwait.
It's just that by the descriptions they sounded similar to something I know is being used there.

john hurley said...

Sorry didn't apparently see the bottom of the posting where the author was noted.