Linux: sftp gets stalled after some time and it won't progress

 The solution that helped me, was to run instead:

>scp -l 8192 <file> <remote_destination>

It is slower, but ot doesn't get stalled. I hope it will help others as well.

How to find if the Oracle Client installation is 32 or 64 bits, on Linux?

 [prdbmleod1@DUMMY]/u01/app/oracle/product/19.3.0/bin > file exp

exp: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked, interpreter /lib/ld-linux.so.2, for GNU/Linux 2.6.32, BuildID[sha1]=a04d7ff56d7b1b76605408eae9135f3deec77518, not stripped

Site that is formatting very long sql_text, a life safer :-)

 https://www.dpriver.com/pp/sqlformat.htm

How to run a script on Linux, silent mode and having as input

 [florinm]$ sudo printf 'y\ny' | sudo /u01/app/oracle/product/19.3.0/root.sh

PGA_AGGREGATE_TARGET

 PGA_AGGREGATE_LIMIT can be set to 0 either in a parameter file or dynamically after startup. If a value of 0 is specified, it means there is no limit to the aggregate PGA memory consumed by the instance.

Oracle GG, how to skip a failing transactions? The Replicat is in ABBEND mode

 >START REPLICAT replicate_name SKIPTRANSACTION

How to install oracle 19c in silent mode? This is useful to overcome the Xterm issue

 ./runInstaller -silent -ignorePrereqFailure -waitforcompletion -responseFile /u01/app/oracle/soft/install/response/db_install.rsp -debug