Oracle Recyclebin - Cronologia

WikiSysop il 09:12, 21 gen 2021

2021-01-21T09:12:28Z

← Versione meno recente		Versione delle 09:12, 21 gen 2021
Riga 3:		Riga 3:
	with a as (select sum(r.space) as sp from dba_recyclebin r)		with a as (select sum(r.space) as sp from dba_recyclebin r)
	select (a.sp*(p.value/1024))/1024 mb_recyclebin from a,v$parameter p where p.name='db_block_size';		select (a.sp*(p.value/1024))/1024 mb_recyclebin from a,v$parameter p where p.name='db_block_size';


			Elimina dal recyclebin tutti gli oggetti cancellati da almeno 3 giorni:

	<pre>		<pre>
Riga 20:		Riga 23:
	</pre>		</pre>

			Schedula job che elimina periodicamente dal recyclebin tutti gli oggetti cancellati da almeno 3 giorni:
	<pre>		<pre>
	BEGIN		BEGIN

WikiSysop il 09:09, 21 gen 2021

2021-01-21T09:09:47Z

← Versione meno recente		Versione delle 09:09, 21 gen 2021
Riga 1:		Riga 1:
			Spazio occupato dal recyclebin:

			with a as (select sum(r.space) as sp from dba_recyclebin r)
			select (a.sp*(p.value/1024))/1024 mb_recyclebin from a,v$parameter p where p.name='db_block_size';

	<pre>		<pre>
	begin		begin

WikiSysop il 08:29, 22 set 2017

2017-09-22T08:29:01Z

← Versione meno recente		Versione delle 08:29, 22 set 2017
Riga 42:		Riga 42:

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

WikiSysop il 14:49, 14 giu 2016

2016-06-14T14:49:12Z

← Versione meno recente		Versione delle 14:49, 14 giu 2016
Riga 39:		Riga 39:
	/		/
	</pre>		</pre>


			[[Categoria:Database]]

WikiSysop: Creata pagina con "

 begin   for c1 in (select owner,type,OBJECT_NAME from dba_recyclebin where to_date(DROPTIME,'YYYY-MM-DD:HH24:MI:SS') < sysdate-3 and CAN_PURGE='YES')    loop      begin..."

2016-06-14T14:48:54Z

Creata pagina con "<pre> begin for c1 in (select owner,type,OBJECT_NAME from dba_recyclebin where to_date(DROPTIME,'YYYY-MM-DD:HH24:MI:SS') < sysdate-3 and CAN_PURGE='YES') loop begin..."

Nuova pagina

<pre>
begin
for c1 in (select owner,type,OBJECT_NAME from dba_recyclebin where to_date(DROPTIME,'YYYY-MM-DD:HH24:MI:SS') < sysdate-3 and CAN_PURGE='YES')
loop
begin
dbms_output.put_line(c1.object_name);
execute immediate 'purge ' || c1.type || ' ' || c1.owner || '."' || c1.object_name || '"';
exception
when others then
null;
end;
end loop;
end;
/
</pre>

<pre>
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'purge_recyclebin_3days',
job_type => 'PLSQL_BLOCK',
job_action => '
begin
for c1 in (select owner,type,OBJECT_NAME from dba_recyclebin where to_date(DROPTIME,''YYYY-MM-DD:HH24:MI:SS'') < sysdate-3 and CAN_PURGE=''YES'')
loop
begin
execute immediate ''purge '' || c1.type || '' '' || c1.owner || ''."'' || c1.object_name || ''"'';
exception
when others then
null;
end;
end loop;
end;
',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=daily; byhour=0; byminute=0; bysecond=0;',
enabled => TRUE);
END;
/
</pre>