#!/bin/bash input file format is: hostname USAGE: ./scan_oem_ports_remote_hosts.sh hostfile if test ‘X' »$1″ = ‘X’; then echo -n « ENter full path and name of file containing host names: « ;read file else. read more…
Josselin Joly
Patching OEM 13c Release 2 PSU for OMS and Agent
Patching OMS 13c Release 2 (13.2.0.0.181016) System PSU Patch :- Download Link : OPatch version 13.9.3.3.0 for EMCC 13.x customers Only (not for FMW 12c) (Patch) Download Link : OPatch version 13.9.3.3.0. read more…
optimizer_index_cost_adj.sql
col c1 heading ‘Average Waits for|Full Scan Read I/O’ format 9999.999col c2 heading ‘Average Waits for|Index Read I/O’ format 9999.999col c3 heading ‘Percent of| I/O Waits|for Full Scans’ format 9.99col. read more…
PGA_AGGREGATE_TARGET vs PGA_AGGREGATE_LIMIT
WITH pgastat_denorm_1 AS ( SELECT /*+ MATERIALIZE NO_MERGE */ snap_id, dbid, instance_number, SUM(CASE name WHEN ‘PGA memory freed back to OS’ THEN value ELSE 0 END) pga_mem_freed_to_os, SUM(CASE name WHEN. read more…
Paramètre obsolète
https://mikedietrichde.com/2016/11/22/optimizer_adaptive_features-obsolete-in-oracle-12-2/ The Oracle Database 12.1 parameter OPTIMIZER_ADAPTIVE_FEATURES has been made OBSOLETE (i.e. must be removed from the SPFILE when upgrading) in Oracle Database 12.2. It gets replaced with two parameters of whom one is enabled, the. read more…
Adjusting the optimizer_index_cost_adj Parameter
https://xcoolwinds.wordpress.com/2013/08/23/adjusting-the-optimizer-index-cost-adj-parameter/ Issue the following query to view the average wait times for both of the wait events: SQL> select event, average_wait from v$system_event where event like ‘db file s%read’;EVENT AVERAGE_WAIT——————————— ——————————-db file. read more…
PLug in sqlserver pour OEM 13c
https://docs.oracle.com/cd/E63000_01/SQLPG/overview.htm#SQLPG108 https://docs.oracle.com/cd/E24628_01/doc.121/e24473/plugin_mngr.htm#EMADM13102
OEM Agent 12c: Common issues and resolutions
https://developer.rackspace.com/blog/oemagent12c/ CPU too heavy
Constraint NOT NULL missing
Data Pump Import With EXCLUDE=CONSTRAINT Or INCLUDE=CONSTRAINT Is Excluding And Respectively Not Including NOT NULL Constraints (Doc ID 1930631.1) After doing a Data Pump import (impdp) in 12.1.0.2 database. read more…
Problème avant upgrade en 12.2
Pending dst session datapump (x) https://blog.oracle-ninja.com/2013/09/17/stuck-timezone-upgrades-and-smart-scans/
Translate »