Forced Residency [N] Stack Size (K) [ 32]
Non Res. SegSize (K) [ 8000] Optical Cache Size (K) [ 0]

Physical Log Buffer Size [ 32] K Dbspace Down Option [0]
Logical Log Buffer Size [ 32] K Preserve Log For Log Backup [Y]
Max # of Logical Logs [ 60] Transaction Timeout [ 300]
Max # of Locks [ 10000] * Long TX HWM [ 50]
Max # of Buffers [ 2000] * Long TX HWM Exclusive [ 60]
Index Page Fill Factor [ 90]
Add SegSize (K) [ 8192]
Total Memory (K) [ 0]


3. PERFORMANCE TUNING PARAMETERS 设置

Multiprocessor Machine [N] LRU Max Dirty [ 60]
Num Procs to Affinity [ 0] LRU Min Dirty [ 50]
Proc num to start with [ 0] Checkpoint Interval [ 300]
Num of Read Ahead Pages [ ]
CPU VPs [ 1] Read Ahead Threshold [ ]
AIO VPs [ ]
Single CPU VP [Y] * NETTYPE settings:
Use OS Time [N] Protocol Threads Users VP-class
Disable Priority Aging [N] [ipcshm] [ 1] [ 10] [CPU] *
Off-Line Recovery Threads [ 10] [tlitcp] [ 1] [ 10] [CPU] *
On-Line Recovery Threads [ 1] [ ] [ ] [ ] [ ]
Num of LRUS queues [ 8] [ ] [ ] [ ] [ ]


九、建数据库

上一页  [1] [2] [3] [4] 下一页