Friday, January 30, 2026
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...
Wednesday, January 21, 2026
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...
Sunday, December 14, 2025
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?...
Monday, November 24, 2025
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...
Subscribe to:
Posts (Atom)
Minimalistic Oracle: A SQL-centric and a session-centric way to query V...
Minimalistic Oracle: A SQL-centric and a session-centric way to query V... : Version 1: SQL-Centric This version starts from V$SQL and...
-
When a rac database instance fails, a service which is running on this failed instance (configured as preferred) will fail over to the avail...
-
Minimalistic Oracle: How to detach an ORACLE_HOME to an existing inventory : I want to detach an existing oracle_home from my inventory. No...
-
To see EXADATA machine information of OCI cloud, follow below method. 1) Log in to EXACS/EXACC compute (db server) node with ROOT user. 2)...