课程第20次

secoug

老的advisor:

1. select * from dict where table_name like 'V$%ADVICE' or table_name like '%UNDO%';

复制代码

	TABLE_NAME	COMMENTS
1	DBA_HIST_UNDOSTAT	Undo Historical Statistics Information
2	DBA_UNDO_EXTENTS	Extents comprising all segments in the system managed undo tablespaces
3	V$MEMORY_TARGET_ADVICE	Synonym for V_$MEMORY_TARGET_ADVICE
4	V$MTTR_TARGET_ADVICE	Synonym for V_$MTTR_TARGET_ADVICE
5	V$PGA_TARGET_ADVICE	Synonym for V_$PGA_TARGET_ADVICE
6	V$PX_BUFFER_ADVICE	Synonym for V_$PX_BUFFER_ADVICE
7	V$SGA_TARGET_ADVICE	Synonym for V_$SGA_TARGET_ADVICE
8	V$SHARED_POOL_ADVICE	Synonym for V_$SHARED_POOL_ADVICE
9	V$STREAMS_POOL_ADVICE	Synonym for V_$STREAMS_POOL_ADVICE
10	V$UNDOSTAT	Synonym for V_$UNDOSTAT
11	V$DB_CACHE_ADVICE	Synonym for V_$DB_CACHE_ADVICE
12	V$JAVA_POOL_ADVICE	Synonym for V_$JAVA_POOL_ADVICE
13	GV$UNDOSTAT	Synonym for GV_$UNDOSTAT

1. select  * from dba_hist_undostat;

复制代码

	BEGIN_TIME	END_TIME	DBID	INSTANCE_NUMBER	SNAP_ID	UNDOTSN	UNDOBLKS	TXNCOUNT	MAXQUERYLEN	MAXQUERYSQLID	MAXCONCURRENCY	UNXPSTEALCNT	UNXPBLKRELCNT	UNXPBLKREUCNT	EXPSTEALCNT	EXPBLKRELCNT	EXPBLKREUCNT	SSOLDERRCNT	NOSPACEERRCNT	ACTIVEBLKS	UNEXPIREDBLKS	EXPIREDBLKS	TUNED_UNDORETENTION
1	10/19/2019 8:03:11 AM	10/19/2019 8:13:11 AM	1545528092	1	75	2	454	1369	344	0rc4km05kgzb9	4	0	0	0	0	0	0	0	0	384	1152	9840	1185
2	10/20/2019 2:53:11 AM	10/20/2019 3:03:11 AM	1545528092	1	95	2	625	1446	781	0rc4km05kgzb9	5	0	0	0	0	0	0	0	0	384	896	5312	1561
3	10/20/2019 3:03:11 AM	10/20/2019 3:13:11 AM	1545528092	1	95	2	490	1489	176	0rc4km05kgzb9	4	0	0	0	0	0	0	0	0	384	1824	4128	956
4	10/20/2019 3:13:11 AM	10/20/2019 3:23:11 AM	1545528092	1	95	2	514	1347	778	0rc4km05kgzb9	4	0	0	0	0	0	0	0	0	384	664	5544	1558
5	10/20/2019 3:23:11 AM	10/20/2019 3:33:11 AM	1545528092	1	95	2	524	1328	173	0rc4km05kgzb9	4	0	0	0	0	0	0	0	0	384	1560	4648	953
6	10/20/2019 3:33:11 AM	10/20/2019 3:43:11 AM	1545528092	1	95	2	486	1401	774	0rc4km05kgzb9	4	0	0	0	0	0	0	0	0	384	896	5312	1554
7	10/20/2019 3:43:11 AM	10/20/2019 3:53:11 AM	1545528092	1	95	2	514	1331	171	0rc4km05kgzb9	5	0	0	0	0	0	0	0	0	384	1280	4928	951
8	10/20/2019 2:53:03 PM	10/20/2019 3:03:03 PM	1545528092	1	107	2	682	1469	295	0rc4km05kgzb9	4	0	0	0	0	0	0	0	0	384	1536	5648	1135
9	10/20/2019 3:03:03 PM	10/20/2019 3:13:03 PM	1545528092	1	107	2	509	1503	896	0rc4km05kgzb9	4

..........