SGA / TARGET_MEMORY

[ericclauberParticipante]

Olá Diego, desculpe a demora. Segue retorno abaixo.

1- v$memory_target_advice ****************************

MEMORY_SIZE MEMORY_SIZE_FACTOR ESTD_DB_TIME ESTD_DB_TIME_FACTOR VERSION
———– —————— ———— ——————- ———-
3008 ,5 16721 1,0001 0
4512 ,75 16719 1 0
5264 ,875 16719 1 0
6016 1 16719 1 0
6768 1,125 16717 ,9999 0
7520 1,25 16717 ,9999 0
8272 1,375 16717 ,9999 0
9024 1,5 16717 ,9999 0
9776 1,625 16717 ,9999 0
10528 1,75 16717 ,9999 0
11280 1,875 16717 ,9999 0

MEMORY_SIZE MEMORY_SIZE_FACTOR ESTD_DB_TIME ESTD_DB_TIME_FACTOR VERSION
———– —————— ———— ——————- ———-
12032 2 16717 ,9999 0

******************************************************************
2- set line size………..

KILL SID SERIAL SPID USERNAME OSUSER EVENT SW SQL_ID P1 P1TEXT Inic. Exec. Sql PROGRAM MACHINE
—- —– —— —– ———- ————— —————————— —— ————- ———- ———— ——————- ——————————- ——————————
@k 361 1689 15948 SYS oracle SQL*Net message to client 0 d8nabc2h100v1 1650815232 driver id 02/07/2013 15:17:31 sqlplus@orcl-omega (TNS V1-V3) orcl-omega

*******************************************************************

3- Ultimas 20 linhas do alert.log

alert
Thread 1 advanced to log sequence 9753 (LGWR switch)
Current log# 3 seq# 9753 mem# 0: /u01/app/oracle/oradata/WINT/redo03.log
Tue Jul 02 14:55:43 2013
Archived Log entry 9596 added for thread 1 sequence 9752 ID 0x573dd493 dest 1:
Tue Jul 02 15:04:28 2013
Thread 1 advanced to log sequence 9754 (LGWR switch)
Current log# 1 seq# 9754 mem# 0: /u01/app/oracle/oradata/WINT/redo01.log
Tue Jul 02 15:04:29 2013
Archived Log entry 9597 added for thread 1 sequence 9753 ID 0x573dd493 dest 1:
Tue Jul 02 15:13:35 2013
Thread 1 cannot allocate new log, sequence 9755
Checkpoint not complete
Current log# 1 seq# 9754 mem# 0: /u01/app/oracle/oradata/WINT/redo01.log
Thread 1 cannot allocate new log, sequence 9755
Private strand flush not complete
Current log# 1 seq# 9754 mem# 0: /u01/app/oracle/oradata/WINT/redo01.log
Thread 1 advanced to log sequence 9755 (LGWR switch)
Current log# 2 seq# 9755 mem# 0: /u01/app/oracle/oradata/WINT/redo02.log
Tue Jul 02 15:13:44 2013
Archived Log entry 9598 added for thread 1 sequence 9754 ID 0x573dd493 dest 1: