ORACLE监控系统利用 javascript 在客户端为状态字体加红绿颜色

ORACLE数据库监控

<<上一快照                              服务器配置运行监控                              下一快照>>

snap datetime: 2019-07-30 14:00:01
versions

snap_id	device_id	product	version
2036	4	NLSRTL	11.2.0.4.0
2036	4	Oracle Database 11g Enterprise Edition	11.2.0.4.0
2036	4	PL/SQL	11.2.0.4.0
2036	4	TNS for IBM/AIX RISC System/6000:	11.2.0.4.0

total 4 rows

instances

snap_id	device_id	instance_name	host_name	startup_time	status	logins	shutdown_pending	database_status
2036	4	orcl	testdb	2019-05-23 19:30:15	OPEN	ALLOWED	NO	ACTIVE

total 1 rows

databases

snap_id	device_id	dbid	name	created	log_mode	open_mode
2036	4	1491113733	ORCL	2017-12-21 16:29:57	ARCHIVELOG	READ WRITE

total 1 rows

tablespaces

snap_id	device_id	tablespace_name	max	alloc	used	pct_used_alloc	pct_used_max	status	logging	force_logging	extent_management	allocation_type
2036	4	TEST	34359721984	1782579200	1665990656	93.46	4.85	ONLINE	LOGGING	NO	LOCAL	SYSTEM
2036	4	SYSAUX	34359721984	985661440	913244160	92.65	2.66	ONLINE	LOGGING	NO	LOCAL	SYSTEM
2036	4	SYSTEM	34359721984	859832320	797769728	92.78	2.32	ONLINE	LOGGING	NO	LOCAL	SYSTEM
2036	4	UNDOTBS1	34359721984	89128960	12976128	14.56	.04	ONLINE	LOGGING	NO	LOCAL	SYSTEM
2036	4	TEMP	34359721984	47185920	0	0	0	ONLINE	NOLOGGING	NO	LOCAL	UNIFORM
2036	4	USERS	34359721984	5242880	1376256	26.25	0	ONLINE	LOGGING	NO	LOCAL	SYSTEM
2036	4	TEST2	34359721984	104857600	1048576	1	0	ONLINE	LOGGING	NO	LOCAL	SYSTEM

total 7 rows

datafiles

snap_id	device_id	file_name	file_id	tablespace_name	bytes	status	autoextensible	maxbytes	increment_by
2036	4	/data/oracle/oradata/orcl/users01.dbf	4	USERS	5242880	AVAILABLE	YES	34359721984	160
2036	4	/data/oracle/oradata/orcl/undotbs01.dbf	3	UNDOTBS1	89128960	AVAILABLE	YES	34359721984	640
2036	4	/data/oracle/oradata/orcl/sysaux01.dbf	2	SYSAUX	985661440	AVAILABLE	YES	34359721984	1280
2036	4	/data/oracle/oradata/orcl/system01.dbf	1	SYSTEM	859832320	AVAILABLE	YES	34359721984	1280
2036	4	/data/oracle/oradata/orcl/test.dbf	5	ASSP	1782579200	AVAILABLE	YES	34359721984	12800
2036	4	/data/oracle/oradata/orcl/test2.dbf	6	TEST2	104857600	AVAILABLE	YES	34359721984	12800

total 6 rows

tempfiles

snap_id	device_id	file_name	file_id	tablespace_name	bytes	status	autoextensible	maxbytes	increment_by
2036	4	/data/oracle/oradata/orcl/temp01.dbf	1	TEMP	47185920	ONLINE	YES	34359721984	80

total 1 rows

logfiles

snap_id	device_id	group#	status	type	member
2036	4	3		ONLINE	/data/oracle/oradata/orcl/redo03.log
2036	4	2		ONLINE	/data/oracle/oradata/orcl/redo02.log
2036	4	1		ONLINE	/data/oracle/oradata/orcl/redo01.log

total 3 rows

datafilermanbackups

snap_id	device_id	file#	name	completion_time	max_scn
2036	4	3	/data/oracle/oradata/orcl/undotbs01.dbf	2019-07-29 18:29:35	56806359
2036	4	6	/data/oracle/oradata/orcl/test2.dbf	2019-07-29 18:29:36	56806359
2036	4	5	/data/oracle/oradata/orcl/test.dbf	2019-07-29 18:30:28	56806359
2036	4	4	/data/oracle/oradata/orcl/users01.dbf	2019-07-29 18:30:40	56806360
2036	4	1	/data/oracle/oradata/orcl/system01.dbf	2019-07-29 18:31:56	56806360
2036	4	2	/data/oracle/oradata/orcl/sysaux01.dbf	2019-07-29 18:31:59	56806360

total 6 rows

redologrmanbackups

snap_id	device_id	thread#	sequence#	next_change#	next_time
2036	4	1	65271	56820026	2019-07-29 19:13:36

total 1 rows

controlfilermanbackups

snap_id	device_id	completion_time
2036	4	2019-07-29 19:37:34

total 1 rows

spfilermanbackups

snap_id	device_id	completion_time
2036	4	2019-07-29 19:37:41

total 1 rows

users

snap_id	device_id	username	default_tablespace	temporary_tablespace	account_status	lock_date	created
2036	4	TEST2	TEST2	TEMP	OPEN		2018-05-22 12:23:14
2036	4	TEST	TEST	TEMP	OPEN		2018-05-22 12:22:23
2036	4	ADMIN	USERS	TEMP	OPEN		2018-05-22 12:20:14
2036	4	SCOTT	USERS	TEMP	EXPIRED & LOCKED	2017-12-21 16:30:45	2013-10-01 22:57:11
2036	4	OWBSYS_AUDIT	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:55:42	2013-10-01 22:55:31
2036	4	OWBSYS	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:55:42	2013-10-01 22:55:31
2036	4	APEX_030200	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:55:42	2013-10-01 22:35:32
2036	4	FLOWS_FILES	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:55:42	2013-10-01 22:35:31
2036	4	APEX_PUBLIC_USER	USERS	TEMP	EXPIRED & LOCKED	2013-10-01 22:55:42	2013-10-01 22:35:31
2036	4	MGMT_VIEW	SYSTEM	TEMP	OPEN		2013-10-01 22:33:25
2036	4	SYSMAN	SYSAUX	TEMP	OPEN		2013-10-01 22:27:51
2036	4	SPATIAL_CSW_ADMIN_USR	USERS	TEMP	EXPIRED & LOCKED	2013-10-01 22:27:23	2013-10-01 22:27:23
2036	4	SPATIAL_WFS_ADMIN_USR	USERS	TEMP	EXPIRED & LOCKED	2013-10-01 22:27:11	2013-10-01 22:27:11
2036	4	MDDATA	USERS	TEMP	EXPIRED & LOCKED	2013-10-01 22:55:42	2013-10-01 22:20:43
2036	4	OLAPSYS	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:18:38	2013-10-01 22:18:38
2036	4	SI_INFORMTN_SCHEMA	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:10:12	2013-10-01 22:10:12
2036	4	ORDDATA	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:10:12	2013-10-01 22:10:12
2036	4	MDSYS	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:10:12	2013-10-01 22:10:12
2036	4	ORDSYS	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:10:12	2013-10-01 22:10:12
2036	4	ORDPLUGINS	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:10:12	2013-10-01 22:10:12
2036	4	XS$NULL	USERS	TEMP	EXPIRED & LOCKED	2013-10-01 22:09:41	2013-10-01 22:09:41
2036	4	ANONYMOUS	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:55:42	2013-10-01 22:05:20
2036	4	XDB	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:05:20	2013-10-01 22:05:20
2036	4	CTXSYS	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:55:42	2013-10-01 22:04:23
2036	4	EXFSYS	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 22:03:58	2013-10-01 22:03:58
2036	4	WMSYS	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 21:48:55	2013-10-01 21:48:55
2036	4	APPQOSSYS	SYSAUX	TEMP	EXPIRED & LOCKED	2013-10-01 21:47:11	2013-10-01 21:47:11
2036	4	DBSNMP	SYSAUX	TEMP	OPEN		2013-10-01 21:47:08
2036	4	ORACLE_OCM	USERS	TEMP	EXPIRED & LOCKED	2013-10-01 21:33:36	2013-10-01 21:33:36
2036	4	DIP	USERS	TEMP	EXPIRED & LOCKED	2013-10-01 21:32:06	2013-10-01 21:32:06
2036	4	OUTLN	SYSTEM	TEMP	EXPIRED & LOCKED	2013-10-01 21:29:56	2013-10-01 21:29:56
2036	4	SYSTEM	SYSTEM	TEMP	OPEN		2013-10-01 21:29:52
2036	4	SYS	SYSTEM	TEMP	OPEN		2013-10-01 21:29:52

total 33 rows

sessions

snap_id	device_id	sid	serial#	username	machine	osuser	program	process	type	logon_time	status
2036	4	1	1		testdb	oracle	oracle@testdb (ARC2)	3474162	BACKGROUND	2019-05-23 19:30:25	ACTIVE
2036	4	96	1		testdb	oracle	oracle@testdb (ARC3)	3146174	BACKGROUND	2019-05-23 19:30:25	ACTIVE
2036	4	191	1		testdb	oracle	oracle@testdb (PMON)	1966672	BACKGROUND	2019-05-23 19:30:17	ACTIVE
2036	4	193	6289	TEST2	test	Administrator	JDBC Thin Client	1234	USER	2019-07-09 11:40:13	INACTIVE
2036	4	286	1		testdb	oracle	oracle@testdb (PSP0)	3015436	BACKGROUND	2019-05-23 19:30:17	ACTIVE
2036	4	287	1		testdb	oracle	oracle@testdb (QMNC)	3539136	BACKGROUND	2019-05-23 19:30:27	ACTIVE
2036	4	381	1		testdb	oracle	oracle@testdb (VKTM)	1770298	BACKGROUND	2019-05-23 19:30:17	ACTIVE
2036	4	382	5		testdb	oracle	oracle@testdb (Q001)	3014870	BACKGROUND	2019-05-23 19:30:37	ACTIVE
2036	4	476	1		testdb	oracle	oracle@testdb (GEN0)	3408832	BACKGROUND	2019-05-23 19:30:17	ACTIVE
2036	4	478	60703		testdb	oracle	oracle@testdb (J000)	12255374	USER	2019-07-30 13:59:49	ACTIVE
2036	4	571	1		testdb	oracle	oracle@testdb (DIAG)	3081140	BACKGROUND	2019-05-23 19:30:17	ACTIVE
2036	4	572	52813		testdb	oracle	oracle@testdb (Q003)	19071960	BACKGROUND	2019-07-28 19:01:02	ACTIVE
2036	4	666	1		testdb	oracle	oracle@testdb (DBRM)	3736142	BACKGROUND	2019-05-23 19:30:17	ACTIVE
2036	4	669	50809		testdb	oracle	oracle@testdb (J001)	12714470	USER	2019-07-30 13:59:34	ACTIVE
2036	4	761	1		testdb	oracle	oracle@testdb (DIA0)	4063860	BACKGROUND	2019-05-23 19:30:17	ACTIVE
2036	4	762	107	TEST	test	Administrator	JDBC Thin Client	1234	USER	2019-07-09 11:41:13	INACTIVE
2036	4	856	1		testdb	oracle	oracle@testdb (MMAN)	2883602	BACKGROUND	2019-05-23 19:30:18	ACTIVE
2036	4	857	49	TEST	test	Administrator	JDBC Thin Client	1234	USER	2019-07-09 11:41:13	INACTIVE
2036	4	951	1		testdb	oracle	oracle@testdb (DBW0)	3211402	BACKGROUND	2019-05-23 19:30:18	ACTIVE
2036	4	952	13	TEST	test	Administrator	JDBC Thin Client	1234	USER	2019-07-09 11:41:13	INACTIVE
2036	4	1046	9	TEST	test	Administrator	JDBC Thin Client	1234	USER	2019-07-09 11:41:13	INACTIVE
2036	4	1047	1		testdb	oracle	oracle@testdb (DBW1)	1900846	BACKGROUND	2019-05-23 19:30:18	ACTIVE
2036	4	1141	1		testdb	oracle	oracle@testdb (DBW2)	2949622	BACKGROUND	2019-05-23 19:30:18	ACTIVE
2036	4	1142	7	TEST	test	Administrator	JDBC Thin Client	1234	USER	2019-07-09 11:41:14	INACTIVE
2036	4	1236	1		testdb	oracle	oracle@testdb (LGWR)	3080204	BACKGROUND	2019-05-23 19:30:18	ACTIVE
2036	4	1237	7	TEST	test	Administrator	JDBC Thin Client	1234	USER	2019-07-09 11:41:14	INACTIVE
2036	4	1331	1		testdb	oracle	oracle@testdb (CKPT)	3276972	BACKGROUND	2019-05-23 19:30:18	ACTIVE
2036	4	1332	7	TEST	test	Administrator	JDBC Thin Client	1234	USER	2019-07-09 11:41:14	INACTIVE
2036	4	1426	1		testdb	oracle	oracle@testdb (SMON)	2752924	BACKGROUND	2019-05-23 19:30:18	ACTIVE
2036	4	1427	47	TEST	test	Administrator	JDBC Thin Client	1234	USER	2019-07-09 11:41:14	INACTIVE
2036	4	1521	1		testdb	oracle	oracle@testdb (RECO)	3015104	BACKGROUND	2019-05-23 19:30:18	ACTIVE
2036	4	1522	13	TEST	test	Administrator	JDBC Thin Client	1234	USER	2019-07-09 11:41:14	INACTIVE
2036	4	1616	1		testdb	oracle	oracle@testdb (MMON)	2818450	BACKGROUND	2019-05-23 19:30:18	ACTIVE
2036	4	1618	143		testdb	oracle	oracle@testdb (CJQ0)	4522878	BACKGROUND	2019-05-24 08:35:33	ACTIVE
2036	4	1711	1		testdb	oracle	oracle@testdb (MMNL)	2884014	BACKGROUND	2019-05-23 19:30:18	ACTIVE
2036	4	1713	36037	TEST	test	Administrator	JDBC Thin Client	1234	USER	2019-07-09 11:41:14	INACTIVE
2036	4	1806	5145		testdb	oracle	oracle@testdb (Q000)	13632162	BACKGROUND	2019-07-29 19:00:58	ACTIVE
2036	4	1901	993		testdb	oracle	oracle@testdb (W000)	17040230	BACKGROUND	2019-07-30 13:52:43	ACTIVE
2036	4	1996	3		testdb	oracle	oracle@testdb (ARC0)	3539896	BACKGROUND	2019-05-23 19:30:24	ACTIVE
2036	4	1998	35103		testdb	oracle	oracle@testdb (VKRM)	8519702	BACKGROUND	2019-07-30 11:00:00	ACTIVE
2036	4	2091	5		testdb	oracle	oracle@testdb (SMCO)	6160808	BACKGROUND	2019-05-23 19:35:27	ACTIVE
2036	4	2092	12747	SYSTEM	phporacle	root	php@phporacle (TNS V1-V3)	70047	USER	2019-07-30 14:00:04	ACTIVE
2036	4	2186	3		testdb	oracle	oracle@testdb (ARC1)	3211708	BACKGROUND	2019-05-23 19:30:25	ACTIVE

total 43 rows

controlfiles

snap_id	device_id	status	name
2036	4		/data/oracle/oradata/orcl/control01.ctl
2036	4		/data/oracle/oradata/orcl/control02.ctl

total 2 rows

sgas

snap_id	device_id	name	value
2036	4	Fixed Size	2254496
2036	4	Variable Size	4630514016
2036	4	Database Buffers	14562623488
2036	4	Redo Buffers	45666304

total 4 rows

parameters

snap_id	device_id	num	name	type	value	isdefault
2036	4	37	lock_name_space	2		TRUE
2036	4	38	processes	3	1500	FALSE
2036	4	39	sessions	3	2280	FALSE
2036	4	40	timed_statistics	1	TRUE	TRUE
2036	4	41	timed_os_statistics	3	0	TRUE
2036	4	42	resource_limit	1	FALSE	TRUE
2036	4	43	license_max_sessions	3	0	TRUE
2036	4	44	license_sessions_warning	3	0	TRUE
2036	4	87	cpu_count	3	24	TRUE
2036	4	92	instance_groups	2		TRUE
2036	4	96	event	2	28401 TRACE NAME CONTEXT FOREVER, LEVEL 1	FALSE
2036	4	109	sga_max_size	6	19327352832	TRUE
2036	4	116	use_large_pages	2	TRUE	TRUE
2036	4	121	pre_page_sga	1	FALSE	TRUE
2036	4	122	shared_memory_address	3	0	TRUE
2036	4	123	hi_shared_memory_address	3	0	TRUE
2036	4	124	use_indirect_data_buffers	1	FALSE	TRUE
2036	4	126	lock_sga	1	FALSE	TRUE
2036	4	167	processor_group_name	2		TRUE
2036	4	172	shared_pool_size	6	0	TRUE
2036	4	174	large_pool_size	6	0	TRUE
2036	4	176	java_pool_size	6	0	TRUE
2036	4	178	streams_pool_size	6	0	TRUE
2036	4	180	shared_pool_reserved_size	6	110729625	TRUE
2036	4	183	java_soft_sessionspace_limit	3	0	TRUE
2036	4	184	java_max_sessionspace_size	3	0	TRUE
2036	4	193	spfile	2	/data/oracle/product/11.2.0/dbhome_1/dbs/spfileorcl.ora	TRUE
2036	4	194	instance_type	2	RDBMS	TRUE
2036	4	231	nls_language	2	AMERICAN	TRUE
2036	4	232	nls_territory	2	AMERICA	TRUE
2036	4	233	nls_sort	2		TRUE
2036	4	234	nls_date_language	2	AMERICAN	TRUE
2036	4	235	nls_date_format	2	YYYY-MM-DD HH24:MI:SS	TRUE
2036	4	236	nls_currency	2		TRUE
2036	4	237	nls_numeric_characters	2		TRUE
2036	4	238	nls_iso_currency	2		TRUE
2036	4	239	nls_calendar	2		TRUE
2036	4	240	nls_time_format	2		TRUE
2036	4	241	nls_timTEST2_format	2		TRUE
2036	4	242	nls_time_tz_format	2		TRUE
2036	4	243	nls_timTEST2_tz_format	2		TRUE
2036	4	244	nls_dual_currency	2		TRUE
2036	4	245	nls_comp	2	BINARY	TRUE
2036	4	246	nls_length_semantics	2	BYTE	TRUE
2036	4	247	nls_nchar_conv_excp	2	FALSE	TRUE
2036	4	254	fileio_network_adapters	2		TRUE
2036	4	256	filesystemio_options	2	asynch	TRUE
2036	4	257	dnfs_batch_size	3	4096	TRUE
2036	4	269	clonedb	1	FALSE	TRUE
2036	4	270	instant_restore	1	FALSE	TRUE
2036	4	278	disk_asynch_io	1	TRUE	TRUE
2036	4	279	tape_asynch_io	1	TRUE	TRUE
2036	4	281	dbwr_io_slaves	3	0	TRUE
2036	4	285	backup_tape_io_slaves	1	FALSE	TRUE
2036	4	293	resource_manager_cpu_allocation	3	24	TRUE
2036	4	295	resource_manager_plan	2	SCHEDULER[0x32D9]:DEFAULT_MAINTENANCE_PLAN	TRUE
2036	4	373	cluster_interconnects	2		TRUE
2036	4	440	file_mapping	1	FALSE	TRUE
2036	4	537	gcs_server_processes	3	0	TRUE
2036	4	549	active_instance_count	3		TRUE
2036	4	778	sga_target	6	19327352832	FALSE
2036	4	780	memory_target	6	0	TRUE
2036	4	781	memory_max_target	6	0	TRUE
2036	4	808	control_files	2	/data/oracle/oradata/orcl/control01.ctl, /data/oracle/oradata/orcl/control02.ctl	FALSE
2036	4	817	db_file_name_convert	2		TRUE
2036	4	818	log_file_name_convert	2		TRUE
2036	4	819	control_file_record_keep_time	3	7	TRUE
2036	4	823	db_block_buffers	3	0	TRUE
2036	4	827	db_block_checksum	2	TYPICAL	TRUE
2036	4	828	db_ultra_safe	2	OFF	TRUE
2036	4	829	db_block_size	3	8192	FALSE
2036	4	845	db_cache_size	6	0	TRUE
2036	4	847	db_2k_cache_size	6	0	TRUE
2036	4	848	db_4k_cache_size	6	0	TRUE
2036	4	849	db_8k_cache_size	6	0	TRUE
2036	4	850	db_16k_cache_size	6	0	TRUE
2036	4	851	db_32k_cache_size	6	0	TRUE
2036	4	852	db_keep_cache_size	6	0	TRUE
2036	4	853	db_recycle_cache_size	6	0	TRUE
2036	4	866	db_writer_processes	3	3	TRUE
2036	4	888	buffer_pool_keep	2		TRUE
2036	4	889	buffer_pool_recycle	2		TRUE
2036	4	942	db_flash_cache_file	2		TRUE
2036	4	943	db_flash_cache_size	6	0	TRUE
2036	4	965	db_cache_advice	2	ON	TRUE
2036	4	981	compatible	2	11.2.0.4.0	FALSE
2036	4	992	log_archive_dest_1	2	location=/data/oracle/archive/orcl	FALSE
2036	4	993	log_archive_dest_2	2		TRUE
2036	4	994	log_archive_dest_3	2		TRUE
2036	4	995	log_archive_dest_4	2		TRUE
2036	4	996	log_archive_dest_5	2		TRUE
2036	4	997	log_archive_dest_6	2		TRUE
2036	4	998	log_archive_dest_7	2		TRUE
2036	4	999	log_archive_dest_8	2		TRUE
2036	4	1000	log_archive_dest_9	2		TRUE
2036	4	1001	log_archive_dest_10	2		TRUE
2036	4	1002	log_archive_dest_11	2		TRUE
2036	4	1003	log_archive_dest_12	2		TRUE
2036	4	1004	log_archive_dest_13	2		TRUE
2036	4	1005	log_archive_dest_14	2		TRUE
2036	4	1006	log_archive_dest_15	2		TRUE
2036	4	1007	log_archive_dest_16	2		TRUE
2036	4	1008	log_archive_dest_17	2		TRUE
2036	4	1009	log_archive_dest_18	2		TRUE
2036	4	1010	log_archive_dest_19	2		TRUE
2036	4	1011	log_archive_dest_20	2		TRUE
2036	4	1012	log_archive_dest_21	2		TRUE
2036	4	1013	log_archive_dest_22	2		TRUE
2036	4	1014	log_archive_dest_23	2		TRUE
2036	4	1015	log_archive_dest_24	2		TRUE
2036	4	1016	log_archive_dest_25	2		TRUE
2036	4	1017	log_archive_dest_26	2		TRUE
2036	4	1018	log_archive_dest_27	2		TRUE
2036	4	1019	log_archive_dest_28	2		TRUE
2036	4	1020	log_archive_dest_29	2		TRUE
2036	4	1021	log_archive_dest_30	2		TRUE
2036	4	1022	log_archive_dest_31	2		TRUE
2036	4	1023	log_archive_dest_state_1	2	enable	TRUE
2036	4	1024	log_archive_dest_state_2	2	enable	TRUE
2036	4	1025	log_archive_dest_state_3	2	enable	TRUE
2036	4	1026	log_archive_dest_state_4	2	enable	TRUE
2036	4	1027	log_archive_dest_state_5	2	enable	TRUE
2036	4	1028	log_archive_dest_state_6	2	enable	TRUE
2036	4	1029	log_archive_dest_state_7	2	enable	TRUE
2036	4	1030	log_archive_dest_state_8	2	enable	TRUE
2036	4	1031	log_archive_dest_state_9	2	enable	TRUE
2036	4	1032	log_archive_dest_state_10	2	enable	TRUE
2036	4	1033	log_archive_dest_state_11	2	enable	TRUE
2036	4	1034	log_archive_dest_state_12	2	enable	TRUE
2036	4	1035	log_archive_dest_state_13	2	enable	TRUE
2036	4	1036	log_archive_dest_state_14	2	enable	TRUE
2036	4	1037	log_archive_dest_state_15	2	enable	TRUE
2036	4	1038	log_archive_dest_state_16	2	enable	TRUE
2036	4	1039	log_archive_dest_state_17	2	enable	TRUE
2036	4	1040	log_archive_dest_state_18	2	enable	TRUE
2036	4	1041	log_archive_dest_state_19	2	enable	TRUE
2036	4	1042	log_archive_dest_state_20	2	enable	TRUE
2036	4	1043	log_archive_dest_state_21	2	enable	TRUE
2036	4	1044	log_archive_dest_state_22	2	enable	TRUE
2036	4	1045	log_archive_dest_state_23	2	enable	TRUE
2036	4	1046	log_archive_dest_state_24	2	enable	TRUE
2036	4	1047	log_archive_dest_state_25	2	enable	TRUE
2036	4	1048	log_archive_dest_state_26	2	enable	TRUE
2036	4	1049	log_archive_dest_state_27	2	enable	TRUE
2036	4	1050	log_archive_dest_state_28	2	enable	TRUE
2036	4	1051	log_archive_dest_state_29	2	enable	TRUE
2036	4	1052	log_archive_dest_state_30	2	enable	TRUE
2036	4	1053	log_archive_dest_state_31	2	enable	TRUE
2036	4	1054	log_archive_start	1	FALSE	TRUE
2036	4	1055	log_archive_dest	2		TRUE
2036	4	1056	log_archive_duplex_dest	2		TRUE
2036	4	1057	log_archive_min_succeed_dest	3	1	TRUE
2036	4	1058	standby_archive_dest	2	?/dbs/arch	TRUE
2036	4	1063	fal_client	2		TRUE
2036	4	1064	fal_server	2		TRUE
2036	4	1067	log_archive_trace	3	0	TRUE
2036	4	1084	log_archive_config	2		TRUE
2036	4	1089	log_archive_local_first	1	TRUE	TRUE
2036	4	1091	log_archive_format	2	%t_%s_%r.dbf	TRUE
2036	4	1096	redo_transport_user	2		TRUE
2036	4	1101	log_archive_max_processes	3	4	TRUE
2036	4	1115	log_buffer	3	44179456	TRUE
2036	4	1118	log_checkpoint_interval	3	0	TRUE
2036	4	1119	log_checkpoint_timeout	3	1800	TRUE
2036	4	1121	archive_lag_target	3	600	FALSE
2036	4	1153	db_files	3	200	TRUE
2036	4	1154	db_file_multiblock_read_count	3	128	TRUE
2036	4	1158	read_only_open_delayed	1	FALSE	TRUE
2036	4	1159	cluster_database	1	FALSE	TRUE
2036	4	1160	parallel_server	1	FALSE	TRUE
2036	4	1161	parallel_server_instances	3	1	TRUE
2036	4	1162	cluster_database_instances	3	1	TRUE
2036	4	1163	db_create_file_dest	2		TRUE
2036	4	1164	db_create_online_log_dest_1	2		TRUE
2036	4	1165	db_create_online_log_dest_2	2		TRUE
2036	4	1166	db_create_online_log_dest_3	2		TRUE
2036	4	1167	db_create_online_log_dest_4	2		TRUE
2036	4	1168	db_create_online_log_dest_5	2		TRUE
2036	4	1169	db_recovery_file_dest	2		TRUE
2036	4	1170	db_recovery_file_dest_size	6	0	TRUE
2036	4	1172	standby_file_management	2	MANUAL	TRUE
2036	4	1250	db_unrecoverable_scn_tracking	1	TRUE	TRUE
2036	4	1254	thread	3	0	TRUE
2036	4	1261	fast_start_io_target	3	0	TRUE
2036	4	1262	fast_start_mttr_target	3	0	TRUE
2036	4	1268	log_checkpoints_to_alert	1	FALSE	TRUE
2036	4	1269	db_lost_write_protect	2	NONE	TRUE
2036	4	1273	recovery_parallelism	3	0	TRUE
2036	4	1335	enable_goldengate_replication	1	FALSE	TRUE
2036	4	1377	db_flashback_retention_target	3	1440	TRUE
2036	4	1475	dml_locks	3	10032	TRUE
2036	4	1480	replication_dependency_tracking	1	TRUE	TRUE
2036	4	1488	transactions	3	2508	TRUE
2036	4	1489	transactions_per_rollback_segment	3	5	TRUE
2036	4	1491	rollback_segments	2		TRUE
2036	4	1499	undo_management	2	AUTO	TRUE
2036	4	1500	undo_tablespace	2	UNDOTBS1	FALSE
2036	4	1517	undo_retention	3	900	TRUE
2036	4	1520	fast_start_parallel_rollback	2	LOW	TRUE
2036	4	1522	resumable_timeout	3	0	TRUE
2036	4	1543	instance_number	3	0	TRUE
2036	4	1596	db_block_checking	2	FALSE	TRUE
2036	4	1599	recyclebin	2	on	TRUE
2036	4	1723	db_securefile	2	PERMITTED	TRUE
2036	4	1768	create_stored_outlines	2		TRUE
2036	4	1771	serial_reuse	2	disable	TRUE
2036	4	1779	ldap_directory_access	2	NONE	TRUE
2036	4	1780	ldap_directory_sysauth	2	no	TRUE
2036	4	1781	os_roles	1	FALSE	TRUE
2036	4	1782	rdbms_server_dn	2		TRUE
2036	4	1783	max_enabled_roles	3	150	TRUE
2036	4	1784	remote_os_authent	1	FALSE	TRUE
2036	4	1785	remote_os_roles	1	FALSE	TRUE
2036	4	1787	sec_case_sensitive_logon	1	FALSE	FALSE
2036	4	1788	O7_DICTIONARY_ACCESSIBILITY	1	FALSE	TRUE
2036	4	1790	remote_login_passwordfile	2	EXCLUSIVE	FALSE
2036	4	1791	license_max_users	3	0	TRUE
2036	4	1795	audit_sys_operations	1	FALSE	TRUE
2036	4	1798	global_context_pool_size	2		TRUE
2036	4	1803	db_domain	2		FALSE
2036	4	1804	global_names	1	FALSE	TRUE
2036	4	1805	distributed_lock_timeout	3	60	TRUE
2036	4	1807	commit_point_strength	3	1	TRUE
2036	4	1810	global_txn_processes	3	1	TRUE
2036	4	1818	instance_name	2	orcl	TRUE
2036	4	1819	service_names	2	orcl	TRUE
2036	4	1821	dispatchers	2	(PROTOCOL=TCP) (SERVICE=orclXDB)	FALSE
2036	4	1822	shared_servers	3	1	TRUE
2036	4	1823	max_shared_servers	3		TRUE
2036	4	1824	max_dispatchers	3		TRUE
2036	4	1825	circuits	3		TRUE
2036	4	1826	shared_server_sessions	3		TRUE
2036	4	1827	local_listener	2		TRUE
2036	4	1828	remote_listener	2		TRUE
2036	4	1829	listener_networks	2		TRUE
2036	4	1843	cursor_space_for_time	1	FALSE	TRUE
2036	4	1844	session_cached_cursors	3	50	TRUE
2036	4	1851	remote_dependencies_mode	2	TIMTEST2	TRUE
2036	4	1852	utl_file_dir	2		TRUE
2036	4	1853	smtp_out_server	2		TRUE
2036	4	1855	plsql_v2_compatibility	1	FALSE	TRUE
2036	4	1857	plsql_warnings	2	DISABLE:ALL	TRUE
2036	4	1858	plsql_code_type	2	INTERPRETED	TRUE
2036	4	1860	plsql_debug	1	FALSE	TRUE
2036	4	1861	plsql_optimize_level	3	2	TRUE
2036	4	1862	plsql_ccflags	2		TRUE
2036	4	1864	plscope_settings	2	IDENTIFIERS:NONE	TRUE
2036	4	1868	permit_92_wrap_format	1	TRUE	TRUE
2036	4	1869	java_jit_enabled	1	TRUE	TRUE
2036	4	1870	java_restrict	2	none	TRUE
2036	4	1871	job_queue_processes	3	1000	TRUE
2036	4	1874	parallel_min_percent	3	0	TRUE
2036	4	1877	create_bitmap_area_size	3	8388608	TRUE
2036	4	1878	bitmap_merge_area_size	3	1048576	TRUE
2036	4	1881	cursor_sharing	2	EXACT	TRUE
2036	4	1884	result_cache_mode	2	MANUAL	TRUE
2036	4	1899	parallel_min_servers	3	0	TRUE
2036	4	1900	parallel_max_servers	3	960	TRUE
2036	4	1905	parallel_instance_group	2		TRUE
2036	4	1909	parallel_execution_message_size	3	16384	TRUE
2036	4	1920	hash_area_size	3	131072	TRUE
2036	4	1940	result_cache_max_size	6	96665600	TRUE
2036	4	1941	result_cache_max_result	3	5	TRUE
2036	4	1942	result_cache_remote_expiration	3	0	TRUE
2036	4	1954	shadow_core_dump	2	partial	TRUE
2036	4	1955	background_core_dump	2	partial	TRUE
2036	4	1956	background_dump_dest	2	/data/oracle/diag/rdbms/orcl/orcl/trace	TRUE
2036	4	1957	user_dump_dest	2	/data/oracle/diag/rdbms/orcl/orcl/trace	TRUE
2036	4	1958	core_dump_dest	2	/data/oracle/diag/rdbms/orcl/orcl/cdump	TRUE
2036	4	1967	use_sigio	1	TRUE	TRUE
2036	4	1968	audit_file_dest	2	/data/oracle/admin/orcl/adump	FALSE
2036	4	1969	audit_syslog_level	2		TRUE
2036	4	1974	object_cache_optimal_size	3	102400	TRUE
2036	4	1975	object_cache_max_size_percent	3	10	TRUE
2036	4	1979	session_max_open_files	3	10	TRUE
2036	4	1985	open_links	3	4	TRUE
2036	4	1986	open_links_per_instance	3	4	TRUE
2036	4	1990	commit_write	2		TRUE
2036	4	1991	commit_wait	2		TRUE
2036	4	1992	commit_logging	2		TRUE
2036	4	1994	optimizer_features_enable	2	11.2.0.4	TRUE
2036	4	1995	fixed_date	2		TRUE
2036	4	1996	audit_trail	2	NONE	FALSE
2036	4	1997	sort_area_size	3	65536	TRUE
2036	4	1998	sort_area_retained_size	3	0	TRUE
2036	4	2012	cell_offload_processing	1	TRUE	TRUE
2036	4	2013	cell_offload_decryption	1	TRUE	TRUE
2036	4	2014	cell_offload_parameters	2		TRUE
2036	4	2015	cell_offload_compaction	2	ADAPTIVE	TRUE
2036	4	2016	cell_offload_plan_display	2	AUTO	TRUE
2036	4	2019	db_name	2	orcl	FALSE
2036	4	2020	db_unique_name	2	orcl	TRUE
2036	4	2021	open_cursors	3	3000	FALSE
2036	4	2022	ifile	4		TRUE
2036	4	2023	sql_trace	1	FALSE	TRUE
2036	4	2024	os_authent_prefix	2	ops$	TRUE
2036	4	2026	optimizer_mode	2	ALL_ROWS	TRUE
2036	4	2031	sql92_security	1	FALSE	TRUE
2036	4	2034	blank_trimming	1	FALSE	TRUE
2036	4	2040	star_transformation_enabled	2	FALSE	TRUE
2036	4	2082	parallel_degree_policy	2	MANUAL	TRUE
2036	4	2090	parallel_adaptive_multi_user	1	TRUE	TRUE
2036	4	2091	parallel_threads_per_cpu	3	2	TRUE
2036	4	2092	parallel_automatic_tuning	1	FALSE	TRUE
2036	4	2098	parallel_io_cap_enabled	1	FALSE	TRUE
2036	4	2119	optimizer_index_cost_adj	3	100	TRUE
2036	4	2120	optimizer_index_caching	3	0	TRUE
2036	4	2132	query_rewrite_enabled	2	TRUE	TRUE
2036	4	2133	query_rewrite_integrity	2	enforced	TRUE
2036	4	2191	pga_aggregate_target	6	6442450944	FALSE
2036	4	2194	workarea_size_policy	2	AUTO	TRUE
2036	4	2219	optimizer_dynamic_sampling	3	2	TRUE
2036	4	2249	statistics_level	2	TYPICAL	TRUE
2036	4	2274	cursor_bind_capture_destination	2	memory+disk	TRUE
2036	4	2293	skip_unusable_indexes	1	TRUE	TRUE
2036	4	2375	optimizer_secure_view_merging	1	TRUE	TRUE
2036	4	2419	ddl_lock_timeout	3	0	TRUE
2036	4	2421	deferred_segment_creation	1	TRUE	TRUE
2036	4	2429	optimizer_use_pending_statistics	1	FALSE	TRUE
2036	4	2434	optimizer_capture_sql_plan_baselines	1	FALSE	TRUE
2036	4	2435	optimizer_use_sql_plan_baselines	1	TRUE	TRUE
2036	4	2456	parallel_min_time_threshold	2	AUTO	TRUE
2036	4	2458	parallel_degree_limit	2	CPU	TRUE
2036	4	2459	parallel_force_local	1	FALSE	TRUE
2036	4	2468	optimizer_use_invisible_indexes	1	FALSE	TRUE
2036	4	2492	dst_upgrade_insert_conv	1	TRUE	TRUE
2036	4	2497	parallel_servers_target	3	384	TRUE
2036	4	2556	sec_protocol_error_trace_action	2	TRACE	TRUE
2036	4	2557	sec_protocol_error_further_action	2	CONTINUE	TRUE
2036	4	2558	sec_max_failed_login_attempts	3	10	TRUE
2036	4	2559	sec_return_server_release_banner	1	FALSE	TRUE
2036	4	2562	enable_ddl_logging	1	FALSE	TRUE
2036	4	2565	client_result_cache_size	6	0	TRUE
2036	4	2566	client_result_cache_lag	6	3000	TRUE
2036	4	2591	aq_tm_processes	3	1	TRUE
2036	4	2607	hs_autoregister	1	TRUE	TRUE
2036	4	2608	xml_db_events	2	enable	TRUE
2036	4	2609	dg_broker_start	1	FALSE	TRUE
2036	4	2610	dg_broker_config_file1	2	/data/oracle/product/11.2.0/dbhome_1/dbs/dr1orcl.dat	TRUE
2036	4	2611	dg_broker_config_file2	2	/data/oracle/product/11.2.0/dbhome_1/dbs/dr2orcl.dat	TRUE
2036	4	2623	olap_page_pool_size	6	0	TRUE
2036	4	2720	asm_diskstring	2		TRUE
2036	4	2722	asm_preferred_read_failure_groups	2		TRUE
2036	4	2733	asm_diskgroups	2		TRUE
2036	4	2734	asm_power_limit	3	1	TRUE
2036	4	2810	control_management_pack_access	2	DIAGNOSTIC+TUNING	TRUE
2036	4	2832	awr_snapshot_time_offset	3	0	TRUE
2036	4	2837	sqltune_category	2	DEFAULT	TRUE
2036	4	2873	diagnostic_dest	2	/data/oracle	FALSE
2036	4	2897	tracefile_identifier	2		TRUE
2036	4	2899	max_dump_file_size	2	unlimited	TRUE
2036	4	2902	trace_enabled	1	TRUE	TRUE
2036	4	2913	cell_offloadgroup_name	2		TRUE

total 353 rows

nls_parameters

snap_id	device_id	parameter	value
2036	4	NLS_LANGUAGE	AMERICAN
2036	4	NLS_TERRITORY	AMERICA
2036	4	NLS_CURRENCY	$
2036	4	NLS_ISO_CURRENCY	AMERICA
2036	4	NLS_NUMERIC_CHARACTERS	.,
2036	4	NLS_CALENDAR	GREGORIAN
2036	4	NLS_DATE_FORMAT	YYYY-MM-DD HH24:MI:SS
2036	4	NLS_DATE_LANGUAGE	AMERICAN
2036	4	NLS_CHARACTERSET	ZHS16GBK
2036	4	NLS_SORT	BINARY
2036	4	NLS_TIME_FORMAT	HH.MI.SSXFF AM
2036	4	NLS_TIMTEST2_FORMAT	DD-MON-RR HH.MI.SSXFF AM
2036	4	NLS_TIME_TZ_FORMAT	HH.MI.SSXFF AM TZR
2036	4	NLS_TIMTEST2_TZ_FORMAT	DD-MON-RR HH.MI.SSXFF AM TZR
2036	4	NLS_DUAL_CURRENCY	$
2036	4	NLS_NCHAR_CHARACTERSET	AL16UTF16
2036	4	NLS_COMP	BINARY
2036	4	NLS_LENGTH_SEMANTICS	BYTE
2036	4	NLS_NCHAR_CONV_EXCP	FALSE

total 19 rows

options

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

total 65 rows

registrys

snap_id	device_id	comp_id	comp_name	version	status	modified	schema
2036	4	OWB	OWB	11.2.0.4.0	VALID	01-OCT-2013 22:57:11	OWBSYS
2036	4	APEX	Oracle Application Express	3.2.1.00.12	VALID	01-OCT-2013 22:57:11	APEX_030200
2036	4	EM	Oracle Enterprise Manager	11.2.0.4.0	VALID	01-OCT-2013 22:35:31	SYSMAN
2036	4	SDO	Spatial	11.2.0.4.0	VALID	01-OCT-2013 22:57:10	MDSYS
2036	4	AMD	OLAP Catalog	11.2.0.4.0	VALID	01-OCT-2013 22:57:10	OLAPSYS
2036	4	XOQ	Oracle OLAP API	11.2.0.4.0	VALID	01-OCT-2013 22:57:09	SYS
2036	4	APS	OLAP Analytic Workspace	11.2.0.4.0	VALID	01-OCT-2013 22:57:07	SYS
2036	4	ORDIM	Oracle Multimedia	11.2.0.4.0	VALID	01-OCT-2013 22:57:07	ORDSYS
2036	4	RUL	Oracle Rules Manager	11.2.0.4.0	VALID	01-OCT-2013 22:57:07	EXFSYS
2036	4	XDB	Oracle XML Database	11.2.0.4.0	VALID	01-OCT-2013 22:57:03	XDB
2036	4	CONTEXT	Oracle Text	11.2.0.4.0	VALID	01-OCT-2013 22:57:01	CTXSYS
2036	4	EXF	Oracle Expression Filter	11.2.0.4.0	VALID	01-OCT-2013 22:57:01	EXFSYS
2036	4	CATJAVA	Oracle Database Java Packages	11.2.0.4.0	VALID	01-OCT-2013 22:57:00	SYS
2036	4	XML	Oracle XDK	11.2.0.4.0	VALID	01-OCT-2013 22:57:00	SYS
2036	4	JAVAVM	JServer JAVA Virtual Machine	11.2.0.4.0	VALID	01-OCT-2013 22:57:00	SYS
2036	4	OWM	Oracle Workspace Manager	11.2.0.4.0	VALID	01-OCT-2013 22:56:58	WMSYS
2036	4	CATPROC	Oracle Database Packages and Types	11.2.0.4.0	VALID	01-OCT-2013 22:56:58	SYS
2036	4	CATALOG	Oracle Database Catalog Views	11.2.0.4.0	VALID	01-OCT-2013 22:56:58	SYS

total 18 rows

licenses

snap_id	device_id	sessions_max	sessions_warning	sessions_current	sessions_highwater	users_max
2036	4	0	0	14	24	0

total 1 rows