Below you will find a script which I created for a customer, due to the fact we needed to have an overview of the flash cache usage after enable write back mode. In a table the storage cell, allocated flash cache, used and dirty is provide. Very useful to see in one run the current
Namens het gehele GRID-IT team bedanken wij onze klanten voor het vertrouwen wat u ons heeft gegeven in het afgelopen jaar en we hopen onze kennis en kunde ook in 2016 voor u te mogen inzetten. Daar naast wensen wij u en uw naaste een goed maar vooral gezond 2016!
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