Name init.ora parameters which effects system performance.

Showing Answers 1 - 5 of 5 Answers

srinivas reddy

  • Mar 22nd, 2005
 

sort_area_sizedbwr_io_slaveschekpoint intervalparallel server configdb cachesga

  Was this answer useful?  Yes

Ratna Kumari

  • Aug 2nd, 2005
 

These are the Parameters for init.ora 
 
DB_BLOCK_BUFFERS

SHARED_POOL_SIZE

SORT_AREA_SIZE

DBWR_IO_SLAVES

ROLLBACK_SEGMENTS

SORT_AREA_RETAINED_SIZE

DB_BLOCK_LRU_EXTENDED_STATISTICS

SHARED_POOL_RESERVE_SIZE

  Was this answer useful?  Yes

Pooja Agrawal

  • Nov 22nd, 2006
 

Additionally,

PGA_Aggregate_target set when Work_area_policy is set to auto and FAST_START_MTTR_Target set may also affect d/b performance

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions