Auteur/autrice : admin
-
[Systeme] Create a logical volume for ora2pg
Create a logical volume of 450 Go volume group : vg_appslogical volume : lv_ora2pgmigFS : /dev/mapper/vg_apps-lv_ora2pgmigMounted on : /apps/ora2pg/migrationlvcreate -L 450G -n lv_ora2pgmig vg_apps mkfs.ext4 /dev/mapper/vg_apps-lv_ora2pgmigmkdir -p /apps/ora2pg/migrationmount /dev/mapper/vg_apps-lv_ora2pgmig /apps/ora2pg/migration
-
[PostgreSQL]tables sans oid en big serial
select sch.nspname as schemaname, tab.relname as tablename, col.attname as columnname, col.attnum as columnnumber, col.atttypid, typ.typname as columntypefrom pg_attribute coljoin pg_type […]
-
ADRCI
existe depuis la 11G , adrci est un outil pratique pour à la fois visualiser facilement le contenu de l’alert.logpurger les fichiers de logs , trace, et incidentspacakger les incidents ou les […]
-
[PostgreSQL] Find all the table and index size
SELECT TableName ,pg_size_pretty(pg_table_size(TableName)) AS TableSize ,pg_size_pretty(pg_indexes_size(TableName)) AS IndexSize ,pg_size_pretty(pg_total_relation_size(TableName)) AS TotalSize FROM ( SELECT (‘ »‘ || table_schema || ‘ ». »‘ || table_name || ‘ »‘) AS TableName FROM information_schema.tables ) AS Tables […]
-
[PostgreSQL] Streaming Replication Monitoring Script
Script de création d’une fonction « streaming_slave_check » pour la réplication en postgreSQL.
-
[Oracle] Calculate the lobs size
#!/bin/sh#script to calculate the lobs sizesqlplus /nolog<<!EOF conn / as sysdbaspool req1.sqlset head offset feed offselect ‘SELECT max(dbms_lob.getlength( »’||col.column_name|| »’)) from ‘||col.owner||’.’||col.table_name||’;’from sys.dba_tab_columns col inner join sys.dba_tables t on col.owner = t.owner and […]
-
Badge WAICF
pdf_39aaf456b8f44ab3265fd5f0e0f841e7004e8f8e2d7f1f427ce1a7c0787618104c70a3cfa1025e61334fa86bf77978ca.pdf (mobicheckin-badges.s3-eu-west-1.amazonaws.com) pdf_1cae86610290b086ab67333c9e9a994ca8a7069d0490b6b6b4a65587f90e008585f678e713994118897be3a6d2efe987.pdf (mobicheckin-badges.s3-eu-west-1.amazonaws.com)
-
PostgreSQL Un tour d’horizon !
PostgreSQL around the world PostgreSQL 16 is out. https://www.postgresql.org/docs/16/release-16.html Digging into PostgreSQL iceberg https://avestura.dev/blog/explaining-the-postgres-meme PostgreSQL partitioning https://www.timescale.com/blog/when-to-consider-postgres-partitioning/ Who does PostgreSQL https://momjian.us/main/blogs/pgblog/2023.html#September_11_2023