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...
Thursday, November 20, 2025
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/...
Monday, November 17, 2025
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...
Subscribe to:
Comments (Atom)
-
Minimalistic Oracle: How to detach an ORACLE_HOME to an existing inventory : I want to detach an existing oracle_home from my inventory. No...
-
Bryan's Oracle Blog: Oracle Database Encryption (TDE) : Oracle TDE (Transparent Data Encryption) is a critical piece of data protection,...
-
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)...