Skip to content

Instantly share code, notes, and snippets.

View achampav's full-sized avatar

achampav

View GitHub Profile
@achampav
achampav / optim_rqe_fonction.sql
Last active July 16, 2019 07:48
create or replace function f_requete_metier(v_dte_min date,v_dte_max date,v_filtre1 number,v_filtre2 number,v_filtre3 number)
return t_tbl_rqe_metier
as
pragma autonomous_transaction;
v_select t_tbl_requete_metier := t_tbl_requete_metier();
cpt number := 1;
cursor c1 is
select
d1,ca,cb,cc,c1,c2,c3,c4,c5,c6,c7,c8
from
@achampav
achampav / rqe_sur_fonction_optim.sql
Created July 16, 2019 05:50
select
d1,ca,cb,cc,c1,c2,c3,c4,c5,c6,c7,c8
from
table(f_requete_metier(&dte_min,&dte_max,&filtre1,&filtre2,&filtre3));
@achampav
achampav / all_awr.sh
Last active July 22, 2019 14:56
# Récupération d'AWR par lots (bash)
#!/bin/bash
# Pour IBM AIX : !/usr/bin/bash
###############################################################################
# @(#) Script : all_awr.sh
# @(#) Licence : GNU GPL
# @(#) Autrice : Alexandra Champavert
# @(#) Date creation : 11/03/2016
# @(#) Date modification : 22/07/2019
# @(#) Version : 1.01
@achampav
achampav / verif_libaio_oracle.sh
Last active November 19, 2019 10:52
$ ldd $ORACLE_HOME/bin/oracle | grep libaio
libaio.so.1 => /usr/lib/libaio.so.1 (0x0093d000)
$ nm $ORACLE_HOME/bin/oracle | grep io_getevent
w io_getevents@@LIBAIO_0.1
@achampav
achampav / verif_not_libaio_oracle.sh
Created November 19, 2019 10:49
$ ldd $ORACLE_HOME/bin/oracle | grep libaio
$ nm $ORACLE_HOME/bin/oracle | grep io_getevent
w io_getevents
@achampav
achampav / asynch_io.sql
Created November 19, 2019 10:54
alter system set filesystemio_options = asynch scope = spfile;
@achampav
achampav / setall.sql
Created November 19, 2019 10:57
alter system set filesystemio_options = setall scope = spfile;
@achampav
achampav / httpd-vhosts.conf
Created November 26, 2019 18:47
<VirtualHost mattermost.domaine-non-standard.com:80>
ServerAdmin webmestre@domaine-non-standard.com
DocumentRoot "/data/pourcertifs"
ServerName mattermost.domaine-non-standard.com
ErrorLog "logs/mattermost.domaine-non-standard.com-error_log"
CustomLog "logs/mattermost.domaine-non-standard.com-access_log" common
</VirtualHost>
@achampav
achampav / index.html
Created November 26, 2019 18:48
<!-- Ce fichier est dans le repertoire /data/pourcertifs -->
<html>
<head>
</head>
<body>
</body>
</html>
@achampav
achampav / listener_dataguard_1.ora
Created March 11, 2020 13:00
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = dataguard01)(PORT = 1521))
    )
  )
SID_LIST_LISTENER =
  (SID_LIST =