InnerLife.io

  • Database
    • Oracle
    • HP Vertica
    • PostgreSQL
  • Administration
    • Virtualization
    • OpenVPN
    • HTTPD
    • OrangePI
  • Android
  • About
  • RU

Oracle DB. Changing and fixing query execution plan using dbms_spm.

22.01.2016
by InnerLife
5 min read
1 Comment

Oracle Query Optimizer generally works well, but sometimes it makes your fast and polished queries slow down. Often, you can not simply add hints and recompile them on production environment. In such case be ready to use dbms_spm...

Continue reading

Oracle DB. Using dbms_alert for queuing and parallel data processing.

21.01.2016
by InnerLife
3 min read
Add Comment

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

Continue reading

Oracle DB. Run OS command from database itself using Java stored procedure.

20.01.2016
by InnerLife
2 min read
Add Comment

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

Continue reading

Oracle DB. Advanced Queuing. Simple subscriber example.

20.01.2016
by InnerLife
4 min read
Add Comment

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

Continue reading

Oracle DB. Simple AWR report generation from the database itself.

20.01.2016
by InnerLife
2 min read
Add Comment

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

Continue reading

Previous 1 … 3 4 5 6 Next

Featured Posts

  • How to minimize your Docker image. 5 tips and tricks. Example of minifying from 328MB to 56MB.
  • Multicast Proxy Server
  • DBMail over PostgreSQL + Postfix + SASL on Debian. Part 1. Introduction.
  • Running QEMU VM with the latest kernel inside 2.6 OpenVZ container.
  • Fault tolerant PostgreSQL cluster with automatic failover using Repmgr and Barman. Part 1. Introduction.



This site is hosted on php-friends.de VPS.

Copyright © 2021. Created by Meks. Powered by WordPress.
  • Database
    • Oracle
    • HP Vertica
    • PostgreSQL
  • Administration
    • Virtualization
    • OpenVPN
    • HTTPD
    • OrangePI
  • Android
  • About
  • RU