KEEP CACHE和并行查询简单使用

KEEP CACHE和并行查询简单使用

a)
1.Check db keep cache size:
show parameter db_keep_cache_size
if it is 0,please set it:
alter system set db_keep_cache_size=<size>;
2.keep table:
alter table <tablename> cache;

b) 并行查询
SELECT /*+PARALLEL(P,4)*/
 ROW_NUMBER() OVER(ORDER BY P.PP, P.BEGDA) AS ROW_NUMBER,
 P.*,
 NVL((SELECT
WMSYS.WM_CONCAT(Z.ORGEH)
 FROM (SELECT DISTINCT ORGEH, STEXT, OBJID FROM SNAP) Z
 START WITH Z.ORGEH = P.ZSZBMID
 CONNECT BY PRIOR Z.OBJID = Z.ORGEH),
 P.ZSZBMID) ORGEHS
 FROM TP1 P;