ORACLE数据库监控内容

version

PRODUCT	VERSION
Oracle Database 11g Enterprise Edition	11.2.0.4.0

instance

INSTANCE_NAME	HOST_NAME	STARTUP_TIME	STATUS	LOGINS	SHUTDOWN_PENDING	DATABASE_STATUS
orcl	jdbcoraclemon	08-JUL-19	OPEN	ALLOWED	NO	ACTIVE

database

DBID	NAME	CREATED	LOG_MODE	OPEN_MODE	PLATFORM_NAME	CURRENT_SCN	DB_UNIQUE_NAME
1540710443	ORCL	06-JUL-19	NOARCHIVELOG	READ WRITE	Linux x86 64-bit	1101831	orcl

session

SID	SERIAL#	USERNAME	MACHINE	OSUSER	PROGRAM	PROCESS	TYPE	LOGON_TIME	STATUS
1	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (VKTM)	7389	BACKGROUND	08-JUL-19	ACTIVE
2	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (DIA0)	7399	BACKGROUND	08-JUL-19	ACTIVE
3	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (CKPT)	7407	BACKGROUND	08-JUL-19	ACTIVE
4	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (MMNL)	7415	BACKGROUND	08-JUL-19	ACTIVE
5	3		jdbcoraclemon	oracle	oracle@jdbcoraclemon (QMNC)	7432	BACKGROUND	08-JUL-19	ACTIVE
7	63		jdbcoraclemon	oracle	oracle@jdbcoraclemon (W000)	18503	BACKGROUND	08-JUL-19	ACTIVE
9	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (Q001)	7474	BACKGROUND	08-JUL-19	ACTIVE
569	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (GEN0)	7393	BACKGROUND	08-JUL-19	ACTIVE
570	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (MMAN)	7401	BACKGROUND	08-JUL-19	ACTIVE
571	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (SMON)	7409	BACKGROUND	08-JUL-19	ACTIVE
572	47		jdbcoraclemon	oracle	oracle@jdbcoraclemon (SMCO)	7791	BACKGROUND	08-JUL-19	ACTIVE
574	99	SYSTEM	x220win10	Administrator	DBeaver 6.1.1 - Metadata	1234	USER	08-JUL-19	INACTIVE
1137	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (PMON)	7384	BACKGROUND	08-JUL-19	ACTIVE
1138	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (DIAG)	7395	BACKGROUND	08-JUL-19	ACTIVE
1139	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (DBW0)	7403	BACKGROUND	08-JUL-19	ACTIVE
1140	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (RECO)	7411	BACKGROUND	08-JUL-19	ACTIVE
1141	3		jdbcoraclemon	oracle	oracle@jdbcoraclemon (CJQ0)	7445	BACKGROUND	08-JUL-19	ACTIVE
1144	351	SYSTEM	phpjdbcoracle	apache	httpd@phpjdbcoracle (TNS V1-V3)	7274	USER	08-JUL-19	ACTIVE
1705	5	SYS	jdbcoraclemon	oracle	sqlplus@jdbcoraclemon (TNS V1-V3)	7370	USER	08-JUL-19	INACTIVE
1706	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (PSP0)	7386	BACKGROUND	08-JUL-19	ACTIVE
1707	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (DBRM)	7397	BACKGROUND	08-JUL-19	ACTIVE
1708	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (LGWR)	7405	BACKGROUND	08-JUL-19	ACTIVE
1709	1		jdbcoraclemon	oracle	oracle@jdbcoraclemon (MMON)	7413	BACKGROUND	08-JUL-19	ACTIVE
1711	83	SYSTEM	x220win10	Administrator	DBeaver 6.1.1 - Main	1234	USER	08-JUL-19	INACTIVE
1713	5		jdbcoraclemon	oracle	oracle@jdbcoraclemon (Q000)	7472	BACKGROUND	08-JUL-19	ACTIVE

controlfile

STATUS	NAME	IS_RECOVERY_DEST_FILE	BLOCK_SIZE	FILE_SIZE_BLKS
	/data/oracle/oradata/orcl/control01.ctl	NO	16384	594
	/data/oracle/oradata/orcl/control02.ctl	NO	16384	594

sga

NAME	VALUE
Fixed Size	2253624
Variable Size	922750152
Database Buffers	654311424
Redo Buffers	7393280

parameter

NUM	NAME	TYPE	VALUE	ISDEFAULT
38	lock_name_space	2		TRUE
39	processes	3	1500	FALSE
40	sessions	3	2272	FALSE
41	timed_statistics	1	TRUE	TRUE
42	timed_os_statistics	3	0	TRUE
43	resource_limit	1	FALSE	TRUE
44	license_max_sessions	3	0	TRUE
45	license_sessions_warning	3	0	TRUE
88	cpu_count	3	4	TRUE
93	instance_groups	2		TRUE
97	event	2		TRUE
110	sga_max_size	6	1593835520	TRUE
117	use_large_pages	2	TRUE	TRUE
122	pre_page_sga	1	FALSE	TRUE
123	shared_memory_address	3	0	TRUE
124	hi_shared_memory_address	3	0	TRUE
125	use_indirect_data_buffers	1	FALSE	TRUE
127	lock_sga	1	FALSE	TRUE
168	processor_group_name	2		TRUE
173	shared_pool_size	6	0	TRUE
175	large_pool_size	6	0	TRUE
177	java_pool_size	6	0	TRUE
179	streams_pool_size	6	0	TRUE
181	shared_pool_reserved_size	6	7549747	TRUE
184	java_soft_sessionspace_limit	3	0	TRUE
185	java_max_sessionspace_size	3	0	TRUE
194	spfile	2	/data/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora	TRUE
195	instance_type	2	RDBMS	TRUE
232	nls_language	2	AMERICAN	TRUE
233	nls_territory	2	AMERICA	TRUE
234	nls_sort	2		TRUE
235	nls_date_language	2		TRUE
236	nls_date_format	2		TRUE
237	nls_currency	2		TRUE
238	nls_numeric_characters	2		TRUE
239	nls_iso_currency	2		TRUE
240	nls_calendar	2		TRUE
241	nls_time_format	2		TRUE
242	nls_timestamp_format	2		TRUE
243	nls_time_tz_format	2		TRUE
244	nls_timestamp_tz_format	2		TRUE
245	nls_dual_currency	2		TRUE
246	nls_comp	2	BINARY	TRUE
247	nls_length_semantics	2	BYTE	TRUE
248	nls_nchar_conv_excp	2	FALSE	TRUE
255	fileio_network_adapters	2		TRUE
257	filesystemio_options	2	none	TRUE
258	dnfs_batch_size	3	4096	TRUE
270	clonedb	1	FALSE	TRUE
271	instant_restore	1	FALSE	TRUE
279	disk_asynch_io	1	TRUE	TRUE
280	tape_asynch_io	1	TRUE	TRUE
282	dbwr_io_slaves	3	0	TRUE
286	backup_tape_io_slaves	1	FALSE	TRUE
294	resource_manager_cpu_allocation	3	4	TRUE
296	resource_manager_plan	2		TRUE
374	cluster_interconnects	2		TRUE
441	file_mapping	1	FALSE	TRUE
538	gcs_server_processes	3	0	TRUE
550	active_instance_count	3		TRUE
779	sga_target	6	0	TRUE
781	memory_target	6	1593835520	FALSE
782	memory_max_target	6	1593835520	TRUE
809	control_files	2	/data/oracle/oradata/orcl/control01.ctl, /data/oracle/oradata/orcl/control02.ctl	FALSE
818	db_file_name_convert	2		TRUE
819	log_file_name_convert	2		TRUE
820	control_file_record_keep_time	3	7	TRUE
824	db_block_buffers	3	0	TRUE
828	db_block_checksum	2	TYPICAL	TRUE
829	db_ultra_safe	2	OFF	TRUE
830	db_block_size	3	8192	FALSE
846	db_cache_size	6	0	TRUE
848	db_2k_cache_size	6	0	TRUE
849	db_4k_cache_size	6	0	TRUE
850	db_8k_cache_size	6	0	TRUE
851	db_16k_cache_size	6	0	TRUE
852	db_32k_cache_size	6	0	TRUE
853	db_keep_cache_size	6	0	TRUE
854	db_recycle_cache_size	6	0	TRUE
867	db_writer_processes	3	1	TRUE
889	buffer_pool_keep	2		TRUE
890	buffer_pool_recycle	2		TRUE
943	db_flash_cache_file	2		TRUE
944	db_flash_cache_size	6	0	TRUE
966	db_cache_advice	2	ON	TRUE
982	compatible	2	11.2.0.4.0	FALSE
993	log_archive_dest_1	2		TRUE
994	log_archive_dest_2	2		TRUE
995	log_archive_dest_3	2		TRUE
996	log_archive_dest_4	2		TRUE
997	log_archive_dest_5	2		TRUE
998	log_archive_dest_6	2		TRUE
999	log_archive_dest_7	2		TRUE
1000	log_archive_dest_8	2		TRUE
1001	log_archive_dest_9	2		TRUE
1002	log_archive_dest_10	2		TRUE
1003	log_archive_dest_11	2		TRUE
1004	log_archive_dest_12	2		TRUE
1005	log_archive_dest_13	2		TRUE
1006	log_archive_dest_14	2		TRUE
1007	log_archive_dest_15	2		TRUE
1008	log_archive_dest_16	2		TRUE
1009	log_archive_dest_17	2		TRUE
1010	log_archive_dest_18	2		TRUE
1011	log_archive_dest_19	2		TRUE
1012	log_archive_dest_20	2		TRUE
1013	log_archive_dest_21	2		TRUE
1014	log_archive_dest_22	2		TRUE
1015	log_archive_dest_23	2		TRUE
1016	log_archive_dest_24	2		TRUE
1017	log_archive_dest_25	2		TRUE
1018	log_archive_dest_26	2		TRUE
1019	log_archive_dest_27	2		TRUE
1020	log_archive_dest_28	2		TRUE
1021	log_archive_dest_29	2		TRUE
1022	log_archive_dest_30	2		TRUE
1023	log_archive_dest_31	2		TRUE
1024	log_archive_dest_state_1	2	enable	TRUE
1025	log_archive_dest_state_2	2	enable	TRUE
1026	log_archive_dest_state_3	2	enable	TRUE
1027	log_archive_dest_state_4	2	enable	TRUE
1028	log_archive_dest_state_5	2	enable	TRUE
1029	log_archive_dest_state_6	2	enable	TRUE
1030	log_archive_dest_state_7	2	enable	TRUE
1031	log_archive_dest_state_8	2	enable	TRUE
1032	log_archive_dest_state_9	2	enable	TRUE
1033	log_archive_dest_state_10	2	enable	TRUE
1034	log_archive_dest_state_11	2	enable	TRUE
1035	log_archive_dest_state_12	2	enable	TRUE
1036	log_archive_dest_state_13	2	enable	TRUE
1037	log_archive_dest_state_14	2	enable	TRUE
1038	log_archive_dest_state_15	2	enable	TRUE
1039	log_archive_dest_state_16	2	enable	TRUE
1040	log_archive_dest_state_17	2	enable	TRUE
1041	log_archive_dest_state_18	2	enable	TRUE
1042	log_archive_dest_state_19	2	enable	TRUE
1043	log_archive_dest_state_20	2	enable	TRUE
1044	log_archive_dest_state_21	2	enable	TRUE
1045	log_archive_dest_state_22	2	enable	TRUE
1046	log_archive_dest_state_23	2	enable	TRUE
1047	log_archive_dest_state_24	2	enable	TRUE
1048	log_archive_dest_state_25	2	enable	TRUE
1049	log_archive_dest_state_26	2	enable	TRUE
1050	log_archive_dest_state_27	2	enable	TRUE
1051	log_archive_dest_state_28	2	enable	TRUE
1052	log_archive_dest_state_29	2	enable	TRUE
1053	log_archive_dest_state_30	2	enable	TRUE
1054	log_archive_dest_state_31	2	enable	TRUE
1055	log_archive_start	1	FALSE	TRUE
1056	log_archive_dest	2		TRUE
1057	log_archive_duplex_dest	2		TRUE
1058	log_archive_min_succeed_dest	3	1	TRUE
1059	standby_archive_dest	2	?/dbs/arch	TRUE
1064	fal_client	2		TRUE
1065	fal_server	2		TRUE
1068	log_archive_trace	3	0	TRUE
1085	log_archive_config	2		TRUE
1090	log_archive_local_first	1	TRUE	TRUE
1092	log_archive_format	2	%t_%s_%r.dbf	TRUE
1097	redo_transport_user	2		TRUE
1102	log_archive_max_processes	3	4	TRUE
1116	log_buffer	3	7069696	TRUE
1119	log_checkpoint_interval	3	0	TRUE
1120	log_checkpoint_timeout	3	1800	TRUE
1122	archive_lag_target	3	0	TRUE
1154	db_files	3	200	TRUE
1155	db_file_multiblock_read_count	3	15	TRUE
1159	read_only_open_delayed	1	FALSE	TRUE
1160	cluster_database	1	FALSE	TRUE
1161	parallel_server	1	FALSE	TRUE
1162	parallel_server_instances	3	1	TRUE
1163	cluster_database_instances	3	1	TRUE
1164	db_create_file_dest	2		TRUE
1165	db_create_online_log_dest_1	2		TRUE
1166	db_create_online_log_dest_2	2		TRUE
1167	db_create_online_log_dest_3	2		TRUE
1168	db_create_online_log_dest_4	2		TRUE
1169	db_create_online_log_dest_5	2		TRUE
1170	db_recovery_file_dest	2		TRUE
1171	db_recovery_file_dest_size	6	0	TRUE
1173	standby_file_management	2	MANUAL	TRUE
1251	db_unrecoverable_scn_tracking	1	TRUE	TRUE
1255	thread	3	0	TRUE
1262	fast_start_io_target	3	0	TRUE
1263	fast_start_mttr_target	3	0	TRUE
1269	log_checkpoints_to_alert	1	FALSE	TRUE
1270	db_lost_write_protect	2	NONE	TRUE
1274	recovery_parallelism	3	0	TRUE
1336	enable_goldengate_replication	1	FALSE	TRUE
1378	db_flashback_retention_target	3	1440	TRUE
1476	dml_locks	3	9996	TRUE
1481	replication_dependency_tracking	1	TRUE	TRUE
1489	transactions	3	2499	TRUE
1490	transactions_per_rollback_segment	3	5	TRUE
1492	rollback_segments	2		TRUE
1500	undo_management	2	AUTO	TRUE
1501	undo_tablespace	2	UNDOTBS1	FALSE
1518	undo_retention	3	900	TRUE
1521	fast_start_parallel_rollback	2	LOW	TRUE
1523	resumable_timeout	3	0	TRUE
1544	instance_number	3	0	TRUE
1597	db_block_checking	2	FALSE	TRUE
1600	recyclebin	2	on	TRUE
1724	db_securefile	2	PERMITTED	TRUE
1769	create_stored_outlines	2		TRUE
1772	serial_reuse	2	disable	TRUE
1780	ldap_directory_access	2	NONE	TRUE
1781	ldap_directory_sysauth	2	no	TRUE
1782	os_roles	1	FALSE	TRUE
1783	rdbms_server_dn	2		TRUE
1784	max_enabled_roles	3	150	TRUE
1785	remote_os_authent	1	FALSE	TRUE
1786	remote_os_roles	1	FALSE	TRUE
1788	sec_case_sensitive_logon	1	TRUE	TRUE
1789	O7_DICTIONARY_ACCESSIBILITY	1	FALSE	TRUE
1791	remote_login_passwordfile	2	EXCLUSIVE	FALSE
1792	license_max_users	3	0	TRUE
1796	audit_sys_operations	1	FALSE	TRUE
1799	global_context_pool_size	2		TRUE
1804	db_domain	2		FALSE
1805	global_names	1	FALSE	TRUE
1806	distributed_lock_timeout	3	60	TRUE
1808	commit_point_strength	3	1	TRUE
1811	global_txn_processes	3	1	TRUE
1819	instance_name	2	orcl	TRUE
1820	service_names	2	orcl	TRUE
1822	dispatchers	2	(PROTOCOL=TCP) (SERVICE=orclXDB)	FALSE
1823	shared_servers	3	1	TRUE
1824	max_shared_servers	3		TRUE
1825	max_dispatchers	3		TRUE
1826	circuits	3		TRUE
1827	shared_server_sessions	3		TRUE
1828	local_listener	2		TRUE
1829	remote_listener	2		TRUE
1830	listener_networks	2		TRUE
1844	cursor_space_for_time	1	FALSE	TRUE
1845	session_cached_cursors	3	50	TRUE
1852	remote_dependencies_mode	2	TIMESTAMP	TRUE
1853	utl_file_dir	2		TRUE
1854	smtp_out_server	2		TRUE
1856	plsql_v2_compatibility	1	FALSE	TRUE
1858	plsql_warnings	2	DISABLE:ALL	TRUE
1859	plsql_code_type	2	INTERPRETED	TRUE
1861	plsql_debug	1	FALSE	TRUE
1862	plsql_optimize_level	3	2	TRUE
1863	plsql_ccflags	2		TRUE
1865	plscope_settings	2	IDENTIFIERS:NONE	TRUE
1869	permit_92_wrap_format	1	TRUE	TRUE
1870	java_jit_enabled	1	TRUE	TRUE
1871	java_restrict	2	none	TRUE
1872	job_queue_processes	3	1000	TRUE
1875	parallel_min_percent	3	0	TRUE
1878	create_bitmap_area_size	3	8388608	TRUE
1879	bitmap_merge_area_size	3	1048576	TRUE
1882	cursor_sharing	2	EXACT	TRUE
1885	result_cache_mode	2	MANUAL	TRUE
1900	parallel_min_servers	3	0	TRUE
1901	parallel_max_servers	3	160	TRUE
1906	parallel_instance_group	2		TRUE
1910	parallel_execution_message_size	3	16384	TRUE
1921	hash_area_size	3	131072	TRUE
1941	result_cache_max_size	6	3997696	TRUE
1942	result_cache_max_result	3	5	TRUE
1943	result_cache_remote_expiration	3	0	TRUE
1955	shadow_core_dump	2	partial	TRUE
1956	background_core_dump	2	partial	TRUE
1957	background_dump_dest	2	/data/oracle/diag/rdbms/orcl/orcl/trace	TRUE
1958	user_dump_dest	2	/data/oracle/diag/rdbms/orcl/orcl/trace	TRUE
1959	core_dump_dest	2	/data/oracle/diag/rdbms/orcl/orcl/cdump	TRUE
1968	audit_file_dest	2	/data/oracle/admin/orcl/adump	FALSE
1969	audit_syslog_level	2		TRUE
1975	object_cache_optimal_size	3	102400	TRUE
1976	object_cache_max_size_percent	3	10	TRUE
1980	session_max_open_files	3	10	TRUE
1986	open_links	3	4	TRUE
1987	open_links_per_instance	3	4	TRUE
1991	commit_write	2		TRUE
1992	commit_wait	2		TRUE
1993	commit_logging	2		TRUE
1995	optimizer_features_enable	2	11.2.0.4	TRUE
1996	fixed_date	2		TRUE
1997	audit_trail	2	DB	FALSE
1998	sort_area_size	3	65536	TRUE
1999	sort_area_retained_size	3	0	TRUE
2013	cell_offload_processing	1	TRUE	TRUE
2014	cell_offload_decryption	1	TRUE	TRUE
2015	cell_offload_parameters	2		TRUE
2016	cell_offload_compaction	2	ADAPTIVE	TRUE
2017	cell_offload_plan_display	2	AUTO	TRUE
2020	db_name	2	orcl	FALSE
2021	db_unique_name	2	orcl	TRUE
2022	open_cursors	3	300	FALSE
2023	ifile	4		TRUE
2024	sql_trace	1	FALSE	TRUE
2025	os_authent_prefix	2	ops$	TRUE
2027	optimizer_mode	2	ALL_ROWS	TRUE
2032	sql92_security	1	FALSE	TRUE
2035	blank_trimming	1	FALSE	TRUE
2041	star_transformation_enabled	2	FALSE	TRUE
2083	parallel_degree_policy	2	MANUAL	TRUE
2091	parallel_adaptive_multi_user	1	TRUE	TRUE
2092	parallel_threads_per_cpu	3	2	TRUE
2093	parallel_automatic_tuning	1	FALSE	TRUE
2099	parallel_io_cap_enabled	1	FALSE	TRUE
2120	optimizer_index_cost_adj	3	100	TRUE
2121	optimizer_index_caching	3	0	TRUE
2133	query_rewrite_enabled	2	TRUE	TRUE
2134	query_rewrite_integrity	2	enforced	TRUE
2192	pga_aggregate_target	6	0	TRUE
2195	workarea_size_policy	2	AUTO	TRUE
2220	optimizer_dynamic_sampling	3	2	TRUE
2250	statistics_level	2	TYPICAL	TRUE
2275	cursor_bind_capture_destination	2	memory+disk	TRUE
2294	skip_unusable_indexes	1	TRUE	TRUE
2376	optimizer_secure_view_merging	1	TRUE	TRUE
2420	ddl_lock_timeout	3	0	TRUE
2422	deferred_segment_creation	1	TRUE	TRUE
2430	optimizer_use_pending_statistics	1	FALSE	TRUE
2435	optimizer_capture_sql_plan_baselines	1	FALSE	TRUE
2436	optimizer_use_sql_plan_baselines	1	TRUE	TRUE
2457	parallel_min_time_threshold	2	AUTO	TRUE
2459	parallel_degree_limit	2	CPU	TRUE
2460	parallel_force_local	1	FALSE	TRUE
2469	optimizer_use_invisible_indexes	1	FALSE	TRUE
2493	dst_upgrade_insert_conv	1	TRUE	TRUE
2498	parallel_servers_target	3	64	TRUE
2557	sec_protocol_error_trace_action	2	TRACE	TRUE
2558	sec_protocol_error_further_action	2	CONTINUE	TRUE
2559	sec_max_failed_login_attempts	3	10	TRUE
2560	sec_return_server_release_banner	1	FALSE	TRUE
2563	enable_ddl_logging	1	FALSE	TRUE
2566	client_result_cache_size	6	0	TRUE
2567	client_result_cache_lag	6	3000	TRUE
2592	aq_tm_processes	3	1	TRUE
2608	hs_autoregister	1	TRUE	TRUE
2609	xml_db_events	2	enable	TRUE
2610	dg_broker_start	1	FALSE	TRUE
2611	dg_broker_config_file1	2	/data/oracle/product/11.2.0/dbhome_1/dbs/dr1orcl.dat	TRUE
2612	dg_broker_config_file2	2	/data/oracle/product/11.2.0/dbhome_1/dbs/dr2orcl.dat	TRUE
2624	olap_page_pool_size	6	0	TRUE
2721	asm_diskstring	2		TRUE
2723	asm_preferred_read_failure_groups	2		TRUE
2734	asm_diskgroups	2		TRUE
2735	asm_power_limit	3	1	TRUE
2811	control_management_pack_access	2	DIAGNOSTIC+TUNING	TRUE
2833	awr_snapshot_time_offset	3	0	TRUE
2838	sqltune_category	2	DEFAULT	TRUE
2874	diagnostic_dest	2	/data/oracle	FALSE
2898	tracefile_identifier	2		TRUE
2900	max_dump_file_size	2	unlimited	TRUE
2903	trace_enabled	1	TRUE	TRUE
2914	cell_offloadgroup_name	2		TRUE

nls_parameters

PARAMETER	VALUE
NLS_LANGUAGE	AMERICAN
NLS_TERRITORY	AMERICA
NLS_CURRENCY	$
NLS_ISO_CURRENCY	AMERICA
NLS_NUMERIC_CHARACTERS	.,
NLS_CALENDAR	GREGORIAN
NLS_DATE_FORMAT	DD-MON-RR
NLS_DATE_LANGUAGE	AMERICAN
NLS_CHARACTERSET	ZHS16GBK
NLS_SORT	BINARY
NLS_TIME_FORMAT	HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT	DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY	$
NLS_NCHAR_CHARACTERSET	AL16UTF16
NLS_COMP	BINARY
NLS_LENGTH_SEMANTICS	BYTE
NLS_NCHAR_CONV_EXCP	FALSE

option

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

tablespace

TABLESPACE_NAME	MAX	ALLOC	USED	PCT_USED_ALLOC	PCT_USED_MAX	STATUS	LOGGING	FORCE_LOGGING	EXTENT_MANAGEMENT	ALLOCATION_TYPE
TEMP	34359721984	1342177280	1048576	.08	0	ONLINE	NOLOGGING	NO	LOCAL	UNIFORM
USERS	34359721984	5242880	1376256	26.25	0	ONLINE	LOGGING	NO	LOCAL	SYSTEM
TESTTBS	68719443968	209715200	2097152	1	0	ONLINE	LOGGING	NO	LOCAL	SYSTEM
UNDOTBS1	34359721984	94371840	21757952	23.06	.06	ONLINE	LOGGING	NO	LOCAL	SYSTEM
SYSAUX	34359721984	587202560	553779200	94.31	1.61	ONLINE	LOGGING	NO	LOCAL	SYSTEM
SYSTEM	34359721984	786432000	779747328	99.15	2.27	ONLINE	LOGGING	NO	LOCAL	SYSTEM

datafiles

FILE_NAME	FILE_ID	TABLESPACE_NAME	BYTES	STATUS	AUTOEXTENSIBLE	MAXBYTES	INCREMENT_BY	ONLINE_STATUS
/data/oracle/oradata/orcl/users01.dbf	4	USERS	5242880	AVAILABLE	YES	34359721984	160	ONLINE
/data/oracle/oradata/orcl/undotbs01.dbf	3	UNDOTBS1	94371840	AVAILABLE	YES	34359721984	640	ONLINE
/data/oracle/oradata/orcl/sysaux01.dbf	2	SYSAUX	587202560	AVAILABLE	YES	34359721984	1280	ONLINE
/data/oracle/oradata/orcl/system01.dbf	1	SYSTEM	786432000	AVAILABLE	YES	34359721984	1280	SYSTEM
/data/oracle/oradata/orcl/test01.dbf	5	TESTTBS	104857600	AVAILABLE	YES	34359721984	13	ONLINE
/data/oracle/oradata/orcl/test02.dbf	6	TESTTBS	104857600	AVAILABLE	YES	34359721984	13	ONLINE

tempfiles

FILE_NAME	FILE_ID	TABLESPACE_NAME	BYTES	STATUS	AUTOEXTENSIBLE	MAXBYTES	INCREMENT_BY
/data/oracle/oradata/orcl/temp01.dbf	1	TEMP	1342177280	ONLINE	YES	34359721984	80

logfile

GROUP#	STATUS	TYPE	MEMBER	IS_RECOVERY_DEST_FILE
3		ONLINE	/data/oracle/oradata/orcl/redo03.log	NO
2		ONLINE	/data/oracle/oradata/orcl/redo02.log	NO
1		ONLINE	/data/oracle/oradata/orcl/redo01.log	NO

users

USERNAME	DEFAULT_TABLESPACE	TEMPORARY_TABLESPACE	ACCOUNT_STATUS	LOCK_DATE	CREATED
SCOTT	USERS	TEMP	EXPIRED & LOCKED	06-JUL-19	24-AUG-13
OWBSYS_AUDIT	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
OWBSYS	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
APEX_PUBLIC_USER	USERS	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
APEX_030200	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
FLOWS_FILES	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
MGMT_VIEW	SYSTEM	TEMP	OPEN		24-AUG-13
SYSMAN	SYSAUX	TEMP	OPEN		24-AUG-13
SPATIAL_CSW_ADMIN_USR	USERS	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
SPATIAL_WFS_ADMIN_USR	USERS	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
MDDATA	USERS	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
OLAPSYS	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
ORDSYS	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
MDSYS	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
ORDDATA	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
SI_INFORMTN_SCHEMA	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
ORDPLUGINS	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
XS$NULL	USERS	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
XDB	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
ANONYMOUS	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
CTXSYS	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
EXFSYS	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
WMSYS	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
APPQOSSYS	SYSAUX	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
DBSNMP	SYSAUX	TEMP	OPEN		24-AUG-13
ORACLE_OCM	USERS	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
DIP	USERS	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
OUTLN	SYSTEM	TEMP	EXPIRED & LOCKED	24-AUG-13	24-AUG-13
SYS	SYSTEM	TEMP	OPEN		24-AUG-13
SYSTEM	SYSTEM	TEMP	OPEN		24-AUG-13

registry

COMP_ID	COMP_NAME	VERSION	STATUS	MODIFIED	SCHEMA
OWB	OWB	11.2.0.4.0	VALID	24-AUG-2013 12:04:20	OWBSYS
APEX	Oracle Application Express	3.2.1.00.12	VALID	24-AUG-2013 12:04:20	APEX_030200
EM	Oracle Enterprise Manager	11.2.0.4.0	VALID	24-AUG-2013 11:58:27	SYSMAN
SDO	Spatial	11.2.0.4.0	VALID	24-AUG-2013 12:04:20	MDSYS
AMD	OLAP Catalog	11.2.0.4.0	VALID	24-AUG-2013 12:04:20	OLAPSYS
XOQ	Oracle OLAP API	11.2.0.4.0	VALID	24-AUG-2013 12:04:20	SYS
APS	OLAP Analytic Workspace	11.2.0.4.0	VALID	24-AUG-2013 12:04:20	SYS
ORDIM	Oracle Multimedia	11.2.0.4.0	VALID	24-AUG-2013 12:04:20	ORDSYS
RUL	Oracle Rules Manager	11.2.0.4.0	VALID	24-AUG-2013 12:04:19	EXFSYS
XDB	Oracle XML Database	11.2.0.4.0	VALID	24-AUG-2013 12:04:19	XDB
CONTEXT	Oracle Text	11.2.0.4.0	VALID	24-AUG-2013 12:04:18	CTXSYS
EXF	Oracle Expression Filter	11.2.0.4.0	VALID	24-AUG-2013 12:04:18	EXFSYS
CATJAVA	Oracle Database Java Packages	11.2.0.4.0	VALID	24-AUG-2013 12:04:18	SYS
XML	Oracle XDK	11.2.0.4.0	VALID	24-AUG-2013 12:04:18	SYS
JAVAVM	JServer JAVA Virtual Machine	11.2.0.4.0	VALID	24-AUG-2013 12:04:18	SYS
OWM	Oracle Workspace Manager	11.2.0.4.0	VALID	24-AUG-2013 12:04:18	WMSYS
CATPROC	Oracle Database Packages and Types	11.2.0.4.0	VALID	24-AUG-2013 12:04:18	SYS
CATALOG	Oracle Database Catalog Views	11.2.0.4.0	VALID	24-AUG-2013 12:04:18	SYS

feature

NAME	VERSION	DETECTED_USAGES	TOTAL_SAMPLES	CURRENTLY_USED	FIRST_USAGE_DATE	LAST_USAGE_DATE	LAST_SAMPLE_DATE
Change Data Capture	11.2.0.4.0	0	1	FALSE			06-JUL-19
Services	11.2.0.4.0	0	1	FALSE			06-JUL-19
Semantics/RDF	11.2.0.4.0	0	1	FALSE			06-JUL-19
SecureFiles (user)	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
SecureFiles (system)	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
SecureFile Encryption (user)	11.2.0.4.0	0	1	FALSE			06-JUL-19
SecureFile Encryption (system)	11.2.0.4.0	0	1	FALSE			06-JUL-19
SecureFile Compression (user)	11.2.0.4.0	0	1	FALSE			06-JUL-19
SecureFile Compression (system)	11.2.0.4.0	0	1	FALSE			06-JUL-19
SecureFile Deduplication (user)	11.2.0.4.0	0	1	FALSE			06-JUL-19
SecureFile Deduplication (system)	11.2.0.4.0	0	1	FALSE			06-JUL-19
Segment Advisor (user)	11.2.0.4.0	0	1	FALSE			06-JUL-19
HeapCompression	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Hybrid Columnar Compression	11.2.0.4.0	0	1	FALSE			06-JUL-19
ZFS Storage	11.2.0.4.0	0	1	FALSE			06-JUL-19
Pillar Storage	11.2.0.4.0	0	1	FALSE			06-JUL-19
Sun ZFS with EHCC	11.2.0.4.0	0	1	FALSE			06-JUL-19
Pillar Storage with EHCC	11.2.0.4.0	0	1	FALSE			06-JUL-19
Segment Shrink	11.2.0.4.0	0	1	FALSE			06-JUL-19
Job Scheduler	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Java Virtual Machine (user)	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Java Virtual Machine (system)	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Exadata	11.2.0.4.0	0	1	FALSE			06-JUL-19
Automatic Memory Tuning	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Automatic Undo Management	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Oracle Multimedia DICOM	11.2.0.4.0	0	1	FALSE			06-JUL-19
Materialized Views (User)	11.2.0.4.0	0	1	FALSE			06-JUL-19
Deferred Segment Creation	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Advanced Replication	11.2.0.4.0	0	1	FALSE			06-JUL-19
ASO native encryption and checksumming	11.2.0.4.0	0	1	FALSE			06-JUL-19
Audit Options	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Automatic Maintenance - Optimizer Statistics Gathering	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Automatic Maintenance - Space Advisor	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Automatic Maintenance - SQL Tuning Advisor	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Automatic Segment Space Management (system)	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Automatic Segment Space Management (user)	11.2.0.4.0	0	1	FALSE			06-JUL-19
Automatic SQL Execution Memory	11.2.0.4.0	0	1	FALSE			06-JUL-19
Automatic Storage Management	11.2.0.4.0	0	1	FALSE			06-JUL-19
Automatic Workload Repository	11.2.0.4.0	0	1	FALSE			06-JUL-19
AWR Baseline	11.2.0.4.0	0	1	FALSE			06-JUL-19
AWR Baseline Template	11.2.0.4.0	0	1	FALSE			06-JUL-19
AWR Report	11.2.0.4.0	0	1	FALSE			06-JUL-19
Backup Encryption	11.2.0.4.0	0	1	FALSE			06-JUL-19
Baseline Adaptive Thresholds	11.2.0.4.0	0	1	FALSE			06-JUL-19
Baseline Static Computations	11.2.0.4.0	0	1	FALSE			06-JUL-19
Change-Aware Incremental Backup	11.2.0.4.0	0	1	FALSE			06-JUL-19
Client Identifier	11.2.0.4.0	0	1	FALSE			06-JUL-19
Clusterwide Global Transactions	11.2.0.4.0	0	1	FALSE			06-JUL-19
Crossedition Triggers	11.2.0.4.0	0	1	FALSE			06-JUL-19
CSSCAN	11.2.0.4.0	0	1	FALSE			06-JUL-19
Character Semantics	11.2.0.4.0	0	1	FALSE			06-JUL-19
Character Set	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Data Guard	11.2.0.4.0	0	1	FALSE			06-JUL-19
Data Mining	11.2.0.4.0	0	1	FALSE			06-JUL-19
Dynamic SGA	11.2.0.4.0	0	1	FALSE			06-JUL-19
Database Migration Assistant for Unicode	11.2.0.4.0	0	1	FALSE			06-JUL-19
Editions	11.2.0.4.0	0	1	FALSE			06-JUL-19
Editioning Views	11.2.0.4.0	0	1	FALSE			06-JUL-19
EM Database Control	11.2.0.4.0	0	1	FALSE			06-JUL-19
EM Grid Control	11.2.0.4.0	0	1	FALSE			06-JUL-19
EM Performance Page	11.2.0.4.0	0	1	FALSE			06-JUL-19
SQL Monitoring and Tuning pages	11.2.0.4.0	0	1	FALSE			06-JUL-19
File Mapping	11.2.0.4.0	0	1	FALSE			06-JUL-19
Flashback Database	11.2.0.4.0	0	1	FALSE			06-JUL-19
Flashback Data Archive	11.2.0.4.0	0	1	FALSE			06-JUL-19
Internode Parallel Execution	11.2.0.4.0	0	1	FALSE			06-JUL-19
Label Security	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Database Vault	11.2.0.4.0	0	1	FALSE			06-JUL-19
Locally Managed Tablespaces (system)	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Locally Managed Tablespaces (user)	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Messaging Gateway	11.2.0.4.0	0	1	FALSE			06-JUL-19
Very Large Memory	11.2.0.4.0	0	1	FALSE			06-JUL-19
Automatic SGA Tuning	11.2.0.4.0	0	1	FALSE			06-JUL-19
Encrypted Tablespaces	11.2.0.4.0	0	1	FALSE			06-JUL-19
MTTR Advisor	11.2.0.4.0	0	1	FALSE			06-JUL-19
Multiple Block Sizes	11.2.0.4.0	0	1	FALSE			06-JUL-19
OLAP - Analytic Workspaces	11.2.0.4.0	0	1	FALSE			06-JUL-19
OLAP - Cubes	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Managed Files	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Secure Backup	11.2.0.4.0	0	1	FALSE			06-JUL-19
Parallel SQL DDL Execution	11.2.0.4.0	0	1	FALSE			06-JUL-19
Parallel SQL DML Execution	11.2.0.4.0	0	1	FALSE			06-JUL-19
Parallel SQL Query Execution	11.2.0.4.0	0	1	FALSE			06-JUL-19
Partitioning (system)	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Partitioning (user)	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Text	11.2.0.4.0	0	1	FALSE			06-JUL-19
PL/SQL Native Compilation	11.2.0.4.0	0	1	FALSE			06-JUL-19
Quality of Service Management	11.2.0.4.0	0	1	FALSE			06-JUL-19
Real Application Clusters (RAC)	11.2.0.4.0	0	1	FALSE			06-JUL-19
Recovery Area	11.2.0.4.0	0	1	FALSE			06-JUL-19
Recovery Manager (RMAN)	11.2.0.4.0	0	1	FALSE			06-JUL-19
RMAN - Disk Backup	11.2.0.4.0	0	1	FALSE			06-JUL-19
RMAN - Tape Backup	11.2.0.4.0	0	1	FALSE			06-JUL-19
Backup ZLIB Compression	11.2.0.4.0	0	1	FALSE			06-JUL-19
Backup BZIP2 Compression	11.2.0.4.0	0	1	FALSE			06-JUL-19
Backup BASIC Compression	11.2.0.4.0	0	1	FALSE			06-JUL-19
Backup LOW Compression	11.2.0.4.0	0	1	FALSE			06-JUL-19
Backup MEDIUM Compression	11.2.0.4.0	0	1	FALSE			06-JUL-19
Backup HIGH Compression	11.2.0.4.0	0	1	FALSE			06-JUL-19
Long-term Archival Backup	11.2.0.4.0	0	1	FALSE			06-JUL-19
Multi Section Backup	11.2.0.4.0	0	1	FALSE			06-JUL-19
Block Media Recovery	11.2.0.4.0	0	1	FALSE			06-JUL-19
Restore Point	11.2.0.4.0	0	1	FALSE			06-JUL-19
Logfile Multiplexing	11.2.0.4.0	0	1	FALSE			06-JUL-19
Bigfile Tablespace	11.2.0.4.0	0	1	FALSE			06-JUL-19
Transportable Tablespace	11.2.0.4.0	0	1	FALSE			06-JUL-19
Read Only Tablespace	11.2.0.4.0	0	1	FALSE			06-JUL-19
Deferred Open Read Only	11.2.0.4.0	0	1	FALSE			06-JUL-19
Active Data Guard - Real-Time Query on Physical Standby	11.2.0.4.0	0	1	FALSE			06-JUL-19
Backup Rollforward	11.2.0.4.0	0	1	FALSE			06-JUL-19
Data Recovery Advisor	11.2.0.4.0	0	1	FALSE			06-JUL-19
Resource Manager	11.2.0.4.0	0	1	FALSE			06-JUL-19
Instance Caging	11.2.0.4.0	0	1	FALSE			06-JUL-19
Direct NFS	11.2.0.4.0	0	1	FALSE			06-JUL-19
Server Flash Cache	11.2.0.4.0	0	1	FALSE			06-JUL-19
Server Parameter File	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Shared Server	11.2.0.4.0	0	1	FALSE			06-JUL-19
Spatial	11.2.0.4.0	0	1	FALSE			06-JUL-19
Locator	11.2.0.4.0	0	1	FALSE			06-JUL-19
ADDM	11.2.0.4.0	0	1	FALSE			06-JUL-19
SQL Access Advisor	11.2.0.4.0	0	1	FALSE			06-JUL-19
Undo Advisor	11.2.0.4.0	0	1	FALSE			06-JUL-19
SQL Tuning Advisor	11.2.0.4.0	0	1	FALSE			06-JUL-19
SQL Workload Manager	11.2.0.4.0	0	1	FALSE			06-JUL-19
Tune MView	11.2.0.4.0	0	1	FALSE			06-JUL-19
SQL Performance Analyzer	11.2.0.4.0	0	1	FALSE			06-JUL-19
SQL Repair Advisor	11.2.0.4.0	0	1	FALSE			06-JUL-19
Compression Advisor	11.2.0.4.0	0	1	FALSE			06-JUL-19
Real-Time SQL Monitoring	11.2.0.4.0	0	1	FALSE			06-JUL-19
SQL Tuning Set (user)	11.2.0.4.0	0	1	FALSE			06-JUL-19
SQL Tuning Set (system)	11.2.0.4.0	0	1	FALSE			06-JUL-19
Automatic SQL Tuning Advisor	11.2.0.4.0	0	1	FALSE			06-JUL-19
SQL Profile	11.2.0.4.0	0	1	FALSE			06-JUL-19
Database Replay: Workload Capture	11.2.0.4.0	0	1	FALSE			06-JUL-19
Database Replay: Workload Replay	11.2.0.4.0	0	1	FALSE			06-JUL-19
Streams (system)	11.2.0.4.0	0	1	FALSE			06-JUL-19
Streams (user)	11.2.0.4.0	0	1	FALSE			06-JUL-19
XStream In	11.2.0.4.0	0	1	FALSE			06-JUL-19
XStream Out	11.2.0.4.0	0	1	FALSE			06-JUL-19
XStream Streams	11.2.0.4.0	0	1	FALSE			06-JUL-19
GoldenGate	11.2.0.4.0	0	1	FALSE			06-JUL-19
Transparent Gateway	11.2.0.4.0	0	1	FALSE			06-JUL-19
Virtual Private Database (VPD)	11.2.0.4.0	1	1	TRUE	06-JUL-19	06-JUL-19	06-JUL-19
Workspace Manager	11.2.0.4.0	0	1	FALSE			06-JUL-19
XDB	11.2.0.4.0	0	1	FALSE			06-JUL-19
Application Express	11.2.0.4.0	0	1	FALSE			06-JUL-19
LOB	11.2.0.4.0	0	1	FALSE			06-JUL-19
Object	11.2.0.4.0	0	1	FALSE			06-JUL-19
Extensibility	11.2.0.4.0	0	1	FALSE			06-JUL-19
SQL Plan Management	11.2.0.4.0	0	1	FALSE			06-JUL-19
DBMS_STATS Incremental Maintenance	11.2.0.4.0	0	1	FALSE			06-JUL-19
Rules Manager	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Utility Datapump (Export)	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Utility Datapump (Import)	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Utility SQL Loader (Direct Path Load)	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Utility Metadata API	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Utility External Table	11.2.0.4.0	0	1	FALSE			06-JUL-19
Result Cache	11.2.0.4.0	0	1	FALSE			06-JUL-19
Transparent Data Encryption	11.2.0.4.0	0	1	FALSE			06-JUL-19
Data Redaction	11.2.0.4.0	0	1	FALSE			06-JUL-19
Oracle Multimedia	11.2.0.4.0	0	1	FALSE			06-JUL-19

license

SESSIONS_MAX	SESSIONS_WARNING	SESSIONS_CURRENT	SESSIONS_HIGHWATER	USERS_MAX	CPU_COUNT_CURRENT	CPU_CORE_COUNT_CURRENT	CPU_SOCKET_COUNT_CURRENT	CPU_COUNT_HIGHWATER	CPU_CORE_COUNT_HIGHWATER	CPU_SOCKET_COUNT_HIGHWATER
0	0	4	7	0	4	4	4	4	4	4