Skip to content

Instantly share code, notes, and snippets.

View Tracnac's full-sized avatar

Tracnac

View GitHub Profile
@Tracnac
Tracnac / elefen.md
Last active December 6, 2022 14:12
Lingua Franca Nova

Lingua Franca Nova

le

@Tracnac
Tracnac / playlists
Created December 5, 2022 13:44
Playlists
#EXTM3U
#EXTINF:0,1.FM Classic
http://185.33.21.112:80/crock_mobile_mp3
#EXTM3U
#EXTINF:0,Radio Paradise
https://stream.radioparadise.com/aac-320
@Tracnac
Tracnac / Couple de sérrage vélo.md
Created October 19, 2022 12:01
Couple de sérrage vélo #cycle #mécanique

Boitier de pédalier : 35-50 NM * Pédalier Shimano :

  • Réglage de la contrainte : 0.7-1.5 NM
  • Manivelle : 12-15 NM Manette : 6-8 NM Dérailleur avant : 5-7 NM Dérailleur arrière : 8-10 NM Etrier avant : Pivot acier / carbone: 8-10 NM / * Etrier arrière : 8-10 NM Patin de frein : 5-7 NM
@Tracnac
Tracnac / Alterer une séquence sans la supprimer.md
Last active October 19, 2022 11:59
Alterer une séquence sans la supprimer #oracle #sql
alter sequence seq increment by (desired_value-current_value);
select seq.nextval from dual;
alter sequence seq increment by (old_increment);
@Tracnac
Tracnac / ASM Imbalance.md
Last active October 19, 2022 11:58
ASM Imbalance #oracle #cluster
select group_number, min(free_mb),max(free_mb) from v$asm_disk group by group_number;


column "Diskgroup" format A30
column "Imbalance" format 99.9 Heading "Percent|Imbalance"
column "Variance" format 99.9 Heading "Percent|Disk Size|Variance"
column "MinFree" format 99.9 Heading "Minimum|Percent|Free"
column "DiskCnt" format 9999 Heading "Disk|Count"
column "Type" format A10 Heading "Diskgroup|Redundancy"
@Tracnac
Tracnac / Auto SQLTUNE Report.md
Last active October 19, 2022 11:57
Auto SQLTUNE Report #oracle #sql
set long 5000000
set linesize 512
set pagesize 10000
column auto_tuning_task_report format a256


select DBMS_AUTO_SQLTUNE.REPORT_AUTO_TUNING_TASK(
NULL,
NULL,
@Tracnac
Tracnac / AWR en SQL.md
Last active October 19, 2022 11:56
AWR en SQL #oracle #sql

SYSDATE – 0 = AUJOURD’HUI SYSDATE – 1 = HIER SYSDATE – 2 = AVANT HIER etc…

set linesize 2048
set pagesize 0
set trimout on
set trimspool on
@Tracnac
Tracnac / Catblock.md
Last active October 19, 2022 11:55
Catblock #oracle #sql

The script creates dba_locks and dba_blockers, along with the following views:

$ORACLE_HOME/rdbms/admin/catblock.sql
  • dba_kgllock
  • dba_lock (dba_locks is synonym for this)
  • dba_lock_internal
  • dba_dml_locks
@Tracnac
Tracnac / Change OCR location.md
Last active October 19, 2022 11:54
Change OCR location #oracle #cluster

Change OCR location :

Under root :

cd $GRID_HOME
./ocrcheck
./ocrconfig -add +NEW_DG
./ocrconfig -delete +OLD_DG