[ORACLE] Check DB Activity HTML version

check_db_activity_html.sh performs a quick health and activity snapshot across multiple Oracle database instances on a host. It automatically discovers instances from PMON processes or accepts an explicit list of SIDs, initializes the environment per SID, connects as SYSDBA, and captures key runtime indicators (state, sessions, waits, Data Guard lag, long operations).
Output is written to a HTML file.

[ORACLE] Check DB Activity

check_db_activity.sh performs a quick health and activity snapshot across multiple Oracle database instances on a host. It automatically discovers instances from PMON processes or accepts an explicit list of SIDs, initializes the environment per SID, connects as SYSDBA, and captures key runtime indicators (state, sessions, waits, Data Guard lag, long operations).
Output is written to a timestamped log file.

[ORACLE] Diagnostic from the PID (top CPU) -> output HTML file

Output file generated : HTML file.

 

# Auto-detect top CPU process and generate HTML file in current dir

./diag_top_pid.sh

 

# Explicit PID and output directory

./diag_top_pid.sh -p 3010886 -o /appli/home/oracle/diag

 

# With explicit connect string (if not using / as sysdba)

./diag_top_pid.sh -c "sys/YourPwd@//host:1521/PDB as sysdba"

[ORACLE] Diagnostic from the PID (top CPU) -> output logfile

Output file generated : log file.

 

# Auto-detect top CPU process and generate logfile  in current dir

./diag_top_pid.sh

 

# Explicit PID and output directory

./diag_top_pid.sh -p 3010886 -o /appli/home/oracle/diag

 

# With explicit connect string (if not using / as sysdba)

./diag_top_pid.sh -c "sys/YourPwd@//host:1521/PDB as sysdba"

[PostgreSQL]pg_auto_failover

A tester et à compléter 

 

[POSTGRESQL] Les extensions indispensables

Pg_stat_statement

Pg_store_plan 

Pgsentinel

• pg_buffercache : état du cache
• pgstattuple (fragmentation des tables et index)
• Autoexplain

Source : https://public.dalibo.com/exports/formation/manuels/modules/x1/x1.handout.html

Coffre - Fort pour les identifiants mots de passe

Je recommande : 

https://www.securden.com/

Anonymization & Data Masking for PostgreSQL

Anonymisation des données dans postgres avec l'extension anon :

PostgreSQL Anonymizer (postgresql-anonymizer.readthedocs.io)

Export de la base : 

Anonymous Dumps - PostgreSQL Anonymizer (postgresql-anonymizer.readthedocs.io)

 

Calculate the value for memory postgresql parameters

Postgresql parameter : PostgreSQL Documentation: shared_buffers parameter (postgresqlco.nf)

(aide)tuner les paramètres postgresql : 

https://pgtune.leopard.in.ua/
https://www.enterprisedb.com/postgres-tutorials/how-tune-postgresql-guc-parameters
https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Server
postgresqltuner.pl

parameter_working.xlsx

Changer le owner des tables

#Change owner of tables qui sont à postgres

for tbl in `psql -qAt -c "select tablename from pg_tables where tableowner = 'postgres' and schemaname='SCHEMA';" dbname` ; 
do  psql -c "alter table SCHEMA."$tbl" owner to NEW_OWNER" dbname ; done