Oracle Open World 2016 was really amazing. It was already 1 month ago and only now I had some time to talk about it and Oracle trends for this year. This is the biggest event in DBA area and was outstanding to be in a place with so many experts exchanging ideas! So, there are a lot of …
Aug 16
Oracle Scheduler Jobs and Database Vault
As everybody knows, the “Oracle Scheduler” is the official task manager for an Oracle Database. It is a robust and complex tool, allowing the user to create chains, parameterized intervals on several types of metrics, execution windows, etc. In most cases, when a job is created, modified and executed by its owner, there are not many …
Aug 11
AWR snapshots not being generated even though it’s enabled
Those days, I was facing an issue in my Oracle Database 11.2.0.4. My AWR Snapshots were not being generated even though it was full enabled. I did some checks to be sure I had no issues: Checked that I had enough free space on SYSAUX tablespace. I was using only 5GB of the total 15GB. My control_management_pack_access was …
Aug 11
How to protect CREATE PUBLIC SYNONYM against privilege escalation
During my last presentation on GUOB Tech Tour 2016 – Oracle Technology Tour LA – Brazil, I demonstrate how we could easily use the CREATE PUBLIC SYNONYM privilege to escalate and get DBA privilege. In this article, I will give you a package that I’ve created and I use in my systems to allow users to …
Jun 16
GUOB TECHDAY 2016
The year passed very fast and GUOB TechDay 2016 is now closer than it looks! And for those who do not know, this is one of the major Oracle users event in Brazil. It takes place annually in São Paulo, on a July or August Saturday. Unlike the OOW, which is a more commercial and …
About
Rodrigo Jorge
Oracle OCM Database 11g & 12c
Oracle OCM MAA & Cloud
Oracle OCE Data Guard 12c
Oracle OCE RAC and Grid 11gR2 & 12c
Oracle OCE Performance Tuning 11g & 12c
Oracle OCS Security 11g
Oracle OCS Data Warehousing 11g
