It’s been three months since I moved to Vancouver Canada, and so far everything is going well. My wife started her studies, my kids started their daycare and kindergarten and
It’s been three months since I moved to Vancouver Canada, and so far everything is going well. My wife started her studies, my kids started their daycare and kindergarten and
The listener is the first contact we make in order to connect to the Oracle database. Therefore, as DBAs, it is also the front-end component we can secure. There are
While writing the last post about paging queries (can be found here) I checked the 12c new top-n feature.The idea behind this feature is to tell Oracle, in native SQL
In the past few months I had several occasions to use the “rownum” pseudo-column to page a query result set. As we know, a query returns a result set, which
Hi all, I know I haven’t published a technical post for a while now, I’m quite busy lately. As you might know, I’m moving to Vancouver, Canada on August 3rd,
Over the years I ran into many Oracle bug related to the optimizer (the last one was yesterday with join push predicates). Many times this is related to Optimizer new
Database Identifiers are basically names of objects in the database, like tables, indexes, etc. There are restrictions about identifiers in Oracle, they can be up to 30 characters, must begin
Many times we need to understand what our server process does. When we run an application flow or in cases we cannot get or analyze a specific query, we turn
I’m moving to Vancouver, Canada! This is one of the biggest decisions I’ve made in my life, and it wasn’t an easy one. My wife decided to leave her job
As part of the ilOUG (Israeli Oracle User Group) team, I had quite a big part in organizing this conference, and it’s not easy…