Moving to a Different Continent

It’s been a year (and a week) since I moved from the small Israel to the huge Canada. I knew it wouldn’t be easy both personally and professionally, but until you actually do this you don’t know how strange it is.

I’d like to share with you some of the professional difficulties I’ve experienced in the last year. These difficulties are related to many areas, founding DBAces Canada, being an Oracle ACE and more.

Continue reading

The Problem with autotrace

There are few ways to see the execution plan of a SQL statement. One of these ways is the autotrace option in sqlplus. It is a very easy-to-use feature and people use it quite often. But there is a risk here. The autotrace option doesn’t always show you the correct execution plan.

Lately I prepared a demo and had a simple case that showed the incorrect info from autotrace, so here it is.

Continue reading

Intro to Database Security – Part 5

In the previous parts I talked about security of the application and infrastructure layer of database security. This will be the last post in the series and I want to dedicated it to a very important topic that is not a database only issue – passwords.

Links to the previous posts:
Part 1 – general introduction to security
Part 2 – introduction to database security
Part 3 – infrastructure aspect of database security
Part 4 – application aspect of database security

Continue reading