oracle连接到空闲实例

Question

现在oracle每几个小时就会关闭一次  然后要重新startup  而且需要带上参数启动  就是pfile=".../init-XXX.org"  下面这个是系统日志  我估摸着和内存管理有关  希望有大神们指导不胜感激。
*** 2013-04-20 14:00:04.607
----- Error Stack Dump -----
ORA-00600: 内部错误代码, 参数: [kksCallPopCallback], [], [], [], [], [], [], []
ORA-04030: 在尝试分配 56 字节 (kxs-heap-c,kxscomp) 时进程内存不足
----- Current SQL Statement for this session (sql_id=apv12st3mwfzg) -----
SELECT property_name, property_value FROM java$jvm$system$property$defs where user_name is null
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
6B1566BC        10  package body WKSYS.WK_ERR
6B1566BC        53  package body WKSYS.WK_ERR
6B1A6488       386  package body WKSYS.WK_JOB
6B19B6FC         1  anonymous block----- Call Stack Trace -----
calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
EnumerateLoadedModules64 failed with error 183
_skdstdst()+114      CALLrel  _kgdsdst()+0         7FAB5260 2
_ksedst1()+91        CALLrel  _skdstdst()+0        
_ksedst()+50         CALLrel  _ksedst1()+0         0 1
_dbkedDefDump()+298  CALLrel  _ksedst()+0          0
5                                                  
_ksedmp()+40         CALLrel  _dbkedDefDump()+0    3 0
_ksupop()+1714       CALLrel  _ksedmp()+0          3
_opiodr()+3208       CALLrel  _ksupop()+0          2
_rpidrus()+178       CALLrel  _opiodr()+0          4A F 7FAB5E08 A
_rpidru()+88         CALLrel  _rpidrus()+0         7FAB5980
_rpiswu2()+560       CALLreg  00000000             7FAB5D54
_rpidrv()+1357       CALLrel  _rpiswu2()+0         70C90300 0 7FAB5D28 2
                                                   7FAB5D48 0 7FAB5D28 0
                                                   7FC21070 9DBAE4 9DBBA4
                                                   7FAB5D54 8
_rpisplu()+399       CALLrel  _rpidrv()+0          
_jox_initprops_from  CALLrel  _rpisplu()+0         A 0 0 0 5562540 60 0 0
_table()+422                                       
_jox_initprops()+68  CALLrel  _jox_initprops_from  31365410 7FCA3B7C 31365410
6                             _table()+0           7FCA3B7C 5566E10 707FE849 0 0
                                                   0
_ioc_get_arbitrary_  CALLrel  _jox_initprops()+0   31365410 7FCA3B7C
system_property()+3                                
36                                                 
_iocbf_get_arbitrar  CALLrel  _ioc_get_arbitrary_  7FABC198 0 7FAB8FDC 7FAB8FD8
y_system_property()           system_property()+0  
+22                                                
_ioc_do_call()+1252  CALLreg  00000000             7FABC198 7FAB8CDC
_joet_switched_env_  CALLrel  _ioc_do_call()+0     7FABC198 3C58AB4 7FAB8CDC 0
callback()+392                                     7FAB88A4 7FAB8C8C 7FAB8C90
_ioct_get_arbitrary  CALLrel  _joet_switched_env_  7FABC198 7FCC0C47 3C58AB4
_system_property()+           callback()+0         7FAB8CDC 0 0
43                                                 
_jonsys_init_proper  CALLrel  _ioct_get_arbitrary  7FABC198 7FCC0C47 0 7FAB8FDC
ties()+1633                   _system_property()+  7FAB8FD8 7FCC0C47 7FDAC430
                              0                    7FAB8D4C 5596E50 7FDAE000
                                                   7FCC0C47 5596E5C 1F 7FCC0C47
                                                   7FDAC430 7FAB8D4C 5596E3C
                                                   7FDADF38 7FCC0C47 4B55F84 0
_jonsys9_init_prope  CALLrel  _jonsys_init_proper  7FCC0C47 7FCFAC03 7FDAC430
rties()+15                    ties()+0             
_joevm_invoke_sysna  CALLreg  00000000             7FCC0C47 7FCFAC03 7FCB1FEC
tive()+300                                         7FCB1FEC
_joevm_invokerecurs  CALLreg  00000000             7FCC0C47 7FB7D93C 7FCB1FC8
ive()+118                                          7FCB1FEC 59A0204 1 7FCC0C47
                                                   7FAB9110 7FCB1FC8 7FCFAC03
                                                   7FCB1FD8 7FCFAC03
_joe_run_vm()+33518  CALLrel  _joevm_invokerecurs  
                              ive()+0              
_joeintp_opcode_arr  CALL???  00000000             
ay()+1060                                          OracleDBA内存分配04030

Answer 1

机器内存多大，sga是如何分配的？pfile里的内存参数是如何配置的，将 pfile=".../init-XXX.org"的pflile的内容贴出来看看

Answer 2

max_sga_size指的是可动态分配的最大值﹐而sga_target是当前已分配的最大sga。
max_sga_size是不可以动态修改的﹐而sga_target是可动态修改﹐直到max_sga_size的值（前提是你设定的max_sga_size>sga_target的情況)
如果在实例启动时﹐max_sga_size < sga_target或max_sga_size没设定﹐则启动后max_sga_size的值会等于sga_target的值，这时如果内存占用超过sga_target，也可能会出现ORA-04030的错误

Answer 3

OS多少位？ OS内存多大?分配给oracle的内存有多大？

Answer 4

这个表是什么表：
SELECT property_name, property_value FROM java$jvm$system$property$defs where user_name is null