When you are using the tenant option it can be very useful to run sql script or sql statements agains all or some of the PDBS. Of course you can logon to each individual pluggable database but it would be more useful if you do this in one run. One of the perl scripts Oracle
When it is required to resize the online redo logfiles in a Data Guard configuration you need to perform the resize for both the online redo logfiles as well as the standby redo logfiles. In this blog post an example how to accomplish this task. In another post will explain an issue which can occur
samen met verzorgen voor de laatste keer dit jaar een New Features 12c training. Er zijn nog 3 plaatsen vrij. Ook aan de slag met Oracle RDBMS 12c? Eerste 2 dagen lekker aan de slag met basis concept van multitenancy, pluggable databases. De andere 2 dagen RMAN, Security, Performance, VLDB en een aantal generieke RDBMS features.
One of the great new features is unified auditing in Oracle 12c, with this feature you can start to define your own auditing, or use one of the built in policies. We don’t look into this blog about the general unified auditing. But what will happen when you use Unified Auditing and the database is
Last week I needed to validate an issue with an archive backup on a standby database. And I run into a “problem” which seems to be a change of behavior starting from 11.2.0.4. which I wasn’t aware of. First lets me show the error message before I explain the change in behavior. When I connect
When you plugin/clone a pluggable from a source container into a target container it is possible you have a mismatch in parameters or patches installed. In this blog post I list an example what you will notice when you perform a pluggable cloning action, into a new container with newer installed patches. I always advise
In a previous post I talked about the Force Full DB Caching feature introduced in Oracle RDBMS release 12.1.0.2. This feature is available in two flavours. – Database Caching (when possible) – Database Caching with force option. In this blog we look at the database caching when possible. And this one is simple,
With the introduction of Oracle 12c, 12.1.0.2 a few new features are introduced. One of those features is FULL Database Caching. No additional licensing is required when using this feature This feature is available in two flavours. - Database Caching (when possible) - Database Caching with force option. In this blog we look at the
I’ve created a document with a short howto on creating a master - slave DNS server configuration. You can find it here: Creating a master-slave DNS configuration.
One of the new features of 12.1 is the automatic stats collection when performing a Create table as Select action. But be aware of the site effects when using this feature, one a index is created it is also maintained but only for the first time, when an append is performed or a turncate table