Color your SQL*Plus scripts!
You’re in a hurry and want to quick identify some hot spot in the output you got from your SQL*Plus script? Color your SQL*Plus scripts! Here is one dummy example of it: create or replace package colors is function color(p_text in varchar2, p_fg_color in varchar2 default \'m\', p_bg_color in varchar2 default \'40m\') return varchar2; procedure ...
ORA-01548 & drop Undo tablespace
Recently I was cloning one RAC database to single instance database, and afterwards I wanted to remove one of the Undo tablespaces. Unfortunately, it didn’t go so smoothly as I expected… SQL> drop tablespace UNDOTBS2 including contents and datafiles; * ERROR at line 1: ORA-01548: active rollback segment \'_SYSSMU39_1583257383$\' found, terminate dropping tablespace Hmmm, ok ...
Start OMS failed with “javax.xml.stream.XMLStreamException: Premature end of file encountered”
There was one tricky problem at the customers site yesterday – Enteprise Manager was “dead”. I tried to open Enterprise Manager login page, but nothing happened… not even the famous 500 Internal server error displayed! Strange… Ok, I logged into that server via ssh and checked log file. This is the output I found: <Feb ...
Boost your RMAN catalog!
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!
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
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 – ...
Search Anything