by Maciej Tokar | Sep 9, 2016 | ASM, Linux, Oracle Database, Other, Redhat 7
This post is quite simple, but may help some of you in the process of discovering and adding new disks to ASM diskgroups on linux servers. I tend to treat my blog as a place to keep some procedures, commands and howtos for a future reference. My memory is not perfect,...
by Maciej Tokar | Aug 17, 2016 | Oracle 11g R2, Oracle 12c R1, Oracle Database, Other
Playing recently a little with one of the databases having as a task improvement of its overall performance I had noticed a group of queries with hundreds of child cursors. Let me show you one of them. Looks more or less like this – logic doesn’t matter at...
by Maciej Tokar | Jul 18, 2016 | Oracle 11g R2, Oracle Database, Other, Patching
I was playing with the query published by Syed Jaffar Hussain to list installed patches using DBMS_QOPATCH package that I described here http://dba24.pl/2016/07/12/how-to-list-the-db-patch-details-in-sql/. Unfortunately I came across some problems and would like to...
by Maciej Tokar | Jul 13, 2016 | Enterprise Edition, Multitenancy, Oracle 12c R1, Oracle Database
I would like to gather here in this document some specific traits of the Container Databases of Oracle 12c (Multitenancy) – the traits the are not broadly known. The list will be extended when some interesting characteristic of CDBs/PDBs pops up. RMAN...
by Maciej Tokar | Jul 7, 2016 | Enterprise Edition, Multitenancy, Oracle 12c R1, Oracle Database
Playing lately with PDBs and CDBs I have encountered interesting problem. While doing some investigations I found out that it is possible to affect the CDB$ROOT parameters from the PDB level what shouldn’t be possible in my humble opinion. Let’s go...
by Maciej Tokar | May 5, 2016 | Oracle 12c R1, Oracle Database, Other, RMAN
1. Introduction I have been looking lately for the best solution in Oracle 12c to relocate database from one server to another with minimum downtime and hassle. I had a few requirements: The method should provide minimum downtime for the service affected. A MUST HAVE:...