Shannon's JD Edwards CNC Blog: February 2016

Monday, 29 February 2016

harsh but fair

Look at my role…

Not too sure, hopefully stands for Separation of Duty…

Wednesday, 24 February 2016

starting e1 on linux OEL 6.5

Brand new install, I did not do it, I’m starting it for the first time..

I know, excuses – excuses

28698/-150964528 MAIN_THREAD Wed Feb 24 14:08:23.266286 ipcmisc.c299
IPC1300001 - cannot create IPC semaphore array, errno=22: Invalid argument.

28698/-150964528 MAIN_THREAD Wed Feb 24 14:08:23.266387 ipcmisc.c299
IPC1200011 - Check OS kernel parameters semmni and semmns.

28698/-150964528 MAIN_THREAD Wed Feb 24 14:08:23.269578 ipcmisc.c299
IPC1400001 - IPC routine called without successful IPC initialization.

28698/-150964528 MAIN_THREAD Wed Feb 24 14:08:23.269883 ipcmisc.c299
IPC1400001 - IPC routine called without successful IPC initialization.

28698/-150964528 MAIN_THREAD Wed Feb 24 14:08:23.269920 ipcmisc.c299
ipcSawInit: Error: ipcCreateResource 27

28698/-150964528 MAIN_THREAD Wed Feb 24 14:08:23.270289 ipcmisc.c299
IPC1400001 - IPC routine called without successful IPC initialization.

28698/-150964528 MAIN_THREAD Wed Feb 24 14:08:23.270328 ipcmisc.c299
Error: ipcLockResource 27

28698/-150964528 MAIN_THREAD Wed Feb 24 14:08:23.270378 jdenet_n.c148
process <> could not be registered

I need to augment the kernel parameters

vi /etc/sysctl.conf

original:

# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Controls the default maxmimum size of a mesage queue
kernel.msgmnb = 65536

# Controls the maximum size of a message, in bytes
kernel.msgmax = 65536

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296
kernel.sem = 100
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576

Changes

# Kernel sysctl configuration file for Red Hat Linux
#
# For binary values, 0 is disabled, 1 is enabled. See sysctl(8) and
# sysctl.conf(5) for more details.

# Controls IP packet forwarding
net.ipv4.ip_forward = 0

# Controls source route verification
net.ipv4.conf.default.rp_filter = 1

# Do not accept source routing
net.ipv4.conf.default.accept_source_route = 0

# Controls the System Request debugging functionality of the kernel
kernel.sysrq = 0

# Controls whether core dumps will append the PID to the core filename.
# Useful for debugging multi-threaded applications.
kernel.core_uses_pid = 1

# Controls the use of TCP syncookies
net.ipv4.tcp_syncookies = 1

# Controls the default maxmimum size of a mesage queue
kernel.msgmnb = 65536

# Controls the maximum size of a message, in bytes
kernel.msgmax = 65536

# Controls the maximum shared segment size, in bytes
kernel.shmmax = 68719476736

# Controls the maximum number of shared memory segments, in pages
kernel.shmall = 4294967296
kernel.sem = 1250 320000 100 1024
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576

Then run sysctl –p as root

All good!

Tuesday, 23 February 2016

select * from DBA_FEATURE_USAGE_STATISTICS ;

Want to know what has been done on your database during audit time, here is some more handy hints for working it out:

select * from DBA_FEATURE_USAGE_STATISTICS ;

Another example of when you are trying to audit what a client is using so that you can replicate this functionality. My use case is moving someone to RDS in AWS and I want to ensure that the database features are mapped appropriately.

NAME	DETECTED_USAGES	CURRENTLY_USED	VERSION
----------------------------------------------------------------	----------------------	--------------	-----------------
ADDM	1	TRUE	11.2.0.4.0
AWR Report	1	TRUE	11.2.0.4.0
Audit Options	65	TRUE	11.2.0.4.0
Automatic Maintenance - Optimizer Statistics Gathering	3	FALSE	11.2.0.4.0
Automatic Maintenance - SQL Tuning Advisor	65	TRUE	11.2.0.4.0
Automatic Maintenance - Space Advisor	65	TRUE	11.2.0.4.0
Automatic SGA Tuning	2	FALSE	11.2.0.4.0
Automatic SQL Execution Memory	65	TRUE	11.2.0.4.0
Automatic SQL Tuning Advisor	64	TRUE	11.2.0.4.0
Automatic Segment Space Management (system)	65	TRUE	11.2.0.4.0
Automatic Segment Space Management (user)	64	TRUE	11.2.0.4.0
Automatic Undo Management	65	TRUE	11.2.0.4.0
Character Set	65	TRUE	11.2.0.4.0
Deferred Segment Creation	65	TRUE	11.2.0.4.0
EM Performance Page	1	TRUE	11.2.0.4.0
Extensibility	62	TRUE	11.2.0.4.0
LOB	64	TRUE	11.2.0.4.0
Locally Managed Tablespaces (system)	65	TRUE	11.2.0.4.0
Locally Managed Tablespaces (user)	65	TRUE	11.2.0.4.0
Logfile Multiplexing	65	TRUE	11.2.0.4.0
Object	62	TRUE	11.2.0.4.0
Oracle Java Virtual Machine (system)	65	TRUE	11.2.0.4.0
Oracle Java Virtual Machine (user)	62	TRUE	11.2.0.4.0
Oracle Utility Datapump (Export)	4	FALSE	11.2.0.4.0
Oracle Utility Metadata API	6	FALSE	11.2.0.4.0
Partitioning (system)	65	TRUE	11.2.0.4.0
Result Cache	64	TRUE	11.2.0.4.0
SecureFiles (system)	65	TRUE	11.2.0.4.0
SecureFiles (user)	65	TRUE	11.2.0.4.0
Server Parameter File	65	TRUE	11.2.0.4.0
Streams (user)	62	TRUE	11.2.0.4.0
Virtual Private Database (VPD)	65	TRUE	11.2.0.4.0

v$license

select * from v$license;

SESSIONS_MAX SESSIONS_WARNING SESSIONS_CURRENT SESSIONS_HIGHWATER USERS_MAX CPU_COUNT_CURRENT CPU_CORE_COUNT_CURRENT CPU_SOCKET_COUNT_CURRENT CPU_COUNT_HIGHWATER CPU_CORE_COUNT_HIGHWATER CPU_SOCKET_COUNT_HIGHWATER
---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ---------------------- ------------------------ ---------------------- ------------------------ --------------------------
0 0 259 281 0 8 1 1 8 1 1

select * from v$option;

PARAMETER                                                        VALUE
---------------------------------------------------------------- ----------------------------------------------------------------
Partitioning                                                     TRUE
Objects                                                          TRUE
Real Application Clusters                                        FALSE
Advanced replication                                             TRUE
Bit-mapped indexes                                               TRUE
Connection multiplexing                                          TRUE
Connection pooling                                               TRUE
Database queuing                                                 TRUE
Incremental backup and recovery                                  TRUE
Instead-of triggers                                              TRUE
Parallel backup and recovery                                     TRUE
Parallel execution                                               TRUE
Parallel load                                                    TRUE
Point-in-time tablespace recovery                                TRUE
Fine-grained access control                                      TRUE
Proxy authentication/authorization                               TRUE
Change Data Capture                                              TRUE
Plan Stability                                                   TRUE
Online Index Build                                               TRUE
Coalesce Index                                                   TRUE
Managed Standby                                                  TRUE
Materialized view rewrite                                        TRUE
Database resource manager                                        TRUE
Spatial                                                          TRUE
Automatic Storage Management                                     FALSE
Export transportable tablespaces                                 TRUE
Transparent Application Failover                                 TRUE
Fast-Start Fault Recovery                                        TRUE
Sample Scan                                                      TRUE
Duplexed backups                                                 TRUE
Java                                                             TRUE
OLAP Window Functions                                            TRUE
Block Media Recovery                                             TRUE
Fine-grained Auditing                                            TRUE
Application Role                                                 TRUE
Enterprise User Security                                         TRUE
Oracle Data Guard                                                TRUE
Oracle Label Security                                            FALSE
OLAP                                                             TRUE
Basic Compression                                                TRUE
Join index                                                       TRUE
Trial Recovery                                                   TRUE
Data Mining                                                      TRUE
Online Redefinition                                              TRUE
Streams Capture                                                  TRUE
File Mapping                                                     TRUE
Block Change Tracking                                            TRUE
Flashback Table                                                  TRUE
Flashback Database                                               TRUE
Transparent Data Encryption                                      TRUE
Backup Encryption                                                TRUE
Unused Block Compression                                         TRUE
Oracle Database Vault                                            FALSE
Result Cache                                                     TRUE
SQL Plan Management                                              TRUE
SecureFiles Encryption                                           TRUE
Real Application Testing                                         TRUE
Flashback Data Archive                                           TRUE
DICOM                                                            TRUE
Active Data Guard                                                TRUE
Server Flash Cache                                               TRUE
Advanced Compression                                             TRUE
XStream                                                          TRUE
Deferred Segment Creation                                        TRUE
Data Redaction                                                   TRUE

select * from v$version

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
"CORE 11.2.0.4.0 Production"
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 – Production

select * from v$parameter;

NUM NAME TYPE VALUE DISPLAY_VALUE ISDEFAULT ISSES_MODIFIABLE ISSYS_MODIFIABLE ISINSTANCE_MODIFIABLE ISMODIFIED ISADJUSTED ISDEPRECATED ISBASIC DESCRIPTION UPDATE_COMMENT HASH

Num

Na

Value

38

lock_name_space

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

lock name space used for generating lock names for standby/clone database

1022980314

39

processes

3

900

900

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

user processes

4162014761

40

sessions

3

1376

1376

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

user and system sessions

3194028855

41

timed_statistics

1

TRUE

TRUE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

maintain internal timing statistics

2224114877

42

timed_os_statistics

3

0

0

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

internal os statistic gathering interval in seconds

2425331770

43

resource_limit

1

FALSE

FALSE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

master switch for resource limit

19363908

44

license_max_sessions

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

maximum number of non-system user sessions allowed

2409810571

45

license_sessions_warning

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

warning level for number of non-system user sessions

4168462818

88

cpu_count

3

8

8

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

number of CPUs for this instance

1095434542

93

instance_groups

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

list of instance group names

714080904

97

event

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

debug event control - default null string

557769962

110

sga_max_size

6

25165824000

24000M

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

max total SGA size

internally adjusted

3640569645

117

use_large_pages

2

ONLY

ONLY

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Use large pages if available (TRUE/FALSE/ONLY)

6.22 NON-EBSO

3303635063

122

pre_page_sga

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

pre-page sga for process

4157293338

123

shared_memory_address

3

0

0

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

SGA starting address (low order 32-bits on 64-bit platforms)

1147088340

124

hi_shared_memory_address

3

0

0

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

SGA starting address (high order 32-bits on 64-bit platforms)

2467282562

125

use_indirect_data_buffers

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Enable indirect data buffers (very large SGA on 32-bit platforms)

1450736570

127

lock_sga

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Lock entire SGA in physical memory

3105560606

168

processor_group_name

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Name of the processor group that this instance should run in.

3670365524

173

shared_pool_size

6

2885681152

2752M

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

size in bytes of shared pool

1378805370

175

large_pool_size

6

268435456

256M

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

size in bytes of large pool

4033299612

177

java_pool_size

6

268435456

256M

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

size in bytes of java pool

682389752

179

streams_pool_size

6

67108864

64M

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

size in bytes of the streams pool

4113905875

181

shared_pool_reserved_size

6

209715200

200M

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

size in bytes of reserved area of shared pool

3099794371

184

java_soft_sessionspace_limit

3

0

0

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

warning limit on size in bytes of a Java sessionspace

2289238341

185

java_max_sessionspace_size

3

0

0

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

max allowed size in bytes of a Java sessionspace

2976582011

194

spfile

2

/pvlne8/oracle/product/11204/dbs/spfilePVLNE8.ora

/pvlne8/oracle/product/11204/dbs/spfilePVLNE8.ora

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

server parameter file

3653611964

195

instance_type

2

RDBMS

RDBMS

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

type of instance to be executed

3061809694

232

nls_language

2

AMERICAN

AMERICAN

TRUE

TRUE

FALSE

FALSE

MODIFIED

FALSE

FALSE

TRUE

NLS language name

3485237129

233

nls_territory

2

AMERICA

AMERICA

TRUE

TRUE

FALSE

FALSE

MODIFIED

FALSE

FALSE

TRUE

NLS territory name

4101776966

234

nls_sort

2

binary

binary

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

NLS linguistic definition name

1540560305

235

nls_date_language

2

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

NLS date language name

1568340031

236

nls_date_format

2

DD-MON-RR

DD-MON-RR

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

NLS Oracle date format

677968994

237

nls_currency

2

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

NLS local currency symbol

1866631167

238

nls_numeric_characters

2

.,

.,

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

NLS numeric characters

1350504691

239

nls_iso_currency

2

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

NLS ISO currency territory name

1902084911

240

nls_calendar

2

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

NLS calendar system name

600406646

241

nls_time_format

2

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

time format

279591871

242

nls_timestamp_format

2

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

time stamp format

1867855122

243

nls_time_tz_format

2

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

time with timezone format

3395216182

244

nls_timestamp_tz_format

2

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

timestamp with timezone format

197674624

245

nls_dual_currency

2

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Dual currency symbol

3671532261

246

nls_comp

2

binary

binary

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

NLS comparison

2564149862

247

nls_length_semantics

2

BYTE

BYTE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

create columns using byte or char semantics by default

726541850

248

nls_nchar_conv_excp

2

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

NLS raise an exception instead of allowing implicit conversion

928612038

255

fileio_network_adapters

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Network Adapters for File I/O

3529525450

257

filesystemio_options

2

SETALL

SETALL

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

IO operations on filesystem files

752770605

258

dnfs_batch_size

3

4096

4096

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Max number of dNFS asynch I/O requests queued per session

1994133209

270

clonedb

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

clone database

928499171

271

instant_restore

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

instant repopulation of datafiles

4142333245

279

disk_asynch_io

1

TRUE

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Use asynch I/O for random access devices

629465343

280

tape_asynch_io

1

TRUE

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Use asynch I/O requests for tape devices

4219463829

282

dbwr_io_slaves

3

0

0

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

DBWR I/O slaves

3394903742

286

backup_tape_io_slaves

1

FALSE

FALSE

TRUE

FALSE

DEFERRED

TRUE

FALSE

FALSE

FALSE

FALSE

BACKUP Tape I/O slaves

3484415485

294

resource_manager_cpu_allocation

3

8

8

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

TRUE

FALSE

Resource Manager CPU allocation

2295969896

296

resource_manager_plan

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

resource mgr top plan

771115908

374

cluster_interconnects

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

interconnects for RAC use

453198651

437

_ksmg_granule_size

3

67108864

67108864

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

granule size in bytes

4165852122

441

file_mapping

1

FALSE

FALSE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

enable file mapping

232153461

538

gcs_server_processes

3

0

0

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

number of background gcs server processes to start

3586934196

550

active_instance_count

3

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

number of active instances in the cluster database

1385697455

779

sga_target

6

0

0

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

Target size of SGA

3134551790

781

memory_target

6

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Target size of Oracle SGA and PGA memory

1127054141

782

memory_max_target

6

0

0

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Max size for Memory Target

3306918234

795

_memory_imm_mode_without_autosga

1

FALSE

FALSE

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Allow immediate mode without sga/memory target

3612257904

809

control_files

2

/pvlne8/oradata/data01/control01.ctl, /pvlne8/oradata/data02/control02.ctl, /pvlne8/oradata/data03/control03.ctl

/pvlne8/oradata/data01/control01.ctl, /pvlne8/oradata/data02/control02.ctl, /pvlne8/oradata/data03/control03.ctl

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

control file names list

2567365799

818

db_file_name_convert

2

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

datafile name convert patterns and strings for standby/clone db

2967069573

819

log_file_name_convert

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

logfile name convert patterns and strings for standby/clone db

3861982543

820

control_file_record_keep_time

3

7

7

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

control file record keep time in days

98688804

824

db_block_buffers

3

0

0

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Number of database blocks cached in memory

2234540729

828

db_block_checksum

2

TYPICAL

TYPICAL

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

store checksum in db blocks and check during reads

236379301

829

db_ultra_safe

2

OFF

OFF

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Sets defaults for other parameters that control protection levels

93442106

830

db_block_size

3

8192

8192

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

Size of database block in bytes

3433134853

846

db_cache_size

6

21541945344

20544M

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Size of DEFAULT buffer pool for standard block size buffers

1878231416

848

db_2k_cache_size

6

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Size of cache for 2K buffers

1251260559

849

db_4k_cache_size

6

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Size of cache for 4K buffers

2460170291

850

db_8k_cache_size

6

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Size of cache for 8K buffers

1564706367

851

db_16k_cache_size

6

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Size of cache for 16K buffers

1652300362

852

db_32k_cache_size

6

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Size of cache for 32K buffers

63005144

853

db_keep_cache_size

6

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Size of KEEP buffer pool for standard block size buffers

1851163622

854

db_recycle_cache_size

6

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Size of RECYCLE buffer pool for standard block size buffers

409865660

856

_shared_io_pool_size

6

0

0

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Size of shared IO pool

761083846

867

db_writer_processes

3

1

1

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

number of background database writer processes to start

2675391963

889

buffer_pool_keep

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

Number of database blocks/latches in keep buffer pool

4221146327

890

buffer_pool_recycle

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

Number of database blocks/latches in recycle buffer pool

243965399

943

db_flash_cache_file

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

flash cache file for default block size

2154593857

944

db_flash_cache_size

6

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

flash cache size for db_flash_cache_file

2662488753

966

db_cache_advice

2

ON

ON

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Buffer cache sizing advisory

76537751

982

compatible

2

11.2.0.0.0

11.2.0.0.0

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

Database will be completely compatible with this software version

2586206788

993

log_archive_dest_1

2

LOCATION=/pvlne8/arch MANDATORY

LOCATION=/pvlne8/arch MANDATORY

FALSE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

archival destination #1 text string

2668113655

994

log_archive_dest_2

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

archival destination #2 text string

993174268

995

log_archive_dest_3

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #3 text string

4019416444

996

log_archive_dest_4

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #4 text string

4076933173

997

log_archive_dest_5

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #5 text string

2983371913

998

log_archive_dest_6

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #6 text string

3163254911

999

log_archive_dest_7

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #7 text string

1195731386

1000

log_archive_dest_8

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #8 text string

1294131998

1001

log_archive_dest_9

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #9 text string

2975895765

1002

log_archive_dest_10

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #10 text string

4052929217

1003

log_archive_dest_11

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #11 text string

250996408

1004

log_archive_dest_12

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #12 text string

2055242793

1005

log_archive_dest_13

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #13 text string

3129541886

1006

log_archive_dest_14

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #14 text string

646973396

1007

log_archive_dest_15

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #15 text string

2102065363

1008

log_archive_dest_16

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #16 text string

3433075299

1009

log_archive_dest_17

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #17 text string

3605958982

1010

log_archive_dest_18

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #18 text string

2185923656

1011

log_archive_dest_19

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #19 text string

3460444459

1012

log_archive_dest_20

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #20 text string

4223402204

1013

log_archive_dest_21

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #21 text string

1524973738

1014

log_archive_dest_22

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #22 text string

2302788208

1015

log_archive_dest_23

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #23 text string

428356674

1016

log_archive_dest_24

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #24 text string

875888895

1017

log_archive_dest_25

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #25 text string

2545053957

1018

log_archive_dest_26

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #26 text string

1817558786

1019

log_archive_dest_27

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #27 text string

4097113290

1020

log_archive_dest_28

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #28 text string

1607184325

1021

log_archive_dest_29

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #29 text string

3817697632

1022

log_archive_dest_30

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #30 text string

2615509879

1023

log_archive_dest_31

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #31 text string

3017163142

1024

log_archive_dest_state_1

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

archival destination #1 state text string

2730384854

1025

log_archive_dest_state_2

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

archival destination #2 state text string

148092523

1026

log_archive_dest_state_3

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #3 state text string

2513869874

1027

log_archive_dest_state_4

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #4 state text string

3691366817

1028

log_archive_dest_state_5

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #5 state text string

3081952655

1029

log_archive_dest_state_6

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #6 state text string

304021296

1030

log_archive_dest_state_7

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #7 state text string

3630253584

1031

log_archive_dest_state_8

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #8 state text string

3554679994

1032

log_archive_dest_state_9

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #9 state text string

1436305019

1033

log_archive_dest_state_10

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #10 state text string

1751244906

1034

log_archive_dest_state_11

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #11 state text string

2886606469

1035

log_archive_dest_state_12

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #12 state text string

3304517691

1036

log_archive_dest_state_13

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #13 state text string

2269052938

1037

log_archive_dest_state_14

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #14 state text string

2727699920

1038

log_archive_dest_state_15

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #15 state text string

2514322449

1039

log_archive_dest_state_16

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #16 state text string

2187424721

1040

log_archive_dest_state_17

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #17 state text string

1347081708

1041

log_archive_dest_state_18

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #18 state text string

2558416988

1042

log_archive_dest_state_19

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #19 state text string

1838072217

1043

log_archive_dest_state_20

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #20 state text string

2897696991

1044

log_archive_dest_state_21

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #21 state text string

1810950964

1045

log_archive_dest_state_22

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #22 state text string

3965758431

1046

log_archive_dest_state_23

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #23 state text string

1640771709

1047

log_archive_dest_state_24

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #24 state text string

312358666

1048

log_archive_dest_state_25

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #25 state text string

2480335086

1049

log_archive_dest_state_26

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #26 state text string

2373194801

1050

log_archive_dest_state_27

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #27 state text string

3084460413

1051

log_archive_dest_state_28

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #28 state text string

1760097473

1052

log_archive_dest_state_29

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #29 state text string

2023610917

1053

log_archive_dest_state_30

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #30 state text string

2972207749

1054

log_archive_dest_state_31

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination #31 state text string

4128759905

1055

log_archive_start

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

start archival process on SGA initialization

952772995

1056

log_archive_dest

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

archival destination text string

2428527576

1057

log_archive_duplex_dest

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

duplex archival destination text string

3687644184

1058

log_archive_min_succeed_dest

3

1

1

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

minimum number of archive destinations that must succeed

3835057806

1059

standby_archive_dest

2

?/dbs/arch

?/dbs/arch

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

TRUE

FALSE

standby database archivelog destination text string

323222115

1064

fal_client

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

FAL client

1512728298

1065

fal_server

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

FAL server list

72419950

1068

log_archive_trace

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Establish archivelog operation tracing level

967210318

1085

log_archive_config

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

log archive config parameter

1745268181

1090

log_archive_local_first

1

TRUE

TRUE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

TRUE

FALSE

Establish EXPEDITE attribute default value

438609192

1092

log_archive_format

2

PVLNE8_%r_%t_%s.arc

PVLNE8_%r_%t_%s.arc

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

archival destination format

267180648

1097

redo_transport_user

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Data Guard transport user when using password file

2619943614

1102

log_archive_max_processes

3

4

4

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

maximum number of active ARCH processes

3132953756

1116

log_buffer

3

18898944

18898944

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

redo circular buffer size

log buffer update

1173026923

1119

log_checkpoint_interval

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

# redo blocks checkpoint threshold

421865232

1120

log_checkpoint_timeout

3

3600

3600

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Maximum time interval between checkpoints in seconds

1325866608

1122

archive_lag_target

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Maximum number of seconds of redos the standby could lose

592789495

1142

_use_adaptive_log_file_sync

2

FALSE

FALSE

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Adaptively switch between post/wait and polling

3774038192

1154

db_files

3

1024

1024

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

max allowable # db files

314572703

1155

db_file_multiblock_read_count

3

128

128

FALSE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

db block to be read each IO

1428169303

1159

read_only_open_delayed

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

if TRUE delay opening of read only files until first access

3134028732

1160

cluster_database

1

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

if TRUE startup in cluster database mode

3044213568

1161

parallel_server

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

if TRUE startup in parallel server mode

463488463

1162

parallel_server_instances

3

1

1

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

number of instances to use for sizing OPS SGA structures

623279130

1163

cluster_database_instances

3

1

1

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

number of instances to use for sizing cluster db SGA structures

2296134110

1164

db_create_file_dest

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

default database location

203090614

1165

db_create_online_log_dest_1

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

online log/controlfile destination #1

1631516011

1166

db_create_online_log_dest_2

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

online log/controlfile destination #2

563999388

1167

db_create_online_log_dest_3

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

online log/controlfile destination #3

1878635215

1168

db_create_online_log_dest_4

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

online log/controlfile destination #4

2503927821

1169

db_create_online_log_dest_5

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

online log/controlfile destination #5

1433039549

1170

db_recovery_file_dest

2

TRUE

FALSE

IMMEDIATE

FALSE

FALSE

FALSE

FALSE

TRUE

default database recovery file location

3387568471

1171

db_recovery_file_dest_size

6

0

0

TRUE

FALSE

IMMEDIATE

FALSE

FALSE

FALSE

FALSE

TRUE

database recovery files size limit

1541539076

1173

standby_file_management

2

MANUAL

MANUAL

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

if auto then files are created/dropped automatically on standby

3958066716

1251

db_unrecoverable_scn_tracking

1

TRUE

TRUE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Track nologging SCN in controlfile

1772971972

1255

thread

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Redo thread to mount

2684606808

1262

fast_start_io_target

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

TRUE

FALSE

Upper bound on recovery reads

1445495989

1263

fast_start_mttr_target

3

0

0

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

MTTR target in seconds

3666596407

1269

log_checkpoints_to_alert

1

TRUE

TRUE

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

log checkpoint begin/end to alert file

1565101272

1270

db_lost_write_protect

2

NONE

NONE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

enable lost write detection

1160013993

1274

recovery_parallelism

3

0

0

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

number of server processes to use for parallel recovery

4261073806

1336

enable_goldengate_replication

1

FALSE

FALSE

TRUE

FALSE

IMMEDIATE

FALSE

FALSE

FALSE

FALSE

FALSE

goldengate replication enabled

1531782384

1378

db_flashback_retention_target

3

1440

1440

TRUE

FALSE

IMMEDIATE

FALSE

FALSE

FALSE

FALSE

FALSE

Maximum Flashback Database log retention time in minutes.

2211957778

1476

dml_locks

3

6052

6052

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

dml locks - one for each table modified in a transaction

1576699050

1481

replication_dependency_tracking

1

TRUE

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

tracking dependency for Replication parallel propagation

2475358177

1489

transactions

3

1513

1513

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

max. number of concurrent active transactions

812710636

1490

transactions_per_rollback_segment

3

5

5

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

number of active transactions per rollback segment

2728085332

1492

rollback_segments

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

undo segment list

1884290623

1500

undo_management

2

AUTO

AUTO

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

instance runs in SMU mode if TRUE, else in RBU mode

1401409411

1501

undo_tablespace

2

UNDOTBS1

UNDOTBS1

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

use/switch undo tablespace

2692150816

1518

undo_retention

3

900

900

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

undo retention in seconds

3327480172

1521

fast_start_parallel_rollback

2

LOW

LOW

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

max number of parallel recovery slaves that may be used

1116456128

1523

resumable_timeout

3

0

0

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

set resumable_timeout

3544280463

1544

instance_number

3

0

0

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

instance number

3331028598

1597

db_block_checking

2

false

false

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

header checking and data and index block checking

1476124072

1600

recyclebin

2

OFF

OFF

FALSE

TRUE

DEFERRED

TRUE

FALSE

FALSE

FALSE

FALSE

recyclebin processing

4276141125

1724

db_securefile

2

PERMITTED

PERMITTED

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

permit securefile storage during lob creation

3201873517

1769

create_stored_outlines

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

create stored outlines for DML statements

4265209363

1772

serial_reuse

2

disable

disable

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

reuse the frame segments

319631122

1780

ldap_directory_access

2

NONE

NONE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

RDBMS's LDAP access option

366357953

1781

ldap_directory_sysauth

2

no

no

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

OID usage parameter

3590721065

1782

os_roles

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

retrieve roles from the operating system

3783461165

1783

rdbms_server_dn

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

RDBMS's Distinguished Name

3271017715

1784

max_enabled_roles

3

150

150

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

max number of roles a user can have enabled

2310035663

1785

remote_os_authent

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

allow non-secure remote clients to use auto-logon accounts

1794288875

1786

remote_os_roles

1

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

allow non-secure remote clients to use os roles

1402234932

1788

sec_case_sensitive_logon

1

FALSE

FALSE

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

case sensitive password enabled for logon

1474075370

1789

O7_DICTIONARY_ACCESSIBILITY

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Version 7 Dictionary Accessibility Support

1977079269

1791

remote_login_passwordfile

2

EXCLUSIVE

EXCLUSIVE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

password file usage parameter

3127891494

1792

license_max_users

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

maximum number of named users that can be created in the database

849023886

1796

audit_sys_operations

1

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

enable sys auditing

2991425711

1799

global_context_pool_size

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

Global Application Context Pool Size in Bytes

1444745400

1804

db_domain

2

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

directory part of global database name stored with CREATE DATABASE

2669961844

1805

global_names

1

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

enforce that database links have same name as remote database

2700405834

1806

distributed_lock_timeout

3

60

60

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

number of seconds a distributed transaction waits for a lock

842900040

1808

commit_point_strength

3

1

1

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Bias this node has toward not preparing in a two-phase commit

2235849826

1811

global_txn_processes

3

1

1

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

number of background global transaction processes to start

1426614060

1819

instance_name

2

PVLNE8

PVLNE8

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

instance name supported by the instance

2256857119

1820

service_names

2

PVLNE8

PVLNE8

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

service names supported by the instance

715667293

1822

dispatchers

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

specifications of dispatchers

2044337135

1823

shared_servers

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

number of shared servers to start up

3176325557

1824

max_shared_servers

3

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

max number of shared servers

2826600650

1825

max_dispatchers

3

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

max number of dispatchers

1521154394

1826

circuits

3

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

max number of circuits

4176376279

1827

shared_server_sessions

3

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

max number of shared server sessions

3395071916

1828

local_listener

2

LISTENER_PVLNE8

LISTENER_PVLNE8

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

local listener

1166810346

1829

remote_listener

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

remote listener

3804628476

1830

listener_networks

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

listener registration networks

131162088

1844

cursor_space_for_time

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

use more memory in order to get faster execution

4277774490

1845

session_cached_cursors

3

50

50

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Number of cursors to cache in a session.

766615249

1852

remote_dependencies_mode

2

TIMESTAMP

TIMESTAMP

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

remote-procedure-call dependencies mode parameter

3590465749

1853

utl_file_dir

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

utl_file accessible directories list

379739569

1854

smtp_out_server

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

utl_smtp server and port configuration parameter

3248157648

1856

plsql_v2_compatibility

1

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

TRUE

FALSE

PL/SQL version 2.x compatibility flag

3179637611

1858

plsql_warnings

2

DISABLE:ALL

DISABLE:ALL

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

PL/SQL compiler warnings settings

PL/SQL warnings at init.ora

1215950514

1859

plsql_code_type

2

INTERPRETED

INTERPRETED

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

PL/SQL code-type

2972627138

1861

plsql_debug

1

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

TRUE

FALSE

PL/SQL debug

2795594338

1862

plsql_optimize_level

3

2

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

PL/SQL optimize level

818269884

1863

plsql_ccflags

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

PL/SQL ccflags

2398569109

1865

plscope_settings

2

identifiers:all

identifiers:all

TRUE

TRUE

IMMEDIATE

TRUE

MODIFIED

FALSE

FALSE

FALSE

plscope_settings controls the compile time collection, cross reference, and storage of PL/SQL source code identifier data

3026899342

1869

permit_92_wrap_format

1

TRUE

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

allow 9.2 or older wrap format in PL/SQL

3263158038

1870

java_jit_enabled

1

TRUE

TRUE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Java VM JIT enabled

3091533831

1871

java_restrict

2

none

none

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Restrict Java VM Access

3776423980

1872

job_queue_processes

3

10

10

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

maximum number of job queue slave processes

1663833312

1875

parallel_min_percent

3

0

0

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

minimum percent of threads required for parallel query

2166267089

1878

create_bitmap_area_size

3

8388608

8388608

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

size of create bitmap buffer for bitmap index

2520699331

1879

bitmap_merge_area_size

3

1048576

1048576

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

maximum memory allow for BITMAP MERGE

1575972631

1882

cursor_sharing

2

EXACT

EXACT

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

cursor sharing mode

3355675594

1885

result_cache_mode

2

MANUAL

MANUAL

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

result cache operator usage mode

866827446

1900

parallel_min_servers

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

minimum parallel query servers per instance

759236997

1901

parallel_max_servers

3

0

0

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

maximum parallel query servers per instance

3629921023

1906

parallel_instance_group

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

instance group to use for all parallel operations

1634530335

1910

parallel_execution_message_size

3

16384

16384

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

message buffer size for parallel execution

502422959

1921

hash_area_size

3

131072

131072

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

size of in-memory hash work area

3018060907

1941

result_cache_max_size

6

28868608

28192K

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

maximum amount of memory to be used by the cache

4221019766

1942

result_cache_max_result

3

5

5

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

maximum result size as percent of cache size

4174962580

1943

result_cache_remote_expiration

3

0

0

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

maximum life time (min) for any result using a remote object

2062733047

1955

shadow_core_dump

2

partial

partial

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Core Size for Shadow Processes

89911312

1956

background_core_dump

2

partial

partial

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Core Size for Background Processes

1863643544

1957

background_dump_dest

2

/pvlne8/log/diag/rdbms/pvlne8/PVLNE8/trace

/pvlne8/log/diag/rdbms/pvlne8/PVLNE8/trace

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

TRUE

FALSE

Detached process dump directory

3665100166

1958

user_dump_dest

2

/pvlne8/log/diag/rdbms/pvlne8/PVLNE8/trace

/pvlne8/log/diag/rdbms/pvlne8/PVLNE8/trace

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

TRUE

FALSE

User process dump directory

2332088509

1959

core_dump_dest

2

/pvlne8/log/diag/rdbms/pvlne8/PVLNE8/cdump

/pvlne8/log/diag/rdbms/pvlne8/PVLNE8/cdump

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Core dump directory

18033226

1968

audit_file_dest

2

/pvlne8/log/audit

/pvlne8/log/audit

FALSE

FALSE

DEFERRED

TRUE

FALSE

FALSE

FALSE

FALSE

Directory in which auditing files are to reside

2188534560

1969

audit_syslog_level

2

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Syslog facility and level

1189300432

1975

object_cache_optimal_size

3

102400

102400

TRUE

TRUE

DEFERRED

TRUE

FALSE

FALSE

FALSE

FALSE

optimal size of the user session's object cache in bytes

2564444157

1976

object_cache_max_size_percent

3

10

10

TRUE

TRUE

DEFERRED

TRUE

FALSE

FALSE

FALSE

FALSE

percentage of maximum size over optimal of the user session's object cache

3695573432

1980

session_max_open_files

3

10

10

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

maximum number of open files allowed per session

3334892241

1986

open_links

3

4

4

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

max # open links per session

3842870833

1987

open_links_per_instance

3

4

4

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

max # open links per instance

1931961830

1991

commit_write

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

TRUE

FALSE

transaction commit log write behaviour

4194277916

1992

commit_wait

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

transaction commit log wait behaviour

3338003716

1993

commit_logging

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

transaction commit log write behaviour

1056517785

1995

optimizer_features_enable

2

11.2.0.4

11.2.0.4

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

optimizer plan compatibility parameter

2759770534

1996

fixed_date

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

fixed SYSDATE value

48917745

1997

audit_trail

2

OS

OS

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

enable system auditing

4289193100

1998

sort_area_size

3

65536

65536

TRUE

TRUE

DEFERRED

TRUE

FALSE

FALSE

FALSE

FALSE

size of in-memory sort work area

2099108347

1999

sort_area_retained_size

3

0

0

TRUE

TRUE

DEFERRED

TRUE

FALSE

FALSE

FALSE

FALSE

size of in-memory sort work area retained between fetch calls

3312265650

2013

cell_offload_processing

1

TRUE

TRUE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

enable SQL processing offload to cells

3671696352

2014

cell_offload_decryption

1

TRUE

TRUE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

enable SQL processing offload of encrypted data to cells

1760070659

2015

cell_offload_parameters

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Additional cell offload parameters

2383178748

2016

cell_offload_compaction

2

ADAPTIVE

ADAPTIVE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Cell packet compaction strategy

3388561534

2017

cell_offload_plan_display

2

AUTO

AUTO

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Cell offload explain plan display

1313668841

2020

db_name

2

PVLNE8

PVLNE8

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

database name specified in CREATE DATABASE

704871292

2021

db_unique_name

2

PVLNE8

PVLNE8

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

Database Unique Name

2994684304

2022

open_cursors

3

300

300

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

max # cursors per session

4033294835

2023

ifile

4

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

include file in init.ora

636214420

2024

sql_trace

1

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

TRUE

FALSE

enable SQL trace

750089050

2025

os_authent_prefix

2

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

prefix for auto-logon accounts

4201741605

2027

optimizer_mode

2

ALL_ROWS

ALL_ROWS

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

optimizer mode

487657984

2032

sql92_security

1

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

require select privilege for searched update/delete

2745708589

2035

blank_trimming

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

blank trimming semantics parameter

1367606241

2041

star_transformation_enabled

2

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

enable the use of star transformation

1860374294

2083

parallel_degree_policy

2

MANUAL

MANUAL

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

policy used to compute the degree of parallelism (MANUAL/LIMITED/AUTO)

1979359697

2091

parallel_adaptive_multi_user

1

TRUE

TRUE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

enable adaptive setting of degree for multiple user streams

1602823864

2092

parallel_threads_per_cpu

3

2

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

number of parallel execution threads per CPU

1020981983

2093

parallel_automatic_tuning

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

TRUE

FALSE

enable intelligent defaults for parallel execution parameters

2442154617

2099

parallel_io_cap_enabled

1

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

TRUE

FALSE

enable capping DOP by IO bandwidth

1152212467

2120

optimizer_index_cost_adj

3

100

100

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

optimizer index cost adjustment

3753899412

2121

optimizer_index_caching

3

0

0

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

optimizer percent index caching

699019442

2133

query_rewrite_enabled

2

TRUE

TRUE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

allow rewrite of queries using materialized views if enabled

3941771694

2134

query_rewrite_integrity

2

enforced

enforced

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

perform rewrite using materialized views with desired integrity

485484145

2192

pga_aggregate_target

6

4194304000

4000M

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

TRUE

Target size for the aggregate PGA memory consumed by the instance

6.22 NON-EBSO

2184567208

2195

workarea_size_policy

2

AUTO

AUTO

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

policy used to size SQL working areas (MANUAL/AUTO)

4004437305

2220

optimizer_dynamic_sampling

3

2

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

optimizer dynamic sampling

549852465

2250

statistics_level

2

TYPICAL

TYPICAL

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

statistics level

3696230136

2275

cursor_bind_capture_destination

2

memory+disk

memory+disk

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Allowed destination for captured bind variables

766397948

2294

skip_unusable_indexes

1

TRUE

TRUE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

skip unusable indexes if set to TRUE

3916780315

2376

optimizer_secure_view_merging

1

FALSE

FALSE

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

optimizer secure view merging and predicate pushdown/movearound

2261060089

2420

ddl_lock_timeout

3

0

0

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

timeout to restrict the time that ddls wait for dml lock

2606707053

2422

deferred_segment_creation

1

TRUE

TRUE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

defer segment creation to first insert

2736380908

2430

optimizer_use_pending_statistics

1

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Control whether to use optimizer pending statistics

244859984

2435

optimizer_capture_sql_plan_baselines

1

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

automatic capture of SQL plan baselines for repeatable statements

147559078

2436

optimizer_use_sql_plan_baselines

1

TRUE

TRUE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

use of SQL plan baselines for captured sql statements

2379667345

2457

parallel_min_time_threshold

2

AUTO

AUTO

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

threshold above which a plan is a candidate for parallelization (in seconds)

1842587524

2459

parallel_degree_limit

2

CPU

CPU

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

limit placed on degree of parallelism

3004872640

2460

parallel_force_local

1

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

force single instance execution

1406010451

2469

optimizer_use_invisible_indexes

1

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Usage of invisible indexes (TRUE/FALSE)

1348858726

2493

dst_upgrade_insert_conv

1

TRUE

TRUE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Enables/Disables internal conversions during DST upgrade

2379457992

2498

parallel_servers_target

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

instance target in terms of number of parallel servers

3701086916

2557

sec_protocol_error_trace_action

2

TRACE

TRACE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

TTC protocol error action

1358668447

2558

sec_protocol_error_further_action

2

CONTINUE

CONTINUE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

TTC protocol error continue action

3049131826

2559

sec_max_failed_login_attempts

3

3

3

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

maximum number of failed login attempts on a connection

121837060

2560

sec_return_server_release_banner

1

FALSE

FALSE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

whether the server retruns the complete version information

3794764196

2563

enable_ddl_logging

1

FALSE

FALSE

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

enable ddl logging

2442221836

2566

client_result_cache_size

6

0

0

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

client result cache max size in bytes

3890547889

2567

client_result_cache_lag

6

3000

3000

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

client result cache maximum lag in milliseconds

1078110587

2592

aq_tm_processes

3

1

1

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

number of AQ Time Managers to start

2948523121

2608

hs_autoregister

1

TRUE

TRUE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

enable automatic server DD updates in HS agent self-registration

3959246632

2609

xml_db_events

2

enable

enable

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

are XML DB events enabled

2688671432

2610

dg_broker_start

1

FALSE

FALSE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

start Data Guard broker (DMON process)

2843461333

2611

dg_broker_config_file1

2

/pvlne8/oracle/product/11204/dbs/dr1PVLNE8.dat

/pvlne8/oracle/product/11204/dbs/dr1PVLNE8.dat

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

data guard broker configuration file #1

2265440370

2612

dg_broker_config_file2

2

/pvlne8/oracle/product/11204/dbs/dr2PVLNE8.dat

/pvlne8/oracle/product/11204/dbs/dr2PVLNE8.dat

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

data guard broker configuration file #2

2561076650

2624

olap_page_pool_size

6

0

0

TRUE

TRUE

DEFERRED

TRUE

FALSE

FALSE

FALSE

FALSE

size of the olap page pool in bytes

3715775675

2721

asm_diskstring

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

disk set locations for discovery

2084877408

2723

asm_preferred_read_failure_groups

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

preferred read failure groups

1510746396

2734

asm_diskgroups

2

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

disk groups to mount automatically

3280069317

2735

asm_power_limit

3

1

1

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

number of parallel relocations for disk rebalancing

3074083193

2811

control_management_pack_access

2

DIAGNOSTIC+TUNING

DIAGNOSTIC+TUNING

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

declares which manageability packs are enabled

1240641681

2833

awr_snapshot_time_offset

3

0

0

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Setting for AWR Snapshot Time Offset

3285753433

2838

sqltune_category

2

DEFAULT

DEFAULT

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Category qualifier for applying hintsets

161860720

2874

diagnostic_dest

2

/pvlne8/log

/pvlne8/log

FALSE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

diagnostic base directory

3957361937

2898

tracefile_identifier

2

TRUE

TRUE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

trace file custom identifier

978134115

2899

_trace_files_public

1

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

FALSE

Create publicly accessible trace files

3324140323

2900

max_dump_file_size

2

20480

20480

FALSE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Maximum size (in bytes) of dump file

1271961010

2903

trace_enabled

1

TRUE

TRUE

TRUE

FALSE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

enable in memory tracing

1583875908

2914

cell_offloadgroup_name

2

TRUE

TRUE

IMMEDIATE

TRUE

FALSE

FALSE

FALSE

FALSE

Set the offload group name

2577808808

lots of things, too much to list here

select * from v$database;

DBID	1574613902
NAME	MYLNE8
CREATED	30-Nov-14
RESETLOGS_CHANGE#	1
RESETLOGS_TIME	30-Nov-14
PRIOR_RESETLOGS_CHANGE#	0
PRIOR_RESETLOGS_TIME
LOG_MODE	ARCHIVELOG
CHECKPOINT_CHANGE#	2473613392
ARCHIVE_CHANGE#	2472275490
CONTROLFILE_TYPE	CURRENT
CONTROLFILE_CREATED	30-Nov-14
CONTROLFILE_SEQUENCE#	931248
CONTROLFILE_CHANGE#	2475202794
CONTROLFILE_TIME	23-Feb-16
OPEN_RESETLOGS	NOT ALLOWED
VERSION_TIME	30-Nov-14
OPEN_MODE	READ WRITE
PROTECTION_MODE	MAXIMUM PERFORMANCE
PROTECTION_LEVEL	MAXIMUM PERFORMANCE
REMOTE_ARCHIVE	ENABLED
ACTIVATION#	1574608782
SWITCHOVER#	1574608782
DATABASE_ROLE	PRIMARY
ARCHIVELOG_CHANGE#	2474946120
ARCHIVELOG_COMPRESSION	DISABLED
SWITCHOVER_STATUS	NOT ALLOWED
DATAGUARD_BROKER	DISABLED
GUARD_STATUS	NONE
SUPPLEMENTAL_LOG_DATA_MIN	NO
SUPPLEMENTAL_LOG_DATA_PK	NO
SUPPLEMENTAL_LOG_DATA_UI	NO
FORCE_LOGGING	YES
PLATFORM_ID	13
PLATFORM_NAME	Linux x86 64-bit
RECOVERY_TARGET_INCARNATION#	1
LAST_OPEN_INCARNATION#	1
CURRENT_SCN	2475202974
FLASHBACK_ON	NO
SUPPLEMENTAL_LOG_DATA_FK	NO
SUPPLEMENTAL_LOG_DATA_ALL	NO
DB_UNIQUE_NAME	PVLNE8
STANDBY_BECAME_PRIMARY_SCN	0
FS_FAILOVER_STATUS	DISABLED
FS_FAILOVER_CURRENT_TARGET
FS_FAILOVER_THRESHOLD	0
FS_FAILOVER_OBSERVER_PRESENT
FS_FAILOVER_OBSERVER_HOST
CONTROLFILE_CONVERTED	NO
PRIMARY_DB_UNIQUE_NAME
SUPPLEMENTAL_LOG_DATA_PL	NO
MIN_REQUIRED_CAPTURE_CHANGE#

You need to be sys / system for this below, allow you to read the alertlogs.

select message_text from X$DBGALERTEXT where rownum <= 20;

Subscribe to: Posts (Atom)