oracle out of memory
ÓÐһ̨·þÎñÆ÷,²Ù×÷ϵͳÊÇsolaris x86(32),»úÆ÷ÓÐ16GÄÚ´æ,°²×°oralce10.2,Èç¹û·ÖÅ䏸oracleµÄÄÚ´æ´ó,¾Í±¨out of memory´íÎó,ÏÖÔÚÖ»ÄÜ·ÖÅäСÓÚ4GµÄÄÚ´æ. ÈçºÎ½â¾ö?
/etc/system²ÎÊý
set rlim_fd_max=65536
set shmsys:shminfo_shmmin=1
set semsys:seminfo_semmap=900
set semsys:seminfo_semmnu=1024
set semsys:seminfo_semume=200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
set rlim_fd_cur=8192
set semsys:seminfo_semmni=1024
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmseg=1200
set shmsys:shminfo_shmmni=1024
set msgsys:msginfo_msgmax=8192
set msgsys:msginfo_msgmni=50
set msgsys:msginfo_msgtql=2000
set msgsys:msginfo_msgmnb=200000
лл
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ʹÓÃt-sqlÓï¾ä½«sqlserver2kÊý¾Ýµ¼ÈëparadoxµÄ¹¦ÄÜÎÒÒÑʵÏÖ£¬ÓõÄÊÇinsert into ... from table in [ODBC][ODBC;Driver=SQL Server...]µÄ°ì·¨£¬µ±ÎÒ×¼±¸Èç·¨ÅÚÖÆÍê³Éparadoxµ¼Èëoracleʱȴ²»ÐУ¬²»±¨´íµ«ÊÇÖ´ÐкóÃ»Ó ......
ÎÒдµÄÒ»¸öJob
declare
job1 integer;
begin
dbms_job.submit(job1,
'Sale_FinanceUseFee(4,null,null,null);',
TRUNC(SYSDATE)+1.103, ......
ÐÖµÜ Í¼¹ÒÁË¡£
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value ......