Oracle has an interesting package to provide an event-based logic named dbms_alert. In this article I will use it to create a classic queue processing. First, we need to create a simple table, which store queue message ID and...
There are some cases, when you need to access an OS running your database. You need it just right now, but you don’t have an accees or permissions. Let’s do it from database using java stored procedure. If you want...
In this article I will show you how to create Oracle queues, pull messages and push them using subscriber. Before we begin, please, grant dbms_aqadm and dbms_aq execute privileges to user. Queue table use an object data type...
From the version 10g, Oracle database let you to use AWR for system performance analisis. I will show you how to generate AWR report fast and simple. All commands are running under SYS user, but you can use another one with...
One of the key moments using HP Vertica is an optimization of data storage using encoding. Encoding reduces disk space usage, making it faster to get huge amounts of data using on-the-fly decoding. We can suggest optimal encoding...
