Boost your RMAN catalog!

15. September 2014 Uncategorized 1
We have a couple of RMAN catalogs holding details for hundreds of databases. The more databases we added to the catalog, the more time RMAN needs to query some of the catalog tables. The CPUs are starving! For the following statements we have created an index on the corresponding table: – SQL ID: 9h3pcpkzpr0vc SELECT ...

Boost your ODI jobs!

15. September 2014 Uncategorized 0
We have a lot of databases running many thousands of ODI (Oracle Data Integrator) jobs. The more jobs/sessions, the more our database holding ODI repository got saturated/busy. The CPU is starving and there are a lot of buffer gets… After we analyzed some of the busiest databases, we decided to create a couple of indexes ...

Sending secure E-Mails out of the database: SSL/TLS + UTL_SMTP + OpenSSL + ACL + Wallet

03. September 2014 Uncategorized 14
Last year I got an interesting task to do – “Sending secure E-Mails out of the database“. Additionally it should be also possible to send attachments larger than 32k! After I spent a couple of days to develop it and lost many hours to troubleshoot some errors, I would like to share some details – ...