Auteur/autrice : admin

#!/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 […]

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 […]

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 […]

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 […]

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 […]