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

Database-Box: How to Use Oracle Data Pump with Oracle RAC

Database-Box: How to Use Oracle Data Pump with Oracle RAC: How to Use Oracle Data Pump with Oracle RAC📚 Using Oracle Data Pump in an Oracle Real Application Clusters (Oracle RAC) environment require...

Minimalistic Oracle: How to unload rows in an Oracle database to disk u...

Minimalistic Oracle: How to unload rows in an Oracle database to disk u...: In sqlcl, execute these lines to unload SCOTT.EMP to disk: set arraysize 200 set load batch_rows 200 UNLOAD TABLE SCOTT.EMP DIR /datadisk1/...

Database-Box: A strong technical review on Oracle Bigfile Tables...

Database-Box: A strong technical review on Oracle Bigfile Tables...:  A strong technical review on Oracle Bigfile Tablespace and exploring the challenges & Concerns for DBAs Bigfile Tablespaces in Oracle...