Damir Vadas Linux and Oracle ... as I learned

Browsing history data changes for tables-how to

2012-02-01T17:26:00.010+01:00

Monitoring changes in database tables data is always a pain in the ass for many developers. It was even for me until recently, when I had to create a dozen of tables which should have save history of changes. Saving the history was not a big deal but how to show differences in a clear (and easy as possible way) was a real challenge for me. I was able to do hard codding for each table, but I

EM on Oracle Fail Safe on Windows

2012-01-24T16:25:00.004+01:00

Oracle Fail Safe is the oldest fail-over techniques ... invented much much more before RAC. The matter of fact it was only solution before RAC come to stable phase. Because of easiness of implementation and stability in work, Oracle on Oracle Fail Safe on any OS environment was the biggest advantage for a long time. How ever, if you wanted to use EM (Enterprise Manager) on such a platform, until

Oracle 11g architecture Interactive Quick Reference

2012-01-08T13:01:00.001+01:00

People say that picture shows more then 1.000 words. I agree 1,000%. Here is Oracle 11g architecture in one image, taken from official Oracle site. Processes shown are started by default Processes in red are mandatory Processes ARC and RVWR are not started by default but are recommended for productions Processes marked with * are new in 11g For those who want full information, here is

Dangerous careless trigger declaration

2012-01-03T23:56:00.003+01:00

Just few days before going to Christmas holidays, I have run into one pretty interesting and dangerous situation which was caused because careless trigger definition. The beauty of this example is that it is very hard to see real problem until you run in it. I had a luck that, regardless all happened on production database, involved table were part of source data for warehouse part, which is

2011-12-21T20:08:00.020+01:00

Kad se kazaljke sklope u pola noći ruku Vam pružit neću moći, zato šaljem poruku ovu : Sretan Božić i Godinu Novu! Merry Christmas and Happy New year! Cheers!

It's Christmass time (part II)

2011-12-19T17:01:00.013+01:00

In theses days when we are all happy and make fun and jocks all around, I got a beautiful pictures on mail. Picture describe how do IT people see each other. Here it is: Because relations with real life situations, from mine point of view, are more then obvious, mine decision was to resend this picture to all mine friends through mail and to try to explain "who we are and what we do ... in IT".

It's Christmass time (part I)

2011-12-01T19:28:00.000+01:00

Let's have fun...

Can SELECT privilege lock table?

2011-11-18T19:46:00.002+01:00

Recent discussion on one forum remind me to share a part of knowledge, which in core, seems that anyone understand well, but I think that many would find them self confused. Question is: If a user has been granted select privilege on table, is there any way to lock table in any way? You might be surprised, but answer is: Yes. And this is normal behavior on any Oracle database version which have

Client side solution for Oracle/Windows service/resource checking

2011-10-31T21:36:00.009+01:00

Most of the client side OS is Windows-this is a fact. In classic client-server environments (and those who are strictly not), 99% of the problems lay on the client side. So detecting those problems as quick as possible is always a big challenge to any IT structure and necessary foundation for any help desk structure. Based on such a premises, recently I got a task to design a client side tool

Monitor database size (part II)

2011-10-17T22:45:00.006+02:00

When I wrote my previous post on the same subject, Monitor database size, I have shown a way how to monitor database size. In that blog post, beside core methods, all other results are retrieved as pure sqlplus calls. In this 16th annual HROUG (Croatian Oracle Users Group) conference, I have a chance to present this solution publicly. As a little extension according previous post, Apex visual