Minimalistic Oracle: Dropping an audit policy for a specific user

Minimalistic Oracle: Dropping an audit policy for a specific user: You have the following audit policy: CREATE AUDIT POLICY monitor_sys_everything ACTIONS ALL; AUDIT POLICY monitor_sys_everything BY SYS;...

Erman Arslan's Oracle Blog: Exadata X11M / X11M-Z / Naming, Elasticity, RoCE a...

Erman Arslan's Oracle Blog: Exadata X11M / X11M-Z / Naming, Elasticity, RoCE a...: Recently dived into a new project with newest Exadata(s) inside :) and today, I wanted to share you a quick info about the newest Exadata na...

Minimalistic Oracle: How to detach an ORACLE_HOME to an existing inventory

Minimalistic Oracle: How to detach an ORACLE_HOME to an existing inventory: I want to detach an existing oracle_home from my inventory. Note that the last argument must be the full path to the oracle software, NOT t...

Minimalistic Oracle: Compression for Postgres tables

Minimalistic Oracle: Compression for Postgres tables: In PostgreSQL you don’t create a “compressed table” in the Oracle sense. Rather, compression is achieved per-column compression via TOAST, p...

Bryan's Oracle Blog: Oracle Database Encryption (TDE)

Bryan's Oracle Blog: Oracle Database Encryption (TDE): Oracle TDE (Transparent Data Encryption) is a critical piece of data protection, and online encryption is a great tool you can use to simpli...

Oracle DBA by Example. Code samples, Scripts, Reference.: du vs df giving wrong disk usage results

Oracle DBA by Example. Code samples, Scripts, Reference.: du vs df giving wrong disk usage results: du vs df giving wrong disk usage results In OS, oracle is reported as using 168 Gb While in oracle, the usage is only 78 Gb How can that be?...

Minimalistic Oracle: Find total size of all databases in PostgreSQL clu...

Minimalistic Oracle: Find total size of all databases in PostgreSQL clu...: SELECT database, size FROM ( SELECT datname AS database, pg_size_pretty(pg_database_size(datname)) AS size, 0 AS sort_o...