Database Administration (MOSC)

MOSC Banner

Looking for experts advice

edited Mar 15, 2010 12:45AM in Database Administration (MOSC) 5 commentsAnswered ✓
  Hi,

Please find the oracle db details in my site:

Oracle Version : Oracle 11g Ver 11.1.0.7

OS  : AIX 6.1

Maximum session connected at any given point of time : 1500

Herewith i am attaching my sp file parameter list.  Looking for experts advise what are the parameters i have to change in this.

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
O7_DICTIONARY_ACCESSIBILITY          boolean     FALSE
active_instance_count                integer
aq_tm_processes                      integer     0
archive_lag_target                   integer     0
asm_diskgroups                       string
asm_diskstring                       string
asm_power_limit                      integer     1
asm_preferred_read_failure_groups    string
audit_file_dest                      string      /u01/app/oracle/admin/GSM
                                                 /adump
audit_sys_operations                 boolean     FALSE

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center