Report Exadata Flashcache usage

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

6 januari 2016|11g, 12c, rdbms|

Data Guard Broker property tracelevel from 11.2.0.3 and higher

In the old days, trace information of the broker command was automatically written in the logfiles for Data Guard  broker.  One of het nice things about this default logging, is the logging of the SQL statements the broker is executing. Starting from 11.2.0.3 this behavior is changed, and a tracelevel property is introduced.  When you check the broker

20 september 2013|11g, 12c, Data Guard, rdbms|