Starting with Oracle 12.1 we can export views as tables. This means that the export will contains a “create table” command and its data, while the original object was actually
Starting with Oracle 12.1 we can export views as tables. This means that the export will contains a “create table” command and its data, while the original object was actually
I’ve written a few “diagnostics” posts in the past (you can see them all under the “Troubleshooting” category). People really like these type of posts, and I got many comments
Oracle is using the same numbering scheme since I’ve started working with it (7.2). The 5 number scheme with the release number, patchset and PSU is quite confusing and the
After talking a bit about the AWR report (if you haven’t read the previous posts, you can find part 1 here and part 2 here), I think one of the
OK, so KScope17 was my first KScope, don’t be petty about it. I also know that it’s been already a month, but I’ve been doing a lot and didn’t have
In the previous part I explained the top part of the report. In this part I’ll continue with the actual information about database activity, what we are looking for and
Once in a while I get requests for some information about reading and analyzing an AWR report. I have been thinking for a long time about writing such a post,
The LIKE operator is a very useful one. It is used to match strings with partial match while using the underscore (‘_’) as a single character wildcard and the percentage sign
In February ’17 I participated in Mike Dietrich’s upgrade workshop and it was great! I don’t want to repeat stuff that he said there, you can read everything on his
One of my customers is working with ASM and their database grows really fast. So every one in a while we need to add another ASM disk to the system.