Les plans d'exécution sont historisés

Désolé J-F tu avais raison :

 

select SQL_ID,COST,TIME from DBA_HIST_SQL_PLAN

Tuning Latch Contention: Cache-Buffers-Chain Latches

Researching Further

Re-querying v$session_wait, I see that a couple of latches are hot. I will consider one latch children with latch address 19875043200 as an example, and drill down further.

 

Hang Those Buffers!

Next, I needed to find buffers protected by these latch children, and then find the buffers causing latch contention. Many such hash buckets (and so, numerous buffers) are protected by a latch children. 

I don’t favour the above script, since its performance is not optimal. It is much easier to dump the blocks and convert them to object ids. Let’s dump these three blocks.

Now I can query dba_objects to find the object_names.

https://blog.pythian.com/tuning-latch-contention-cache-buffers-chain-latches/

[PostgreSQL] Identifying locked objects

my client called me. Help I m doing big insert on partitionned tables and it s running very low.

Beside that the statement is faster during the midnight.

 

Amélioration de la version Oracle 19c

ouais

Problème de compilation de trigger RMAN après montée de version en 12.2

alter trigger RMAN.VPC_CONTEXT_TRG disable; 

 

=> marche pas :(

lancer :

 

@?/rdbms/admin/dbmsrmanvpc.sql -vpd rman

 

puis UPGRADE CATALOG ; 

source

Merci aux dev SQL

Merci aux dev sql qui m'ont bien aidé sur ce forum : 

 

https://www.developpez.net/forums/d2021961/bases-donnees/langage-sql/insert-into-long-s-executer-optimiser/#post11229277

Gestion entreprise

avocat généraliste :
01 64 86 14 05

Le lundi : de 09h00 à 12h00 et de 13h30 à 18h45
Le mardi : de 09h00 à 12h00 et de 13h30 à 17h30
Le mercredi : de 09h00 à 12h00 et de 13h30 à 17h30
Le jeudi : de 09h00 à 12h00 et de 13h30 à 17h30
Le vendredi : de 09h00 à 12h30 et de 13h30 à 16h15
Par correspondance

Maison de justice et du droit des Ulis
rue des Bergeres
91940 LES ULIS

Maison de l'avocat à Evry
01 60 77 00 28

lundi au vendredi de 9h à 12h
mercredi 14h à 17h00

 

arpagon

gratuit

autres

Lister les disques et type de disque

lsdev -Cc disk

exemple : 

hdisk0 Available C6-T1-01 Hitachi MPIO Disk VSP (Fibre)
hdisk26 Available C6-T1-01 Hitachi MPIO Disk VSP (Fibre)
hdisk27 Available C6-T1-01 Hitachi MPIO Disk VSP (Fibre)
hdisk28 Available C6-T1-01 Hitachi MPIO Disk VSP (Fibre)
hdisk29 Available C6-T1-01 Hitachi MPIO Disk VSP (Fibre)
hdisk30 Available C6-T1-01 Hitachi MPIO Disk VSP (Fibre)
hdisk31 Available C6-T1-01 Hitachi MPIO Disk VSP (Fibre)
hdisk32 Available C6-T1-01 Hitachi MPIO Disk VSP (Fibre)
hdisk33 Available C4-T1-01 Hitachi MPIO Disk VSP (Fibre)
hdisk34 Available C4-T1-01 Hitachi MPIO Disk VSP (Fibre)

Show which hdisk(s) each of your filesystems reside on for AIX

Hyper utile :

 

#!/bin/ksh
for vg in `lsvg -o`; do 
        for fs in `lsvgfs $vg`; do 
                printf "%-22s" $fs; 
                for disk in `lsvg -p $vg | tail +3 | awk '{print $1}'`; do
                        lspv -l $disk | grep -q " ${fs}$" && printf "%-8s" $disk; 
                done; 
                echo
        done; 
done

source

CHECK SUPPORTED ALGORITHMS IN OPENSSH

https://cinhtau.net/2016/03/21/check-supported-algorithms-in-openssh/

 

 -Q cipher | cipher-auth | mac | kex | key
             Queries ssh for the algorithms supported for the specified version 2.  The available features are: cipher (supported sym‐
             metric ciphers), cipher-auth (supported symmetric ciphers that support authenticated encryption), mac (supported message
             integrity codes), kex (key exchange algorithms), key (key types).