str[bits]

Oh yeah, I finished now my Oracle DBA course. Our last class was last Monday and it was full of suspense. All of us don’t know if we can finish the workshop on time, otherwise we need to extend that session one more day. We are in Performance Tuning Workshop and we are running some scripts to simulate that our sample database having an artificial load like in the real production database with many users doing multiple transactions. Then we will analyze and fine-tune that database for optimal performance.

Unluckily, one after the other, all our database crashed including used by our instructor.

It took some time to fix it (thanks to our knowledge we learned from “Backup and Recovery Course”).

Again, we need to simulate the load again. Analyze the database performance by running some built in utilities, and changing needed parameters that causing the low performance.

After that, we need to restart the database and see if it really improves the performance. If it improves, you did it right! But still you need to think more how you can optimize it more by considering different load cases. But if the performance doesn’t change or worsen, you need to re-analyze the report from the result after you run the utilities and make sure you are changing the right parameters with the right option.

So it’s an almost never-ending process. It’s really a cycle and basically that’s the job of a DBA – to closely monitor your database specially the performance and security… forever.

In that class, we just finished one cycle of it, and I told you, until the end of the class, all of us don’t know if we can finish it. All of us were very happy when we able to at least improved the performance of our own test database.

Well, that was the end of my DBA course. My instructor was really excellent. My classmates were all best in their own way. The subject I thought a new thing for me, but at the end I discover that Oracle DBA is already an old part of me.

And perhaps I belong here.

I’m very thankful to my company for giving me the opportunity and chance to attend this DBA track. This will really change my life and career more than they are anticipating for me.

My next track will be Oracle Developer and it will start on July 7.

I still have more than a week of needed rest.

I hope so…

For couple of days I’m unable to post in strdoc for some strange reasons. Maybe there was temporary problem in my host server. That’s why when I’m posting and compiling my new posting to be automatically recorded in my archives, it showing me access denied. I reviewed my security option and everything seems right. I tried to contact the technical support of the server hosting strdoc but I did not receive any favorable reply. So I thought, some problem with Greymatter - the utility I’m using to do the auto-archiving. I tried to alter some option in the configuration but it just worsens the case - I’m unable to login at all!

I read the manual of Greymatter and strictly it says that never touch or alter the cgi scripts inside, otherwise it will make my whole archives and journal unusable!

Wow! It means I need to recompile and reconfigure this whole site again.

Wew! Back to zero again.