Oracle Query Varie - Cronologia

WikiSysop: /* Sessioni */

2026-09-18T13:37:09Z

Sessioni

← Versione meno recente		Versione delle 13:37, 18 set 2026
Riga 164:		Riga 164:

	=Sessioni=		=Sessioni=
	[[Oracle_Sessioni_e_processi]]		[[Oracle_Sessioni_e_processi \| Sessioni e processi]]

	=Gestione Spazio Disco=		=Gestione Spazio Disco=

2026-09-18T13:36:52Z

Gestione Spazio Disco

← Versione meno recente		Versione delle 13:36, 18 set 2026
Riga 167:		Riga 167:

	=Gestione Spazio Disco=		=Gestione Spazio Disco=
	[[Oracle_Spazio#Controllo_Allocazione_Spazio Gestione Spazio]]		[[Oracle_Spazio#Controllo_Allocazione_Spazio \| Gestione Spazio]]

	=Ricerca files orfani ASM=		=Ricerca files orfani ASM=

2026-09-18T13:36:39Z

Sessioni

← Versione meno recente		Versione delle 13:36, 18 set 2026
Riga 165:		Riga 165:
	=Sessioni=		=Sessioni=
	[[Oracle_Sessioni_e_processi]]		[[Oracle_Sessioni_e_processi]]

			=Gestione Spazio Disco=
			[[Oracle_Spazio#Controllo_Allocazione_Spazio Gestione Spazio]]

	=Ricerca files orfani ASM=		=Ricerca files orfani ASM=

2026-09-18T13:35:07Z

Controllo Allocazione Spazio

2026-09-15T16:17:49Z

Job

← Versione meno recente		Versione delle 16:17, 15 set 2026
Riga 38:		Riga 38:

	=Job=		=Job=

			==job in esecuzione==
			SELECT job_name, state, running_instance, session_id
			FROM dba_scheduler_running_jobs
			WHERE owner = '&1';

	==Elenco Job==		==Elenco Job==

2026-09-15T16:14:21Z

lock

← Versione meno recente		Versione delle 16:14, 15 set 2026
Riga 776:		Riga 776:

	</pre>		</pre>


			===row cache lock===
			SELECT
			s1.username AS waiting_user,
			s1.sid AS waiting_sid,
			s1.serial# AS waiting_serial,
			s1.event AS wait_event,
			s2.username AS holding_user,
			s2.sid AS holding_sid,
			s2.serial# AS holding_serial,
			s2.sql_id AS holding_sql_id
			FROM v$session s1, v$lock l1, v$lock l2, v$session s2
			WHERE s1.lockwait = l1.kaddr
			AND l1.id1 = l2.id1
			AND l1.id2 = l2.id2
			AND l2.addr = s2.lockwait
			AND s1.sid != s2.sid
			AND s1.event LIKE '%row cache%';

	==Tablespaces Read Only==		==Tablespaces Read Only==

2026-09-11T15:15:44Z

Indici

@@ Riga 91: / Riga 91: @@
+/
 </pre>
 =Piano della query per sql_id=

2026-09-11T12:48:45Z

Logging

← Versione meno recente		Versione delle 12:48, 11 set 2026
Riga 197:		Riga 197:
	select 'alter index ' \|\| index_owner \|\| '.' \|\| index_name \|\| ' modify partition ' \|\| partition_name \|\| ' logging;' from dba_ind_partitions where index_owner!='SYS' and logging='NO' and status='USABLE';		select 'alter index ' \|\| index_owner \|\| '.' \|\| index_name \|\| ' modify partition ' \|\| partition_name \|\| ' logging;' from dba_ind_partitions where index_owner!='SYS' and logging='NO' and status='USABLE';
	select 'alter table ' \|\| table_owner \|\| '.' \|\| table_name \|\| ' modify partition ' \|\| partition_name \|\| ' lob (' \|\| column_name \|\| ') (cache logging);' from dba_lob_partitions where table_owner!='SYS' and logging='NO';		select 'alter table ' \|\| table_owner \|\| '.' \|\| table_name \|\| ' modify partition ' \|\| partition_name \|\| ' lob (' \|\| column_name \|\| ') (cache logging);' from dba_lob_partitions where table_owner!='SYS' and logging='NO';

			=Sessioni=
			[[Oracle_Sessioni_e_processi]]

	=Controllo Allocazione Spazio=		=Controllo Allocazione Spazio=

2026-09-11T12:47:26Z

Processi e sessioni

2026-09-03T07:04:09Z

long operations

← Versione meno recente		Versione delle 07:04, 3 set 2026
Riga 247:		Riga 247:

	<pre>		<pre>
	~~SET~~ ~~LINESize~~ 200		set linesize 200
	set pagesize 200		set pagesize 200
	set autotrace off		set autotrace off
	~~COL~~ sid ~~FORMAT~~ 9999		col sid for 9999
	~~COL~~ serial# ~~FORMAT~~ 9999999		col serial# for 9999999
	col sid_ser for a12		col sid_ser for a12
	~~COL~~ username ~~FORMAT~~ A30		col username for A30
	~~COL~~ machine ~~FORMAT~~ A50		col machine for A50
	~~COL~~ prog% ~~FORMAT~~ 999.00		col prog% for 999.00
	~~COL~~ elapsed ~~FORMAT~~ A10		col elapsed for A10
	~~COL~~ remaining ~~FORMAT~~ A10		col remaining for A10
	col message for a80		col message for a80
	spool longops2.log		spool longops2.log
	~~SELECT~~ s.sid \|\| ',' \|\| s.serial# sid_ser,		select s.sid \|\| ',' \|\| s.serial# sid_ser,
	s.username,		s.username,
	-- s.machine,		-- s.machine,
Riga 268:		Riga 268:
	s.sql_id,		s.sql_id,
	replace(sl.message,'Blocks done','') as message		replace(sl.message,'Blocks done','') as message
	~~FROM~~ v$session s		from v$session s
	inner join v$session_longops sl on ( s.sid = sl.sid AND s.serial# = sl.serial# AND sl.time_remaining > 0 )		inner join v$session_longops sl on ( s.sid = sl.sid AND s.serial# = sl.serial# AND sl.time_remaining > 0 )
	order by s.sql_id;		order by s.sql_id;