procédure stockée pour ajouter une image de cul dans la table GONZO de ma base de données PORNO : create or replace procedure ajoute_image_X( nom_fichier in VARCHAR2, p_id_image in. read more…
Josselin Joly
Insérer plusieurs données bidon
SQL> set timing on SQL> set autotrace traceonly SQL> insert into rd 2 select 3 (dbms_random.value(1,1.99999999999999999999999999999999999999)) r_id, 4 dbms_random.string(‘U’,20) r_string from dual 5 connect by level. read more…
Library Cache Miss
Explaination of Misses in library cache during parse (Misses while looking for plan in library cache–Hard parse) Misses in library cache during execute (Misses while about to execute the plan. read more…
Mise en trace oracle , Tuning avec TKPROF
Pour tracer les requêtes SQL dans une base Oracle il faut passer la commande : execute dbms_monitor.database_trace_enable(waits=>TRUE,binds=>TRUE,instance_name=>’QUALIF’); Pour stopper la trace : execute dbms_monitor.database_trace_disable(instance_name=>’QUALIF’); La trace sera stockée sous :. read more…
oradebug
http://what-when-how.com/Tutorial/topic-16mglm7e/Secrets-of-the-Oracle-Database-520.html
Show replication status in PostgreSQL
https://www.niwi.nz/2013/02/16/replication-status-in-postgresql/ select client_addr, state, sent_location, write_location, flush_location, replay_location from pg_stat_replication; This query can output can be like this: postgres=# select client_addr, state, sent_location,write_location, flush_location, replay_location, sync_priority from pg_stat_replication;
Disable Streaming Replication without restarting either master or slave
I understand the way things work currently, but would it not be moreconvenient to let the replication be stopped and started from SQL commandslike: On Master: select pg_pause_streaming_replication(slave_fqdn);select pg_resume_streaming_replication(slave_fqdn); On. read more…
[UNIX] convertir un paquage debian en rpm et vice versa
https://blog.packagecloud.io/eng/2015/10/26/use-alien-to-convert-deb-to-rpm-and-rpm-to-deb/ https://help.ubuntu.com/community/RPM/AlienHowto
[script] Backup
backup.txt
last access table oracle
select a.obj#,a.table_scans_delta,b.object_name,b.owner,b.object_type from dba_hist_seg_stat a, dba_objects b where a.obj# = b.object_id and b.owner like ‘USERNAME%’ order by table_scans_total desc
Translate »