About

Martin Klier

usn-it.de

Oracle RMAN destination with variable restrains “not backed up” clause

Today I was a bit surprised – being always under the impression that Oracle RMAN should accept “backup backupset not backed up to destination ‘xyz’” AND work with it successfully. But I learned that in 11.2.0.4 the Oracle RMAN “to destination” containing variables restrains the “not backed up” clause. No error thrown, but just does not work […]

read more

Oracle Database 12.2 on-premises release dates

Oracle recently announced the availability of Oracle Database 12c release 2 (12.2) for on-premises servers. https://www.performing-databases.com/en/2017/01/oracle-database-12-2-on-premises-release-dates/ Linux x86-64, Solaris SPARC and Solaris x86-64: 15-Mar-2017 Other supported platforms (Windows x86-64, IBM AIX on POWER, IBM Linux on System z, HP UX Itanium): Q2CY2017 Source: MOS DOc ID 742060.1 […]

read more

Oracle Automatic Big Table Caching – an improvement, not a fix

Too much TABLE ACCESS FULL in your Oracle Database? Thus, SQL elapsed time too slow for the demand? Plenty of Buffer Cache to create a temporary fix? maybe you want to consider Automatic Big Table Caching. Usually, Oracle only does Full Table Caching for small tables. Big ones will only use the Buffer Cache for the current chunk […]

read more

Oracle 11g unable to extend datafile but ASM disk group shows free space

Sometimes Oracle Database 11gR2 complains about not being able to extend a (lob) segment with ORA-1691, but ASM monitoring based on USABLE_FILE_MB did not fire. Adding a new data file fails with ASM ORA-15041. I was under the impression this behaviour of ASM deserved some explanation. Situation Database Alert Log complains with ORA-1691: ORA-1691: unable to extend lobsegment MYUSER.SYS_LOB0013128030C00003$$ […]

read more

My COLLABORATE16 look-at’s – an aftermath

From April 10th to April 14th 2016 many Oracle professionals congregated in Las Vegas. The three big U.S. user groups, the IOUG, the OAUG and the Quest User Group once again formed one of the best Oracle Conferences in the world: COLLABORATE16. I was honored to be there as a speaker, and glad to perform […]

read more

Featured by Oracle Magazine

The Oracle Magazine featured me in its January / February 2016 issue. I really feel honoured and would like to say thank you for the opportunity! For details, please see the Performing Databases Blog post about the publication. […]

read more