Oracle Query Varie - Cronologia

WikiSysop: WikiSysop ha spostato la pagina Query Varie a Oracle Query Varie

2026-06-05T10:06:20Z

WikiSysop ha spostato la pagina Query Varie a Oracle Query Varie

← Versione meno recente

Versione delle 10:06, 5 giu 2026

2026-06-04T15:14:09Z

Job

2026-06-04T15:13:28Z

Job

← Versione meno recente		Versione delle 15:13, 4 giu 2026
Riga 47:		Riga 47:
	alter session set nls_timestamp_tz_format='DD/MM/YYYY HH24:MI:SS.FF TZH';		alter session set nls_timestamp_tz_format='DD/MM/YYYY HH24:MI:SS.FF TZH';
	select job_name, owner, enabled, state, failure_count, LAST_START_DATE, NEXT_RUN_DATE, START_DATE from dba_scheduler_jobs order by last_start_date;		select job_name, owner, enabled, state, failure_count, LAST_START_DATE, NEXT_RUN_DATE, START_DATE from dba_scheduler_jobs order by last_start_date;


		⚫	col job_name for a50
		⚫	col owner for a20
		⚫	select job_name, owner, enabled from dba_scheduler_jobs;

	==abilitare e disabilitare job==		==abilitare e disabilitare job==
Riga 57:		Riga 62:
	==Job Immediato==		==Job Immediato==


⚫	col job_name for a50
⚫	col owner for a20
⚫	select job_name, owner, enabled from dba_scheduler_jobs;

2026-06-04T14:26:00Z

← Versione meno recente		Versione delle 14:26, 4 giu 2026
Riga 1:		Riga 1:
			=Tracciare operazioni nell'alert log=
			EXEC SYS.DBMS_SYSTEM.kfnwrt(1, 'NOTA OPERATORE: Inizio manutenzione di Mario Rossi');

	=ACL=		=ACL=
	==creazione acl==		==creazione acl==

2026-06-01T08:09:07Z

Controllo Allocazione Spazio

← Versione meno recente		Versione delle 08:09, 1 giu 2026
Riga 400:		Riga 400:
	files as (select tablespace_name,count(file_name) nfiles,sum(case when maxbytes=0 then bytes else maxbytes end)/(10241024) max,sum(bytes)/(10241024) mba		files as (select tablespace_name,count(file_name) nfiles,sum(case when maxbytes=0 then bytes else maxbytes end)/(10241024) max,sum(bytes)/(10241024) mba
	from dba_data_files group by tablespace_name)		from dba_data_files group by tablespace_name)
	select t.tablespace_name,		select t.tablespace_name,
	t.block_size,		t.block_size,
	f.nfiles,		f.nfiles,

2026-05-27T15:38:27Z

Autoextend datafiles

← Versione meno recente		Versione delle 15:38, 27 mag 2026
Riga 564:		Riga 564:
	end;		end;
	/		/

			Su un solo tablespace

	begin		begin
Riga 573:		Riga 575:
	/		/

			Mette in autoextend i files non in autoextend, ma con maxsize uguale alla grandezza reale
	Autoextend ma tenendo la maxsize (serve per eseguire shrink)

	begin		begin

2026-05-27T13:01:43Z

Autoextend datafiles

← Versione meno recente		Versione delle 13:01, 27 mag 2026
Riga 559:		Riga 559:
	begin		begin
	for c1 in (select file_id from dba_data_files)		for c1 in (select file_id from dba_data_files)
			loop
			execute immediate 'alter database datafile ' \|\| c1.file_id \|\| ' autoextend on next 128M maxsize unlimited';
			end loop;
			end;
			/

			begin
			for c1 in (select file_id from dba_data_files where tablespace_name='&1')
	loop		loop
	execute immediate 'alter database datafile ' \|\| c1.file_id \|\| ' autoextend on next 128M maxsize unlimited';		execute immediate 'alter database datafile ' \|\| c1.file_id \|\| ' autoextend on next 128M maxsize unlimited';

2026-05-26T13:53:12Z

Autoextend datafiles

@@ Riga 564: / Riga 564: @@
  end;
+ /
 Autoextend tempfiles:

2026-05-25T15:21:35Z

Per 10.2

2026-05-25T15:20:35Z

Per 10.2

@@ Riga 452: / Riga 452: @@
  order by 1,2,3;
 </pre>
 <!--