ICT: Diary
D: 28 W: 05

<	May 2011					>
Sun	Mon	Tue	Wed	Thu	Fri	Sat
1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31

search:

Based on notaweblog.php by joshua stein

[ < ] Monday, 23 May 2011 [ > ]

Random day in May

conn sys/Oracl3 as sysdba

select name, floor(space_limit/1024/1024) "Size Mb",
	ceil(space_used/1024/1024) "Used Mb"
	from v$recovery_file_dest

alter system set db_recovery_file_dest_size=30000m scope both;

Actually needed

sys/Oracl3@live as sysdba;

This event happened in the autumn, this is the SQL solution.

Next Entry >