Catégorie : Oracle12C,19C

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

La requête suivant permet de te lister la taille des partitions qui contiennent des LOBS  :   SELECT DS.TABLESPACE_NAME, SEGMENT_NAME,PARTITION_NAME,ROUND(SUM(DS.BYTES)/(1024 * 1024)) AS MBFROM DBA_SEGMENTS DSWHERE DS.TABLESPACE_NAME not in (‘SYSAUX’,’SYSTEM’)AND […]

beginfor f in (select table_name from user_tables) loopexecute immediate ‘drop table « ‘||f.table_name||’ » cascade constraints’;end loop;for f in (select object_type, object_name from user_objects where object_type in (‘SEQUENCE’,’VIEW’,’FUNCTION’,’PROCEDURE’,’PACKAGE’,’SYNONYM’,’DATABASE LINK’)) loopexecute immediate ‘drop […]

http://www.br8dba.com/tag/manually-run-sql-advisor/#2

ts_extent_map.sql

exec dbms_space_admin.drop_empty_segments(schema_name=>’HR’);