Oracle Asm - Cronologia

WikiSysop: /* report utilizzo */

2020-09-17T08:17:48Z

report utilizzo

← Versione meno recente		Versione delle 08:17, 17 set 2020
Riga 27:		Riga 27:
	,d.TOTAL_MB TOTAL_MB		,d.TOTAL_MB TOTAL_MB
	,d.FREE_MB		,d.FREE_MB
	,d.FREE_MB-(avg(d.FREE_MB) over (partition by g.NAME)) ~~DIFF~~		,d.FREE_MB-(avg(d.FREE_MB) over (partition by g.NAME)) SCO
	,d.SECTOR_SIZE		,d.SECTOR_SIZE
	,d.READS		,d.READS

2020-09-17T07:45:59Z

report utilizzo

← Versione meno recente		Versione delle 07:45, 17 set 2020
Riga 27:		Riga 27:
	,d.TOTAL_MB TOTAL_MB		,d.TOTAL_MB TOTAL_MB
	,d.FREE_MB		,d.FREE_MB
			,d.FREE_MB-(avg(d.FREE_MB) over (partition by g.NAME)) DIFF
	,d.SECTOR_SIZE		,d.SECTOR_SIZE
	,d.READS		,d.READS

2020-09-16T20:19:50Z

report utilizzo

← Versione meno recente		Versione delle 20:19, 16 set 2020
Riga 8:		Riga 8:
	==report utilizzo==		==report utilizzo==

	select GROUP_NUMBER,TYPE,sum(bytes)/(1024*1024) MB from v$asm_file group by GROUP_NUMBER,TYPE;		select GROUP_NUMBER,TYPE,sum(bytes)/(1024*1024) MB from v$asm_file group by GROUP_NUMBER,TYPE order by 1,2;

2020-05-08T16:59:36Z

report utilizzo

← Versione meno recente		Versione delle 16:59, 8 mag 2020
Riga 32:		Riga 32:
	from v$asm_disk d, v$asm_diskgroup g		from v$asm_disk d, v$asm_diskgroup g
	where d.GROUP_NUMBER=g.GROUP_NUMBER(+) order by 1,2;		where d.GROUP_NUMBER=g.GROUP_NUMBER(+) order by 1,2;


			select GROUP_NUMBER,NAME,STATE,TYPE,TOTAL_MB,FREE_MB,
			round(((TOTAL_MB-FREE_MB)/nullif(TOTAL_MB,0))*100,2) "USED%",
			ALLOCATION_UNIT_SIZE,OFFLINE_DISKS
			from v$asm_diskgroup order by 1;

	==ricerca file orfani==		==ricerca file orfani==

2020-05-08T16:58:17Z

report utilizzo

2020-05-08T16:57:12Z

report utilizzo

← Versione meno recente		Versione delle 16:57, 8 mag 2020
Riga 30:		Riga 30:
	,d.READS		,d.READS
	,d.WRITES		,d.WRITES
	from v\$asm_disk d, v\$asm_diskgroup g		from v$asm_disk d, v$asm_diskgroup g
	where d.GROUP_NUMBER=g.GROUP_NUMBER(+) order by 1,2;		where d.GROUP_NUMBER=g.GROUP_NUMBER(+) order by 1,2;



	==ricerca file orfani==		==ricerca file orfani==

2020-05-08T16:56:56Z

← Versione meno recente		Versione delle 16:56, 8 mag 2020
Riga 9:		Riga 9:

	select GROUP_NUMBER,TYPE,sum(bytes)/(1024*1024) MB from v$asm_file group by GROUP_NUMBER,TYPE;		select GROUP_NUMBER,TYPE,sum(bytes)/(1024*1024) MB from v$asm_file group by GROUP_NUMBER,TYPE;


			set pagesize 200
			set linesize 200
			set feedback off
			col PATH for a20
			col GROUPNAME for a10
			col NAME for a15
			col FAILGROUP_TYPE for a14
			col FAILGROUP for a15
			col REDUNDANCY for a10
			select g.NAME GROUPNAME
			,d.FAILGROUP
			,d.NAME NAME
			,d.PATH PATH
			,d.STATE STATE
			,d.TOTAL_MB TOTAL_MB
			,d.FREE_MB
			,d.SECTOR_SIZE
			,d.READS
			,d.WRITES
			from v\$asm_disk d, v\$asm_diskgroup g
			where d.GROUP_NUMBER=g.GROUP_NUMBER(+) order by 1,2;



	==ricerca file orfani==		==ricerca file orfani==

2018-03-19T15:23:03Z

ASM Senza oracleasm

← Versione meno recente		Versione delle 15:23, 19 mar 2018
Riga 111:		Riga 111:

	cat /etc/udev/rules.d/99-oracle-asmdevices.rules		cat /etc/udev/rules.d/99-oracle-asmdevices.rules
			#xen
	KERNEL=="xvd?", SUBSYSTEM=="block", ENV{ID_FS_TYPE}=="oracleasm", OWNER="grid", GROUP="asmadmin", MODE="0660"		KERNEL=="xvd?", SUBSYSTEM=="block", ENV{ID_FS_TYPE}=="oracleasm", OWNER="grid", GROUP="asmadmin", MODE="0660"
			#scsi
			KERNEL=="sd?", SUBSYSTEM=="block", ENV{ID_FS_TYPE}=="oracleasm", OWNER="grid", GROUP="asmadmin", MODE="0660"

	* udev per /dev/asm		* udev per /dev/asm

2018-03-19T15:21:48Z

ASM Senza oracleasm

← Versione meno recente		Versione delle 15:21, 19 mar 2018
Riga 109:		Riga 109:
	=ASM Senza oracleasm=		=ASM Senza oracleasm=
	* udev per permission a grid:oracleasm		* udev per permission a grid:oracleasm

			cat /etc/udev/rules.d/99-oracle-asmdevices.rules
			KERNEL=="xvd?", SUBSYSTEM=="block", ENV{ID_FS_TYPE}=="oracleasm", OWNER="grid", GROUP="asmadmin", MODE="0660"

	* udev per /dev/asm		* udev per /dev/asm

2018-03-19T15:18:30Z

← Versione meno recente		Versione delle 15:18, 19 mar 2018
Riga 106:		Riga 106:

	http://anjo.pt/wp/keyword-oracle/2013/02/26/find-orphan-asm-files/		http://anjo.pt/wp/keyword-oracle/2013/02/26/find-orphan-asm-files/

			=ASM Senza oracleasm=
			* udev per permission a grid:oracleasm
			* udev per /dev/asm



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