Blog: dbwhisperer

209 blogs updated: 40 min. ago
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
Smarter DG Broker in Oracle 12c
In Oracle 11G, DG Broker needed to be told whether the standby database was physical or logical. The command to add database in 11G was some...
29-08-2016 00:23:01 dbwhisperer Oracle
Synthetic Full Backup for Oracle
Synthetic full backup is a method for combining incremental backup into a full backup. It is not a new thing, many backup utilities can do t...
28-08-2016 07:43:09 dbwhisperer Oracle
A New Version of an Old Trick
A long, long time ago, people started using the following SQL idiom: with t as (select /*+ materialize */ ..) select . from t If my memory s...
05-10-2015 10:53:47 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.