This year we organized the 2nd ever BCOUG Tech Day. Last year we (the BCOUG board) decided to try and go for a full day conference for the first time
WIT and LanguageWIT and Language
I’ve been thinking about this post for a while, but it took me some time to write it because this is not the kind of thing I usually write about.
Strange Index BehaviorStrange Index Behavior
During a performance problem I had with a query I wanted to create an index on the table. Since this was a large table I wanted the index to include
UTOUG Training DaysUTOUG Training Days
You probably know by now that I moved to Vancouver about 3.5 years ago. You also know by now that I like conferences (especially speaking, but also meet people and
Did You Know #29 – Who is Executing Jobs?Did You Know #29 – Who is Executing Jobs?
When you create a job using DBMS_SCHEDULER.CREATE_JOB you can specify a schema for the job (job_name => ‘my_schema.my_job’). What does it mean?
Thoughts about Oracle Version ChangeThoughts about Oracle Version Change
It’s been about a year since Oracle decided to change their database version schema, from version with a couple of releases (e.g. 12.1 is 12cR1 and 12.2 is 12cR2) to
More 19c New FeaturesMore 19c New Features
I’ve just noticed that Oracle 19c documentation is online here, so I’m writing this post after going over the “New Features” guide and finding some interesting stuff there.
Why I Don't Like ANSI JoinsWhy I Don't Like ANSI Joins
Since Oracle started supporting ANSI joins in 9i, the Oracle community was divided into two groups: one loved it and tried to convince everyone to use it, and the other
Top-N QueriesTop-N Queries
This is an old story. It started in 2015 when I found a problem with TOP-N query performance. I wrote a blog post about it and later an update. Here
Bash script to monitor log filesBash script to monitor log files
This is a short post about something I wrote a while ago. I wrote a monitoring tool (haven’t we all?) and wanted to add a capability to scan log files