Tuesday, 23 February 2016

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;
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Extending JDE to generative AI