oracle error- ORA-00337: log file 'string' does not exist and no size specified

ORA-00337:	log file 'string' does not exist and no size specified
Cause:	An attempt to add a log found neither an existing file nor a size for creating the file.
Action:	Specify a size for the log file.

oracle error- ORA-00336: log file size string blocks is less than minimum string blocks

ORA-00336:	log file size string blocks is less than minimum string blocks
Cause:	The log file size as specified in create database is too small.
Action:	Increase the log file size.

Oracle- Sga monitorando a memória livre

Para verificar o tamanho da Sga(System Global Area) disponível é muito simples basta acessar o sql plus e rodar as queries abaixo:


sqlplus> select * from v$sgastat where name = 'free memory';


POOL         NAME                            BYTES
------------ -------------------------- ----------
shared pool  free memory                 243958752
large pool   free memory                 244376096
java pool    free memory                  16777216

Verificando o tamanho em MB.

select pool, name, bytes, round(bytes/(1024*1024)) from v$sgastat where name = 'free memory'


POOL         NAME                            BYTES ROUND(BYTES/(1024*1024))
------------ -------------------------- ---------- ------------------------
shared pool  free memory                   243888232                      233
large pool   free memory                     244376096                      233
java pool    free memory                     16777216                       16