Database Administration - Name init.ora parameters which effects system performance.

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 77 of 231

Name init.ora parameters which effects system performance.

Total Answers and Comments: 3

Last Update: November 22, 2006

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

March 22, 2005 03:14:23

srinivas reddy

RE: Name init.ora parameters which effects system performance.

sort_area_sizedbwr_io_slaveschekpoint intervalparallel server configdb cachesga

Is this answer useful? Yes | No

August 02, 2005 09:18:08

Ratna Kumari

RE: Name init.ora parameters which effects system performance.

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

Is this answer useful? Yes | No

November 22, 2006 01:10:04

Pooja Agrawal

RE: Name init.ora parameters which effects system perf...

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

Is this answer useful? Yes | No

User Name		Remember Me?
Password

Question Bank