Oracle a modo mio - Cronologia

WikiSysop: /* db block checking */

2026-05-15T14:46:27Z

db block checking

← Versione meno recente		Versione delle 14:46, 15 mag 2026
Riga 130:		Riga 130:
	alter system set db_block_checksum='FULL' scope=spfile sid='*';		alter system set db_block_checksum='FULL' scope=spfile sid='*';

			dalla versione 11.2 è possibile modificare a caldo:
	11.2

	alter system set db_block_checking='FULL' scope=both sid='*';		alter system set db_block_checking='FULL' scope=both sid='*';

2026-05-15T14:44:13Z

pulizia alert e diag con adrci

← Versione meno recente		Versione delle 14:44, 15 mag 2026
Riga 157:		Riga 157:

	==pulizia alert e diag con adrci==		==pulizia alert e diag con adrci==

			<pre>
			#!/bin/bash


			#ORACLE_HOME=/sw/app/oracle/product/19.0.0.0/db_3
			#ORACLE_SID=CECOPRD1
			#ORAENV_ASK=NO
			#export ORACLE_HOME ORACLE_SID ORAENV_ASK
			#. oraenv
			#unset ORAENV_ASK


			. /home/oracle/.CECOPRD.env

			#ADR_BASE=/oradiag/rdbmsdiag
			#export ADR_BASE

			# 21 giorni (504 ore 30240 minuti)

			for ADR_BASE in /oradiag/rdbmsdiag /oradiag/griddiag
			do
			echo ADR_BASE=$ADR_BASE
			export ADR_BASE=$ADR_BASE
			sleep 2

			adrci exec='show homes' \| grep -v 'ADR Homes:' \| while read H
			do
			adrci exec="set home $H
			set control $SHORTP_POLICY=504$
			set control $LONGP_POLICY=504$
			show control
			purge -age 30240
			"
			done
			done
			</pre>

	==incrementare SDU e BUF_SIZE==		==incrementare SDU e BUF_SIZE==

2026-05-15T14:43:54Z

pulizia trace con adrci

← Versione meno recente		Versione delle 14:43, 15 mag 2026
Riga 314:		Riga 314:
	http://ksun-oracle.blogspot.com/2015/12/oracle-bigfile-tablespace-pre.html		http://ksun-oracle.blogspot.com/2015/12/oracle-bigfile-tablespace-pre.html

	=pulizia trace con adrci=
	<pre>
	#!/bin/bash


	#ORACLE_HOME=/sw/app/oracle/product/19.0.0.0/db_3
	#ORACLE_SID=CECOPRD1
	#ORAENV_ASK=NO
	#export ORACLE_HOME ORACLE_SID ORAENV_ASK
	#. oraenv
	#unset ORAENV_ASK


	. /home/oracle/.CECOPRD.env

	#ADR_BASE=/oradiag/rdbmsdiag
	#export ADR_BASE

	# 21 giorni (504 ore 30240 minuti)

	for ADR_BASE in /oradiag/rdbmsdiag /oradiag/griddiag
	do
	echo ADR_BASE=$ADR_BASE
	export ADR_BASE=$ADR_BASE
	sleep 2

	adrci exec='show homes' \| grep -v 'ADR Homes:' \| while read H
	do
	adrci exec="set home $H
	set control $SHORTP_POLICY=504$
	set control $LONGP_POLICY=504$
	show control
	purge -age 30240
	"
	done
	done
	</pre>

2026-05-15T14:42:37Z

pulizia trace

← Versione meno recente		Versione delle 14:42, 15 mag 2026
Riga 314:		Riga 314:
	http://ksun-oracle.blogspot.com/2015/12/oracle-bigfile-tablespace-pre.html		http://ksun-oracle.blogspot.com/2015/12/oracle-bigfile-tablespace-pre.html

	=pulizia trace=		=pulizia trace con adrci=
	<pre>		<pre>
	#!/bin/bash		#!/bin/bash

2026-05-15T13:44:00Z

← Versione meno recente		Versione delle 13:44, 15 mag 2026
Riga 314:		Riga 314:
	http://ksun-oracle.blogspot.com/2015/12/oracle-bigfile-tablespace-pre.html		http://ksun-oracle.blogspot.com/2015/12/oracle-bigfile-tablespace-pre.html

			=pulizia trace=
			<pre>
			#!/bin/bash


			#ORACLE_HOME=/sw/app/oracle/product/19.0.0.0/db_3
			#ORACLE_SID=CECOPRD1
			#ORAENV_ASK=NO
			#export ORACLE_HOME ORACLE_SID ORAENV_ASK
			#. oraenv
			#unset ORAENV_ASK


			. /home/oracle/.CECOPRD.env

			#ADR_BASE=/oradiag/rdbmsdiag
			#export ADR_BASE

			# 21 giorni (504 ore 30240 minuti)

			for ADR_BASE in /oradiag/rdbmsdiag /oradiag/griddiag
			do
			echo ADR_BASE=$ADR_BASE
			export ADR_BASE=$ADR_BASE
			sleep 2

			adrci exec='show homes' \| grep -v 'ADR Homes:' \| while read H
			do
			adrci exec="set home $H
			set control $SHORTP_POLICY=504$
			set control $LONGP_POLICY=504$
			show control
			purge -age 30240
			"
			done
			done
			</pre>

2024-03-26T11:28:22Z

svuota schema

← Versione meno recente		Versione delle 11:28, 26 mar 2024
Riga 206:		Riga 206:
	end;		end;
	/		/


	begin		begin
	for c1 in (select owner,object_name,object_type from dba_objects where owner='&1' and object_type !='JOB')		for c1 in (select owner,object_name,object_type from dba_objects where owner='&1' and object_type !='JOB')

2024-03-26T11:27:28Z

svuota schema

← Versione meno recente		Versione delle 11:27, 26 mar 2024
Riga 198:		Riga 198:
	loop		loop
	begin		begin
	execute immediate 'drop table ' \|\| c1.owner \|\| '.' \|\| c1.table_name \|\| ' cascade constraints';		execute immediate 'drop table ' \|\| c1.owner \|\| '."' \|\| c1.table_name \|\| '" cascade constraints';
	exception		exception
	when others then		when others then
Riga 211:		Riga 211:
	loop		loop
	begin		begin
	execute immediate 'drop ' \|\| c1.object_type \|\| ' ' \|\| c1.owner \|\| '.' \|\| c1.object_name ;		execute immediate 'drop ' \|\| c1.object_type \|\| ' ' \|\| c1.owner \|\| '."' \|\| c1.object_name \|\| '"';
	exception		exception
	when others then		when others then

2023-11-08T11:24:53Z

impdp

← Versione meno recente		Versione delle 11:24, 8 nov 2023
Riga 249:		Riga 249:
	directory=DPUMP_DIR		directory=DPUMP_DIR
	logfile=impdp_tabella_singola.log		logfile=impdp_tabella_singola.log
	network_link=~~impdp_daol_prod~~		network_link=impdp_database_prod
	tables=esempio.tabella01		tables=esempio.tabella01
	remap_schema=ESEMPIO:NUOVOSCHEMA1		remap_schema=ESEMPIO:NUOVOSCHEMA1

2023-11-08T11:23:36Z

impdp

← Versione meno recente		Versione delle 11:23, 8 nov 2023
Riga 256:		Riga 256:
	exclude=statistics,grant		exclude=statistics,grant
	transform=DISABLE_ARCHIVE_LOGGING:Y,OID:N		transform=DISABLE_ARCHIVE_LOGGING:Y,OID:N

			Opzioni possibili:

			transform=table_compression_clause:"ROW STORE COMPRESS ADVANCED"
			transform=lob_storage:securefile

	<code>systimestamp</code> ritorna sempre un <code>timestamp with time zone</code>.		<code>systimestamp</code> ritorna sempre un <code>timestamp with time zone</code>.

2023-05-22T12:02:34Z

optimizer_adaptive_features

← Versione meno recente		Versione delle 12:02, 22 mag 2023
Riga 144:		Riga 144:
	alter system set optimizer_adaptive_features=false scope=both sid='*';		alter system set optimizer_adaptive_features=false scope=both sid='*';

	Con versione 12.2 le funzioni del parametro sono state divise in due parametri diversi:		Con versione 12.2 le funzioni del parametro sono state divise in due parametri diversi, per cui non serve modificare il default:
	optimizer_adaptive_plans boolean TRUE		optimizer_adaptive_plans boolean TRUE
	optimizer_adaptive_statistics boolean FALSE		optimizer_adaptive_statistics boolean FALSE