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

Minimalistic Oracle: How to delete all lines above and below the curren...

Minimalistic Oracle: How to delete all lines above and below the curren...: In vi (or vim), you can delete all lines above the current line with this one simple command: :1,.−1d To delete all rows above the current...

Minimalistic Oracle: Convert all contents in a file to lower case using...

Minimalistic Oracle: Convert all contents in a file to lower case using...: Open your file in vi vi myfile Press the escape key to enter interactive mode, then type :%s/.*/\L&/ Press escape, then save + exit ...

How to list the postgres processes running on your server and what their jobs are

Minimalistic Oracle: How to list the postgres processes running on your...: A neet little trick I learned from the series " Mirage of memory, part 2: PSS " ps -fu postgres | grep $(pgrep -f postmaster) p...