注册

能说明下,这些查询的结果是会什么含义,有没有什么问题啊。

周小胖 2026/01/26 183 2

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:v8.1.2.192
【操作系统】:Kylin Linux Advanced Server release V10 (Lance)
【CPU】:海光C86
【问题描述】*: 谁能说明下,这些查询的结果是会什么含义,有没有什么问题。

查询SQL :

	SELECT name, total_size/1024/1024 as total_size_mb, n_extend_exclusive
FROM v$mem_pool 
WHERE n_extend_exclusive > 0
ORDER BY total_size DESC;	

查询结果

name	total_size_mb	n_extend_exclusive
MON ITEM ARR	169	919703
FLASHBACK SYS	21	38
DSQL STAT HISTORY	19	35508351
MAL SYS	18	1
MAL SYS	18	3
MAL SYS	16	5
MAL SYS	16	7
MAL SYS	16	3
MAL SYS	16	4
MAL SYS	16	1
MAL SYS	16	8
MAL SYS	16	4
MAL SYS	16	8
DSQL BIND DATA HISTORY	15	1537013
MAL SYS	14	2
MAL SYS	14	3
MAL SYS	14	3
MAL SYS	14	5
MAL SYS	14	7
MAL SYS	14	7
MAL SYS	14	5
MAL SYS	14	5
MAL SYS	14	1
MAL SYS	14	5
MAL SYS	14	4
MAL SYS	14	3
MAL SYS	14	9
MAL SYS	14	2

查询SQL

"SELECT TOP 10 sql_Txt,Max_MEM_Used,*
FROM V$SQL_STAT 
ORDER BY MAX_MEM_USED DESC;"																																																											

查询结果

image.png

/*DMJDBC*/ SELECT /*+ MAX_OPT_N_TABLES(5) */ NULL AS TABLE_CAT,SCHEMAS.NAME AS TABLE_SCHEM,TABS.NAME AS TABLE_NAME, CASE TABS.SUBTYPE$ WHEN 'UTAB' THEN 'TABLE' WHEN 'VIEW' THEN 'VIEW' WHEN 'STAB' THEN 'SYSTEM TABLE' WHEN 'SYNOM' THEN 'SYNONYM' END AS TABLE_TYPE, (SELECT COMMENT$ FROM SYS.SYSTABLECOMMENTS WHERE SCHNAME = SCHEMAS.NAME AND TVNAME = TABS.NAME) AS REMARKS, NULL AS TYPE_CAT, NULL AS TYPE_SCHEM, NULL AS TYPE_NAME, NULL AS SELF_REFERENCING_COL_NAME, NULL AS REF_GENERATION  FROM(SELECT ID, P ... _OPT(UID(), CURRENT_USERTYPE(), TABS.ID, SCHEMAS.PID, -1, TABS.ID) = 1)  ORDER BY TABLE_TYPE ASC,TABLE_SCHEM ASC,TABLE_NAME ASC;	89786
"SELECT TOP 10 sql_Txt,Max_MEM_Used,*
FROM V$SQL_STAT 
ORDER BY MAX_MEM_USED DESC"	33095
UPDATE "WCSXDXK"."WCS_TASKINFO" SET "TASKSTATUS"=:P_0,"UPDATETIME"=:P_1 WHERE "WCSXDXK"."WCS_TASKINFO"."TASKID" = :P_2	2112
SELECT SYS_CONTEXT( 'USERENV', 'CURRENT_SCHEMA' ) FROM DUAL	1088

回答 0
暂无回答
扫一扫
联系客服