Oracle Standard Edition - Cronologia

WikiSysop: /* Statspack */

2021-01-25T10:56:24Z

Statspack

← Versione meno recente		Versione delle 10:56, 25 gen 2021
Riga 4:		Riga 4:
	=Statspack=		=Statspack=

			==Job schedulazione statspack==
⚫	select * from dba_scheduler_jobs where job_name='STATSPACK_SNAP_AND_PURGE';

	ALTER SESSION SET time_zone = 'EUROPE/ROME';		ALTER SESSION SET time_zone = 'EUROPE/ROME';

		⚫	select * from dba_scheduler_jobs where job_name='STATSPACK_SNAP_AND_PURGE';

	BEGIN		BEGIN

2021-01-25T10:55:32Z

Statspack

← Versione meno recente		Versione delle 10:55, 25 gen 2021
Riga 4:		Riga 4:
	=Statspack=		=Statspack=

			select * from dba_scheduler_jobs where job_name='STATSPACK_SNAP_AND_PURGE';


	ALTER SESSION SET time_zone = 'EUROPE/ROME';		ALTER SESSION SET time_zone = 'EUROPE/ROME';

2021-01-25T10:51:49Z

Statspack

@@ Riga 5: / Riga 5: @@
-BEGIN
+ BEGIN
- DBMS_SCHEDULER.CREATE_JOB (
+  DBMS_SCHEDULER.DROP_JOB('PERFSTAT.STATSPACK_SNAP_AND_PURGE');
 =Baseline=

2021-01-25T10:50:07Z

Statspack

← Versione meno recente		Versione delle 10:50, 25 gen 2021
Riga 7:		Riga 7:
	<code>		<code>
	ALTER SESSION SET time_zone = 'EUROPE/ROME';		ALTER SESSION SET time_zone = 'EUROPE/ROME';



	BEGIN		BEGIN
	DBMS_SCHEDULER.DROP_JOB('PERFSTAT.STATSPACK_SNAP_AND_PURGE');		DBMS_SCHEDULER.DROP_JOB('PERFSTAT.STATSPACK_SNAP_AND_PURGE');
			END;
			/

			BEGIN
	DBMS_SCHEDULER.CREATE_JOB (		DBMS_SCHEDULER.CREATE_JOB (
	job_name => 'PERFSTAT.STATSPACK_SNAP_AND_PURGE',		job_name => 'PERFSTAT.STATSPACK_SNAP_AND_PURGE',

2021-01-25T10:15:13Z

Statspack

← Versione meno recente		Versione delle 10:15, 25 gen 2021
Riga 3:		Riga 3:

	=Statspack=		=Statspack=


			<code>
			ALTER SESSION SET time_zone = 'EUROPE/ROME';



			BEGIN
			DBMS_SCHEDULER.DROP_JOB('PERFSTAT.STATSPACK_SNAP_AND_PURGE');
			DBMS_SCHEDULER.CREATE_JOB (
			job_name => 'PERFSTAT.STATSPACK_SNAP_AND_PURGE',
			job_type => 'PLSQL_BLOCK',
			job_action => 'BEGIN
			statspack.snap();
			if extract(hour from systimestamp) = 1 and extract(minute from systimestamp) < 30
			then
			statspack.purge(i_num_days=>180,i_extended_purge=>TRUE);
			end if;
			END;',
			repeat_interval => 'FREQ=MINUTELY; INTERVAL=30;',
			auto_drop => FALSE,
			enabled => TRUE,
			comments => 'Statspack automated snap and purge');
			END;
			/


			</code>

	=Baseline=		=Baseline=

2021-01-25T09:56:21Z

Tuning Checkpoint

← Versione meno recente		Versione delle 09:56, 25 gen 2021
Riga 7:		Riga 7:

	=Tuning Checkpoint=		=Tuning Checkpoint=

			==checkpoint con SE==


			Checkpoint ad ogni switch di log:

			<pre>
			select max(BYTES/BLOCKSIZE) from v$log;

			MAX(BYTES/BLOCKSIZE)
			--------------------
			262144


			alter system set log_checkpoint_interval=262144 scope=both;
			</pre>

			Checkpoint almeno ogni 5 minuti

			alter system set log_checkpoint_timeout=600 scope=both;


	[[Categoria:Oracle]]		[[Categoria:Oracle]]

2021-01-25T09:55:18Z

2021-01-25T09:54:17Z

Nuova pagina

[[Categoria:Oracle]]
[[Categoria:Database]]