开发者

Parameters used by the optimizer query

I vaguely remember that I need to join the two weird tables to get an output of all the parameters like this:

OPTIMIZER_MODE/GOAL = Choose
_OPTIMIZER_PERCENT_PARALLEL = 101
HASH_AREA_SIZE = 131072
HASH_JOIN_ENABLED = TRUE
HASH_MULTIBLOCK_IO_COUNT = 0
SORT_AREA_SIZE = 65536
...

This is an output from 10053, but I don't have OS access to get full trace (and get parameters as a si开发者_如何学Pythondeffect). I need sql query.


select * from v$parameter2 order by name;

This will show all regular parameter values for the session but only the hidden parameter values that are different than the default.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜