domingo, 19 de octubre de 2014

Cambiar el tamaño de la Fast recovery area

Size in bytes
1 kb= 1024   bytes
1 mb= 1024^2 bytes
1 gb= 1024^3 bytes

SQL> select * from v$recovery_file_dest;

NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
+FRA
 4259315712  268435456         0        9



SQL> show parameter recovery_file_dest_size;

NAME         TYPE  VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size      big integer 4062M

ALTER SYSTEM SET db_recovery_file_dest_size = 6442450944 SCOPE=BOTH;

No hay comentarios.:

Publicar un comentario