Profile Resource - Name Resource Limit
Profile Resource - Name Resource Limit
Profile Resource - Name Resource Limit
Username User ID Password Account Status Lock date Expiry date Def Tablespace Created Assgn Profile Consumer Grp Ext Name
AIM_DBA 49 0FAD92BC1D2E68E6 OPEN SYSTEM 30-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
AMDBA 48 E5D0C7C57D6D2AB2 LOCKED 28-MAY-10 SYSTEM 30-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
AMDOCS 91 52048C6380CA5DB0 EXPIRED & LOCKED 23-MAR-10 08-AUG-09 POOL_DATA 06-AUG-09 DEFAULT DEFAULT_CONSUMER_GRO
ANONYMOUS 36 anonymous EXPIRED & LOCKED 25-SEP-08 25-SEP-08 SYSAUX 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
BDCDBA 80 100693545F41DDDE LOCKED 28-MAY-10 SYSTEM 06-MAR-09 DEFAULT DEFAULT_CONSUMER_GRO
BRO 71 C04AE96F3FDAE0F8 LOCKED 10-MAY-10 SYSTEM 23-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
CDLABPOWN 54 1BB3F39BF93B85FF OPEN POOL_DATA 07-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
CDLCODE 55 0BE99E015A0B9C9D OPEN POOL_DATA 07-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
CDLCODEOWN 56 450C1F62A6825A32 OPEN POOL_DATA 07-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
CDLOMS 57 7DF6593B86CFC6F6 OPEN POOL_DATA 07-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
CDLOMSOWN 58 A69778C9E1A63F87 OPEN POOL_DATA 07-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
CDLPC 59 88F646B141334D4A OPEN POOL_DATA 07-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
CDLPCOWN 60 4B8D6033DC4988D0 OPEN POOL_DATA 07-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
CDLREF 61 9DF84EB5F8A87D58 OPEN POOL_DATA 07-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
CDLREFOWN 62 5ED2F8F2AA515A91 OPEN POOL_DATA 07-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
CRMSALES 84 07D08B3C35C838C6 OPEN OMS_BIG_DATA1 03-APR-09 DEFAULT DEFAULT_CONSUMER_GRO
DBEXTRACT 117 6F683BE1DFDDFD88 OPEN INTERFASES 13-OCT-11 DEFAULT DEFAULT_CONSUMER_GRO
DBEXTRACT_CONN 119 696BBA34136BBA11 OPEN INTERFASES 13-OCT-11 DEFAULT DEFAULT_CONSUMER_GRO
DBEXTRACT_USER 118 F17BB8585A36D143 OPEN INTERFASES 13-OCT-11 DEFAULT DEFAULT_CONSUMER_GRO
DBSNMP 24 698C4AC4BDE42C1B OPEN SYSAUX 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
DBTOOL 104 AC9E793F32C23AF2 OPEN POOL_DATA 10-MAY-10 DEFAULT DEFAULT_CONSUMER_GRO
DEVMETRICAPROV 134 D2BE22B03C23FE30 OPEN INTERFASES 08-APR-13 DEFAULT DEFAULT_CONSUMER_GRO
DIP 19 CE4A36B8E06CA59C EXPIRED & LOCKED 25-SEP-08 SYSTEM 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
EDW 74 5BF9667D6BE9F3DB OPEN POOL_DATA 18-DEC-08 DEFAULT DEFAULT_CONSUMER_GRO
ENVISION 124 C88B7CF0F26F2D0A OPEN SYSTEM 27-AUG-12 DEFAULT DEFAULT_CONSUMER_GRO
EXFSYS 34 66F4EF5650C20355 EXPIRED & LOCKED 25-SEP-08 25-SEP-08 SYSAUX 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
HOTSPOTS 141 2BBB33281B0FFA61 OPEN INTERFASES 19-MAY-14 DEFAULT DEFAULT_CONSUMER_GRO
INTRAWAYAMX 130 9254A0CFDE845779 OPEN INTERFASES 08-MAR-13 DEFAULT DEFAULT_CONSUMER_GRO
JMON 121 C1532D4713CD93EE OPEN INTERFASES 02-DEC-11 DEFAULT DEFAULT_CONSUMER_GRO
MDSYS 43 72979A94BAD2AF80 EXPIRED & LOCKED 25-SEP-08 25-SEP-08 SYSAUX 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
METRICAOM 101 6D481E4A0609B049 OPEN INTERFASES 03-FEB-10 DEFAULT DEFAULT_CONSUMER_GRO
MGMT_VIEW 46 22D40257CD10624D OPEN SYSTEM 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
OMSAMDOCS 135 A3905B4C5898644E OPEN INTERFASES 02-JUL-13 DEFAULT DEFAULT_CONSUMER_GRO
OMSAUTODSGN 138 DE19704DC0452A7C OPEN INTERFASES 18-JUL-13 DEFAULT DEFAULT_CONSUMER_GRO
OMSCDIG 125 56C5EBC36779B724 OPEN INTERFASES 29-NOV-12 DEFAULT DEFAULT_CONSUMER_GRO
OMSCRXA 127 D7A3799E5C9CFB51 OPEN INTERFASES 06-DEC-12 DEFAULT DEFAULT_CONSUMER_GRO
OMSDIGWEB 136 8136F84887659BC0 OPEN INTERFASES 18-JUL-13 DEFAULT DEFAULT_CONSUMER_GRO
OMSOGS 106 A8364647B21F9720 OPEN INTERFASES 06-AUG-10 DEFAULT DEFAULT_CONSUMER_GRO
OMSREBOTES 137 DFDC74307D183D82 OPEN INTERFASES 18-JUL-13 DEFAULT DEFAULT_CONSUMER_GRO
OMSREP 85 379FF476ADD6E894 OPEN INTERFASES 13-APR-09 DEFAULT DEFAULT_CONSUMER_GRO
OMSREPTWC 143 3D30461E269D0C62 OPEN 09-NOV-14 OMS_BIG_DATA1 10-SEP-14 CONTROLOMS DEFAULT_CONSUMER_GRO
OMSSEL 77 4475A28AC30FA111 LOCKED 28-MAY-10 SYSTEM 22-JAN-09 DEFAULT DEFAULT_CONSUMER_GRO
OMSTVIRTUAL 126 389F995AF34B52EF OPEN INTERFASES 05-DEC-12 DEFAULT DEFAULT_CONSUMER_GRO
OMSUSR 94 5E93A2DB63CC1CDC OPEN INTERFASES 29-SEP-09 DEFAULT DEFAULT_CONSUMER_GRO
OPS$DAEMON 105 EXTERNAL OPEN SYSTEM 22-JUL-10 DEFAULT DEFAULT_CONSUMER_GRO
OPS$ORACLE 72 EXTERNAL OPEN SYSTEM 31-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
ORABCK 111 103A0A2C671DFB99 OPEN SYSTEM 15-DEC-10 DEFAULT DEFAULT_CONSUMER_GRO
ORATEST 47 B29ADCD82A9A1D7D OPEN SYSTEM 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
ORDPLUGINS 41 88A2B2C183431F00 EXPIRED & LOCKED 25-SEP-08 25-SEP-08 SYSAUX 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
ORDSYS 40 7EFA02EC7EA6B86F EXPIRED & LOCKED 25-SEP-08 25-SEP-08 SYSAUX 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
OUTLN 11 4A3BA55E08595C81 EXPIRED & LOCKED 25-SEP-08 25-SEP-08 SYSTEM 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
PA_AWR_USER 88 1F71EAF720067B66 LOCKED 28-MAY-10 PERFSTAT 29-JUL-09 DEFAULT DEFAULT_CONSUMER_GRO
REPBALANCEO 100 3C033CCDD37EBD4D OPEN INTERFASES 08-DEC-09 DEFAULT DEFAULT_CONSUMER_GRO
SASOMS 120 D3685499E26C16E7 OPEN INTERFASES 29-NOV-11 DEFAULT DEFAULT_CONSUMER_GRO
SAYDOT_USR 110 D5C205C87396F8E0 OPEN INTERFASES 14-DEC-10 DEFAULT DEFAULT_CONSUMER_GRO
SI_INFORMTN_SCHEMA 42 84B8CBCA4D477FA3 EXPIRED & LOCKED 25-SEP-08 25-SEP-08 SYSAUX 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
SYS 0 03810891F2E08463 OPEN SYSTEM 25-SEP-08 DEFAULT SYS_GROUP
SYSMAN 44 2D77FF4D9AC5562E OPEN SYSAUX 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
SYSTEM 5 FDBAB2F52F48CF36 OPEN SYSTEM 25-SEP-08 DEFAULT SYS_GROUP
TD06527 123 B82468F5733346EC OPEN 21-NOV-14 POOL_DATA 10-APR-12 CONTROLOMS DEFAULT_CONSUMER_GRO
TD13594 107 9D8E2FF804FDF949 OPEN 05-DEC-14 POOL_DATA 10-SEP-10 CONTROLOMS DEFAULT_CONSUMER_GRO
TD15941 82 B5862EB50D92FBD6 OPEN POOL_DATA 13-MAR-09 DEFAULT DEFAULT_CONSUMER_GRO
TD17152 90 03EC00C961C117E3 OPEN 28-SEP-09 POOL_DATA 30-JUL-09 CONTROLOMS DEFAULT_CONSUMER_GRO
TD17165 99 8602A7475F9106D8 OPEN 08-FEB-10 POOL_DATA 23-NOV-09 CONTROLOMS DEFAULT_CONSUMER_GRO
TD17719 97 D472EFEF8D324338 EXPIRED 23-NOV-09 POOL_DATA 23-NOV-09 CONTROLOMS DEFAULT_CONSUMER_GRO
TD17827 116 1A99C1CFF0AFF69D EXPIRED INTERFASES 21-JUL-11 CONTROLOMS DEFAULT_CONSUMER_GRO
TD18113 96 8D9CF79FE5DF4021 OPEN 27-APR-10 POOL_DATA 23-NOV-09 CONTROLOMS DEFAULT_CONSUMER_GRO
TD18190 108 AA504CCDA9221D28 LOCKED(TIMED) 17-JUL-12 05-FEB-12 POOL_DATA 10-SEP-10 CONTROLOMS DEFAULT_CONSUMER_GRO
TD18487 86 184E747D03437204 OPEN 02-NOV-14 OMS_BIG_DATA1 01-MAY-09 CONTROLOMS DEFAULT_CONSUMER_GRO
TD18505 109 53E3BBEF1D510DA9 OPEN 26-OCT-14 POOL_DATA 10-SEP-10 CONTROLOMS DEFAULT_CONSUMER_GRO
TD18509 128 E4FD658AEDE0C3EE OPEN 23-APR-13 INTERFASES 01-FEB-13 CONTROLOMS DEFAULT_CONSUMER_GRO
TD18513 103 0BF0AC7DC2C93989 OPEN 11-MAY-10 POOL_DATA 03-MAR-10 CONTROLOMS DEFAULT_CONSUMER_GRO
TD18927 98 C478036FADCFA2E5 LOCKED 03-JUN-14 24-APR-12 POOL_DATA 23-NOV-09 ELIMINADO DEFAULT_CONSUMER_GRO
TD19878 102 A13AB1D3F486E8BF EXPIRED 09-MAY-12 POOL_DATA 03-MAR-10 CONTROLOMS DEFAULT_CONSUMER_GRO
TD21228 142 916654BD5247C3A9 EXPIRED POOL_DATA 29-AUG-14 CONTROLOMS DEFAULT_CONSUMER_GRO
TD21474 129 8A6E0FC2E2D86D30 OPEN 23-APR-13 INTERFASES 14-FEB-13 CONTROLOMS DEFAULT_CONSUMER_GRO
TIGER_PROD_ADR 53 BD3C7D455DE6A8DD OPEN POOL_DATA 06-OCT-08 DEFAULT DEFAULT_CONSUMER_GRO
TIGER_REP 50 317530D9278E5D3A OPEN SYSTEM 30-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
TRACKOMS 140 372BCCD33139E717 OPEN INTERFASES 14-FEB-14 DEFAULT DEFAULT_CONSUMER_GRO
TSMSYS 21 3DF26A8B17D0F29F EXPIRED & LOCKED 25-SEP-08 25-SEP-08 SYSTEM 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
TVMAIL 115 BA9D7F04725992F7 OPEN INTERFASES 17-FEB-11 DEFAULT DEFAULT_CONSUMER_GRO
VOLDBA 79 2748220CA116C775 LOCKED 10-MAY-10 POOL_DATA 13-FEB-09 DEFAULT DEFAULT_CONSUMER_GRO
WMSYS 25 7C9BA362F8314299 EXPIRED & LOCKED 25-SEP-08 25-SEP-08 SYSAUX 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
XDB 35 88D8364765FCE6AF EXPIRED & LOCKED 25-SEP-08 25-SEP-08 SYSAUX 25-SEP-08 DEFAULT DEFAULT_CONSUMER_GRO
Control: Test Access to Data Modification Utilities (SQL*Plus)
Display Product_Profile
Control: Test Access to Privileged IT Functions
USER_NAME FAILURE
BY ACCESS
Control: Test for Host-Based Authentication Methods
Control: Test Monitoring of User Access
Control: Test Password Settings
Num Name Type Value Isdefault Isses_modifiable Issys_modifiable Ismodified Isadjusted Description Ordinal Update_Comment
2 tracefile_identifier 2 TRUE TRUE FALSE FALSE FALSE trace file custom id 0
25 lock_name_space 2 TRUE FALSE FALSE FALSE FALSE lock name space used 0
26 processes 3 4000 FALSE FALSE FALSE FALSE FALSE user processes 1
27 sessions 3 4405 FALSE FALSE FALSE FALSE FALSE user and system sess 1
28 timed_statistics 1 TRUE TRUE TRUE IMMEDIATE FALSE FALSE maintain internal ti 1
29 timed_os_statistics 3 0 TRUE TRUE IMMEDIATE FALSE FALSE internal os statisti 1
30 resource_limit 1 FALSE TRUE FALSE IMMEDIATE FALSE FALSE master switch for re 1
31 license_max_sessions 3 0 TRUE FALSE IMMEDIATE FALSE FALSE maximum number of no 1
32 license_sessions_war 3 0 TRUE FALSE IMMEDIATE FALSE FALSE warning level for nu 1
54 cpu_count 3 24 TRUE FALSE IMMEDIATE FALSE FALSE number of CPUs for t 1
59 instance_groups 2 TRUE FALSE FALSE FALSE FALSE list of instance gro 0
60 event 2 TRUE FALSE FALSE FALSE FALSE debug event control 1
69 sga_max_size 6 12582912000 FALSE FALSE FALSE FALSE FALSE max total SGA size 1 internally adjusted
72 _enable_NUMA_optimiz 1 FALSE FALSE FALSE FALSE FALSE FALSE Enable NUMA specific 1
73 pre_page_sga 1 FALSE TRUE FALSE FALSE FALSE FALSE pre-page sga for pro 1
74 shared_memory_addres 3 0 TRUE FALSE FALSE FALSE FALSE SGA starting address 1
75 hi_shared_memory_add 3 0 TRUE FALSE FALSE FALSE FALSE SGA starting address 1
76 use_indirect_data_bu 1 FALSE TRUE FALSE FALSE FALSE FALSE Enable indirect data 1
78 lock_sga 1 FALSE TRUE FALSE FALSE FALSE FALSE Lock entire SGA in p 1
111 shared_pool_size 6 2634022912 FALSE FALSE IMMEDIATE FALSE FALSE size in bytes of sha 1
113 large_pool_size 6 67108864 FALSE FALSE IMMEDIATE FALSE FALSE size in bytes of lar 1
115 java_pool_size 6 67108864 FALSE FALSE IMMEDIATE FALSE FALSE size in bytes of jav 1
117 streams_pool_size 6 167772160 FALSE FALSE IMMEDIATE FALSE FALSE size in bytes of the 1
119 shared_pool_reserved 6 131701145 TRUE FALSE FALSE FALSE FALSE size in bytes of res 1
122 java_soft_sessionspa 3 0 TRUE FALSE FALSE FALSE FALSE warning limit on siz 1
123 java_max_sessionspac 3 0 TRUE FALSE FALSE FALSE FALSE max allowed size in 1
131 spfile 2 /oravl01/oracle/10.2 TRUE FALSE FALSE FALSE FALSE server parameter fil 1
132 instance_type 2 RDBMS TRUE FALSE FALSE FALSE FALSE type of instance to 1
149 trace_enabled 1 TRUE TRUE FALSE IMMEDIATE FALSE FALSE enable KST tracing 1
158 nls_language 2 AMERICAN TRUE TRUE FALSE FALSE FALSE NLS language name 1
159 nls_territory 2 AMERICA TRUE TRUE FALSE FALSE FALSE NLS territory name 1
160 nls_sort 2 TRUE TRUE FALSE FALSE FALSE NLS linguistic defin 1
161 nls_date_language 2 TRUE TRUE FALSE FALSE FALSE NLS date language na 1
162 nls_date_format 2 TRUE TRUE FALSE FALSE FALSE NLS Oracle date form 1
163 nls_currency 2 TRUE TRUE FALSE FALSE FALSE NLS local currency s 1
164 nls_numeric_characte 2 TRUE TRUE FALSE FALSE FALSE NLS numeric characte 1
165 nls_iso_currency 2 TRUE TRUE FALSE FALSE FALSE NLS ISO currency ter 1
166 nls_calendar 2 TRUE TRUE FALSE FALSE FALSE NLS calendar system 1
167 nls_time_format 2 TRUE TRUE FALSE FALSE FALSE time format 1
168 nls_timestamp_format 2 TRUE TRUE FALSE FALSE FALSE time stamp format 1
169 nls_time_tz_format 2 TRUE TRUE FALSE FALSE FALSE time with timezone f 1
170 nls_timestamp_tz_for 2 TRUE TRUE FALSE FALSE FALSE timestampe with time 1
171 nls_dual_currency 2 TRUE TRUE FALSE FALSE FALSE Dual currency symbol 1
172 nls_comp 2 TRUE TRUE FALSE FALSE FALSE NLS comparison 1
173 nls_length_semantics 2 BYTE TRUE TRUE IMMEDIATE FALSE FALSE create columns using 1
174 nls_nchar_conv_excp 2 FALSE TRUE TRUE IMMEDIATE FALSE FALSE NLS raise an excepti 1
179 fileio_network_adapt 2 TRUE FALSE FALSE FALSE FALSE Network Adapters for 0
181 filesystemio_options 2 SETALL FALSE FALSE FALSE FALSE FALSE IO operations on fil 1
188 disk_asynch_io 1 TRUE TRUE FALSE FALSE FALSE FALSE Use asynch I/O for r 1
189 tape_asynch_io 1 TRUE TRUE FALSE FALSE FALSE FALSE Use asynch I/O reque 1
191 dbwr_io_slaves 3 0 TRUE FALSE FALSE FALSE FALSE DBWR I/O slaves 1
195 backup_tape_io_slave 1 FALSE TRUE FALSE DEFERRED FALSE FALSE BACKUP Tape I/O slav 1
199 resource_manager_pla 2 TRUE FALSE IMMEDIATE FALSE FALSE resource mgr top pla 0
209 cluster_interconnect 2 TRUE FALSE FALSE FALSE FALSE interconnects for RA 0
227 file_mapping 1 FALSE TRUE FALSE IMMEDIATE FALSE FALSE enable file mapping 1
243 gcs_server_processes 3 0 TRUE FALSE FALSE FALSE FALSE number of background 1
254 active_instance_coun 3 TRUE FALSE FALSE FALSE FALSE number of active ins 0
343 sga_target 6 0 FALSE FALSE IMMEDIATE FALSE FALSE Target size of SGA 1
361 control_files 2 /omsdb/oravl02/orada FALSE FALSE FALSE FALSE FALSE control file names l 1
361 control_files 2 /omsdb/oravl03/orada FALSE FALSE FALSE FALSE FALSE control file names l 2
361 control_files 2 /omsdb/oravl04/orada FALSE FALSE FALSE FALSE FALSE control file names l 3
368 db_file_name_convert 2 TRUE TRUE FALSE FALSE FALSE datafile name conver 0
369 log_file_name_conver 2 TRUE FALSE FALSE FALSE FALSE logfile name convert 0
370 control_file_record_ 3 35 FALSE FALSE IMMEDIATE FALSE FALSE control file record 1
372 db_block_buffers 3 0 TRUE FALSE FALSE FALSE FALSE Number of database b 1
376 db_block_checksum 2 FALSE FALSE FALSE IMMEDIATE FALSE FALSE store checksum in db 1
377 db_block_size 3 8192 FALSE FALSE FALSE FALSE FALSE Size of database blo 1
389 db_cache_size 6 6660554752 FALSE FALSE IMMEDIATE FALSE FALSE Size of DEFAULT buff 1
390 _db_block_numa 3 1 FALSE FALSE FALSE FALSE FALSE Number of NUMA nodes 1
391 db_2k_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of cache for 2K 1
392 db_4k_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of cache for 4K 1
393 db_8k_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of cache for 8K 1
394 db_16k_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of cache for 16 1
395 db_32k_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of cache for 32 1
396 db_keep_cache_size 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of KEEP buffer 1
397 db_recycle_cache_siz 6 0 TRUE FALSE IMMEDIATE FALSE FALSE Size of RECYCLE buff 1
401 db_writer_processes 3 3 TRUE FALSE FALSE FALSE FALSE number of background 1
419 buffer_pool_keep 2 TRUE FALSE FALSE FALSE FALSE Number of database b 1
420 buffer_pool_recycle 2 TRUE FALSE FALSE FALSE FALSE Number of database b 1
460 db_cache_advice 2 ON TRUE FALSE IMMEDIATE FALSE FALSE Buffer cache sizing 1
470 max_commit_propagati 3 0 TRUE FALSE FALSE FALSE FALSE Max age of new snaps 1
472 compatible 2 10.2.0.3.0 FALSE FALSE FALSE FALSE FALSE Database will be com 1
483 remote_archive_enabl 2 true TRUE FALSE FALSE FALSE FALSE remote archival enab 1
484 log_archive_config 2 TRUE FALSE IMMEDIATE FALSE FALSE log archive config p 1
486 log_archive_start 1 FALSE TRUE FALSE FALSE FALSE FALSE start archival proce 1
492 log_archive_dest 2 TRUE FALSE IMMEDIATE FALSE FALSE archival destination 1
493 log_archive_duplex_d 2 TRUE FALSE IMMEDIATE FALSE FALSE duplex archival dest 1
494 log_archive_dest_1 2 LOCATION=/omsdb/oraa FALSE TRUE IMMEDIATE FALSE FALSE archival destination 1
495 log_archive_dest_2 2 TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
496 log_archive_dest_3 2 TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
497 log_archive_dest_4 2 TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
498 log_archive_dest_5 2 TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
499 log_archive_dest_6 2 TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
500 log_archive_dest_7 2 TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
501 log_archive_dest_8 2 TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
502 log_archive_dest_9 2 TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
503 log_archive_dest_10 2 TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
504 log_archive_dest_sta 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
505 log_archive_dest_sta 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
506 log_archive_dest_sta 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
507 log_archive_dest_sta 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
508 log_archive_dest_sta 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
509 log_archive_dest_sta 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
510 log_archive_dest_sta 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
511 log_archive_dest_sta 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
512 log_archive_dest_sta 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
513 log_archive_dest_sta 2 enable TRUE TRUE IMMEDIATE FALSE FALSE archival destination 1
514 log_archive_max_proc 3 2 TRUE FALSE IMMEDIATE FALSE FALSE maximum number of ac 1
517 log_archive_min_succ 3 1 TRUE TRUE IMMEDIATE FALSE FALSE minimum number of ar 1
518 standby_archive_dest 2 ?/dbs/arch TRUE FALSE IMMEDIATE FALSE FALSE standby database arc 1
519 log_archive_trace 3 0 TRUE FALSE IMMEDIATE FALSE FALSE Establish archivelog 1
520 log_archive_local_fi 1 TRUE TRUE FALSE IMMEDIATE FALSE FALSE Establish EXPEDITE a 1
521 log_archive_format 2 pdroms1_%t_%s_%r.arc FALSE FALSE FALSE FALSE FALSE archival destination 1
534 fal_client 2 TRUE FALSE IMMEDIATE FALSE FALSE FAL client 1
535 fal_server 2 TRUE FALSE IMMEDIATE FALSE FALSE FAL server list 1
539 log_buffer 3 14274560 TRUE FALSE FALSE FALSE FALSE redo circular buffer 1 log buffer update
542 log_checkpoint_inter 3 0 TRUE FALSE IMMEDIATE FALSE FALSE # redo blocks checkp 1
543 log_checkpoint_timeo 3 0 FALSE FALSE IMMEDIATE FALSE FALSE Maximum time interva 1
545 archive_lag_target 3 0 TRUE FALSE IMMEDIATE FALSE FALSE Maximum number of se 1
559 db_files 3 200 TRUE FALSE FALSE FALSE FALSE max allowable # db f 1
560 db_file_multiblock_r 3 32 FALSE TRUE IMMEDIATE FALSE FALSE db block to be read 1
564 read_only_open_delay 1 FALSE TRUE FALSE FALSE FALSE FALSE if TRUE delay openin 1
565 cluster_database 1 FALSE TRUE FALSE FALSE FALSE FALSE if TRUE startup in c 1
566 parallel_server 1 FALSE TRUE FALSE FALSE FALSE FALSE if TRUE startup in p 1
567 parallel_server_inst 3 1 TRUE FALSE FALSE FALSE FALSE number of instances 1
568 cluster_database_ins 3 1 TRUE FALSE FALSE FALSE FALSE number of instances 1
569 db_create_file_dest 2 TRUE TRUE IMMEDIATE FALSE FALSE default database loc 1
570 db_create_online_log 2 TRUE TRUE IMMEDIATE FALSE FALSE online log/controlfi 1
571 db_create_online_log 2 TRUE TRUE IMMEDIATE FALSE FALSE online log/controlfi 1
572 db_create_online_log 2 TRUE TRUE IMMEDIATE FALSE FALSE online log/controlfi 1
573 db_create_online_log 2 TRUE TRUE IMMEDIATE FALSE FALSE online log/controlfi 1
574 db_create_online_log 2 TRUE TRUE IMMEDIATE FALSE FALSE online log/controlfi 1
575 db_recovery_file_des 2 TRUE FALSE IMMEDIATE FALSE FALSE default database rec 1
576 db_recovery_file_des 6 0 TRUE FALSE IMMEDIATE FALSE FALSE database recovery fi 1
578 standby_file_managem 2 MANUAL TRUE FALSE IMMEDIATE FALSE FALSE if auto then files a 1
582 gc_files_to_locks 2 TRUE FALSE FALSE FALSE FALSE mapping between file 1
622 thread 3 0 TRUE FALSE IMMEDIATE FALSE FALSE Redo thread to mount 1
629 fast_start_io_target 3 0 TRUE FALSE IMMEDIATE FALSE FALSE Upper bound on recov 1
630 fast_start_mttr_targ 3 300 FALSE FALSE IMMEDIATE FALSE FALSE MTTR target of forwa 1
635 log_checkpoints_to_a 1 TRUE FALSE FALSE IMMEDIATE FALSE FALSE log checkpoint begin 1
636 recovery_parallelism 3 0 TRUE FALSE FALSE FALSE FALSE number of server pro 1
650 logmnr_max_persisten 3 1 TRUE FALSE FALSE FALSE FALSE maximum number of th 1
673 db_flashback_retenti 3 1440 TRUE FALSE IMMEDIATE FALSE FALSE Maximum Flashback Da 1
694 dml_locks 3 19380 TRUE FALSE FALSE FALSE FALSE dml locks - one for 1
695 ddl_wait_for_locks 1 FALSE TRUE TRUE IMMEDIATE FALSE FALSE Disable NOWAIT DML l 1
698 replication_dependen 1 TRUE TRUE FALSE FALSE FALSE FALSE tracking dependency 1
704 instance_number 3 0 TRUE FALSE FALSE FALSE FALSE instance number 1
719 transactions 3 4845 TRUE FALSE FALSE FALSE FALSE max. number of concu 1
720 transactions_per_rol 3 5 TRUE FALSE FALSE FALSE FALSE number of active tra 1
722 rollback_segments 2 TRUE FALSE FALSE FALSE FALSE undo segment list 0
730 undo_management 2 AUTO FALSE FALSE FALSE FALSE FALSE instance runs in SMU 1
731 undo_tablespace 2 UNDOTBS1 FALSE FALSE IMMEDIATE FALSE FALSE use/switch undo tabl 1
744 undo_retention 3 86400 FALSE FALSE IMMEDIATE FALSE FALSE undo retention in se 1
748 fast_start_parallel_ 2 LOW TRUE FALSE IMMEDIATE FALSE FALSE max number of parall 1
750 resumable_timeout 3 0 TRUE TRUE IMMEDIATE FALSE FALSE set resumable_timeou 1
756 db_block_checking 2 FALSE TRUE TRUE IMMEDIATE FALSE FALSE header checking and 1
757 recyclebin 2 on TRUE TRUE IMMEDIATE FALSE FALSE recyclebin processin 1
786 create_stored_outlin 2 TRUE TRUE IMMEDIATE FALSE FALSE create stored outlin 0
787 serial_reuse 2 disable TRUE FALSE FALSE FALSE FALSE reuse the frame segm 1
794 ldap_directory_acces 2 NONE TRUE FALSE IMMEDIATE FALSE FALSE RDBMS's LDAP access 1
795 os_roles 1 FALSE TRUE FALSE FALSE FALSE FALSE retrieve roles from 1
796 rdbms_server_dn 2 TRUE FALSE FALSE FALSE FALSE RDBMS's Distinguishe 1
797 max_enabled_roles 3 150 TRUE FALSE FALSE FALSE FALSE max number of roles 1
798 remote_os_authent 1 FALSE TRUE FALSE FALSE FALSE FALSE allow non-secure rem 1
799 remote_os_roles 1 FALSE TRUE FALSE FALSE FALSE FALSE allow non-secure rem 1
800 O7_DICTIONARY_ACCESS 1 FALSE TRUE FALSE FALSE FALSE FALSE Version 7 Dictionary 1
802 remote_login_passwor 2 EXCLUSIVE FALSE FALSE FALSE FALSE FALSE password file usage 1
803 license_max_users 3 0 TRUE FALSE IMMEDIATE FALSE FALSE maximum number of na 1
807 audit_sys_operations 1 TRUE FALSE FALSE FALSE FALSE FALSE enable sys auditing 1
810 global_context_pool_ 2 TRUE FALSE FALSE FALSE FALSE Global Application C 1
811 db_domain 2 FALSE FALSE FALSE FALSE FALSE directory part of gl 1
812 global_names 1 FALSE TRUE TRUE IMMEDIATE FALSE FALSE enforce that databas 1
813 distributed_lock_tim 3 60 TRUE FALSE FALSE FALSE FALSE number of seconds a 1
815 commit_point_strengt 3 1 TRUE FALSE FALSE FALSE FALSE Bias this node has t 1
816 instance_name 2 pdroms1 TRUE FALSE FALSE FALSE FALSE instance name suppor 1
817 service_names 2 pdroms1 TRUE FALSE IMMEDIATE FALSE FALSE service names suppor 1
819 dispatchers 2 (PROTOCOL=TCP) (SERV FALSE FALSE IMMEDIATE FALSE FALSE specifications of di 1
820 shared_servers 3 1 TRUE FALSE IMMEDIATE FALSE FALSE number of shared ser 1
821 max_shared_servers 3 TRUE FALSE IMMEDIATE FALSE FALSE max number of shared 0
822 max_dispatchers 3 TRUE FALSE IMMEDIATE FALSE FALSE max number of dispat 0
823 circuits 3 TRUE FALSE IMMEDIATE FALSE FALSE max number of circui 0
824 shared_server_sessio 3 TRUE FALSE IMMEDIATE FALSE FALSE max number of shared 0
825 local_listener 2 TRUE FALSE IMMEDIATE FALSE FALSE local listener 0
826 remote_listener 2 TRUE FALSE IMMEDIATE FALSE FALSE remote listener 0
837 cursor_space_for_tim 1 FALSE TRUE FALSE FALSE FALSE FALSE use more memory in o 1
838 session_cached_curso 3 20 TRUE TRUE FALSE FALSE FALSE Number of cursors to 1
841 remote_dependencies_ 2 TIMESTAMP TRUE TRUE IMMEDIATE FALSE FALSE remote-procedure-cal 1
842 utl_file_dir 2 TRUE FALSE FALSE FALSE FALSE utl_file accessible 0
843 smtp_out_server 2 TRUE TRUE IMMEDIATE FALSE FALSE utl_smtp server and 0
845 plsql_v2_compatibili 1 FALSE TRUE TRUE IMMEDIATE FALSE FALSE PL/SQL version 2.x c 1
846 plsql_compiler_flags 2 INTERPRETED, NON_DEB TRUE TRUE IMMEDIATE FALSE FALSE PL/SQL compiler flag 1
847 plsql_native_library 2 TRUE FALSE IMMEDIATE FALSE FALSE plsql native library 1
848 plsql_native_library 3 0 TRUE FALSE IMMEDIATE FALSE FALSE plsql native library 1
849 plsql_warnings 2 DISABLE:ALL TRUE TRUE IMMEDIATE FALSE FALSE PL/SQL compiler warn 1 PL/SQL warnings at i
850 plsql_code_type 2 INTERPRETED TRUE TRUE IMMEDIATE FALSE FALSE PL/SQL code-type 1
852 plsql_debug 1 FALSE TRUE TRUE IMMEDIATE FALSE FALSE PL/SQL debug 1
853 plsql_optimize_level 3 2 TRUE TRUE IMMEDIATE FALSE FALSE PL/SQL optimize leve 1
854 plsql_ccflags 2 TRUE TRUE IMMEDIATE FALSE FALSE PL/SQL ccflags 1
857 job_queue_processes 3 10 FALSE FALSE IMMEDIATE FALSE FALSE number of job queue 1
859 parallel_min_percent 3 0 TRUE TRUE FALSE FALSE FALSE minimum percent of t 1
Num Name Type Value Isdefault Isses_modifiable Issys_modifiable Ismodified Isadjusted Description Ordinal Update_Comment
862 create_bitmap_area_s 3 8388608 TRUE FALSE FALSE FALSE FALSE size of create bitma 1
863 bitmap_merge_area_si 3 1048576 TRUE FALSE FALSE FALSE FALSE maximum memory allow 1
865 cursor_sharing 2 EXACT FALSE TRUE IMMEDIATE FALSE FALSE cursor sharing mode 1
874 parallel_min_servers 3 0 TRUE FALSE IMMEDIATE FALSE FALSE minimum parallel que 1
875 parallel_max_servers 3 48 FALSE FALSE IMMEDIATE FALSE FALSE maximum parallel que 1
880 parallel_instance_gr 2 TRUE TRUE IMMEDIATE FALSE FALSE instance group to us 1
883 parallel_execution_m 3 2152 TRUE FALSE FALSE FALSE FALSE message buffer size 1
893 hash_area_size 3 131072 TRUE TRUE FALSE FALSE FALSE size of in-memory ha 1
907 shadow_core_dump 2 partial TRUE FALSE FALSE FALSE FALSE Core Size for Shadow 1
908 background_core_dump 2 partial TRUE FALSE FALSE FALSE FALSE Core Size for Backgr 1
909 background_dump_dest 2 /omsdb/oradmp/admin/ FALSE FALSE IMMEDIATE FALSE FALSE Detached process dum 1
910 user_dump_dest 2 /omsdb/oradmp/admin/ FALSE FALSE IMMEDIATE FALSE FALSE User process dump di 1
911 max_dump_file_size 2 UNLIMITED TRUE TRUE IMMEDIATE FALSE FALSE Maximum size (blocks 1
912 core_dump_dest 2 /omsdb/oradmp/admin/ FALSE FALSE IMMEDIATE FALSE FALSE Core dump directory 1
919 audit_file_dest 2 /omsdb/oradmp/admin/ FALSE FALSE DEFERRED FALSE FALSE Directory in which a 1
920 audit_syslog_level 2 TRUE FALSE FALSE FALSE FALSE Syslog facility and 0
921 object_cache_optimal 3 102400 TRUE TRUE DEFERRED FALSE FALSE optimal size of the 1
922 object_cache_max_siz 3 10 TRUE TRUE DEFERRED FALSE FALSE percentage of maximu 1
924 session_max_open_fil 3 10 TRUE FALSE FALSE FALSE FALSE maximum number of op 1
929 open_links 3 4 TRUE FALSE FALSE FALSE FALSE max # open links per 1
930 open_links_per_insta 3 4 TRUE FALSE FALSE FALSE FALSE max # open links per 1
934 commit_write 2 TRUE TRUE IMMEDIATE FALSE FALSE transaction commit l 0
936 optimizer_features_e 2 10.2.0.3 TRUE TRUE IMMEDIATE FALSE FALSE optimizer plan compa 1
937 fixed_date 2 TRUE FALSE IMMEDIATE FALSE FALSE fixed SYSDATE value 1
938 audit_trail 2 DB FALSE FALSE FALSE FALSE FALSE enable system auditi 1
939 sort_area_size 3 65536 TRUE TRUE DEFERRED FALSE FALSE size of in-memory so 1
940 sort_area_retained_s 3 0 TRUE TRUE DEFERRED FALSE FALSE size of in-memory so 1
945 db_name 2 pdroms1 FALSE FALSE FALSE FALSE FALSE database name specif 1
946 db_unique_name 2 pdroms1 TRUE FALSE FALSE FALSE FALSE Database Unique Name 1
947 open_cursors 3 4000 FALSE FALSE IMMEDIATE FALSE FALSE max # cursors per se 1
948 ifile 4 TRUE FALSE FALSE FALSE FALSE include file in init 0
949 sql_trace 1 FALSE TRUE TRUE IMMEDIATE FALSE FALSE enable SQL trace 1
950 os_authent_prefix 2 ops$ TRUE FALSE FALSE FALSE FALSE prefix for auto-logo 1
952 optimizer_mode 2 ALL_ROWS TRUE TRUE IMMEDIATE FALSE FALSE optimizer mode 1
957 sql92_security 1 FALSE TRUE FALSE FALSE FALSE FALSE require select privi 1
959 blank_trimming 1 FALSE TRUE FALSE FALSE FALSE FALSE blank trimming seman 1
963 _b_tree_bitmap_plans 1 FALSE FALSE TRUE IMMEDIATE FALSE FALSE enable the use of bi 1
964 star_transformation_ 2 FALSE TRUE TRUE IMMEDIATE FALSE FALSE enable the use of st 1
968 _optimizer_cost_mode 2 IO FALSE TRUE IMMEDIATE FALSE FALSE optimizer cost model 1
990 _optimizer_skip_scan 1 FALSE FALSE TRUE IMMEDIATE FALSE FALSE enable/disable index 1
1007 parallel_adaptive_mu 1 TRUE TRUE FALSE IMMEDIATE FALSE FALSE enable adaptive sett 1
1008 parallel_threads_per 3 2 TRUE FALSE IMMEDIATE FALSE FALSE number of parallel e 1
1009 parallel_automatic_t 1 FALSE TRUE FALSE FALSE FALSE FALSE enable intelligent d 1
1032 optimizer_index_cost 3 10 FALSE TRUE IMMEDIATE FALSE FALSE optimizer index cost 1
1033 optimizer_index_cach 3 90 FALSE TRUE IMMEDIATE FALSE FALSE optimizer percent in 1
1042 query_rewrite_enable 2 TRUE TRUE TRUE IMMEDIATE FALSE FALSE allow rewrite of que 1
1043 query_rewrite_integr 2 enforced TRUE TRUE IMMEDIATE FALSE FALSE perform rewrite usin 1
1074 sql_version 2 NATIVE TRUE TRUE FALSE FALSE FALSE sql language version 1
1100 pga_aggregate_target 6 3221225472 FALSE FALSE IMMEDIATE FALSE FALSE Target size for the 1
1102 workarea_size_policy 2 AUTO TRUE TRUE IMMEDIATE FALSE FALSE policy used to size 1
1119 optimizer_dynamic_sa 3 0 FALSE TRUE IMMEDIATE FALSE FALSE optimizer dynamic sa 1
1143 statistics_level 2 TYPICAL TRUE TRUE IMMEDIATE FALSE FALSE statistics level 1
1166 _optimizer_sortmerge 1 FALSE FALSE TRUE IMMEDIATE FALSE FALSE enable/disable sort- 1
1179 skip_unusable_indexe 1 TRUE TRUE TRUE IMMEDIATE FALSE FALSE skip unusable indexe 1
1246 optimizer_secure_vie 1 TRUE TRUE FALSE IMMEDIATE FALSE FALSE optimizer secure vie 1
1283 aq_tm_processes 3 0 TRUE FALSE IMMEDIATE FALSE FALSE number of AQ Time Ma 1
1288 hs_autoregister 1 TRUE TRUE FALSE IMMEDIATE FALSE FALSE enable automatic ser 1
1289 dg_broker_start 1 FALSE TRUE FALSE IMMEDIATE FALSE FALSE start Data Guard bro 1
1290 drs_start 1 FALSE TRUE FALSE IMMEDIATE FALSE FALSE start DG Broker moni 1
1291 dg_broker_config_fil 2 /oravl01/oracle/10.2 TRUE FALSE IMMEDIATE FALSE FALSE data guard broker co 1
1292 dg_broker_config_fil 2 /oravl01/oracle/10.2 TRUE FALSE IMMEDIATE FALSE FALSE data guard broker co 1
1303 olap_page_pool_size 6 0 TRUE TRUE DEFERRED FALSE FALSE size of the olap pag 1
1385 asm_diskstring 2 TRUE FALSE IMMEDIATE FALSE FALSE disk set locations f 0
1389 asm_diskgroups 2 TRUE FALSE IMMEDIATE FALSE FALSE disk groups to mount 0
1390 asm_power_limit 3 1 TRUE TRUE IMMEDIATE FALSE FALSE number of processes 1
1427 sqltune_category 2 DEFAULT TRUE TRUE IMMEDIATE FALSE FALSE Category qualifier f 1
end of script