Blog: dbwhisperer

213 blogs updated: 58 min. ago
IO Calibration
One of the long time problems with Oracle is IO calibration. I am talking, of course, about DBMS_RESOURCE_MANAGER.CAL IBRATE_IO procedure. T...
26-09-2018 00:35:48 dbwhisperer Oracle
Upgrade to Oracle problems
I was recently tasked with upgrading an Oracle RDBMS to The platform is Windows 2012 R2. I know about not being able to m...
31-03-2018 22:03:37 dbwhisperer Oracle
SAP Hana is becoming increasingly popular these days. It comes with its own demo schema, STUDENT. However, being an old Oracle hack, I porte...
22-11-2017 04:39:09 dbwhisperer Oracle
Finding the trace files
In Oracle versions before 12c, it was necessary to resort to complex magic to find out the location of the process trace file. One of the mo...
10-11-2017 21:17:51 dbwhisperer Oracle
ACFS 12.2 Quirks with defragmentation
I have a 12.2 RAC cluster in my lab, on two virtual machines. Checking out what acfsutil can do, I figured out that it can supposedly do def...
01-09-2017 05:15:04 dbwhisperer Oracle
RAC 12.2, part 2
Well, today was an interesting day. My ASM, configured with so much effort, stopped working: root@rac1 grid]# . grid/.bashrc [root@rac1 grid...
28-08-2017 01:58:28 dbwhisperer Oracle
RAC 12.2
I am in the process of installing RAC 12.2. The installation procedure has undergone a significant change, for the better. It's now much eas...
27-08-2017 00:50:40 dbwhisperer Oracle
Rename Pluggable Database
I stumbled upon a convenient way to rename a pluggable database: SQL> alter system enable restricted session; System altered. SQL> alter dat...
08-12-2016 21:40:45 dbwhisperer Oracle
Oracle 12c has a new feature related to optimizer dynamic sampling. The new level 11 is supposed to put the dynamic sampling on auto pilot a...
05-11-2016 21:07:33 dbwhisperer Oracle
Oracle 12c, big table caching
In Oracle 11g, there has been annoying change which has frequently had a seriously detrimental effect to the application performance. All ta...
03-10-2016 04:59:23 dbwhisperer Oracle

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.