fljdin

SELECT schemaname, relname, pg_size_pretty(pg_relation_size(relname::regclass)) relsize, last_vacuum, last_autovacuum, last_analyze, last_autoanalyze
  FROM pg_stat_user_tables 
 WHERE greatest(last_autoanalyze,last_analyze) < now()-interval '5d' 
   AND pg_relation_size(relname::regclass) > 10e6;

fljdin

SELECT 
  sum(heap_blks_read) as heap_read,
  sum(heap_blks_hit)  as heap_hit,
  sum(heap_blks_hit) / (sum(heap_blks_hit) + sum(heap_blks_read)) as ratio
FROM 
  pg_statio_user_tables;

fljdin

awk '/Hugepagesize:/{p=$2}/ 0 /{next}/ kB$/{v[sprintf("%9d GB %-s",int($2/1024/1024),$0)]=$0;next}{h[$0]=$2}END{for(k in v) print k;for (k in h) print sprintf("%9d GB %-s",p*h[k]/1024/1024,k)}' /proc/meminfo|sort -nr|grep --color=auto -E "^|.*(Huge.*_[TF]|Mem).*:|"

fljdin

#! /usr/bin/env bash
#
# comment : perform health check on clusterware and associated databases
# deploy  : chmod +x /usr/local/bin/check_cluster

export version="20170426.0930"

cif ()  { printf "[INFO]\t%s\n" "$1" ; }
ttl ()  { printf "\033[1;34m----\t%s\033[0m\n" "$1" ; }
cok ()  { printf "\033[1;32m[OK]\033[0m\t%s\n" "$1" ; }

fljdin

repctl

Outil de mise en synchro et synchro régulière basé sur le logshipping Oracle Database.

La réplication impose que les bases sources et cibles aient le mode ARCHIVELOG actifs et que la FRA soit un système de fichier standard (EXT4, ACFS, etc.)

Configuration

fljdin

-- Create the trace
DECLARE @TraceID int
DECLARE @stoptime_init datetime = NULL
DECLARE @maxfilesize_init bigint = 50
DECLARE @filecount_init int = 20
DECLARE @tracefile_init nvarchar(200) = N'D:\MSSQL\TRACE\Trace_1second'
DECLARE @duration bigint = 1000000 -- microseconds
  
-- Stop and clear it if running
SELECT @TraceID = traceid FROM ::fn_trace_getinfo(NULL) WHERE property = 2 AND CONVERT(varchar, value) LIKE @tracefile_init + '%';

fljdin

SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;

fljdin

select
  case when level = 1 then own || '.' || obj || ' (' || typ || ')' else
  lpad (' ', 2*(level-1)) || obj || nvl2 (typ, ' (' || typ || ')', null)
  end
from
  (
  /* THE OBJECTS */
    select 
      null          p1, 
      null          p2,

fljdin

set long 1000
set pagesize 0
select  DBMS_METADATA.GET_DDL('OPS$DBO.INDEX','') from DUAL;

fljdin

set line 200
col columns for a100
select i.table_name, i.index_name, listagg(i.column_name, ',') within group (order by i.column_position) columns
 from dba_ind_columns i
 left join dba_constraints c on i.index_name = c.index_name
where i.index_owner = '&owner' and i.table_name = '&table' 
group by i.table_name, i.index_name;