view tablespace list with used, free, total space and free space percentage

col "Tablespace" for a22
col "Used MB" for 99,999,999
col "Free MB" for 99,999,999
col "Total MB" for 99,999,999

SQL>
select df.tablespace_name "Tablespace",
totalusedspace "Used MB",
(df.totalspace - tu.totalusedspace) "Free MB",
df.totalspace "Total MB",
round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
"Pct. Free"
from
(select tablespace_name,
round(sum(bytes) / 1048576) TotalSpace
from dba_data_files
group by tablespace_name) df,
(select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
from dba_segments
group by tablespace_name) tu
where df.tablespace_name = tu.tablespace_name ;

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
AAAPP                       57,847         515      58,362          1
ADAPP                            1          59          60         98
AVAPP                            0          19          19        100
BNAPP                           21          31          52         60
BNLARGE                          1          26          27         96
CCAPP                            3         247         250         99
COAPP                           12           5          17         29
CULARGE                          0           6           6        100
EOAPP                           69           6          75          8
EOCFAPP                          3          17          20         85
EOECAPP                          5          20          25         80

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
EOECLRG                        536          31         567          5
EOEWAPP                          0           9           9        100
EOIUAPP                          0           3           3        100
EPAPP                           30           5          35         14
EPLARGE                        498          27         525          5
ERAPP                            4           9          13         69
FAAPP                           29         271         300         90
FGAPP                            8          27          35         77
FSAPP                            0           5           5        100
GIAPP                            0           8           8        100
GPAPP                       38,207       2,705      40,912          7

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
HPAPP                        2,444         126       2,570          5
HRAPP                       26,326       1,319      27,645          5
HRAPP1                           2          20          22         91
HRAPP2                           6          12          18         67
HRAPP3                           0           7           7        100
HRAPP4                           3          13          16         81
HRAPP5                           2          11          13         85
HRAPP6                           1          34          35         97
HRAPP7                          25          23          48         48
HRLARGE                        369          22         391          6
HRSAPP                          23          41          64         64

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
HRSLARGE                         6           2           8         25
HRSWORK                          0          15          15        100
HRWORK                           0          20          20        100
PAAPP                            3          56          59         95
PIAPP                            0           9           9        100
PSDEFAULT                    1,900         148       2,048          7
PSIMAGE                      4,365         223       4,588          5
PSIMAGE2                       928          52         980          5
PSIMGR                           2           2           4         50
PSINDEX                     40,952       1,993      42,945          5
PSUNDOTS1                   27,986       4,777      32,763         15

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
PSUNDOTS2                   12,407      20,356      32,763         62
PTAMSG                         344       3,619       3,963         91
PTAPP                           15          35          50         70
PTAPPE                           2           3           5         60
PTAUDIT                         15           2          17         12
PTLOCK                           0           3           3        100
PTPRC                           29           3          32          9
PTPRJWK                          0           8           8        100
PTRPTS                         112          11         123          9
PTTBL                        2,982         152       3,134          5
PTTLRG                         454          68         522         13

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
PTTREE                           9           2          11         18
PTWORK                           1          11          12         92
PVAPP                            0           4           4        100
PY0LRG                           0         129         129        100
PYAPP                           12          98         110         89
SAAPP                            7         293         300         98
SRAPP                            1         150         151         99
STAPP                            1          31          32         97
STWORK                           0          17          17        100
SYSAUX                       1,572       2,158       3,730         58
SYSTEM                      14,346      33,782      48,128         70

Tablespace                 Used MB     Free MB    Total MB  Pct. Free
---------------------- ----------- ----------- ----------- ----------
TLAPP                            7          93         100         93
TLLARGE                          0          40          40        100
USERS                            0           5           5        100

69 rows selected.



View details of specific tablespace:
=======================
set linesize 124
col file_name format a75
col AUTOEXTENSIBLE format a18
SELECT FILE_NAME, BYTES/(1024*1024), MAXBYTES/(1024*1024), AUTOEXTENSIBLE from DBA_DATA_FILES
WHERE TABLESPACE_NAME='AAAPP';


FILE_NAME                                                                   BYTES/(1024*1024) MAXBYTES/(1024*1024)
--------------------------------------------------------------------------- ----------------- --------------------
AUTOEXTENSIBLE
------------------
+ORA_DB/hrprd/datafile/aaapp.625.852581469                                              32762           32767.9844
YES

+ORA_DB/hrprd/datafile/aaapp.741.947934975                                              10240                 7168
YES

+ORA_DB/hrprd/datafile/aaapp.851.948719703                                               5120                 5120
YES

Claim empty space of tablespace to reuse

PSIMAGE has 83% free space and need to reclaim it.

SQL> select df.tablespace_name "Tablespace",
 totalusedspace "Used MB",
 (df.totalspace - tu.totalusedspace) "Free MB",
 df.totalspace "Total MB",
 round(100 * ( (df.totalspace - tu.totalusedspace)/ df.totalspace))
 "Pct. Free"
 from
 (select tablespace_name,
 round(sum(bytes) / 1048576) TotalSpace
 from dba_data_files
 group by tablespace_name) df,
 (select round(sum(bytes)/(1024*1024)) totalusedspace, tablespace_name
 from dba_segments
 group by tablespace_name) tu
 where df.tablespace_name = tu.tablespace_name AND
df.tablespace_name='PSIMAGE';


Tablespace                 Used MB     Free MB    Total MB  Pct. Free
----------------------             -----------         -----------       -----------      ----------
PSIMAGE                   4,978           23,530       28,508      83


SQL>
SQL> SELECT * from dba_directories;

OWNER DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS PRD_DIR
/backup1/expimp/hrprd

create directory DUATBK_DIR as '/backup/dbbackup';
grant read, write on directory DUATBK_DIR to system;

TAKE FULL BACKUP:-
expdp system/manager full=y directory=DUATBK_DIR dumpfile='DUAT27MAY2017.dmp' logfile='DUAT27MAY2017.log';

TAKE PSIMAGE TABLESPACE BACKUP:-
expdp system/manager DIRECTORY=DUATBK_DIR DUMPFILE=DUAT27MAY2017TBLPSIMAGE.dmp LOGFILE=DUAT27MAY2017TBLPSIMAGE_LOG.log TABLESPACES= PSIMAGE;


SQL> select file_name from dba_data_files where tablespace_name='PSIMAGE';

FILE_NAME
--------------------------------------------------------------------------------
/backup1/oradata/duat/psimage.dbf


DROP TABLESPACE PSIMAGE INCLUDING CONTENTS and datafile;

SQL> DROP TABLESPACE PSIMAGE INCLUDING CONTENTS;

Tablespace dropped.


Now, PSIMAGE tablespace must not available in database.

SELECT tablespace_name FROM dba_tablespaces where tablespace_name='PSIMAGE';
SELECT file_name FROM dba_data_files where tablespace_name='PSIMAGE';


Create tablespace again:
----------------------------------------
CREATE TABLESPACE PSIMAGE DATAFILE '/backup1/oradata/duat/psimage.dbf' SIZE 1813M EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;


Alter tablespace datafile:
----------------------------------------
ALTER DATABASE DATAFILE '/backup1/oradata/duat/psimage.dbf' AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;


Import data from backup using impdp:
--------------------------------------------------------------
impdp system/manager DIRECTORY=DUATBK_DIR DUMPFILE=DUAT27MAY2017TBLPSIMAGE.dmp LOGFILE=DUAT27MAY2017TBLPSIMAGE_LOG-IMP.log TABLESPACES= PSIMAGE;

Check now, database tablespace PSIMAGE size should be according to the original data only.

Temporary tablespace and files management in oracle

CREATE TEMP TABLESPACE:
-----------------------
CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE '/u01/oradata/tst/temp01.dbf' size 1024M extent management local uniform size 1M;
CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE '+ORA_DB' SIZE 1G EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K;


ADD TEMP FILES IN TEMPORARY TABLESPACE:
---------------------------------------
ALTER TABLESPACE TEMP01 ADD tempfile '/u01/oradata/tst/temp02.dbf' SIZE 1G AUTOEXTEND ON NEXT 1G MAXSIZE 20G;
ALTER TABLESPACE TEMP01 ADD tempfile '+ORA_DB' SIZE 1G AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED;


DROP TEMP TABLESPACE:
---------------------
DROP TABLESPACE TEMP01 including contents and datafiles;


LIST ALL TEMPFILES OF TEMP TABLESPACE:
-------------------------------------

SQL> col file_name for a45
select tablespace_name,file_name,bytes/1024/1024,maxbytes/1024/1024,autoextensible from dba_temp_files order by file_name;

TABLESPACE_NAME FILE_NAME BYTES/1024/1024 MAXBYTES/1024/1024 AUTOEXTENSIBLE
---------------- ---------------------------------- --------------- ------------------ ------------------
TEMP01 /u01/oradata/tst/temp01.dbf 300 0 NO
TEMP01 /u01/oradata/tst/temp02.dbf 20 32767 YES



SET DEFAULT TEMP TABLESPACE:
---------------------------
alter database default temporary tablespace TEMP;

SET DEFAULT TEMP TABLESPACE FOR USER:
-------------------------------------
ALTER USER SYSADM TEMPORARY TABLESPACE PSTEMP1;
ALTER USER PEOPLE TEMPORARY TABLESPACE PSTEMP1;

SQL queries which are using CPU resources

select
ss.username,
ss.serial#,
se.SID,
VALUE/100 cpu_usage_seconds
from
v$session ss,
v$sesstat se,
v$statname sn
where
se.STATISTIC# = sn.STATISTIC#
and
NAME like '%CPU used by this session%'
and
se.SID = ss.SID
and
ss.status='ACTIVE'
and
ss.username is not null
order by VALUE desc;

Query to count hourly log switch in oracle

SQL> set lines 120;
set pages 999;
SQL> SQL>
SQL> SELECT
2 to_char(first_time,'YYYY-MON-DD') day,
3 to_char(sum(decode(to_char(first_time,'HH24'),'00',1,0)),'99') "00",
4 to_char(sum(decode(to_char(first_time,'HH24'),'01',1,0)),'99') "01",
5 to_char(sum(decode(to_char(first_time,'HH24'),'02',1,0)),'99') "02",
6 to_char(sum(decode(to_char(first_time,'HH24'),'03',1,0)),'99') "03",
7 to_char(sum(decode(to_char(first_time,'HH24'),'04',1,0)),'99') "04",
8 to_char(sum(decode(to_char(first_time,'HH24'),'05',1,0)),'99') "05",
9 to_char(sum(decode(to_char(first_time,'HH24'),'06',1,0)),'99') "06",
10 to_char(sum(decode(to_char(first_time,'HH24'),'07',1,0)),'99') "07",
11 to_char(sum(decode(to_char(first_time,'HH24'),'08',1,0)),'99') "0",
12 to_char(sum(decode(to_char(first_time,'HH24'),'09',1,0)),'99') "09",
13 to_char(sum(decode(to_char(first_time,'HH24'),'10',1,0)),'99') "10",
14 to_char(sum(decode(to_char(first_time,'HH24'),'11',1,0)),'99') "11",
15 to_char(sum(decode(to_char(first_time,'HH24'),'12',1,0)),'99') "12",
16 to_char(sum(decode(to_char(first_time,'HH24'),'13',1,0)),'99') "13",
17 to_char(sum(decode(to_char(first_time,'HH24'),'14',1,0)),'99') "14",
18 to_char(sum(decode(to_char(first_time,'HH24'),'15',1,0)),'99') "15",
19 to_char(sum(decode(to_char(first_time,'HH24'),'16',1,0)),'99') "16",
20 to_char(sum(decode(to_char(first_time,'HH24'),'17',1,0)),'99') "17",
21 to_char(sum(decode(to_char(first_time,'HH24'),'18',1,0)),'99') "18",
22 to_char(sum(decode(to_char(first_time,'HH24'),'19',1,0)),'99') "19",
23 to_char(sum(decode(to_char(first_time,'HH24'),'20',1,0)),'99') "20",
24 to_char(sum(decode(to_char(first_time,'HH24'),'21',1,0)),'99') "21",
25 to_char(sum(decode(to_char(first_time,'HH24'),'22',1,0)),'99') "22",
26 to_char(sum(decode(to_char(first_time,'HH24'),'23',1,0)),'99') "23"
27 from
28 v$log_history
29 GROUP by
30 to_char(first_time,'YYYY-MON-DD') ;

DAY 00 01 02 03 04 05 06 07 0 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23
--------------- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- --- ---
2017-JUL-06 1 0 0 0 2 0 1 2 0 7 36 45 37 43 37 44 50 37 22 9 2 1 1 0
2017-JUL-07 1 0 0 0 0 0 1 1 1 4 22 29 24 42 33 40 49 67 28 14 4 2 0 0
2017-JUL-08 0 0 0 1 0 0 1 0 0 0 1 6 7 5 3 4 3 1 3 0 0 1 1 0
2017-JUL-05 0 0 0 0 0 1 1 0 0 0 0 60 57 56 37 48 71 69 40 19 4 0 0 0
2017-JUL-13 1 1 0 0 0 0 0 1 0 5 18 23 28 29 20 27 47 32 20 8 0 1 1 0
2017-JUL-09 1 0 0 0 0 0 1 1 0 0 0 0 1 2 0 2 0 0 2 1 0 0 0 0
2017-JUL-11 2 0 0 0 0 0 1 0 2 4 22 33 27 27 22 34 40 44 26 11 3 0 0 0
2017-JUL-10 1 0 0 0 0 0 1 0 0 2 18 20 32 24 25 29 41 45 26 12 3 1 1 0
2017-JUL-12 2 0 0 0 0 0 1 0 1 3 17 30 24 26 21 34 44 34 25 16 3 1 0 0
2017-JUL-14 0 0 0 0 0 0 2 0 0 3 16 15 20 16 16 22 28 28 16 5 1 0 2 0
2017-JUL-16 1 0 0 0 0 1 0 0 1 1 0 0 1 0 1 0 1 0 0 1 0 0 0 0
2017-JUL-15 0 0 0 0 0 0 1 0 0 3 14 26 23 24 13 20 28 22 16 3 3 0 0 0
2017-JUL-17 2 0 0 0 0 0 1 0 0 2 8 28 17 26 35 0 0 0 0 0 0 0 0 0
2017-JUL-04 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 21 6 2 2 0

14 rows selected.


col day format a15;
col hour format a4;
col total format 999;

select
to_char(first_time,'yyyy-mm-dd') day,
to_char(first_time,'hh24') hour,
count(*) total
from v$log_history
group by to_char(first_time,'yyyy-mm-dd'),to_char(first_time,'hh24')
order by to_char(first_time,'yyyy-mm-dd'),to_char(first_time,'hh24') asc;

DAY HOUR TOTAL
--------------- ---- -----
2017-07-14 15 22
2017-07-14 16 28
2017-07-14 17 28
2017-07-14 18 16
2017-07-14 19 5
2017-07-14 20 1
2017-07-14 22 2
2017-07-15 06 1
2017-07-15 09 3
2017-07-15 10 14
2017-07-15 11 26

DAY HOUR TOTAL
--------------- ---- -----
2017-07-15 12 23
2017-07-15 13 24
2017-07-15 14 13
2017-07-15 15 20
2017-07-15 16 28
2017-07-15 17 22
2017-07-15 18 16
2017-07-15 19 3
2017-07-15 20 3
2017-07-16 00 1
2017-07-16 05 1

DAY HOUR TOTAL
--------------- ---- -----
2017-07-16 08 1
2017-07-16 09 1
2017-07-16 12 1
2017-07-16 14 1
2017-07-16 16 1
2017-07-16 19 1
2017-07-17 00 2
2017-07-17 06 1
2017-07-17 09 2
2017-07-17 10 8
2017-07-17 11 28

DAY HOUR TOTAL
--------------- ---- -----
2017-07-17 12 17
2017-07-17 13 26
2017-07-17 14 35

179 rows selected.

How to check oracle users, alter user password, unlock user

HOW TO CHECK ORACLE USERS AND THEIR STATUS:
-------------------------------------------

SQL> SELECT USERNAME,ACCOUNT_STATUS,EXPIRY_DATE from dba_users;

USERNAME ACCOUNT_STATUS EXPIRY_DA
------------------------------ -------------------------------- ---------
OUTLN OPEN 15-MAR-14
PEOPLE OPEN 11-JUL-17
PS OPEN 05-JUN-17
SYS OPEN 15-MAR-14
SYSTEM OPEN 05-JUN-17
SYSADM EXPIRED 12-JUN-17
APPQOSSYS EXPIRED & LOCKED 16-SEP-13
DIP EXPIRED & LOCKED 16-SEP-13
DBSNMP EXPIRED & LOCKED 16-SEP-13
ORACLE_OCM EXPIRED & LOCKED 16-SEP-13

10 rows selected.

CHANGE USER PASSWORD:
---------------------
ALTER USER myuser IDENTIFIED BY new_password;

ALTER USER myuser ACCOUNT LOCK;
ALTER USER myuser ACCOUNT UNLOCK;
ALTER USER myuser PASSWORD EXPIRE;

how to view datafiles available in tablespace

FETCH ALL DATAFILES WITH TABLESPACE NAME:
-----------------------------------------
col tablespace_name format a16;
col file_name format a36;
SELECT TABLESPACE_NAME, FILE_NAME, BYTES FROM DBA_DATA_FILES;


FETCH DATAFILES AVAILABLE IN TABLESPACE:
----------------------------------------
select file_name from dba_data_files where tablespace_name='PSIMAGE';

FILE_NAME
--------------------------------------------------------------------------------
+ORA_DB/hrprd/datafile/psimage.221.81503
+ORA_DB/hrprd/datafile/psimage.450.97645
+ORA_DB/hrprd/datafile/psimage.589.94091


FETCH DATAFILE SPACE, MAXIMUM SPACE, AUTOEXTEND OF DATAFILE:
-----------------------------------------------------------
set linesize 124
col file_name format a60
col AUTOEXTENSIBLE format a18
SELECT FILE_NAME, BYTES/(1024*1024), MAXBYTES/(1024*1024), AUTOEXTENSIBLE from DBA_DATA_FILES
WHERE TABLESPACE_NAME='PSIMAGE';

FILE_NAME BYTES/(1024*1024) MAXBYTES/(1024*1024) AUTOEXTENSIBLE
--------------------------------- ----------------- -------------------- ------------------
/u01/oradata/hrdemo/psimage.dbf 1813 32767.9844 YES

how to export database using expdp export

To export oracle database using expdp follow the below steps:

1. Create Directory Path.

SQL> create directory BACKUP_DIR as '/backup/dailybackup';
Directory created.

SQL> grant read, write on directory BACKUP_DIR to system;
Grant succeeded.


2. Ensure the directory by following query.

SQL>
SELECT directory_path from dba_directories;
SELECT * from dba_directories;

3. exit from sql prompt.

SQL> exit;

4. To backup database in full export mode issue to following data pump command:

EXPORT FULL BACKUP
==================
[oracle@oracle ~]$ expdp system/manager full=y directory=BACKUP_DIR dumpfile='DB09MAR2017.dmp' logfile='DB09MAR2017.log';


EXPORT BACKUP of TABLESPACE
===========================
expdp hr/hr@ORCL DIRECTORY=exp_tblsp DUMPFILE=tablespace.dmp LOGFILE=tblsp_log.log TABLESPACES=USERS,EXAMPLE;
expdp system/manager DIRECTORY=BACKUP_DIR DUMPFILE=tablespace.dmp LOGFILE=tblsp_log.log TABLESPACES= PSIMAGE;

how to add datafile to tablespace

ADDING DATAFILE TO TABLESPACE IN Filesystem DB:
==========================================
ALTER TABLESPACE users ADD DATAFILE '/u01/oracle/oradata/users_02.dbf' size 100m;


ADDING DATAFILE TO TABLESPACE IN ASM RAC:
========================================
alter tablespace PSIMAGE add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE 5G;

alter tablespace PSIMAGE add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;

alter tablespace AAAPP add datafile '+ORA_DB' size 1G AUTOEXTEND ON NEXT 5M MAXSIZE 5G ;

alter tablespace GPAPP add datafile '+ORA_DB' size 1813M AUTOEXTEND ON NEXT 5M MAXSIZE 5G ;


RESIZE DATAFILE IN TABLESPACE (ASM RAC):
=====================================
alter database datafile '+ORA_DB/hrprd/datafile/gpapp.552.9454654566' resize 5G;

Check Space Available On Disk Group

Check Space Available On Disk Group:
========================

SQL> select name , free_mb/1024 from v$asm_diskgroup;

NAME                           FREE_MB/1024
------------------------------        --------------------------
OCR_DATA                    9.21679688
ORA_ARCH                   190.402344
ORA_DB                        34.3730469
ORA_FRA                      656.569336
ORA_DB1                      499.897461

DELETE Archive Logs using RMAN

In DC and DR environment where RAC and Data Guard implemented. Delete old / applied archive logs files to create space on archive log mount point.

Steps to delete archive files. 
1. Check archive log sequence on Primary Database.

On DC Machine:-
===========

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            +ORA_ARCH
Oldest online log sequence     28006
Next log sequence to archive   28008
Current log sequence           28008



2. Check applied archive log sequence on DR database. 

ON DR Machine:
===========
SQL> select thread#,max(sequence#) from gv$archived_log where applied='YES' group by thread#;
   THREAD# MAX(SEQUENCE#)
---------- --------------
         1          28006
         2          23353

3. Connect RMAN on DC Database Machine.

rman target /

4. Here, We are deleting archive log till 1 days back from current date time. This command will release space on DC database.

delete noprompt archivelog until time 'SYSDATE - 1';

5. Repeat the above step on DR database as well to release space.

rman target /

delete noprompt archivelog until time 'SYSDATE - 1';

OUI-10020: A write lock cannot be obtained

OUI-10020:The target area /u01/app/oraInventory is being used by another session. A write lock cannot be obtained.

To Overcome the Problem:
====================
1. Go to the oraInventory directory.
cd /u01/app/oraInventory/locks

2. Go to the lock directory and delete / rename the read lock under the directory.
rm /oracle/10gR2/oraInventory/locks/reader0.lock
rm /oracle/10gR2/oraInventory/locks/reader1.lock
rm /oracle/10gR2/oraInventory/locks/reader2.lock
rm /oracle/10gR2/oraInventory/locks/reader3.lock

3. Now run your Oracle Universal Installer.

Oracle 11g Hidden Database Parameters

Oracle 11g Hidden Database Parameters
=============================

[oracle@dev ~]$ sqlplus  / as sysdba;

SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 16 13:17:48 2017

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL> SET PAGESIZE 60
SET LINESIZE 300
COLUMN ksppinm FORMAT A50
COLUMN ksppstvl FORMAT A50
SELECT
  ksppinm,
  ksppstvl
FROM
  x$ksppi a,
  x$ksppsv b
WHERE a.indx=b.indx AND substr(ksppinm,1,1) = '_'
ORDER BY ksppinm;
/

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_4030_dump_bitvec                                  4095
_4031_dump_bitvec                                  67194879
_4031_dump_interval                                300
_4031_max_dumps                                    100
_4031_sga_dump_interval                            3600
_4031_sga_max_dumps                                10
_NUMA_instance_mapping                             Not specified
_NUMA_pool_size                                    Not specified
_PX_use_large_pool                                 FALSE
__db_cache_size                                    1526726656
__dg_broker_service_names
__java_pool_size                                   16777216
__large_pool_size                                  100663296
__oracle_base                                      /u01/app/oracle
__pga_aggregate_target                             2248146944
__sga_target                                       4194304000
__shared_io_pool_size                              0
__shared_pool_size                                 2499805184
__streams_pool_size                                0
_abort_recovery_on_join                            FALSE
_accept_versions
_active_instance_count
_active_session_idle_limit                         5
_active_session_legacy_behavior                    FALSE
_active_standby_fast_reconfiguration               TRUE
_adaptive_direct_read                              TRUE
_adaptive_direct_write                             TRUE
_adaptive_fetch_enabled                            TRUE
_adaptive_log_file_sync_high_switch_freq_threshold 3
_adaptive_log_file_sync_poll_aggressiveness        0
_adaptive_log_file_sync_sched_delay_window         60
_adaptive_log_file_sync_use_polling_threshold      200
_adaptive_log_file_sync_use_postwait_threshold     50
_add_col_optim_enabled                             TRUE
_add_stale_mv_to_dependency_list                   TRUE
_add_trim_for_nlssort                              TRUE
_addm_auto_enable                                  TRUE
_addm_skiprules
_addm_version_check                                TRUE
_adjust_literal_replacement                        FALSE
_adr_migrate_runonce                               TRUE
_affinity_on                                       TRUE
_aged_out_cursor_cache_time                        300
_aggregation_optimization_settings                 0
_aiowait_timeouts                                  100
_alert_expiration                                  604800
_alert_message_cleanup                             1
_alert_message_purge                               1
_alert_post_background                             1
_all_shared_dblinks
_allocate_creation_order                           FALSE
_allocation_update_interval                        3
_allow_cell_smart_scan_attr                        TRUE
_allow_commutativity                               TRUE
_allow_compatibility_adv_w_grp                     FALSE
_allow_drop_snapshot_standby_grsp                  FALSE
_allow_drop_ts_with_grp                            FALSE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_allow_error_simulation                            FALSE
_allow_level_without_connect_by                    FALSE
_allow_read_only_corruption                        FALSE
_allow_resetlogs_corruption                        FALSE
_allow_terminal_recovery_corruption                FALSE
_alternate_iot_leaf_block_split_points             TRUE
_always_anti_join                                  CHOOSE
_always_semi_join                                  CHOOSE
_always_star_transformation                        FALSE
_and_pruning_enabled                               TRUE
_app_ctx_vers                                      FALSE
_appqos_qt                                         10
_aq_max_scan_delay                                 1500
_aq_tm_deqcountinterval                            0
_aq_tm_scanlimit                                   0
_aq_tm_statistics_duration                         0
_arch_comp_dbg_scan                                0
_arch_comp_dec_block_check_dump                    1
_arch_compress_checksums                           FALSE
_arch_compression                                  TRUE
_arch_io_slaves                                    0
_arch_sim_mode                                     0
_array_update_vector_read_enabled                  FALSE
_ash_compression_enable                            TRUE
_ash_disk_filter_ratio                             10
_ash_disk_write_enable                             TRUE
_ash_dummy_test_param                              0
_ash_eflush_trigger                                66
_ash_enable                                        TRUE
_ash_min_mmnl_dump                                 90
_ash_sample_all                                    FALSE
_ash_sampling_interval                             1000
_ash_size                                          1048618
_asm_acd_chunks                                    1
_asm_admin_with_sysdba                             FALSE
_asm_allow_appliance_dropdisk_noforce              FALSE
_asm_allow_lvm_resilvering                         TRUE
_asm_allow_only_raw_disks                          TRUE
_asm_allow_system_alias_rename                     FALSE
_asm_appliance_config_file
_asm_ausize                                        1048576
_asm_automatic_rezone                              TRUE
_asm_avoid_pst_scans                               TRUE
_asm_blksize                                       4096
_asm_check_for_misbehaving_cf_clients              FALSE
_asm_compatibility                                 10.1
_asm_dba_batch                                     500000
_asm_dba_threshold                                 0
_asm_dbmsdg_nohdrchk                               FALSE
_asm_diag_dead_clients                             FALSE
_asm_direct_con_expire_time                        120
_asm_disable_amdu_dump                             FALSE
_asm_disable_async_msgs                            FALSE
_asm_disable_multiple_instance_check               FALSE
_asm_disable_profilediscovery                      FALSE
_asm_disable_smr_creation                          FALSE
_asm_disk_repair_time                              14400

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_asm_emulate_nfs_disk                              FALSE
_asm_emulmax                                       10000
_asm_emultimeout                                   0
_asm_evenread                                      0
_asm_evenread_alpha                                0
_asm_evenread_alpha2                               0
_asm_evenread_faststart                            0
_asm_fail_random_rx                                FALSE
_asm_fob_tac_frequency                             9
_asm_force_quiesce                                 FALSE
_asm_hbeatiowait                                   15
_asm_hbeatwaitquantum                              2
_asm_imbalance_tolerance                           3
_asm_instlock_quota                                0
_asm_iostat_latch_count                            31
_asm_kfdpevent                                     0
_asm_kfioevent                                     0
_asm_kill_unresponsive_clients                     TRUE
_asm_libraries                                     ufs
_asm_log_scale_rebalance                           FALSE
_asm_lsod_bucket_size                              13
_asm_max_cod_strides                               5
_asm_max_redo_buffer_size                          2097152
_asm_maxio                                         1048576
_asm_partner_target_disk_part                      8
_asm_partner_target_fg_rel                         4
_asm_primary_load                                  1
_asm_primary_load_cycles                           TRUE
_asm_random_zone                                   FALSE
_asm_rebalance_plan_size                           120
_asm_rebalance_space_errors                        4
_asm_repairquantum                                 60
_asm_reserve_slaves                                TRUE
_asm_root_directory                                ASM
_asm_runtime_capability_volume_support             FALSE
_asm_secondary_load                                10000
_asm_secondary_load_cycles                         FALSE
_asm_serialize_volume_rebalance                    FALSE
_asm_shadow_cycle                                  3
_asm_skip_rename_check                             FALSE
_asm_skip_resize_check                             FALSE
_asm_storagemaysplit                               FALSE
_asm_stripesize                                    131072
_asm_stripewidth                                   8
_asm_sync_rebalance                                FALSE
_asm_usd_batch                                     64
_asm_wait_time                                     18
_asmlib_test                                       0
_asmsid                                            asm
_assm_default                                      TRUE
_assm_force_fetchmeta                              FALSE
_assm_high_gsp_threshold                           11024
_assm_low_gsp_threshold                            10000
_async_recovery_claims                             TRUE
_async_recovery_reads                              TRUE
_async_ts_threshold                                1
_auto_assign_cg_for_sessions                       FALSE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_auto_bmr                                          enabled
_auto_bmr_bg_time                                  3600
_auto_bmr_fc_time                                  60
_auto_bmr_pub_timeout                              10
_auto_bmr_req_timeout                              60
_auto_bmr_sess_threshold                           30
_auto_bmr_sys_threshold                            100
_auto_manage_enable_offline_check                  TRUE
_auto_manage_exadata_disks                         TRUE
_auto_manage_infreq_tout                           0
_auto_manage_ioctl_bufsz                           8192
_auto_manage_max_online_tries                      3
_auto_manage_num_pipe_msgs                         1000
_auto_manage_num_tries                             2
_auto_manage_online_tries_expire_time              86400
_automatic_maintenance_test                        0
_automemory_broker_interval                        3
_autotask_max_window                               480
_autotask_min_window                               15
_autotune_gtx_idle_time                            600
_autotune_gtx_interval                             5
_autotune_gtx_threshold                            60
_available_core_count                              0
_avoid_prepare                                     TRUE
_awr_corrupt_mode                                  FALSE
_awr_disabled_flush_tables
_awr_flush_threshold_metrics                       TRUE
_awr_flush_workload_metrics                        FALSE
_awr_mmon_cpuusage                                 TRUE
_awr_mmon_deep_purge_extent                        7
_awr_mmon_deep_purge_interval                      7
_awr_mmon_deep_purge_numrows                       5000
_awr_restrict_mode                                 FALSE
_awr_sql_child_limit                               200
_b_tree_bitmap_plans                               TRUE
_backup_align_write_io                             TRUE
_backup_automatic_retry                            10
_backup_disk_bufcnt                                0
_backup_disk_bufsz                                 0
_backup_disk_io_slaves                             0
_backup_dynamic_buffers                            TRUE
_backup_encrypt_opt_mode                           4294967294
_backup_file_bufcnt                                0
_backup_file_bufsz                                 0
_backup_io_pool_size                               1048576
_backup_kgc_blksiz                                 9
_backup_kgc_bufsz                                  0
_backup_kgc_memlevel                               8
_backup_kgc_niters                                 0
_backup_kgc_perflevel                              1
_backup_kgc_scheme                                 ZLIB
_backup_kgc_type                                   0
_backup_kgc_windowbits                             15
_backup_ksfq_bufcnt                                0
_backup_ksfq_bufcnt_max                            64
_backup_ksfq_bufsz                                 0
_backup_lzo_size                                   262144

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_backup_max_gap_size                               4294967294
_backup_seq_bufcnt                                 0
_backup_seq_bufsz                                  0
_bct_bitmaps_per_file                              8
_bct_buffer_allocation_max                         104857600
_bct_buffer_allocation_min_extents                 1
_bct_buffer_allocation_size                        2097152
_bct_chunk_size                                    0
_bct_crash_reserve_size                            262144
_bct_file_block_size                               0
_bct_file_extent_size                              0
_bct_fixtab_file
_bct_health_check_interval                         60
_bct_initial_private_dba_buffer_size               0
_bct_public_dba_buffer_size                        0
_bitmap_or_improvement_enabled                     TRUE
_block_sample_readahead_prob_threshold             10
_blocking_sess_graph_cache_size
_blocks_per_cache_server                           32
_bloom_filter_debug                                0
_bloom_filter_enabled                              TRUE
_bloom_folding_density                             16
_bloom_folding_enabled                             TRUE
_bloom_folding_min                                 131072
_bloom_max_size                                    268435456
_bloom_minmax_enabled                              TRUE
_bloom_predicate_enabled                           TRUE
_bloom_predicate_pushdown_to_storage               TRUE
_bloom_pruning_enabled                             TRUE
_bloom_pushing_max                                 512
_bloom_pushing_total_max                           262144
_bloom_vector_elements                             0
_bmr_prefered_standby
_branch_tagging                                    TRUE
_broadcast_scn_wait_timeout                        10
_bsln_adaptive_thresholds_enabled                  TRUE
_bt_mmv_query_rewrite_enabled                      TRUE
_buffer_busy_wait_timeout                          100
_buffered_message_spill_age                        300
_buffered_publisher_flow_control_threshold         0
_bufq_stop_flow_control                            FALSE
_build_deferred_mv_skipping_mvlog_update           TRUE
_bump_highwater_mark_count                         0
_bwr_for_flushed_pi                                TRUE
_bypass_srl_for_so_eor                             FALSE
_bypass_xplatform_error                            FALSE
_cache_stats_monitor                               FALSE
_capture_buffer_size                               65536
_capture_publisher_flow_control_threshold          0
_case_sensitive_logon                              TRUE
_causal_standby_wait_timeout                       20
_cdc_subscription_owner
_cdmp_diagnostic_level                             2
_cell_fast_file_create                             TRUE
_cell_fast_file_restore                            TRUE
_cell_file_format_chunk_size                       0
_cell_index_scan_enabled                           TRUE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_cell_offload_capabilities_enabled                 1
_cell_offload_hybridcolumnar                       TRUE
_cell_offload_predicate_reordering_enabled         FALSE
_cell_offload_timezone                             TRUE
_cell_offload_virtual_columns                      TRUE
_cell_range_scan_enabled                           TRUE
_cell_storidx_mode                                 EVA
_cgs_allgroup_poll_time                            20000
_cgs_dball_group_registration                      local
_cgs_dbgroup_poll_time                             600
_cgs_health_check_in_reconfig                      TRUE
_cgs_node_kill_escalation                          TRUE
_cgs_node_kill_escalation_wait                     0
_cgs_reconfig_extra_wait                           3
_cgs_reconfig_timeout                              0
_cgs_send_timeout                                  300
_cgs_tickets                                       1000
_cgs_zombie_member_kill_wait                       20
_change_vector_buffers                             1
_check_block_after_checksum                        TRUE
_check_block_new_invariant_for_flashback           FALSE
_check_column_length                               TRUE
_check_ts_threshold                                0
_cleanup_rollback_entries                          100
_cleanup_timeout                                   150
_cleanup_timeout_flags                             2
_clear_buffer_before_reuse                         FALSE
_client_ntfn_cleanup_interval                      2400
_client_ntfn_pinginterval                          75
_client_ntfn_pingretries                           6
_client_ntfn_pingtimeout                           30000
_client_result_cache_bypass                        FALSE
_client_tstz_error_check                           TRUE
_close_cached_open_cursors                         FALSE
_close_deq_by_cond_curs                            FALSE
_cluster_library                                   clss
_clusterwide_global_transactions                   TRUE
_collapse_wait_history                             FALSE
_collect_undo_stats                                TRUE
_column_compression_factor                         0
_column_elimination_off                            FALSE
_column_tracking_level                             1
_compilation_call_heap_extent_size                 16384
_complex_view_merging                              TRUE
_compression_above_cache                           0
_compression_advisor                               0
_compression_chain                                 90
_compression_compatibility                         11.2.0.0.0
_connect_by_use_union_all                          TRUE
_connection_broker_host
_controlfile_autobackup_delay                      300
_controlfile_backup_copy_check                     TRUE
_controlfile_block_size                            0
_controlfile_enqueue_dump                          FALSE
_controlfile_enqueue_holding_time                  120
_controlfile_enqueue_holding_time_tracking_size    10
_controlfile_enqueue_timeout                       900

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_controlfile_section_init_size
_controlfile_section_max_expand
_controlfile_update_check                          OFF
_convert_set_to_join                               FALSE
_coord_message_buffer                              0
_corrupted_rollback_segments
_cost_equality_semi_join                           TRUE
_cp_num_hash_latches                               1
_cpu_to_io                                         0
_cr_grant_global_role                              TRUE
_cr_grant_local_role                               AUTO
_cr_grant_only                                     FALSE
_cr_server_log_flush                               TRUE
_cr_trc_buf_size                                   8192
_create_table_in_any_cluster                       FALSE
_cursor_bind_capture_area_size                     400
_cursor_bind_capture_interval                      900
_cursor_cache_time                                 900
_cursor_db_buffers_pinned                          719
_cursor_features_enabled                           2
_cursor_obsolete_threshold                         100
_cursor_plan_enabled                               TRUE
_cursor_plan_hash_version                          1
_cursor_plan_unparse_enabled                       TRUE
_cursor_runtimeheap_memlimit                       5242880
_cursor_stats_enabled                              TRUE
_cvw_enable_weak_checking                          TRUE
_datafile_cow                                      FALSE
_datafile_write_errors_crash_instance              TRUE
_db_16k_flash_cache_file
_db_16k_flash_cache_size                           0
_db_2k_flash_cache_file
_db_2k_flash_cache_size                            0
_db_32k_flash_cache_file
_db_32k_flash_cache_size                           0
_db_4k_flash_cache_file
_db_4k_flash_cache_size                            0
_db_8k_flash_cache_file
_db_8k_flash_cache_size                            0
_db_aging_cool_count                               1
_db_aging_freeze_cr                                FALSE
_db_aging_hot_criteria                             2
_db_aging_stay_count                               0
_db_aging_touch_time                               3
_db_always_check_system_ts                         TRUE
_db_block_adjcheck                                 TRUE
_db_block_adjchk_level                             0
_db_block_align_direct_read                        TRUE
_db_block_bad_write_check                          FALSE
_db_block_buffers                                  360693
_db_block_cache_clone                              FALSE
_db_block_cache_history                            0
_db_block_cache_history_level                      2
_db_block_cache_num_umap                           0
_db_block_cache_protect                            FALSE
_db_block_cache_protect_internal                   0
_db_block_check_for_debug                          FALSE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_db_block_check_objtyp                             TRUE
_db_block_chunkify_ncmbr                           FALSE
_db_block_corruption_recovery_threshold            5
_db_block_do_full_mbreads                          FALSE
_db_block_hash_buckets                             1048576
_db_block_hash_latches                             32768
_db_block_header_guard_level                       0
_db_block_hi_priority_batch_size                   0
_db_block_known_clean_pct                          2
_db_block_lru_latches                              256
_db_block_max_cr_dba                               6
_db_block_max_scan_pct                             40
_db_block_med_priority_batch_size                  0
_db_block_numa                                     1
_db_block_prefetch_fast_longjumps_enabled          TRUE
_db_block_prefetch_limit                           0
_db_block_prefetch_override                        0
_db_block_prefetch_private_cache_enabled           TRUE
_db_block_prefetch_quota                           10
_db_block_prefetch_skip_reading_enabled            TRUE
_db_block_table_scan_buffer_size                   4194304
_db_block_temp_redo                                FALSE
_db_block_trace_protect                            FALSE
_db_block_vlm_check                                FALSE
_db_block_vlm_leak_threshold                       3
_db_blocks_per_hash_latch
_db_cache_advice_max_size_factor                   2
_db_cache_advice_sample_factor                     4
_db_cache_advice_sanity_check                      FALSE
_db_cache_block_read_stack_trace                   0
_db_cache_crx_check                                FALSE
_db_cache_miss_check_les                           FALSE
_db_cache_mman_latch_check                         FALSE
_db_cache_pre_warm                                 TRUE
_db_cache_process_cr_pin_max
_db_cache_wait_debug                               0
_db_change_notification_enable                     TRUE
_db_check_cell_hints                               FALSE
_db_disable_temp_encryption                        FALSE
_db_dump_from_disk_noefc                           0
_db_fast_obj_check                                 FALSE
_db_fast_obj_ckpt                                  TRUE
_db_fast_obj_truncate                              TRUE
_db_file_direct_io_count                           1048576
_db_file_exec_read_count                           128
_db_file_format_io_buffers                         4
_db_file_noncontig_mblock_read_count               11
_db_file_optimizer_read_count                      8
_db_flash_cache_force_replenish_limit              8
_db_flash_cache_keep_limit                         228716368
_db_flash_cache_write_limit                        1
_db_flashback_iobuf_size                           1
_db_flashback_log_min_size                         16777216
_db_flashback_log_min_total_space                  0
_db_flashback_num_iobuf                            32
_db_handles                                        4000
_db_handles_cached                                 8

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_db_hot_block_tracking                             FALSE
_db_index_block_checking                           TRUE
_db_initial_cachesize_create_mb                    256
_db_l2_tracing                                     0
_db_large_dirty_queue                              25
_db_lost_write_checking                            2
_db_lost_write_tracing                             FALSE
_db_mttr_advice                                    ON
_db_mttr_partitions                                0
_db_mttr_sample_factor                             64
_db_mttr_sim_target
_db_mttr_sim_trace_size                            256
_db_mttr_trace_to_alert                            FALSE
_db_noarch_disble_optim                            FALSE
_db_num_evict_waitevents                           64
_db_obj_enable_ksr                                 TRUE
_db_percent_hot_default                            50
_db_percent_hot_keep                               0
_db_percent_hot_recycle                            0
_db_percpu_create_cachesize                        2
_db_prefetch_histogram_statistics                  FALSE
_db_recovery_temporal_file_dest
_db_required_percent_fairshare_usage               10
_db_row_overlap_checking                           TRUE
_db_todefer_cache_create                           TRUE
_db_writer_chunk_writes                            0
_db_writer_coalesce_area_size                      4194304
_db_writer_coalesce_write_limit                    131072
_db_writer_flush_imu                               TRUE
_db_writer_histogram_statistics                    FALSE
_db_writer_max_writes                              0
_db_writer_nomemcopy_coalesce                      FALSE
_db_writer_verify_writes                           FALSE
_dbg_proc_startup                                  FALSE
_dbms_sql_security_level                           1
_dbrm_dynamic_threshold                            16843752
_dbrm_num_runnable_list                            0
_dbrm_quantum
_dbrm_runchk                                       0
_dbrm_short_wait_us                                300
_dbwr_async_io                                     TRUE
_dbwr_scan_interval                                300
_dbwr_tracing                                      0
_dde_flood_control_init                            TRUE
_dead_process_scan_interval                        60
_deadlock_diagnostic_level                         2
_deadlock_resolution_incidents_always              FALSE
_deadlock_resolution_incidents_enabled             TRUE
_deadlock_resolution_level                         1
_deadlock_resolution_min_wait_timeout_secs         60
_deadlock_resolution_signal_process_thresh_secs    60
_dedicated_server_poll_count                       10
_dedicated_server_post_wait                        FALSE
_dedicated_server_post_wait_call                   FALSE
_default_encrypt_alg                               0
_default_non_equality_sel_check                    TRUE
_defer_eor_orl_arch_for_so                         FALSE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_defer_log_boundary_ckpt                           TRUE
_defer_log_count                                   2
_defer_rcv_during_sw_to_sby                        FALSE
_deferred_constant_folding_mode                    DEFAULT
_deferred_log_dest_is_valid                        TRUE
_delay_index_maintain                              TRUE
_delta_push_share_blockers                         0
_deq_execute_reset_time                            30
_deq_ht_child_latches                              8
_deq_ht_max_elements                               100000
_deq_large_txn_size                                25000
_deq_log_array_size                                10000
_deq_max_fetch_count                               10
_deq_maxwait_time                                  0
_desired_readmem_rate                              90
_dg_broker_trace_level
_dg_cf_check_timer                                 15
_dg_corrupt_redo_log                               0
_diag_adr_auto_purge                               TRUE
_diag_adr_enabled                                  TRUE
_diag_adr_test_param                               0
_diag_arb_before_kill                              FALSE
_diag_backward_compat                              TRUE
_diag_cc_enabled                                   TRUE
_diag_conf_cap_enabled                             TRUE
_diag_crashdump_level                              10
_diag_daemon                                       TRUE
_diag_dde_async_age_limit                          300
_diag_dde_async_cputime_limit                      300
_diag_dde_async_mode                               1
_diag_dde_async_msg_capacity                       1024
_diag_dde_async_msgs                               50
_diag_dde_async_process_rate                       5
_diag_dde_async_runtime_limit                      900
_diag_dde_async_slaves                             5
_diag_dde_enabled                                  TRUE
_diag_dde_fc_enabled                               TRUE
_diag_dde_fc_implicit_time                         0
_diag_dde_fc_macro_time                            0
_diag_dde_inc_proc_delay                           1
_diag_diagnostics                                  TRUE
_diag_dump_request_debug_level                     1
_diag_dump_timeout                                 30
_diag_enable_startup_events                        FALSE
_diag_hm_rc_enabled                                TRUE
_diag_hm_tc_enabled                                FALSE
_diag_proc_enabled                                 TRUE
_diag_proc_max_time_ms                             30000
_diag_proc_stack_capture_type                      1
_diag_uts_control                                  0
_diag_verbose_error_on_init                        0
_dimension_skip_null                               TRUE
_direct_io_skip_cur_slot_on_error                  TRUE
_direct_io_slots                                   0
_direct_io_wslots                                  0
_direct_path_insert_features                       0
_direct_read_decision_statistics_driven            TRUE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_disable_12751                                     FALSE
_disable_active_influx_move                        FALSE
_disable_adaptive_shrunk_aggregation               FALSE
_disable_appliance_check                           FALSE
_disable_appliance_partnering                      FALSE
_disable_autotune_gtx                              FALSE
_disable_block_checking                            FALSE
_disable_cell_optimized_backups                    FALSE
_disable_cpu_check                                 FALSE
_disable_cursor_sharing                            FALSE
_disable_datalayer_sampling                        FALSE
_disable_duplex_link                               TRUE
_disable_fast_aggregation                          FALSE
_disable_fast_validate                             FALSE
_disable_fastopen                                  FALSE
_disable_fba_qrw                                   0
_disable_fba_wpr                                   0
_disable_file_locks                                FALSE
_disable_flashback_archiver                        0
_disable_flashback_wait_callback                   FALSE
_disable_function_based_index                      FALSE
_disable_gvaq_cache                                FALSE
_disable_health_check                              FALSE
_disable_highres_ticks                             FALSE
_disable_image_check                               FALSE
_disable_implicit_row_movement                     FALSE
_disable_incremental_checkpoints                   FALSE
_disable_incremental_recovery_ckpt                 FALSE
_disable_index_block_prefetching                   FALSE
_disable_initial_block_compression                 FALSE
_disable_instance_params_check                     FALSE
_disable_interface_checking                        FALSE
_disable_kcb_flashback_blocknew_opt                FALSE
_disable_kcbhxor_osd                               FALSE
_disable_kcbl_flashback_blocknew_opt               FALSE
_disable_kgghshcrc32_osd                           FALSE
_disable_latch_free_SCN_writes_via_32cas           FALSE
_disable_latch_free_SCN_writes_via_64cas           FALSE
_disable_logging                                   FALSE
_disable_metrics_group                             0
_disable_multiple_block_sizes                      FALSE
_disable_odm                                       FALSE
_disable_parallel_conventional_load                FALSE
_disable_primary_bitmap_switch                     FALSE
_disable_read_only_open_dict_check                 FALSE
_disable_rebalance_compact                         FALSE
_disable_rebalance_space_check                     FALSE
_disable_recovery_read_skip                        FALSE
_disable_sample_io_optim                           FALSE
_disable_savepoint_reset                           FALSE
_disable_selftune_checkpointing                    FALSE
_disable_storage_type                              TRUE
_disable_streams_diagnostics                       0
_disable_streams_pool_auto_tuning                  FALSE
_disable_sun_rsm                                   TRUE
_disable_system_state                              4294967294
_disable_system_state_wait_samples                 FALSE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_disable_temp_tablespace_alerts                    FALSE
_disable_thread_internal_disable                   FALSE
_disable_thread_snapshot                           TRUE
_disable_txn_alert                                 0
_disable_undo_tablespace_alerts                    FALSE
_disable_wait_state
_discrete_transactions_enabled                     FALSE
_disk_sector_size_override                         FALSE
_diskmon_pipe_name
_dispatcher_rate_scale
_dispatcher_rate_ttl
_distinct_view_unnesting                           FALSE
_distributed_recovery_connection_hold_time         200
_dlmtrace
_dm_max_shared_pool_pct                            1
_dml_batch_error_limit                             0
_dml_frequency_tracking                            FALSE
_dml_frequency_tracking_advance                    TRUE
_dml_frequency_tracking_slot_time                  15
_dml_frequency_tracking_slots                      4
_dml_monitoring_enabled                            TRUE
_domain_index_batch_size                           2000
_domain_index_dml_batch_size                       200
_dra_bmr_number_threshold                          1000
_dra_bmr_percent_threshold                         10
_dra_enable_offline_dictionary                     FALSE
_drm_parallel_freeze                               TRUE
_drop_flashback_logical_operations_enq             FALSE
_drop_table_granule                                256
_drop_table_optimization_enabled                   TRUE
_ds_enable_auto_txn                                FALSE
_ds_iocount_iosize                                 6553664
_ds_parse_model                                    2
_dsc_feature_level                                 0
_dskm_health_check_cnt                             20
_dss_cache_flush                                   FALSE
_dtree_area_size                                   131072
_dtree_binning_enabled                             TRUE
_dtree_bintest_id                                  0
_dtree_compressbmp_enabled                         TRUE
_dtree_max_surrogates                              1
_dtree_pruning_enabled                             TRUE
_dummy_instance                                    FALSE
_dump_common_subexpressions                        FALSE
_dump_connect_by_loop_data                         FALSE
_dump_cursor_heap_sizes                            FALSE
_dump_interval_limit                               120
_dump_max_limit                                    5
_dump_qbc_tree                                     0
_dump_rcvr_ipc                                     TRUE
_dump_system_state_scope                           local
_dump_trace_scope                                  global
_dynamic_rls_policies                              TRUE
_dynamic_stats_threshold                           30
_eighteenth_spare_parameter
_eighth_spare_parameter
_eleventh_spare_parameter

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_eliminate_common_subexpr                          TRUE
_emon_max_active_connections                       256
_emon_outbound_connect_timeout                     30000
_emon_regular_ntfn_slaves                          4
_enable_Front_End_View_Optimization                1
_enable_LGPG_debug                                 FALSE
_enable_NUMA_interleave                            TRUE
_enable_NUMA_optimization                          FALSE
_enable_NUMA_support                               FALSE
_enable_asyncvio                                   FALSE
_enable_automatic_maintenance                      1
_enable_automatic_sqltune                          TRUE
_enable_block_level_transaction_recovery           TRUE
_enable_check_truncate                             TRUE
_enable_cscn_caching                               FALSE
_enable_ddl_wait_lock                              TRUE
_enable_default_affinity                           0
_enable_default_temp_threshold                     TRUE
_enable_default_undo_threshold                     TRUE
_enable_dml_lock_escalation                        TRUE
_enable_editions_for_users                         FALSE
_enable_exchange_validation_using_check            TRUE
_enable_fast_ref_after_mv_tbs                      FALSE
_enable_ffw                                        TRUE
_enable_flash_logging                              TRUE
_enable_hash_overflow                              FALSE
_enable_hwm_sync                                   TRUE
_enable_kqf_purge                                  TRUE
_enable_list_io                                    FALSE
_enable_midtier_affinity                           TRUE
_enable_minscn_cr                                  TRUE
_enable_nativenet_tcpip                            FALSE
_enable_obj_queues                                 TRUE
_enable_online_index_without_s_locking             TRUE
_enable_query_rewrite_on_remote_objs               TRUE
_enable_redo_global_post                           FALSE
_enable_refresh_schedule                           TRUE
_enable_reliable_latch_waits                       TRUE
_enable_rename_user                                FALSE
_enable_rlb                                        TRUE
_enable_row_shipping                               TRUE
_enable_sb_detection                               TRUE
_enable_schema_synonyms                            FALSE
_enable_scn_wait_interface                         TRUE
_enable_separable_transactions                     FALSE
_enable_shared_pool_durations                      TRUE
_enable_shared_server_vector_io                    FALSE
_enable_space_preallocation                        3
_enable_spacebg                                    TRUE
_enable_tablespace_alerts                          TRUE
_enable_type_dep_selectivity                       TRUE
_endprot_chunk_comment                             chk 10235 dflt
_endprot_heap_comment                              hp 10235 dflt
_endprot_subheaps                                  TRUE
_enqueue_deadlock_scan_secs                        0
_enqueue_deadlock_time_sec                         5
_enqueue_debug_multi_instance                      FALSE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_enqueue_hash                                      1635
_enqueue_hash_chain_latches                        32
_enqueue_locks                                     10190
_enqueue_paranoia_mode_enabled                     FALSE
_enqueue_resources                                 3740
_evolve_plan_baseline_report_level                 typical
_evt_system_event_propagation                      TRUE
_expand_aggregates                                 TRUE
_explain_rewrite_mode                              FALSE
_extended_pruning_enabled                          TRUE
_fair_remote_cvt                                   FALSE
_fairness_threshold                                2
_fast_cursor_reexecute                             FALSE
_fast_dual_enabled                                 TRUE
_fast_full_scan_enabled                            TRUE
_fastpin_enable                                    228793345
_fbda_busy_percentage                              0
_fbda_debug_assert                                 0
_fbda_debug_mode                                   0
_fbda_global_bscn_lag                              0
_fbda_inline_percentage                            0
_fbda_rac_inactive_limit                           0
_fg_iorm_slaves                                    1
_fg_log_checksum                                   TRUE
_fg_sync_sleep_usecs                               0
_fic_algorithm_set                                 automatic
_fic_area_size                                     131072
_fic_max_length                                    20
_fic_min_bmsize                                    1024
_fic_outofmem_candidates                           FALSE
_fifteenth_spare_parameter
_fifth_spare_parameter
_file_size_increase_increment                      67108864
_filemap_dir
_first_k_rows_dynamic_proration                    TRUE
_first_spare_parameter
_fix_control
_flashback_11.1_block_new_opt                      FALSE
_flashback_allow_noarchivelog                      FALSE
_flashback_archiver_partition_size                 0
_flashback_barrier_interval                        1800
_flashback_copy_latches                            10
_flashback_database_test_only                      FALSE
_flashback_delete_chunk_MB                         128
_flashback_dynamic_enable                          TRUE
_flashback_dynamic_enable_failure                  0
_flashback_enable_ra                               TRUE
_flashback_format_chunk_mb                         4
_flashback_format_chunk_mb_dwrite                  16
_flashback_fuzzy_barrier                           TRUE
_flashback_generation_buffer_size                  134217728
_flashback_hint_barrier_percent                    20
_flashback_log_io_error_behavior                   0
_flashback_log_min_size                            100
_flashback_log_rac_balance_factor                  10
_flashback_log_size                                1000
_flashback_logfile_enqueue_timeout                 600

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_flashback_marker_cache_enabled                    TRUE
_flashback_marker_cache_size                       328
_flashback_max_log_size                            0
_flashback_max_n_log_per_thread                    2048
_flashback_max_standby_sync_span                   300
_flashback_n_log_per_thread                        128
_flashback_prepare_log                             TRUE
_flashback_size_based_on_redo                      TRUE
_flashback_standby_barrier_interval                1
_flashback_validate_controlfile                    FALSE
_flashback_verbose_info                            FALSE
_flashback_write_max_loop_limit                    10
_flush_plan_in_awr_sql                             0
_flush_redo_to_standby                             0
_flush_undo_after_tx_recovery                      TRUE
_force_arch_compress                               0
_force_datefold_trunc                              FALSE
_force_hash_join_spill                             FALSE
_force_hsc_compress                                FALSE
_force_oltp_compress                               FALSE
_force_oltp_update_opt                             TRUE
_force_rcv_info_ping                               0
_force_rewrite_enable                              FALSE
_force_slave_mapping_intra_part_loads              FALSE
_force_temptables_for_gsets                        FALSE
_force_tmp_segment_loads                           FALSE
_forwarded_2pc_threshold                           10
_fourteenth_spare_parameter
_fourth_spare_parameter
_frame_cache_time                                  0
_full_pwise_join_enabled                           TRUE
_fusion_security                                   FALSE
_gby_hash_aggregation_enabled                      TRUE
_gby_onekey_enabled                                TRUE
_gc_affinity_locking                               TRUE
_gc_affinity_locks                                 TRUE
_gc_affinity_ratio                                 50
_gc_async_memcpy                                   FALSE
_gc_bypass_readers                                 TRUE
_gc_check_bscn                                     TRUE
_gc_coalesce_recovery_reads                        TRUE
_gc_cpu_time                                       FALSE
_gc_cr_server_read_wait                            TRUE
_gc_defer_ping_index_only                          TRUE
_gc_defer_time                                     1
_gc_delta_push_compression                         3072
_gc_delta_push_max_level                           100
_gc_delta_push_objects                             0
_gc_disable_s_lock_brr_ping_check                  TRUE
_gc_down_convert_after_keep                        TRUE
_gc_element_percent                                110
_gc_escalate_bid                                   TRUE
_gc_fg_merge                                       TRUE
_gc_flush_during_affinity                          TRUE
_gc_fusion_compression                             1024
_gc_global_checkpoint_scn                          TRUE
_gc_global_cpu                                     TRUE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_gc_global_lru                                     AUTO
_gc_global_lru_touch_count                         5
_gc_global_lru_touch_time                          60
_gc_integrity_checks                               1
_gc_keep_recovery_buffers                          TRUE
_gc_latches                                        8
_gc_log_flush                                      TRUE
_gc_long_query_threshold                           0
_gc_max_downcvt                                    256
_gc_maximum_bids                                   0
_gc_no_fairness_for_clones                         TRUE
_gc_override_force_cr                              TRUE
_gc_persistent_read_mostly                         TRUE
_gc_policy_minimum                                 1500
_gc_policy_time                                    10
_gc_read_mostly_flush_check                        FALSE
_gc_read_mostly_locking                            TRUE
_gc_sanity_check_cr_buffers                        FALSE
_gc_serve_high_pi_as_current                       TRUE
_gc_statistics                                     TRUE
_gc_transfer_ratio                                 2
_gc_tsn_undo_affinity                              TRUE
_gc_undo_affinity                                  TRUE
_gc_undo_block_disk_reads                          TRUE
_gc_use_cr                                         TRUE
_gc_vector_read                                    TRUE
_gcr_enable_high_cpu_kill                          FALSE
_gcr_enable_high_cpu_rm                            FALSE
_gcr_enable_high_cpu_rt                            FALSE
_gcr_high_cpu_threshold                            10
_gcr_use_css                                       TRUE
_gcs_disable_remote_handles                        FALSE
_gcs_disable_skip_close_remastering                FALSE
_gcs_fast_reconfig                                 TRUE
_gcs_latches                                       0
_gcs_pkey_history                                  4000
_gcs_process_in_recovery                           TRUE
_gcs_res_per_bucket                                4
_gcs_resources
_gcs_shadow_locks
_gcs_testing                                       0
_generalized_pruning_enabled                       TRUE
_ges_dd_debug                                      1
_ges_designated_master                             FALSE
_ges_diagnostics                                   TRUE
_ges_diagnostics_asm_dump_level                    11
_ges_health_check                                  0
_ges_num_blockers_to_kill                          1
_global_hang_analysis_interval_secs                10
_globalindex_pnum_filter_enabled                   TRUE
_groupby_nopushdown_cut_ratio                      3
_groupby_orderby_combine                           5000
_gs_anti_semi_join_allowed                         TRUE
_hang_analysis_num_call_stacks                     3
_hang_detection_enabled                            TRUE
_hang_detection_interval                           32
_hang_hiload_promoted_ignored_hang_count           2

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_hang_hiprior_session_attribute_list
_hang_ignored_hang_count                           1
_hang_ignored_hangs_interval                       300
_hang_log_incidents                                FALSE
_hang_long_wait_time_threshold                     0
_hang_lws_file_count                               5
_hang_lws_file_time_limit                          3600
_hang_msg_checksum_enabled                         TRUE
_hang_output_suspected_hangs                       FALSE
_hang_resolution_confidence_promotion              FALSE
_hang_resolution_global_hang_confidence_promotion  FALSE
_hang_resolution_policy                            HIGH
_hang_resolution_promote_process_termination       FALSE
_hang_resolution_scope                             PROCESS
_hang_signature_list_match_output_frequency        10
_hang_statistics_collection_interval               15
_hang_statistics_collection_ma_alpha               30
_hang_statistics_high_io_percentage_threshold      45
_hang_verification_interval                        46
_hard_protection                                   FALSE
_hash_join_enabled                                 TRUE
_hash_multiblock_io_count                          0
_hb_redo_msg_interval                              100
_heur_deadlock_resolution_secs                     0
_high_priority_processes                           LMS*|VKTM
_high_server_threshold                             0
_highres_drift_allowed_sec                         1
_highthreshold_undoretention                       4294967294
_hj_bit_filter_threshold                           50
_hm_analysis_oradebug_node_dump_level              0
_hm_analysis_oradebug_sys_dump_level               0
_hm_analysis_output_disk                           FALSE
_hwm_sync_threshold                                10
_idl_conventional_index_maintenance                TRUE
_idle_session_kill_enabled                         TRUE
_idxrb_rowincr                                     100000000
_ignore_desc_in_index                              FALSE
_ignore_edition_enabled_for_EV_creation            FALSE
_ignore_fg_deps
_immediate_commit_propagation                      TRUE
_improved_outerjoin_card                           TRUE
_improved_row_length_enabled                       TRUE
_imr_active                                        TRUE
_imr_avoid_double_voting                           TRUE
_imr_controlfile_access_wait_time                  10
_imr_device_type                                   controlfile
_imr_disk_voting_interval                          3
_imr_diskvote_implementation                       auto
_imr_evicted_member_kill                           TRUE
_imr_evicted_member_kill_wait                      20
_imr_extra_reconfig_wait                           10
_imr_highload_threshold
_imr_max_reconfig_delay                            75
_imr_splitbrain_res_wait                           0
_imr_systemload_check                              TRUE
_imu_pools                                         3
_in_memory_tbs_search                              TRUE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_in_memory_undo                                    TRUE
_incremental_recovery_ckpt_min_batch               500
_index_join_enabled                                TRUE
_index_partition_large_extents                     FALSE
_index_prefetch_factor                             100
_index_scan_check_skip_corrupt                     FALSE
_index_scan_check_stopkey                          FALSE
_init_granule_interval                             10
_init_sql_file                                     ?/rdbms/admin/sql.bsq
_inject_startup_fault                              0
_inline_sql_in_plsql                               FALSE
_inplace_update_retry                              TRUE
_inquiry_retry_interval                            3
_insert_enable_hwm_brokered                        TRUE
_inst_locking_period                               5
_interconnect_checksum                             TRUE
_intrapart_pdml_enabled                            TRUE
_intrapart_pdml_randomlocal_enabled                TRUE
_io_resource_manager_always_on                     FALSE
_io_shared_pool_size                               4194304
_io_slaves_disabled                                FALSE
_io_statistics                                     TRUE
_iocalibrate_init_ios                              2
_iocalibrate_max_ios                               0
_ioq_fanin_multiplier                              2
_ior_serialize_fault                               0
_iorm_tout                                         1000
_ioslave_batch_count                               1
_ioslave_issue_count                               500
_ipc_fail_network                                  0
_ipc_test_failover                                 0
_ipc_test_mult_nets                                0
_ipddb_enable                                      FALSE
_job_queue_interval                                5
_k2q_latches                                       0
_kcfis_block_dump_level                            0
_kcfis_caching_enabled                             TRUE
_kcfis_cell_passthru_enabled                       FALSE
_kcfis_cell_passthru_fromcpu_enabled               TRUE
_kcfis_control1                                    0
_kcfis_control2                                    0
_kcfis_control3                                    0
_kcfis_control4                                    0
_kcfis_control5                                    0
_kcfis_control6                                    0
_kcfis_disable_platform_decryption                 FALSE
_kcfis_dump_corrupt_block                          TRUE
_kcfis_fast_response_enabled                       TRUE
_kcfis_fast_response_initiosize                    2
_kcfis_fast_response_iosizemult                    4
_kcfis_fast_response_threshold                     1048576
_kcfis_fault_control                               0
_kcfis_io_prefetch_size                            8
_kcfis_ioreqs_throttle_enabled                     TRUE
_kcfis_kept_in_cellfc_enabled                      TRUE
_kcfis_large_payload_enabled                       FALSE
_kcfis_max_cached_sessions                         10

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kcfis_max_out_translations                        5000
_kcfis_nonkept_in_cellfc_enabled                   FALSE
_kcfis_oss_io_size                                 0
_kcfis_rdbms_blockio_enabled                       FALSE
_kcfis_read_buffer_limit                           0
_kcfis_spawn_debugger                              FALSE
_kcfis_stats_level                                 0
_kcfis_storageidx_diag_mode                        0
_kcfis_storageidx_disabled                         FALSE
_kcfis_test_control1                               0
_kcfis_trace_bucket_size                           131072
_kcfis_trace_level                                 0
_kcfis_work_set_appliances                         2
_kcl_commit                                        TRUE
_kcl_conservative_log_flush                        FALSE
_kcl_debug                                         TRUE
_kcl_index_split                                   TRUE
_kd_symtab_chk                                     TRUE
_kdbl_enable_post_allocation                       FALSE
_kdi_avoid_block_checking                          FALSE
_kdic_segarr_sz                                    0
_kdis_reject_level                                 24
_kdis_reject_limit                                 5
_kdis_reject_ops                                   FALSE
_kdli_STOP_bsz                                     0
_kdli_STOP_dba                                     0
_kdli_STOP_fsz                                     0
_kdli_STOP_nio                                     0
_kdli_STOP_tsn                                     0
_kdli_allow_corrupt                                TRUE
_kdli_buffer_inject                                TRUE
_kdli_cache_inode                                  TRUE
_kdli_cache_read_threshold                         0
_kdli_cache_size                                   8
_kdli_cache_verify                                 FALSE
_kdli_cache_write_threshold                        0
_kdli_cacheable_length                             0
_kdli_checkpoint_flush                             FALSE
_kdli_dbc                                          none
_kdli_delay_flushes                                TRUE
_kdli_flush_cache_reads                            FALSE
_kdli_flush_injections                             TRUE
_kdli_force_cr                                     TRUE
_kdli_force_cr_meta                                TRUE
_kdli_force_storage                                none
_kdli_full_readahead_threshold                     0
_kdli_inject_assert                                0
_kdli_inject_batch                                 0
_kdli_inject_crash                                 0
_kdli_inline_xfm                                   TRUE
_kdli_inode_preference                             data
_kdli_inplace_overwrite                            0
_kdli_itree_entries                                0
_kdli_memory_protect                               FALSE
_kdli_oneblk                                       FALSE
_kdli_preallocation_mode                           length
_kdli_preallocation_pct                            0

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kdli_rci_lobmap_entries                           255
_kdli_readahead_limit                              0
_kdli_readahead_strategy                           contig
_kdli_recent_scn                                   FALSE
_kdli_reshape                                      FALSE
_kdli_safe_callbacks                               TRUE
_kdli_sio_async                                    TRUE
_kdli_sio_backoff                                  FALSE
_kdli_sio_bps                                      0
_kdli_sio_dop                                      2
_kdli_sio_fbwrite_pct                              35
_kdli_sio_fgio                                     TRUE
_kdli_sio_fileopen                                 none
_kdli_sio_flush                                    FALSE
_kdli_sio_free                                     TRUE
_kdli_sio_min_read                                 0
_kdli_sio_min_write                                0
_kdli_sio_nbufs                                    8
_kdli_sio_niods                                    8
_kdli_sio_on                                       TRUE
_kdli_sio_pga                                      FALSE
_kdli_sio_pga_top                                  FALSE
_kdli_sio_strategy                                 extent
_kdli_sio_write_pct                                100
_kdli_small_cache_limit                            32
_kdli_sort_dbas                                    FALSE
_kdli_space_cache_limit                            2048
_kdli_squeeze                                      TRUE
_kdli_timer_dmp                                    FALSE
_kdli_timer_trc                                    FALSE
_kdli_trace                                        0
_kdli_vll_direct                                   TRUE
_kdlu_max_bucket_size                              4194304
_kdlu_max_bucket_size_mts                          131072
_kdlu_trace_layer                                  0
_kdlu_trace_session                                0
_kdlu_trace_system                                 0
_kdlw_enable_ksi_locking                           FALSE
_kdlw_enable_write_gathering                       TRUE
_kdlwp_flush_threshold                             4194304
_kdlxp_cmp_subunit_size                            262144
_kdlxp_dedup_flush_threshold                       8388608
_kdlxp_dedup_hash_algo                             SHA1
_kdlxp_dedup_inl_pctfree                           5
_kdlxp_dedup_prefix_threshold                      1048576
_kdlxp_dedup_wapp_len                              0
_kdlxp_lobcmpadp                                   FALSE
_kdlxp_lobcmplevel                                 2
_kdlxp_lobcmprciver                                1
_kdlxp_lobcompress                                 FALSE
_kdlxp_lobdeduplicate                              FALSE
_kdlxp_lobdedupvalidate                            TRUE
_kdlxp_lobencrypt                                  FALSE
_kdlxp_mincmp                                      20
_kdlxp_mincmplen                                   200
_kdlxp_minxfm_size                                 32768
_kdlxp_spare1                                      0

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kdlxp_uncmp                                       FALSE
_kdlxp_xfmcache                                    TRUE
_kdt_buffering                                     TRUE
_kdtgsp_retries                                    1024
_kdu_array_depth                                   16
_kdz_hcc_flags                                     0
_kdz_hcc_track_upd_rids                            TRUE
_kebm_nstrikes                                     3
_kebm_suspension_time                              82800
_keep_remote_column_size                           FALSE
_kernel_message_network_driver                     FALSE
_kes_parse_model                                   2
_kffmap_hash_size                                  1024
_kffmop_hash_size                                  2048
_kfm_disable_set_fence                             FALSE
_kghdsidx_count                                    6
_kgl_bucket_count                                  9
_kgl_cluster_lock                                  TRUE
_kgl_cluster_lock_read_mostly                      FALSE
_kgl_cluster_pin                                   TRUE
_kgl_debug
_kgl_fixed_extents                                 TRUE
_kgl_hash_collision                                FALSE
_kgl_heap_size                                     4096
_kgl_hot_object_copies                             0
_kgl_kqr_cap_so_stacks                             FALSE
_kgl_large_heap_warning_threshold                  52428800
_kgl_latch_count                                   0
_kgl_message_locks                                 64
_kgl_min_cached_so_count                           1
_kgl_time_to_wait_for_locks                        15
_kglsim_maxmem_percent                             5
_kgsb_threshold_size                               16777216
_kgx_latches                                       1024
_kill_controlfile_enqueue_blocker                  TRUE
_kill_diagnostics_timeout                          60
_kill_enqueue_blocker                              2
_kill_java_threads_on_eoc                          FALSE
_kill_session_dump                                 TRUE
_kkfi_trace                                        FALSE
_kks_cached_parse_errors                           0
_kks_free_cursor_stat_pct                          10
_kokli_cache_size                                  128
_kokln_current_read                                FALSE
_kolfuseslf                                        FALSE
_kql_subheap_trace                                 0
_ksb_restart_clean_time                            30000
_ksb_restart_policy_times                          0, 60, 120, 240
_ksd_test_param                                    999
_ksdx_charset_ratio                                0
_ksdxdocmd_default_timeout_ms                      30000
_ksdxdocmd_enabled                                 TRUE
_ksdxw_cini_flg                                    0
_ksdxw_nbufs                                       1000
_ksdxw_num_pgw                                     10
_ksdxw_num_sgw                                     10
_ksdxw_stack_depth                                 4

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_kse_die_timeout                                   60000
_kse_pc_table_size                                 256
_kse_signature_entries                             0
_kse_signature_limit                               7
_kse_snap_ring_record_stack                        FALSE
_kse_snap_ring_size                                0
_kse_trace_int_msg_clear                           FALSE
_ksfd_verify_write                                 FALSE
_ksi_clientlocks_enabled                           TRUE
_ksi_trace
_ksi_trace_bucket                                  PRIVATE
_ksi_trace_bucket_size                             8192
_ksm_post_sga_init_notif_delay_secs                0
_ksm_pre_sga_init_notif_delay_secs                 0
_ksmb_debug                                        0
_ksmd_protect_mode                                 off
_ksmg_granule_locking_status                       1
_ksmg_granule_size                                 16777216
_ksmg_lock_check_interval
_ksmg_lock_reacquire_count                         5
_kspol_tac_timeout                                 5
_ksr_unit_test_processes                           0
_kss_callstack_type
_kss_quiet                                         FALSE
_ksu_diag_kill_time                                5
_ksuitm_addon_trccmd
_ksuitm_dont_kill_dumper                           FALSE
_ksv_dynamic_flags1                                0
_ksv_max_spawn_fail_limit                          5
_ksv_pool_hang_kill_to                             0
_ksv_pool_wait_timeout                             600
_ksv_spawn_control_all                             FALSE
_ksv_static_flags1                                 0
_ksvppktmode                                       0
_ksxp_compat_flags                                 0
_ksxp_control_flags                                0
_ksxp_diagmode                                     OFF
_ksxp_disable_clss                                 0
_ksxp_disable_dynamic_loading                      FALSE
_ksxp_disable_ipc_stats                            FALSE
_ksxp_disable_rolling_migration                    FALSE
_ksxp_dump_timeout                                 20
_ksxp_dynamic_skgxp_param
_ksxp_if_config                                    0
_ksxp_init_stats_bkts                              0
_ksxp_lwipc_enabled                                FALSE
_ksxp_max_stats_bkts                               0
_ksxp_ping_enable                                  TRUE
_ksxp_ping_polling_time                            0
_ksxp_reaping                                      20
_ksxp_reporting_process                            LMD0
_ksxp_send_timeout                                 300
_ksxp_skgxp_compat_library_path
_ksxp_skgxp_ctx_flags1                             0
_ksxp_skgxp_ctx_flags1mask                         0
_ksxp_skgxp_dynamic_protocol                       4096
_ksxp_skgxp_library_path

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_ksxp_skgxp_rgn_ports                              0
_ksxp_skgxp_spare_param1
_ksxp_skgxp_spare_param2
_ksxp_skgxp_spare_param3
_ksxp_skgxp_spare_param4
_ksxp_skgxp_spare_param5
_ksxp_skgxpg_last_parameter                        26
_ksxp_stats_mem_lmt                                0
_ksxp_testing                                      0
_ksxp_unit_test_byte_transformation                FALSE
_ksxp_wait_flags                                   0
_ktb_debug_flags                                   0
_ktc_debug                                         0
_ktc_latches                                       0
_ktslj_segext_max_mb                               0
_ktslj_segext_retry                                5
_ktslj_segext_warning                              10
_ktslj_segext_warning_mb                           0
_ktspsrch_maxsc                                    1024
_ktspsrch_maxskip                                  5
_kttext_warning                                    5
_ktu_latches                                       0
_ku_trace                                          none
_large_pool_min_alloc                              65536
_last_allocation_period                            5
_latch_class_0
_latch_class_1
_latch_class_2
_latch_class_3
_latch_class_4
_latch_class_5
_latch_class_6
_latch_class_7
_latch_classes
_latch_miss_stat_sid                               0
_latch_recovery_alignment                          65534
_ldr_io_size                                       262144
_ldr_io_size2                                      1048576
_ldr_pga_lim                                       0
_left_nested_loops_random                          TRUE
_lgwr_delay_write                                  FALSE
_lgwr_io_slaves                                    0
_lgwr_max_ns_wt                                    1
_lgwr_ns_nl_max                                    1000
_lgwr_ns_nl_min                                    500
_lgwr_ns_sim_err                                   0
_lgwr_posts_for_pending_bcasts                     FALSE
_lgwr_ta_sim_err                                   0
_library_cache_advice                              TRUE
_lightweight_hdrs                                  TRUE
_like_with_bind_as_equality                        FALSE
_limit_itls                                        20
_linux_prepage_large_pages                         FALSE
_lm_activate_lms_threshold                         100
_lm_asm_enq_hashing                                TRUE
_lm_batch_compression_threshold                    0
_lm_better_ddvictim                                TRUE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_lm_broadcast_res                                  disable
_lm_broadcast_resname                              AD
_lm_cache_allocated_res_ratio                      50
_lm_cache_lvl0_cleanup                             0
_lm_cache_res_cleanup                              25
_lm_cache_res_cleanup_tries                        10
_lm_cache_res_options                              0
_lm_cache_res_skip_cleanup                         20
_lm_cache_res_type                                 TMHWHVDI
_lm_checksum_batch_msg                             0
_lm_compression_scheme                             zlib
_lm_contiguous_res_count                           128
_lm_dd_ignore_nodd                                 FALSE
_lm_dd_interval                                    10
_lm_dd_max_search_time                             180
_lm_dd_maxdump                                     50
_lm_dd_scan_interval                               5
_lm_dd_search_cnt                                  3
_lm_deferred_msg_timeout                           163
_lm_drm_batch_time                                 10
_lm_drm_disable                                    0
_lm_drm_hiload_percentage                          200
_lm_drm_lowload_percentage                         200
_lm_drm_max_requests                               100
_lm_drm_min_interval                               300
_lm_drm_object_scan                                TRUE
_lm_drm_window                                     0
_lm_drm_xlatch                                     0
_lm_dump_null_lock                                 FALSE
_lm_dynamic_lms                                    FALSE
_lm_dynamic_load                                   TRUE
_lm_enable_aff_benefit_stats                       FALSE
_lm_enq_lock_freelist
_lm_enq_rcfg                                       TRUE
_lm_enqueue_blocker_dump_timeout                   120
_lm_enqueue_blocker_kill_timeout                   0
_lm_enqueue_freelist                               3
_lm_enqueue_timeout                                360
_lm_file_affinity
_lm_file_read_mostly
_lm_free_queue_threshold                           0
_lm_freeze_kill_time                               30
_lm_global_posts                                   TRUE
_lm_hb_callstack_collect_time                      5
_lm_hb_disable_check_list                          none
_lm_high_load_sysload_percentage                   90
_lm_high_load_threshold                            5
_lm_idle_connection_check                          TRUE
_lm_idle_connection_check_interval                 140
_lm_idle_connection_instance_check_callout         FALSE
_lm_idle_connection_kill                           TRUE
_lm_kill_fg_on_timeout                             TRUE
_lm_lhupd_interval                                 5
_lm_lmd_waittime                                   8
_lm_lmon_nowait_latch                              TRUE
_lm_lms                                            0
_lm_lms_priority_dynamic                           TRUE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_lm_lms_rt_threshold
_lm_lms_spin                                       FALSE
_lm_lms_waittime                                   3
_lm_local_hp_enq                                   TRUE
_lm_locks                                          12000
_lm_low_load_percentage                            75
_lm_master_weight                                  1
_lm_max_lms                                        0
_lm_msg_batch_size                                 0
_lm_msg_cleanup_interval                           3000
_lm_no_lh_check                                    FALSE
_lm_no_sync                                        TRUE
_lm_node_join_opt                                  FALSE
_lm_non_fault_tolerant                             FALSE
_lm_num_pt_buckets                                 8192
_lm_num_pt_latches                                 128
_lm_postevent_buffer_size                          256
_lm_preregister_css_restype                        CF
_lm_proc_freeze_timeout                            70
_lm_process_batching                               TRUE
_lm_procs                                          320
_lm_psrcfg                                         TRUE
_lm_rac_spare_dp1                                  0
_lm_rac_spare_dp10
_lm_rac_spare_dp2                                  0
_lm_rac_spare_dp3                                  0
_lm_rac_spare_dp4                                  0
_lm_rac_spare_dp5                                  0
_lm_rac_spare_dp6
_lm_rac_spare_dp7
_lm_rac_spare_dp8
_lm_rac_spare_dp9
_lm_rac_spare_p1                                   0
_lm_rac_spare_p10
_lm_rac_spare_p2                                   0
_lm_rac_spare_p3                                   0
_lm_rac_spare_p4                                   0
_lm_rac_spare_p5                                   0
_lm_rac_spare_p6
_lm_rac_spare_p7
_lm_rac_spare_p8
_lm_rac_spare_p9
_lm_rcfg_timeout                                   489
_lm_rcvinst                                        TRUE
_lm_rcvr_hang_allow_time                           70
_lm_rcvr_hang_cfio_kill                            FALSE
_lm_rcvr_hang_check_frequency                      20
_lm_rcvr_hang_check_system_load                    TRUE
_lm_rcvr_hang_kill                                 TRUE
_lm_rcvr_hang_systemstate_dump_level               0
_lm_res_hash_bucket                                0
_lm_res_part                                       128
_lm_ress                                           6000
_lm_send_mode                                      auto
_lm_send_queue_batching                            TRUE
_lm_send_queue_length                              5000
_lm_sendproxy_reserve                              25

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_lm_share_lock_opt                                 FALSE
_lm_single_inst_affinity_lock                      TRUE
_lm_spare_threads                                  0
_lm_spare_undo                                     0
_lm_sq_batch_factor                                2
_lm_sq_batch_type                                  auto
_lm_sq_batch_waittick                              3
_lm_sync_timeout                                   163
_lm_ticket_active_sendback
_lm_tickets                                        1000
_lm_tx_delta                                       16
_lm_use_gcr                                        TRUE
_lm_use_new_defmsgtmo_action                       TRUE
_lm_use_tx_tsn                                     TRUE
_lm_validate_pbatch                                FALSE
_lm_validate_resource_type                         FALSE
_lm_watchpoint_maximum                             3
_lm_watchpoint_timeout                             3600
_lm_xids                                           352
_lmn_compression                                   TRUE
_load_without_compile                              NONE
_local_arc_assert_on_wait                          FALSE
_local_communication_costing_enabled               TRUE
_local_communication_ratio                         50
_local_hang_analysis_interval_secs                 3
_lock_sga_areas                                    0
_log_archive_avoid_memcpy                          TRUE
_log_archive_buffers                               10
_log_archive_callout
_log_archive_network_redo_size                     10
_log_archive_prot_auto_demote                      FALSE
_log_archive_security_enabled                      TRUE
_log_archive_strong_auth                           TRUE
_log_archive_trace_pids
_log_blocks_during_backup                          TRUE
_log_buffer_coalesce                               FALSE
_log_buffers_corrupt                               FALSE
_log_buffers_debug                                 FALSE
_log_checkpoint_recovery_check                     0
_log_committime_block_cleanout                     FALSE
_log_deletion_policy                               mandatory
_log_event_queues                                  0
_log_file_sync_timeout                             10
_log_io_size                                       0
_log_max_optimize_threads                          128
_log_parallelism_dynamic                           TRUE
_log_parallelism_max                               2
_log_private_mul                                   5
_log_private_parallelism_mul                       10
_log_read_buffer_size                              8
_log_read_buffers                                  8
_log_simultaneous_copies                           64
_log_space_errors                                  TRUE
_log_switch_timeout                                0
_logout_storm_rate                                 0
_logout_storm_retrycnt                             600
_logout_storm_timeout                              5

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_long_bcast_ack_warning_threshold                  500
_long_log_write_warning_threshold                  500
_longops_enabled                                   TRUE
_low_server_threshold                              0
_lowres_drift_allowed_sec                          5
_ltc_trace                                         0
_main_dead_process_scan_interval                   0
_master_direct_sends                               31
_mav_refresh_consistent_read                       TRUE
_mav_refresh_double_count_prevented                FALSE
_mav_refresh_opt                                   0
_mav_refresh_unionall_tables                       3
_max_aq_persistent_queue_memory                    10
_max_async_wait_for_catch_up                       20
_max_cr_rollbacks                                  0
_max_exponential_sleep                             0
_max_filestat_tries                                10
_max_fsu_segments                                  4096
_max_fsu_stale_time                                600
_max_io_size                                       1048576
_max_large_io                                      0
_max_largepage_alloc_time_secs                     10
_max_lns_shutdown_archival_time                    30
_max_pending_scn_bcasts                            8
_max_protocol_support                              10000
_max_reasonable_scn_rate                           32768
_max_rwgs_groupings                                8192
_max_services                                      150
_max_shrink_obj_stats                              0
_max_sleep_holding_latch                           4
_max_small_io                                      0
_max_spacebg_msgs_percentage                       50
_max_spacebg_slaves                                10
_max_spacebg_tasks                                 1000
_media_recovery_read_batch                         32
_mem_annotation_pr_lev                             0
_mem_annotation_scale                              1
_mem_annotation_sh_lev                             0
_mem_annotation_store                              FALSE
_mem_std_extent_size                               4096
_memory_broker_log_stat_entries                    5
_memory_broker_marginal_utility_bc                 12
_memory_broker_marginal_utility_sp                 7
_memory_broker_shrink_heaps                        15
_memory_broker_shrink_java_heaps                   900
_memory_broker_shrink_streams_pool                 900
_memory_broker_shrink_timeout                      60000000
_memory_broker_stat_interval                       30
_memory_checkinuse_timeintv                        30
_memory_imm_mode_without_autosga                   TRUE
_memory_initial_sga_split_perc                     60
_memory_management_tracing                         0
_memory_mgmt_fail_immreq                           FALSE
_memory_mgmt_immreq_timeout                        150
_memory_nocancel_defsgareq                         FALSE
_memory_sanity_check                               0
_messages                                          1000

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_mgd_rcv_handle_orphan_datafiles                   FALSE
_midtier_affinity_clusterwait_threshold            100
_midtier_affinity_goodness_threshold               2000
_minfree_plus                                      0
_minimal_stats_aggregation                         TRUE
_minimum_blocks_to_shrink                          0
_minimum_db_flashback_retention                    60
_minimum_extents_to_shrink                         1
_minimum_giga_scn                                  0
_mirror_redo_buffers                               FALSE
_mmv_query_rewrite_enabled                         TRUE
_module_action_old_length                          TRUE
_mpmt_enabled                                      FALSE
_multi_instance_pmr                                TRUE
_multi_join_key_table_lookup                       TRUE
_multiple_instance_recovery                        FALSE
_mutex_spin_count                                  255
_mutex_wait_scheme                                 2
_mutex_wait_time                                   1
_mv_generalized_oj_refresh_opt                     TRUE
_mv_refresh_ana                                    0
_mv_refresh_costing                                rule
_mv_refresh_delta_fraction                         10
_mv_refresh_enhanced_dml_detection                 ON_RC
_mv_refresh_eut                                    TRUE
_mv_refresh_force_parallel_query                   0
_mv_refresh_new_setup_disabled                     FALSE
_mv_refresh_no_idx_rebuild                         FALSE
_mv_refresh_pkfk_data_units_opt                    auto
_mv_refresh_pkfk_relationship_opt                  TRUE
_mv_refresh_rebuild_percentage                     10
_mv_refresh_selections                             TRUE
_mv_refresh_update_analysis                        TRUE
_mv_refresh_use_hash_sj                            TRUE
_mv_refresh_use_no_merge                           TRUE
_mv_refresh_use_stats                              FALSE
_mv_refsched_timeincr                              300000
_mv_rolling_inv                                    FALSE
_mwin_schedule                                     TRUE
_nchar_imp_cnv                                     TRUE
_nchar_imp_conv                                    TRUE
_ncmb_readahead_enabled                            0
_ncmb_readahead_tracing                            0
_ncomp_shared_objects_dir
_nested_loop_fudge                                 100
_nested_mv_fast_oncommit_enabled                   TRUE
_new_initial_join_orders                           TRUE
_new_sort_cost_estimate                            TRUE
_newsort_enabled                                   TRUE
_newsort_ordered_pct                               63
_newsort_type                                      0
_nineteenth_spare_parameter
_ninth_spare_parameter
_nlj_batching_ae_flag                              2
_nlj_batching_enabled                              1
_nlj_batching_misses_enabled                       1
_nls_parameter_sync_enabled                        TRUE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_no_objects                                        FALSE
_no_or_expansion                                   FALSE
_no_recovery_through_resetlogs                     FALSE
_noseg_for_unusable_index_enabled                  TRUE
_notify_crs                                        FALSE
_ns_max_flush_wt                                   1
_ns_max_send_delay                                 15
_num_longop_child_latches                          32
_numa_buffer_cache_stats                           0
_numa_trace_level                                  0
_number_cached_attributes                          10
_number_cached_group_memberships                   32
_obj_ckpt_tracing                                  0
_object_number_cache_size                          5
_object_reuse_bast                                 2
_object_statistics                                 TRUE
_object_stats_max_entries                          3072
_offline_rollback_segments
_ogms_home
_olap_adv_comp_stats_cc_precomp                    20
_olap_adv_comp_stats_max_rows                      100000
_olap_aggregate_buffer_size                        1048576
_olap_aggregate_flags                              0
_olap_aggregate_function_cache_enabled             TRUE
_olap_aggregate_max_thread_tuples                  5000
_olap_aggregate_min_buffer_size                    1024
_olap_aggregate_min_thread_status                  64
_olap_aggregate_multipath_hier                     FALSE
_olap_aggregate_statlen_thresh                     1024
_olap_aggregate_work_per_thread                    1024
_olap_aggregate_worklist_max                       5000
_olap_allocate_errorlog_format                     %8p %8y %8z %e (%n)
_olap_allocate_errorlog_header                     Dim      Source   Basis
                                                   %-8d %-8s %-8b Description
                                                   -------- -------- -------- -----------

_olap_analyze_max                                  10000
_olap_continuous_trace_file                        false
_olap_dbgoutfile_echo_to_eventlog                  FALSE
_olap_dimension_corehash_force                     FALSE
_olap_dimension_corehash_large                     50000
_olap_dimension_corehash_pressure                  90
_olap_dimension_corehash_size                      30
_olap_eif_export_lob_size                          2147483647
_olap_lmgen_dim_size                               100
_olap_lmgen_meas_size                              1000
_olap_object_hash_class                            3
_olap_page_pool_expand_rate                        20
_olap_page_pool_hi                                 50
_olap_page_pool_hit_target                         100
_olap_page_pool_low                                262144
_olap_page_pool_pressure                           90
_olap_page_pool_shrink_rate                        50
_olap_parallel_update_server_num                   0
_olap_parallel_update_small_threshold              1000
_olap_parallel_update_threshold                    1000
_olap_sesscache_enabled                            TRUE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_olap_sort_buffer_pct                              10
_olap_sort_buffer_size                             262144
_olap_statbool_corebits                            20000000
_olap_statbool_threshold                           8100
_olap_table_function_statistics                    FALSE
_olap_wrap_errors                                  FALSE
_olapi_history_retention                           FALSE
_olapi_iface_object_history                        1000
_olapi_iface_object_history_retention              FALSE
_olapi_iface_operation_history_retention           FALSE
_olapi_interface_operation_history                 1000
_olapi_memory_operation_history                    1000
_olapi_memory_operation_history_pause_at_seqno     0
_olapi_memory_operation_history_retention          FALSE
_olapi_session_history                             300
_olapi_session_history_retention                   FALSE
_old_connect_by_enabled                            FALSE
_ols_cleanup_task                                  TRUE
_oltp_compression                                  TRUE
_oltp_compression_gain                             10
_omf                                               enabled
_oneside_colstat_for_equijoins                     TRUE
_online_patch_disable_stack_check                  FALSE
_ops_per_semop
_optim_adjust_for_part_skews                       TRUE
_optim_dict_stats_at_db_cr_upg                     TRUE
_optim_enhance_nnull_detection                     TRUE
_optim_new_default_join_sel                        TRUE
_optim_peek_user_binds                             TRUE
_optimizer_adaptive_cursor_sharing                 TRUE
_optimizer_adjust_for_nulls                        TRUE
_optimizer_autostats_job                           TRUE
_optimizer_aw_join_push_enabled                    TRUE
_optimizer_aw_stats_enabled                        TRUE
_optimizer_better_inlist_costing                   ALL
_optimizer_block_size                              8192
_optimizer_cache_stats                             FALSE
_optimizer_cartesian_enabled                       TRUE
_optimizer_cbqt_factor                             50
_optimizer_cbqt_no_size_restriction                TRUE
_optimizer_ceil_cost                               TRUE
_optimizer_coalesce_subqueries                     TRUE
_optimizer_complex_pred_selectivity                TRUE
_optimizer_compute_index_stats                     TRUE
_optimizer_connect_by_cb_whr_only                  FALSE
_optimizer_connect_by_combine_sw                   TRUE
_optimizer_connect_by_cost_based                   TRUE
_optimizer_connect_by_elim_dups                    TRUE
_optimizer_correct_sq_selectivity                  TRUE
_optimizer_cost_based_transformation               LINEAR
_optimizer_cost_filter_pred                        FALSE
_optimizer_cost_hjsmj_multimatch                   TRUE
_optimizer_cost_model                              CHOOSE
_optimizer_degree                                  0
_optimizer_dim_subq_join_sel                       TRUE
_optimizer_disable_strans_sanity_checks            0
_optimizer_distinct_agg_transform                  TRUE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_optimizer_distinct_elimination                    TRUE
_optimizer_distinct_placement                      TRUE
_optimizer_dyn_smp_blks                            32
_optimizer_eliminate_filtering_join                TRUE
_optimizer_enable_density_improvements             TRUE
_optimizer_enable_extended_stats                   TRUE
_optimizer_enable_table_lookup_by_nl               TRUE
_optimizer_enhanced_filter_push                    TRUE
_optimizer_extend_jppd_view_types                  TRUE
_optimizer_extended_cursor_sharing                 UDO
_optimizer_extended_cursor_sharing_rel             SIMPLE
_optimizer_extended_stats_usage_control            192
_optimizer_false_filter_pred_pullup                TRUE
_optimizer_fast_access_pred_analysis               TRUE
_optimizer_fast_pred_transitivity                  TRUE
_optimizer_feedback_control
_optimizer_filter_pred_pullup                      TRUE
_optimizer_filter_pushdown                         TRUE
_optimizer_fkr_index_cost_bias                     10
_optimizer_force_CBQT
_optimizer_free_transformation_heap                TRUE
_optimizer_full_outer_join_to_outer                TRUE
_optimizer_group_by_placement                      TRUE
_optimizer_ignore_hints                            FALSE
_optimizer_improve_selectivity                     TRUE
_optimizer_instance_count                          0
_optimizer_interleave_jppd                         TRUE
_optimizer_invalidation_period                     18000
_optimizer_join_elimination_enabled                TRUE
_optimizer_join_factorization                      TRUE
_optimizer_join_order_control                      3
_optimizer_join_sel_sanity_check                   TRUE
_optimizer_max_permutations                        2000
_optimizer_min_cache_blocks                        10
_optimizer_mjc_enabled                             TRUE
_optimizer_mode_force                              TRUE
_optimizer_multi_level_push_pred                   TRUE
_optimizer_multiple_cenv
_optimizer_multiple_cenv_report                    result
_optimizer_multiple_cenv_stmt                      query
_optimizer_native_full_outer_join                  FORCE
_optimizer_nested_rollup_for_gset                  100
_optimizer_new_join_card_computation               TRUE
_optimizer_null_aware_antijoin                     TRUE
_optimizer_or_expansion                            DEPTH
_optimizer_or_expansion_subheap                    TRUE
_optimizer_order_by_elimination_enabled            TRUE
_optimizer_outer_join_to_inner                     TRUE
_optimizer_outer_to_anti_enabled                   TRUE
_optimizer_percent_parallel                        101
_optimizer_purge_stats_iteration_row_count         10000
_optimizer_push_down_distinct                      0
_optimizer_push_pred_cost_based                    TRUE
_optimizer_random_plan                             0
_optimizer_reuse_cost_annotations                  TRUE
_optimizer_rownum_bind_default                     10
_optimizer_rownum_pred_based_fkr                   TRUE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_optimizer_save_stats                              TRUE
_optimizer_search_limit                            5
_optimizer_self_induced_cache_cost                 FALSE
_optimizer_skip_scan_enabled                       TRUE
_optimizer_skip_scan_guess                         FALSE
_optimizer_sortmerge_join_enabled                  TRUE
_optimizer_sortmerge_join_inequality               TRUE
_optimizer_squ_bottomup                            TRUE
_optimizer_star_tran_in_with_clause                TRUE
_optimizer_star_trans_min_cost                     0
_optimizer_star_trans_min_ratio                    0
_optimizer_starplan_enabled                        TRUE
_optimizer_system_stats_usage                      TRUE
_optimizer_table_expansion                         TRUE
_optimizer_trace                                   none
_optimizer_transitivity_retain                     TRUE
_optimizer_try_st_before_jppd                      TRUE
_optimizer_undo_changes                            FALSE
_optimizer_undo_cost_change                        11.2.0.3
_optimizer_unnest_all_subqueries                   TRUE
_optimizer_unnest_corr_set_subq                    TRUE
_optimizer_unnest_disjunctive_subq                 TRUE
_optimizer_use_cbqt_star_transformation            TRUE
_optimizer_use_feedback                            TRUE
_optimizer_use_subheap                             TRUE
_or_expand_nvl_predicate                           TRUE
_oradbg_pathname
_oradebug_cmds_at_startup
_oradebug_force                                    FALSE
_ordered_nested_loop                               TRUE
_ordered_semijoin                                  TRUE
_orph_cln_interval                                 1200
_os_sched_high_priority                            1
_oss_skgxp_udp_dynamic_credit_mgmt                 1
_other_wait_event_exclusion
_other_wait_threshold                              0
_outline_bitmap_tree                               TRUE
_parallel_adaptive_max_users                       4
_parallel_blackbox_enabled                         TRUE
_parallel_blackbox_size                            16384
_parallel_broadcast_enabled                        TRUE
_parallel_cluster_cache_pct                        80
_parallel_cluster_cache_policy                     ADAPTIVE
_parallel_conservative_queuing                     FALSE
_parallel_default_max_instances                    1
_parallel_execution_message_align                  FALSE
_parallel_fake_class_pct                           0
_parallel_fixwrite_bucket                          1000
_parallel_heartbeat_snapshot_interval              2
_parallel_heartbeat_snapshot_max                   128
_parallel_load_bal_unit                            0
_parallel_load_balancing                           TRUE
_parallel_load_publish_threshold                   10
_parallel_min_message_pool                         8192000
_parallel_optimization_phase_for_local             FALSE
_parallel_queuing_max_waitingtime
_parallel_recovery_stopat                          32767

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_parallel_replay_msg_limit                         4000
_parallel_scalability                              50
_parallel_server_idle_time                         30000
_parallel_server_sleep_time                        10
_parallel_slave_acquisition_wait                   1
_parallel_statement_queuing                        FALSE
_parallel_syspls_obey_force                        TRUE
_parallel_time_unit                                10
_parallel_txn_global                               FALSE
_parallelism_cost_fudge_factor                     350
_parameter_table_block_size                        2048
_partial_pwise_join_enabled                        TRUE
_partition_large_extents                           TRUE
_partition_view_enabled                            TRUE
_passwordfile_enqueue_timeout                      900
_pct_refresh_double_count_prevented                TRUE
_pdml_gim_sampling                                 5000
_pdml_gim_staggered                                FALSE
_pdml_slaves_diff_part                             TRUE
_percent_flashback_buf_partial_full                50
_pga_large_extent_size                             1048576
_pga_max_size                                      449617920
_pgactx_cap_stacks                                 FALSE
_pivot_implementation_method                       CHOOSE
_pkt_enable                                        FALSE
_pkt_pmon_interval                                 50
_pkt_start                                         FALSE
_plan_outline_data                                 TRUE
_plan_verify_improvement_margin                    150
_plan_verify_local_time_limit                      0
_plsql_anon_block_code_type                        INTERPRETED
_plsql_cache_enable                                TRUE
_plsql_dump_buffer_events
_plsql_max_stack_size                              0
_plsql_minimum_cache_hit_percent                   20
_plsql_native_frame_threshold                      4294967294
_plsql_nvl_optimize                                FALSE
_pmon_dead_blkrs_alive_chk_rate_secs               3
_pmon_dead_blkrs_max_blkrs                         200
_pmon_dead_blkrs_max_cleanup_attempts              5
_pmon_dead_blkrs_scan_rate_secs                    3
_pmon_enable_dead_blkrs                            TRUE
_pmon_load_constants                               300,192,64,3,10,10,0,0
_pmon_max_consec_posts                             5
_post_wait_queues_dynamic_queues                   40
_post_wait_queues_num_per_class
_pqq_debug_txn_act                                 FALSE
_pqq_enabled                                       TRUE
_pre_rewrite_push_pred                             TRUE
_precompute_gid_values                             TRUE
_pred_move_around                                  TRUE
_predicate_elimination_enabled                     TRUE
_prescomm                                          FALSE
_print_refresh_schedule                            false
_private_memory_address
_project_view_columns                              TRUE
_projection_pushdown                               TRUE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_projection_pushdown_debug                         0
_prop_old_enabled                                  FALSE
_protect_frame_heaps                               FALSE
_ptn_cache_threshold                               0
_push_join_predicate                               TRUE
_push_join_union_view                              TRUE
_push_join_union_view2                             TRUE
_px_adaptive_offload_pecentage                     0
_px_adaptive_offload_threshold                     10
_px_async_getgranule                               FALSE
_px_bind_peek_sharing                              TRUE
_px_broadcast_fudge_factor                         100
_px_buffer_ttl                                     30
_px_chunklist_count_ratio                          8
_px_compilation_debug                              0
_px_compilation_trace                              0
_px_dump_12805_source                              TRUE
_px_dynamic_opt                                    TRUE
_px_dynamic_sample_size                            50
_px_execution_services_enabled                     TRUE
_px_freelist_latch_divisor                         2
_px_gim_factor                                     100
_px_granule_batch_size                             10
_px_granule_randomize                              TRUE
_px_granule_size                                   1000000
_px_hold_time                                      0
_px_index_sampling                                 200
_px_index_sampling_objsize                         TRUE
_px_io_process_bandwidth                           200
_px_io_system_bandwidth                            0
_px_kxib_tracing                                   0
_px_load_factor                                    300
_px_load_publish_interval                          200
_px_loc_msg_cost                                   1000
_px_max_granules_per_slave                         100
_px_max_map_val                                    32
_px_max_message_pool_pct                           40
_px_min_granules_per_slave                         13
_px_minus_intersect                                TRUE
_px_net_msg_cost                                   10000
_px_no_granule_sort                                FALSE
_px_no_stealing                                    FALSE
_px_nss_planb                                      TRUE
_px_numa_stealing_enabled                          TRUE
_px_numa_support_enabled                           TRUE
_px_partition_scan_enabled                         TRUE
_px_partition_scan_threshold                       64
_px_proc_constrain                                 TRUE
_px_pwg_enabled                                    TRUE
_px_round_robin_rowcnt                             1000
_px_rownum_pd                                      TRUE
_px_send_timeout                                   300
_px_slaves_share_cursors                           0
_px_trace                                          none
_px_ual_serial_input                               TRUE
_px_xtgranule_size                                 10000
_qa_control                                        0

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_qa_lrg_type                                       0
_query_cost_rewrite                                TRUE
_query_execution_cache_max_size                    131072
_query_mmvrewrite_maxcmaps                         20
_query_mmvrewrite_maxdmaps                         10
_query_mmvrewrite_maxinlists                       5
_query_mmvrewrite_maxintervals                     5
_query_mmvrewrite_maxpreds                         10
_query_mmvrewrite_maxqryinlistvals                 500
_query_mmvrewrite_maxregperm                       512
_query_on_physical                                 TRUE
_query_rewrite_1                                   TRUE
_query_rewrite_2                                   TRUE
_query_rewrite_drj                                 TRUE
_query_rewrite_expression                          TRUE
_query_rewrite_fpc                                 TRUE
_query_rewrite_fudge                               90
_query_rewrite_jgmigrate                           TRUE
_query_rewrite_maxdisjunct                         257
_query_rewrite_or_error                            FALSE
_query_rewrite_setopgrw_enable                     TRUE
_query_rewrite_vop_cleanup                         TRUE
_queue_buffer_max_dump_len                         65536
_rbr_ckpt_tracing                                  0
_rcfg_disable_verify                               TRUE
_rcfg_parallel_fixwrite                            TRUE
_rcfg_parallel_replay                              TRUE
_rcfg_parallel_verify                              TRUE
_rdbms_compatibility                               10.1
_rdbms_internal_fplib_enabled                      FALSE
_rdbms_internal_fplib_raise_errors                 FALSE
_read_only_violation_dump_to_trace                 FALSE
_read_only_violation_max_count                     500
_read_only_violation_max_count_per_module          100
_readable_standby_sync_timeout                     10
_real_time_apply_sim                               0
_realfree_heap_max_size                            32768
_realfree_heap_mode                                0
_realfree_heap_pagesize_hint                       65536
_reasonable_scn_offset_seconds                     0
_recoverable_recovery_batch_percent                50
_recovery_asserts                                  FALSE
_recovery_percentage                               50
_recovery_read_limit                               1024
_recovery_skip_cfseq_check                         FALSE
_recovery_verify_writes                            FALSE
_recursive_imu_transactions                        FALSE
_recursive_with_max_recursion_level                0
_redo_compatibility_check                          FALSE
_redo_read_from_memory                             TRUE
_redo_transport_compress_all                       TRUE
_redo_transport_sanity_check                       0
_redo_transport_stall_time                         360
_redo_transport_stall_time_long                    3600
_redo_transport_stream_test                        TRUE
_redo_transport_stream_writes                      TRUE
_redo_transport_vio_size_req                       4294967294

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_reduce_sby_log_scan                               TRUE
_release_insert_threshold                          5
_reliable_block_sends                              TRUE
_relocation_commit_batch_size                      8
_remove_aggr_subquery                              TRUE
_rep_base_path
_replace_virtual_columns                           TRUE
_reset_maxcap_history                              10
_resource_manager_always_off                       FALSE
_resource_manager_always_on                        TRUE
_resource_manager_plan
_restore_maxopenfiles                              8
_restore_spfile
_result_cache_auto_dml_monitoring_duration         15
_result_cache_auto_dml_monitoring_slots            4
_result_cache_auto_dml_threshold                   16
_result_cache_auto_dml_trend_threshold             20
_result_cache_auto_execution_threshold             1
_result_cache_auto_size_threshold                  100
_result_cache_auto_time_distance                   300
_result_cache_auto_time_threshold                  1000
_result_cache_block_size                           1024
_result_cache_copy_block_count                     1
_result_cache_global                               TRUE
_result_cache_timeout                              10
_reuse_index_loop                                  5
_right_outer_hash_enable                           TRUE
_rm_cluster_interconnects
_rm_numa_sched_enable                              FALSE
_rm_numa_simulation_cpus                           0
_rm_numa_simulation_pgs                            0
_rman_io_priority                                  3
_rman_restore_through_link                         FALSE
_rollback_segment_count                            0
_rollback_segment_initial                          1
_rollback_stopat                                   0
_row_cache_cursors                                 20
_row_cr                                            TRUE
_row_locking                                       always
_row_shipping_explain                              FALSE
_row_shipping_threshold                            80
_rowsource_execution_statistics                    FALSE
_rowsource_profiling_statistics                    TRUE
_rowsource_statistics_sampfreq                     128
_rowsrc_trace_level                                0
_rta_sync_wait_timeout                             10
_rtc_infeasible_threshold                          25
_sample_rows_per_block                             4
_scatter_gcs_resources                             FALSE
_scatter_gcs_shadows                               FALSE
_sched_delay_max_samples                           4
_sched_delay_measurement_sleep_us                  1000
_sched_delay_os_tick_granularity_us                16000
_sched_delay_sample_collection_thresh_ms           200
_sched_delay_sample_interval_ms                    1000
_scn_wait_interface_max_backoff_time_secs          600
_scn_wait_interface_max_timeout_secs               2147483647

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_sdiag_crash                                       NONE
_sec_enable_test_rpcs                              FALSE
_second_spare_parameter
_securefile_timers                                 FALSE
_securefiles_bulkinsert                            FALSE
_securefiles_concurrency_estimate                  12
_securefiles_fg_retry                              100
_securefiles_forceflush                            FALSE
_securefiles_memory_percentofSGA                   20
_select_any_dictionary_security_enabled            FALSE
_selectivity_for_srf_enabled                       FALSE
_selfjoin_mv_duplicates                            TRUE
_selftune_checkpoint_write_pct                     3
_selftune_checkpointing_lag                        300
_sem_per_semid
_send_ast_to_foreground                            AUTO
_send_close_with_block                             TRUE
_send_requests_to_pi                               TRUE
_serial_direct_read                                auto
_serial_recovery                                   FALSE
_serializable                                      FALSE
_serialize_lgwr_sync_io                            FALSE
_service_cleanup_timeout                           30
_session_allocation_latches                        32
_session_cached_instantiations                     60
_session_context_size                              10000
_session_idle_bit_latches                          0
_session_page_extent                               2048
_session_wait_history                              10
_set_mgd_recovery_state                            0
_seventeenth_spare_parameter
_seventh_spare_parameter
_sga_clear_dump                                    FALSE
_sga_early_trace                                   0
_sga_locking                                       none
_shared_io_pool_buf_size                           1048576
_shared_io_pool_debug_trc                          0
_shared_io_pool_size                               0
_shared_io_set_value                               FALSE
_shared_iop_max_size                               536870912
_shared_pool_max_size                              0
_shared_pool_minsize_on                            FALSE
_shared_pool_reserved_min_alloc                    4400
_shared_pool_reserved_pct                          5
_shared_server_load_balance                        0
_shared_server_num_queues                          3
_shmprotect                                        0
_short_stack_timeout_ms                            30000
_show_mgd_recovery_state                           FALSE
_shrunk_aggs_disable_threshold                     60
_shrunk_aggs_enabled                               TRUE
_shutdown_completion_timeout_mins                  60
_side_channel_batch_size                           200
_side_channel_batch_timeout                        6
_side_channel_batch_timeout_ms                     500
_simple_view_merging                               TRUE
_simulate_disk_sectorsize                          0

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_simulate_io_wait                                  0
_simulate_mem_transfer                             FALSE
_simulator_bucket_mindelta                         8192
_simulator_internal_bound                          10
_simulator_lru_rebalance_sizthr                    5
_simulator_lru_rebalance_thresh                    10240
_simulator_lru_scan_count                          8
_simulator_pin_inval_maxcnt                        16
_simulator_reserved_heap_count                     4096
_simulator_reserved_obj_count                      1024
_simulator_sampling_factor                         2
_simulator_upper_bound_multiple                    2
_single_process                                    FALSE
_siop_flashback_scandepth                          20
_siop_perc_of_bc_x100                              2500
_sixteenth_spare_parameter
_sixth_spare_parameter
_skgxp_ctx_flags1                                  0
_skgxp_ctx_flags1mask                              0
_skgxp_dynamic_protocol                            0
_skgxp_gen_ant_off_rpc_timeout_in_sec              30
_skgxp_gen_ant_ping_misscount                      3
_skgxp_gen_rpc_no_path_check_in_sec                5
_skgxp_gen_rpc_timeout_in_sec                      300
_skgxp_inets
_skgxp_min_rpc_rcv_zcpy_len                        0
_skgxp_min_zcpy_len                                0
_skgxp_reaping                                     1000
_skgxp_rgn_ports                                   0
_skgxp_spare_param1
_skgxp_spare_param2
_skgxp_spare_param3
_skgxp_spare_param4
_skgxp_spare_param5
_skgxp_udp_ach_reaping_time                        120
_skgxp_udp_ack_delay                               0
_skgxp_udp_enable_dynamic_credit_mgmt              0
_skgxp_udp_hiwat_warn                              1000
_skgxp_udp_interface_detection_time_secs           60
_skgxp_udp_keep_alive_ping_timer_secs              300
_skgxp_udp_lmp_mtusize                             0
_skgxp_udp_lmp_on                                  FALSE
_skgxp_udp_timed_wait_buffering                    1024
_skgxp_udp_timed_wait_seconds                      5
_skgxp_udp_use_tcb                                 TRUE
_skgxp_zcpy_flags                                  0
_skgxpg_last_parameter                             26
_skip_assume_msg                                   TRUE
_skip_trstamp_check                                FALSE
_slave_mapping_enabled                             TRUE
_slave_mapping_group_size                          0
_slave_mapping_skew_ratio                          2
_small_table_threshold                             7213
_smm_advice_enabled                                TRUE
_smm_advice_log_size                               0
_smm_auto_cost_enabled                             TRUE
_smm_auto_max_io_size                              248

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_smm_auto_min_io_size                              56
_smm_bound                                         0
_smm_control                                       0
_smm_freeable_retain                               5120
_smm_isort_cap                                     102400
_smm_max_size                                      219540
_smm_min_size                                      1024
_smm_px_max_size                                   1097728
_smm_retain_size                                   0
_smm_trace                                         0
_smon_internal_errlimit                            100
_smon_undo_seg_rescan_limit                        10
_smu_debug_mode                                    0
_smu_error_simulation_site                         0
_smu_error_simulation_type                         0
_smu_timeouts
_sort_elimination_cost_ratio                       0
_sort_multiblock_read_count                        2
_sort_spill_threshold                              0
_space_align_size                                  1048576
_spare_test_parameter                              0
_spawn_diag_opts                                   0
_spawn_diag_thresh_secs                            30
_spin_count                                        2000
_spr_max_rules                                     10000
_spr_push_pred_refspr                              TRUE
_spr_use_AW_AS                                     TRUE
_spr_use_hash_table                                FALSE
_sql_analyze_enable_auto_txn                       FALSE
_sql_analyze_parse_model                           2
_sql_compatibility                                 0
_sql_connect_capability_override                   0
_sql_connect_capability_table
_sql_hash_debug                                    0
_sql_model_unfold_forloops                         RUN_TIME
_sql_ncg_mode                                      OFF
_sql_plan_management_control                       0
_sqlexec_progression_cost                          1000
_sqlmon_binds_xml_format                           default
_sqlmon_max_plan                                   640
_sqlmon_max_planlines                              300
_sqlmon_recycle_time                               60
_sqlmon_threshold                                  5
_sqltune_category_parsed                           DEFAULT
_srvntfn_job_deq_timeout                           60
_srvntfn_jobsubmit_interval                        3
_srvntfn_max_concurrent_jobs                       20
_srvntfn_q_msgcount                                50
_srvntfn_q_msgcount_inc                            100
_sscr_dir
_sscr_osdir
_sta_control                                       0
_stack_guard_level                                 0
_standby_causal_heartbeat_timeout                  2
_standby_flush_mode                                SLFLUSH
_standby_implicit_rcv_timeout                      1
_standby_switchover_timeout                        120

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_static_backgrounds
_statistics_based_srf_enabled                      TRUE
_step_down_limit_in_pct                            1
_streams_pool_max_size                             0
_subquery_pruning_cost_factor                      20
_subquery_pruning_enabled                          TRUE
_subquery_pruning_mv_enabled                       FALSE
_subquery_pruning_reduction                        50
_switchover_to_standby_option                      OPEN_ONE
_switchover_to_standby_switch_log                  TRUE
_swrf_metric_frequent_mode                         FALSE
_swrf_mmon_dbfus                                   TRUE
_swrf_mmon_flush                                   TRUE
_swrf_mmon_metrics                                 TRUE
_swrf_on_disk_enabled                              TRUE
_swrf_test_action                                  0
_swrf_test_dbfus                                   FALSE
_sync_primary_wait_time                            5
_synonym_repoint_tracing                           FALSE
_sysaux_test_param                                 1
_system_api_interception_debug                     FALSE
_system_index_caching                              0
_system_trig_enabled                               TRUE
_ta_lns_wait_for_arch_log                          20
_table_lookup_prefetch_size                        40
_table_lookup_prefetch_thresh                      2
_table_scan_cost_plus_one                          TRUE
_tablespaces_per_transaction                       10
_target_rba_max_lag_percentage                     81
_tdb_debug_mode                                    16
_temp_tran_block_threshold                         100
_temp_tran_cache                                   TRUE
_tenth_spare_parameter
_test_ksusigskip                                   5
_test_param_1                                      25
_test_param_2
_test_param_3
_test_param_4
_test_param_5                                      25
_test_param_6                                      0
_third_spare_parameter
_thirteenth_spare_parameter
_threshold_alerts_enable                           1
_timemodel_collection                              TRUE
_timeout_actions_enabled                           TRUE
_timer_precision                                   10
_total_large_extent_memory                         0
_tq_dump_period                                    0
_trace_buffer_wait_timeouts                        0
_trace_buffers                                     ALL:256
_trace_dump_all_procs                              FALSE
_trace_dump_client_buckets                         TRUE
_trace_dump_cur_proc_only                          FALSE
_trace_dump_static_only                            FALSE
_trace_events
_trace_files_public                                FALSE
_trace_kqlidp                                      FALSE

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_trace_navigation_scope                            global
_trace_pin_time                                    0
_trace_pool_size
_trace_processes                                   ALL
_trace_virtual_columns                             FALSE
_transaction_auditing                              TRUE
_transaction_recovery_servers                      0
_transient_logical_clear_hold_mrp_bit              FALSE
_truncate_optimization_enabled                     TRUE
_tsenc_tracing                                     0
_tsm_connect_string
_tsm_disable_auto_cleanup                          1
_tstz_localtime_bypass                             FALSE
_tts_allow_charset_mismatch                        FALSE
_twelfth_spare_parameter
_twentieth_spare_parameter
_two_pass                                          TRUE
_two_pass_reverse_polish_enabled                   TRUE
_uga_cga_large_extent_size                         262144
_ultrafast_latch_statistics                        TRUE
_undo_autotune                                     TRUE
_undo_block_compression                            TRUE
_undo_debug_mode                                   0
_undo_debug_usage                                  0
_union_rewrite_for_gs                              YES_GSET_MVS
_unnest_subquery                                   TRUE
_unused_block_compression                          TRUE
_update_datafile_headers_with_space_information    FALSE
_use_adaptive_log_file_sync                        TRUE
_use_best_fit                                      FALSE
_use_column_stats_for_function                     TRUE
_use_hybrid_encryption_mode                        FALSE
_use_ism                                           TRUE
_use_ism_for_pga                                   TRUE
_use_nosegment_indexes                             FALSE
_use_platform_compression_lib                      FALSE
_use_platform_encryption_lib                       TRUE
_use_realfree_heap                                 TRUE
_use_seq_process_cache                             TRUE
_use_vector_post                                   TRUE
_use_zero_copy_io                                  TRUE
_validate_flashback_database                       FALSE
_validate_readmem_redo                             OFF
_vendor_lib_loc
_verify_fg_log_checksum                            FALSE
_verify_flashback_redo                             TRUE
_verify_undo_quota                                 FALSE
_very_large_object_threshold                       500
_very_large_partitioned_table                      1024
_virtual_column_overload_allowed                   TRUE
_vkrm_schedule_interval                            10
_vktm_assert_thresh                                30
_wait_breakup_threshold_csecs                      600
_wait_breakup_time_csecs                           300
_wait_for_sync                                     TRUE
_wait_samples_max_sections                         40
_wait_samples_max_time_secs                        120

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_wait_tracker_interval_secs                        10
_wait_tracker_num_intervals                        0
_wait_yield_hp_mode                                yield
_wait_yield_mode                                   yield
_wait_yield_sleep_freq                             100
_wait_yield_sleep_time_msecs                       1
_wait_yield_yield_freq                             20
_walk_insert_threshold                             0
_watchpoint_on                                     FALSE
_wcr_control                                       0
_windowfunc_optimization_settings                  0
_with_subquery                                     OPTIMIZER
_write_clones                                      3
_xengem_devname                                    DEFAULT
_xengem_diagmode                                   OFF
_xengem_enabled                                    TRUE
_xpl_peeked_binds_log_size                         8192
_xpl_trace                                         0
_xsolapi_auto_materialization_bound                20
_xsolapi_auto_materialization_type                 PRED_AND_RC
_xsolapi_build_trace                               FALSE
_xsolapi_debug_output                              SUPPRESS
_xsolapi_densify_cubes                             TABULAR
_xsolapi_dimension_group_creation                  OVERFETCH
_xsolapi_dml_trace
_xsolapi_fetch_type                                PARTIAL
_xsolapi_fix_vptrs                                 TRUE
_xsolapi_generate_with_clause                      FALSE
_xsolapi_hierarchy_value_type                      unique
_xsolapi_load_at_process_start                     NEVER
_xsolapi_materialization_rowcache_min_rows_for_use 1
_xsolapi_materialize_sources                       TRUE
_xsolapi_metadata_reader_mode                      DEFAULT
_xsolapi_odbo_mode                                 FALSE
_xsolapi_opt_aw_position                           TRUE
_xsolapi_optimize_suppression                      TRUE
_xsolapi_precompute_subquery                       TRUE
_xsolapi_remove_columns_for_materialization        TRUE
_xsolapi_set_nls                                   TRUE
_xsolapi_share_executors                           TRUE
_xsolapi_source_trace                              FALSE
_xsolapi_sql_all_multi_join_non_base_hints
_xsolapi_sql_all_non_base_hints
_xsolapi_sql_auto_dimension_hints                  FALSE
_xsolapi_sql_auto_measure_hints                    TRUE
_xsolapi_sql_dimension_hints
_xsolapi_sql_enable_aw_join                        TRUE
_xsolapi_sql_enable_aw_qdr_merge                   TRUE
_xsolapi_sql_hints
_xsolapi_sql_measure_hints
_xsolapi_sql_minus_threshold                       1000
_xsolapi_sql_optimize                              TRUE
_xsolapi_sql_prepare_stmt_cache_size               16
_xsolapi_sql_remove_columns                        TRUE
_xsolapi_sql_result_set_cache_size                 32
_xsolapi_sql_symmetric_predicate                   TRUE
_xsolapi_sql_top_dimension_hints

KSPPINM                                            KSPPSTVL
-------------------------------------------------- --------------------------------------------------
_xsolapi_sql_top_measure_hints
_xsolapi_sql_use_bind_variables                    TRUE
_xsolapi_stringify_order_levels                    FALSE
_xsolapi_support_mtm                               FALSE
_xsolapi_suppression_aw_mask_threshold             1000
_xsolapi_suppression_chunk_size                    4000
_xsolapi_use_models                                TRUE
_xsolapi_use_olap_dml                              TRUE
_xsolapi_use_olap_dml_for_rank                     TRUE
_xt_coverage                                       none
_xt_trace                                          none
_xtbuffer_size                                     0
_xtts_allow_pre10                                  FALSE
_xtts_set_platform_info                            FALSE

2405 rows selected.

SQL>