Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Parameter file

R. RoyalOct 22 2012 — edited Oct 22 2012
Hi,
my Oracle DB is 10.2.0.5 version

O.s. Linux Red Hat

I need to modify some parameter into parameter file:

Some parameters are below:
audit_sys_operations
audit_trail
compatible
db_cache_size
event
java_pool_size
job_queue_processes
large_pool_size
pga_aggregate_target
processes
session_cached_cursors
sessions
sga_max_size
sga_target

into path $ORACLE_HOME/dbs I've these files:

init.ora
initdw.ora
spfileorcl.ora
pfileORCL.ora
orapworcl
spfileORCL.ora

Which step I have to perform to change these parameters?

Thanks in advance!
This post has been answered by EdStevens on Oct 22 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 19 2012
Added on Oct 22 2012
26 comments
640 views