Hi guys, I have a 1Gb Server RAM, with a lot of disc free space (92Gb) :
processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.20GHz stepping : 3 cpu MHz : 3200.787 cache size : 2048 KB physical id : 0 siblings : 2 core id : 0 cpu cores : 1 fdiv_bug : no hlt_bug : no f00f_bug : no coma_bug : no fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm pni monitor ds_cpl cid cx16 xtpr bogomips : 6406.87 processor : 1 vendor_id : GenuineIntel cpu family : 15 model : 4 model name : Intel(R) Xeon(TM) CPU 3.20GHz stepping : 3 cpu MHz : 3200.787 cache size : 2048 KB physical id : 0 siblings : 2 core id : 0 cpu cores : 1 fdiv_bug : no hlt_bug : no f00f_bug : no coma_bug : no fpu : yes fpu_exception : yes cpuid level : 5 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm pni monitor ds_cpl cid cx16 xtpr bogomips : 6400.82 A sapdb database with 30-40 users using it. This server is just for the database. I am doing something wrong, because the database is slow: KERNELVERSION string KERNEL 7.4.3 BUILD 032-121-068-842 INSTANCE_TYPE string OLTP MCOD string NO ALIGN int 16 _SERVERDB_FOR_SAP string YES _UNICODE string NO DEFAULT_CODE string ASCII DATE_TIME_FORMAT string INTERNAL CONTROLUSERID string DBM CONTROLPASSWORD crypt MAXARCHIVELOGS int 2 MAXDATADEVSPACES int 11 LOG_BACKUP_TO_PIPE string NO MAXBACKUPDEVS int 2 BACKUP_BLOCK_CNT int 8 LOG_MIRRORED string NO LOG_MODE string SINGLE _MAXDEVSPACES int 14 _MULT_IO_BLOCK_CNT int 8 _DELAY_LOGWRITER int 0 LOG_IO_QUEUE int 50 _RESTART_TIME int 600 MAXUKPS int 1024 MAXCPU int 2 MAXUSERTASKS int 150 _TREE_RGNS int 8 _TRANS_RGNS int 8 _TAB_RGNS int 8 _OMS_REGIONS int 0 _OMS_RGNS int 25 OMS_HEAP_LIMIT int 0 OMS_HEAP_COUNT int 1 OMS_HEAP_BLOCKSIZE int 10000 OMS_HEAP_THRESHOLD int 100 OMS_VERS_THRESHOLD int 2097152 HEAP_CHECK_LEVEL int 0 _ROW_RGNS int 8 IOSERVERTASKS int _MIN_SERVER_DESC int 21 MAXSERVERTASKS int 21 _ESTIM_MAXTRANS int 3 _MAXTRANS int 692 _LOCK_REGIONS int MAXLOCKS int 13000 _LOCK_SUPPLY_BLOCK int 100 DEADLOCK_DETECTION int 4 _LOCK_SUPPLY_SEGMS int _ROWLOCK_HASHLIST int _TABLOCK_HASHLIST int _TRANS_ENTRIES int _TRANS_HASHLIST int SESSION_TIMEOUT int 900 OMS_STREAM_TIMEOUT int 30 REQUEST_TIMEOUT int 180 _IOPROCS_PER_DEV int 2 _IOPROCS_FOR_PRIO int 0 _USE_IOPROCS_ONLY string NO _IOPROCS_SWITCH int 2 UKPS int 5 _USER_PER_UKP int _SERVER_PER_UKP int LRU_FOR_SCAN string NO _PAGE_SIZE int 8192 _PACKET_SIZE int 36864 _MINREPLY_SIZE int 4096 MAXMBDATASIZE int _MBLOCK_DATA_SIZE int 32768 _MBLOCK_QUAL_SIZE int 8192 MINMBLOCKSTACKSIZE int _MBLOCK_STACK_SIZE int 16384 _WORKSTACK_SIZE int 8192 _WORKDATA_SIZE int 8192 MINCATCACHESIZE int _CAT_CACHE_MINSIZE int 262144 CAT_CACHE_SUPPLY int 24576 INIT_ALLOCATORSIZE int 237568 _TASKCLUSTER_01 string tw;al;ut;2000*sv,100*bup;10*ev,10*gc; _TASKCLUSTER_02 string ti,100*dw;75*us; _TASKCLUSTER_03 string equalize _DYN_TASK_STACK string NO _MP_RGN_QUEUE string YES _MP_RGN_DIRTY_READ string YES _MP_RGN_BUSY_WAIT string YES _MP_DISP_LOOPS int 2 _MP_DISP_PRIO string YES XP_MP_RGN_LOOP int 0 MP_RGN_LOOP int 100 _MP_RGN_PRIO string YES MAXRGN_REQUEST int 3000 _PRIO_BASE_U2U int 100 _PRIO_BASE_IOC int 80 _PRIO_BASE_RAV int 80 _PRIO_BASE_REX int 40 _PRIO_BASE_COM int 10 _PRIO_FACTOR int 80 _DELAY_COMMIT string NO _SVP_1_CONV_FLUSH string NO _MAXGARBAGE_COLL int 0 _MAXTASK_STACK int 400 _DW_IO_AREA_SIZE int 50 _DW_IO_AREA_FLUSH int 50 _FBM_DEVSP_COMPR int 50 _FBM_DEVSP_BALANCE int 10 _FBM_LOW_IO_RATE int 10 CACHE_SIZE int 98304 _DW_LRU_TAIL_FLUSH int 25 XP_DATA_CACHE_RGNS int 0 _DATA_CACHE_RGNS int 32 CONVERTER_REGIONS int 8 _MAXDATAWRITER int 32 DYND_B12_DW_IO_BUF int SEQUENCE_CACHE int 1 _IDXFILE_LIST_SIZE int 2048 DYNP_B49_IDXSIZE int _SERVER_DESC_CACHE int 174 _SERVER_CMD_CACHE int 22 DEVNO_BIT_COUNT int 8 SAVE_QUEUE_SIZE int AUTOSAVE_QUEUE int PAGES_PER_DATACACH int B20_DATACACHE_HEAD int TREEHASHLIST int 0 B20_DATACACHE_PIDQ int B20_DATACACHE_CB int OPTIM_MAX_MERGE int 500 OPTIM_INV_ONLY string YES OPTIM_CACHE string NO OPTIM_JOIN_FETCH int 0 JOIN_SEARCH_LEVEL int 0 JOIN_MAXTAB_LEVEL4 int 16 JOIN_MAXTAB_LEVEL9 int 5 _READAHEAD_BLOBS int 25 RUNDIRECTORY string /dados/HE OPMSG1 string /dev/console OPMSG2 string /dev/null _KERNELDIAGFILE string knldiag KERNELDIAGSIZE int 800 _EVENTFILE string knldiag.evt _EVENTSIZE int 0 _MAXEVENTTASKS int 1 _MAXEVENTS int 100 _KERNELTRACEFILE string knltrace TRACE_PAGES_TI int 2 TRACE_PAGES_GC int 0 TRACE_PAGES_AL int 5 TRACE_PAGES_DW int 3 TRACE_PAGES_US int 10 TRACE_PAGES_UT int 5 TRACE_PAGES_SV int 5 TRACE_PAGES_EV int 2 TRACE_PAGES_BUP int 0 _MAXBACKUPTASKS int KERNELTRACESIZE int 1716 _AK_DUMP_ALLOWED string YES _KERNELDUMPFILE string knldump _RTEDUMPFILE string rtedump _UTILITY_PROTFILE string dbm.utl UTILITY_PROTSIZE int 100 _BACKUP_HISTFILE string dbm.knl _BACKUP_MED_DEF string dbm.mdf _MAX_MESSAGE_FILES int 0 DYND_B12_VTRACE int DYND_B20_DATACACHE int DYND_K38_AUTOSAVE int DYND_K38_SAVE int DYND_K57_KB_PAGES int DYNP_A51_CACHE int _EVENT_ALIVE_CYCLE int 0 DYNP_A42_PARSEID int DYNP_B12_DATA_WRIT int DYNP_B20_DATACACHE int DYNP_B77_TREE_LOCK int DYNP_K38_AUTOSAVE int DYNP_K38_SAVE_GLOB int _K51_LOCK_AUX1 int _K51_LOCK_AUX2 int DYNP_K51_LOCK_LIST int DYNP_K90_SERVER int _SHMCHUNK int 32 DYNP_B930_HISTORY int _SHAREDDYNDATA int 98607 _SHAREDDYNPOOL int 19098 PROCSW int U1 int 1256 S1 int 1048 D1 int 304 B1 int 152 I1 int 384 P1 int 392 P2 int 43 PT int 16 PD int 40 PB int 24 IT int 24 ID int 384 IB int 192 IDT int 24 IBT int 12 GW int 336580 _SHMKERNEL int 822454 COMSEG/S_SIZE int MEMTASK int 406 MEMUKP int 293 MEMPROC int 229 CODE int 2557 ARCHIVE_LOG_? string ARCHIVE_LOG_001 string LOG_001 ARCHIVE_TYPE_? string ARCHIVE_TYPE_001 string F ARCHIVE_SIZE_? int ARCHIVE_SIZE_001 int 35840 M_ARCHIVE_LOG_? string M_ARCHIVE_TYPE_? string DATADEV_? string DATADEV_0001 string DAT_0001 DATA_TYPE_? string DATA_TYPE_0001 string F DATA_SIZE_? int DATA_SIZE_0001 int 262144 __PARAM_CHANGED___ int 0 __PARAM_VERIFIED__ string 2006-07-10 14:21:54 DIAG_HISTORY_NUM int 2 DIAG_HISTORY_PATH string /dados/HE/DIAGHISTORY _DIAG_SEM int 1 SHOW_MAX_STACK_USE string NO LOG_SEGMENT_SIZE int 11946 _COMMENT string SUPPRESS_CORE string YES FORMATTING_MODE string PARALLEL FORMAT_DATAVOLUME string YES OFFICIAL_NODE string LOAD_BALANCING_CHK int 0 LOAD_BALANCING_DIF int 10 LOAD_BALANCING_EQ int 5 EXPAND_COM_TRACE string NO SYMBOL_DEMANGLING string NO USE_OPEN_DIRECT string NO USE_COROUTINES string NO USE_STACK_ON_STACK string YES USE_UCONTEXT string YES MIN_RETENTION_TIME int 60 MAX_RETENTION_TIME int 480 CNSTVIEW_RW_SYNC string NO Can you help me or give me any ideas? I cannot change the erp system. All the stations access with the dba user. Best regards, -- Daniel Castro Website: http://danielti.no-ip.info:2139 MSN: [EMAIL PROTECTED] Skype: danielti2005 ICQ : 316727989 Jabber: danielti Linux User: 387864 AOL User: Danielti2005 Sola Scriptura, Sola Gratia, Sola Fide, Solus Christus, Soli Deo Gloria
