Today I did something very dumb when working with a vendor to trace and issue and rendered our Data Guard physical standby database unusable. I added an AFTER LOGON ON DATABASE trigger which collected information about a session and wrote it to a table. You can see the problem already: standby databases are not writable and so this is not going to work.
Very soon users connecting to the standby were complaining:
This year’s Xen Project Developer Summit is over! We had two days packed with highly technical sessions that were attended by 120 delegates. Our sessions have – as always – been very interactive with lots of discussions during and after the talks. Of course we did also have lots of time for in-corridor conversations during breaks, which most of us look forward to every year.
Truncate is useful in some serial batch processing but it breaks the read-write consistency, generates stranges errors and results for running selects, and it needs DROP ANY TABLE when run over a table that you do not own.
But also, DELETE is faster in the following test case.
In 12c, you could have over one million partition in a table, but for the sake of the universe, I’ll try with 10000.
The initial version of liblognorm v2 is almost ready. It offers many new features, like custom data types, much easier rule description langugage, and potentially even greater performance (we have not yet verfied this). As some of you know, I have worked very hard on liblognorm during the past weeks. I have now reached a very important milestone and will switch the git master branch to use the new version. If things go smooth enough, the initial release of liblognorm v2 will go along with the next rsyslog release. Daily build will have it very soon.
This is mainly a note to myself to save me from looking up the details very time I need it. I can just go to my own post. To use Autotrace in SQL you need to grant the schema the PLUSTRACE role. But in SQL Developer you need the PLUSTRACE role that has a few additional privileges. Connect to SYS as sysdba and run the following.
Oracle MySQL – News, Monitoring, Diagnostic and Backup
Event Oracle MySQL (Session in French) – Lausanne / 29.09.2015
You work on MySQL and your needs evolve? ORACLE and dbi services invite you to a workshop dedicated to the monitoring, the diagnostic and the backup of your MySQL databases. We look forward to meeting you there!
If we call the late 20th century as the information age, 21st century could well belong to Analytics. Leave alone the BIG Data that is lying across various social platforms, there is a real BIG data sitting inside the organizations.
The impact Analytics brings to the table in various walks of life in an organization is [...]