인덱스가 멈추는 현상... 메모리때문일까요? 0 2 3,219

by 다크팬더 [2016.11.01 10:51:06]


갑자기 오라클 전체가 팅기고 다시 붙었다고 해서 로그를 확인해 보니

Initializing PGA for process VKRM in instance test.
Initializing PGA for process CJQ0 in instance test.
Initializing PGA for process SMCO in instance test.
Initializing PGA for process QMNC in instance test.
Initializing PGA for process ARC1 in instance test.
Initializing PGA for process ARC2 in instance test.
Initializing PGA for process ARC3 in instance test.
Initializing PGA for process ARC0 in instance test.
Initializing PGA for process LGWR in instance test.
Initializing PGA for process CKPT in instance test.
Initializing PGA for process DBW0 in instance test.
Initializing PGA for process DIA0 in instance test.
Initializing PGA for process MMAN in instance test.
Initializing PGA for process SMON in instance test.
Audit trail: LENGTH: '172' ACTION :[7] 'STARTUP' DATABASE USER:[1] '/' PRIVILEGE :[4] 'NONE' CLIENT USER:[19] 'NT AUTHORITY\SYSTEM' CLIENT TERMINAL:[13] 'Not Available' STATUS:[1] '0' DBID:[0] '' .
Audit trail: LENGTH: '163' ACTION :[7] 'CONNECT' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[19] 'NT AUTHORITY\SYSTEM' CLIENT TERMINAL:[3] 'server' STATUS:[1] '0' DBID:[0] '' .
Initializing PGA for process MMNL in instance test.
Initializing PGA for process RECO in instance test.
Initializing PGA for process MMON in instance test.
Initializing PGA for process GEN0 in instance test.
Initializing PGA for process VKTM in instance test.
Initializing PGA for process DBRM in instance test.
Initializing PGA for process DIAG in instance test.
Initializing SGA for instance test.
Audit trail: LENGTH: '163' ACTION :[7] 'CONNECT' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[19] 'NT AUTHORITY\SYSTEM' CLIENT TERMINAL:[3] 'EMR' STATUS:[1] '0' DBID:[0] '' .
Initializing PGA for process PSP0 in instance test.
Initializing PGA for process PMON in instance test.
All process in instance test stopped
Audit trail: LENGTH: '164' ACTION :[8] 'SHUTDOWN' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[19] 'NT AUTHORITY\SYSTEM' CLIENT TERMINAL:[3] 'server' STATUS:[1] '0' DBID:[0] '' .
Shutdown normal performed on instance test.
Audit trail: LENGTH: '172' ACTION :[7] 'CONNECT' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[19] 'NT AUTHORITY\SYSTEM' CLIENT TERMINAL:[3] 'server' STATUS:[1] '0' DBID:[9] '273465824' .
Audit trail: LENGTH: '170' ACTION :[7] 'CONNECT' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[17] 'server\Administrator' CLIENT TERMINAL:[3] 'server' STATUS:[1] '0' DBID:[9] '273465824' .

 

이런 로그가 서버 이벤트에 찍혀 있더라고요. PGA면 오라클 메모리쪽인거 같은데 메모리 조정을 다시 해야 할까요?

현재 오라클 11g에 메모리쪽은 전부 0으로 자동으로 돌려놨거든요.

 

SQL> show parameter memory;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address             integer     0
memory_max_target                    big integer 0
memory_target                        big integer 0
shared_memory_address                integer     0

 

메모리를 지정해야 하는건지 궁금해서 문의드립니다!!!!

 

 

by 미스틱매니아 [2016.11.01 13:15:13]

Initializing PGA for process DIAG in instance test.
Initializing SGA for instance test.

 

이 메세지면 인스턴스 기동중인거 같은데요.

그리고 중간에 아래와 같은 내용이 있는데

 

Audit trail: LENGTH: '163' ACTION :[7] 'CONNECT' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[19] 'NT AUTHORITY\SYSTEM' CLIENT TERMINAL:[3] 'EMR' STATUS:[1] '0' DBID:[0] '' .
Initializing PGA for process PSP0 in instance test.
Initializing PGA for process PMON in instance test.
All process in instance test stopped
Audit trail: LENGTH: '164' ACTION :[8] 'SHUTDOWN' DATABASE USER:[1] '/' PRIVILEGE :[6] 'SYSDBA' CLIENT USER:[19] 'NT AUTHORITY\SYSTEM' CLIENT TERMINAL:[3] 'server' STATUS:[1] '0' DBID:[0] '' .
Shutdown normal performed on instance test.

 

이건 누가 중간에 shutdown 날렸네요. 

 

로그만 봐서는 내렸다 올린거 밖에 없어서 어떤 상황인지는 모르겠네요


by 다크팬더 [2016.11.01 13:38:08]

답변 감사드립니다!!

댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.
로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입