Oracle VM Site Review - Oracle VM Health Check
view counter

Feed items

Get Up to Speed at learn.wordpress.com

If you just started a spandy new WordPress blog or site and want to work on setup and configuration in your spare time, we’ve recently refreshed a resource that might be just the thing for you: learn.wordpress.com.

Have you just created a blog or website to:

Get Up to Speed at learn.wordpress.com

If you just started a spandy new WordPress blog or site and want to work on setup and configuration in your spare time, we’ve recently refreshed a resource that might be just the thing for you: learn.wordpress.com.

Have you just created a blog or website to:

Non-working logon trigger on Data Guard standby database

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:

Event Report: Xen Project Developer Summit 2015

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.

DELETE is faster than TRUNCATE

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.

moving towards liblognorm v2

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.

Enabling Autotrace in SQL Developer

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.

Event Oracle MySQL (Session in French) – Lausanne / 29.09.2015

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!

HR Analytics & BIG Data – The Rise of Employee Analytics

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 [...]

view counter