About Me

My photo
I work for Fusion5 Australia . Connect with me on linked in here . I'm raising money for a good cause at the moment, follow donate to leukemia foundation

Monday, 29 February 2016

harsh but fair

Look at my role… 

Not too sure, hopefully stands for Separation of Duty…

image

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;