Skip to Content
0
Feb 16, 2007 at 04:11 PM

Adivece for Ora tuning

80 Views

Hi forum,

this is an old 4.6C system with 4 GB ram and 4 Intel/CPU

-


ALWAYS_ANTI_JOIN

hash

BACKGROUND_DUMP_DEST

f:\oracle\SID\saptrace\background

BITMAP_MERGE_AREA_SIZE

33554432

COMPATIBLE

8.1.7.4.12

CONTROL_FILES

( g:\oracle\SID\sapdata1\cntrl\cntrlSID.dbf,E:\oracle\SID\c

CONTROL_FILE_RECORD_KEEP_TIME

30

CREATE_BITMAP_AREA_SIZE

33554432

DB_BLOCK_BUFFERS

71680

DB_BLOCK_LRU_LATCHES

8

DB_BLOCK_SIZE

8192

DB_FILES

254

DB_FILE_MULTIBLOCK_READ_COUNT

8

DB_NAME

SID

EVENT

"10183 trace name context forever, level 1"

HASH_AREA_SIZE

4194304

HASH_JOIN_ENABLED

false

HASH_MULTIBLOCK_IO_COUNT

8

LOCAL_LISTENER

"(ADDRESS=(PROTOCOL=TCP)(HOST=128.104.1.15)(PORT=1527)(COMMU

LOG_ARCHIVE_DEST

h:\oracle\SID\saparch\SIDarch

LOG_ARCHIVE_FORMAT

ARC%s.%T

LOG_ARCHIVE_START

true

LOG_BUFFER

1048576

LOG_CHECKPOINTS_TO_ALERT

true

LOG_CHECKPOINT_INTERVAL

0

MAX_DUMP_FILE_SIZE

20000

MAX_ROLLBACK_SEGMENTS

400

OPEN_CURSORS

800

OPTIMIZER_INDEX_COST_ADJ

10

OPTIMIZER_MODE

choose

PARALLEL_BROADCAST_ENABLED

true

PARALLEL_EXECUTION_MESSAGE_SIZE

8192

PARALLEL_MAX_SERVERS

4

PROCESSES

100

ROLLBACK_SEGMENTS

(PRS_0,PRS_1,PRS_2,PRS_3,PRS_4,PRS_5,PRS_6,PRS_7,PRS_8,PRS_

ROW_LOCKING

always

SESSIONS

110

SHARED_POOL_RESERVED_SIZE

10000000

SHARED_POOL_SIZE

357019156

SORT_AREA_RETAINED_SIZE

0

SORT_AREA_SIZE

2097152

STAR_TRANSFORMATION_ENABLED

true

TIMED_STATISTICS

true

TRANSACTION_AUDITING

false

USER_DUMP_DEST

f:\oracle\SID\saptrace\usertrace

-


Regards.

Ganimede Dignan.